How to echo a href when using a variable from mysqli

Question

I have a variable retrieved from a mysqli database called eBayURL. I am attempting to assign the variable to a button.

However I get an error when using

echo "<a target='"_blank"' href='".$row['eBayURL']."' class="btn btn-outlined btn-primary btn-md">Click Here <br> To Book Now </a></li>'";

I have also tried with { but also seems to fail. What is the correct syntax please?

Your code contains several parse errors concerning quotes. You need to revisit how quotes and, within them, escaping quotes, works. — Mitya, Nov 09 '18 at 10:59
Possible duplicate of [PHP parse/syntax errors; and how to solve them?](https://stackoverflow.com/questions/18050071/php-parse-syntax-errors-and-how-to-solve-them) — Qirel, Nov 09 '18 at 11:00
Possible duplicate of [Double quotes within php script echo](https://stackoverflow.com/questions/11036420/double-quotes-within-php-script-echo) — Tigger, Nov 09 '18 at 11:09

Tigger · Accepted Answer · 2018-11-09T11:13:48.067

You have an incorrect mix of single and double quotes.

Try the following instead:

echo '<a target="_blank" href="'.$row['eBayURL'].'" class="btn btn-outlined btn-primary btn-md">Click Here <br> To Book Now </a></li>';

Or you can use:

echo "<a target=\"_blank\" href=\"".$row['eBayURL']."\" class=\"btn btn-outlined btn-primary btn-md\">Click Here <br> To Book Now </a></li>";

You could get crazy and use printf() as well if you like:

$format = '<a target="_blank" href="%s" class="btn btn-outlined btn-primary btn-md">Click Here <br> To Book Now </a></li>';
printf($format,$row['eBayURL']);

If that fails, please check the value of $row['eBayURL'] like so:

var_dump($row['eBayURL']);

Shubham Baranwal · Answer 2 · 2018-11-09T11:10:20.673

0

You mixed double quote and single quote in your anchor tag, try this -

echo "<a target='_blank' href='".$row['eBayURL']."' class='btn btn-outlined btn-primary btn-md'>Click Here <br> To Book Now </a></li>";

edited Nov 09 '18 at 11:10

answered Nov 09 '18 at 11:05

Shubham Baranwal

2,492
3
14
26

Thank you so much. Much appreciated. – bitzer Nov 09 '18 at 11:22
My pleasure :). If my answer helps you please upvote it. @bitzer – Shubham Baranwal Nov 09 '18 at 11:22

How to echo a href when using a variable from mysqli

2 Answers2