Echo value from MYSQL Database to url

Question

I have a table that draws information from my MYSQL database. I have a button that I want to echo the id of the row of the information I draw. I can echo all the information to the table but for some reason no idea how to get the information into the URL

I want to use it in the next page in the GET function for additional data being drawn

 echo "<td> <a href='dashboard.php?id="<php echo[id], ?>"'><button>Next</button></a> </td>";

I am receiving this error:

Parse error: syntax error, unexpected 'echo' (T_ECHO), expecting ',' or ';' in

The unexpected Echo they referring to I think is the second one as the first echo on previous rows in my table I have no issues

Update:

I have this sql string:

$sql = "SELECT * FROM new_case WHERE status = 'Active'";

In the table I have one row as below and it shows the id of that row.

echo "<td>" . $row['id'] . "</td>";

You should really rather go and find yourself a beginner’s tutorial that explains the basics of the syntax. Stuff that is as extremely low-level as this, should not be asked about here in the first place, this is not a teaching ground. — 04FS, Dec 06 '19 at 12:15
@04FS Thanks for the comment as this is low-level for you it is a milestone for me — James Brown, Dec 06 '19 at 12:17
@JamesBrown --> $id = $row['id']; echo ""; can you try this? — BhAvik Gajjar, Dec 06 '19 at 12:23

Devsi Odedra · Accepted Answer · 2019-12-06T12:32:45.927

1

You made mistake here <php echo[id], ?>

you are already inside PHP, so dont use <?php ?>

also echo[id] is not valid, PHP variable start with $

So replace your line with below line.

 echo "<td> <a href='dashboard.php?id=".$row['id']."'><button>Next</button></a> </td>";

edited Dec 06 '19 at 12:32

answered Dec 06 '19 at 12:07

Devsi Odedra

5,244
1
23
37

I have tried as above getting new error, Parse error: syntax error, unexpected '$id' (T_VARIABLE), expecting ',' or ';' in. I have also tried with single ' and then no error but no result in url – James Brown Dec 06 '19 at 12:12
what is your variable for id ? – Devsi Odedra Dec 06 '19 at 12:12
id is a number it should show ie 4 the result I am looking for is dashboard.php?id=4 – James Brown Dec 06 '19 at 12:14
if $id is number then it will show as echo " "; – Devsi Odedra Dec 06 '19 at 12:16
if $id not defined then you will get that error – Devsi Odedra Dec 06 '19 at 12:17
I have updated my question. in a previous row I call the id to display in the table all I need now is to be displayed in the URL – James Brown Dec 06 '19 at 12:21
ok, so just use `$row['id']` – Devsi Odedra Dec 06 '19 at 12:26
unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting '-' or identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) Now getting this error – James Brown Dec 06 '19 at 12:31
did u used my updated answer ? – Devsi Odedra Dec 06 '19 at 12:32
use `echo " ";` – Devsi Odedra Dec 06 '19 at 12:33
great, finally worked..!! – Devsi Odedra Dec 06 '19 at 12:39

score 0 · Answer 2 · answered Dec 06 '19 at 12:11

It seems there is a typo at the echo function, the syntax of the echo function is echo <string> you can see it in the documentation.

So calling echo[id] is invalid syntax, it expects a string of some sorts (this can be a variable too, as long as it implements a __toString function).

A right way to call it would be like echo "<td><a href='dashboard.php?id=$id'"... when you use double quotes PHP will try to interpit the quote and parse any variables written inside of it.

However, it is important to know that is is a security risk to directly output database information into an URL.

Narendra Kumar · Answer 3 · 2019-12-06T12:32:10.310

0

Please use below code

echo "<td> <a href='dashboard.php?id=".$id."'><button>Next</button></a> </td>";

instead of

 echo "<td> <a href='dashboard.php?id="<php echo[id], ?>"'><button>Next</button></a> </td>";

edited Dec 06 '19 at 12:32

answered Dec 06 '19 at 12:26

Narendra Kumar

1
2

Echo value from MYSQL Database to url

3 Answers3