How to convert html code to php when inserting in database [duplicate]

Question

I have an HTML table which is generated from MySQL DB... works so far. I tried to insert an "update" button which selects the DB id of each row...

the one with the "->" is the one, that should generate the href:

What I get is: <a href"update.php?id= instead of <a href"update.php?id=[id]

Here is my code-snippet:

while ($zeile = mysqli_fetch_array( $db_erg, MYSQL_ASSOC))
      {
        echo "<tr>";
        echo "<td align=\"center\">". $zeile['vorname'] . "</td>";
        echo "<td align=\"center\">". $zeile['nachname'] . "</td>";
        echo "<td align=\"center\">". $zeile['gender'] . "</td>";
        echo "<td align=\"center\">". $zeile['gamertag'] . "</td>";
        echo "<td align=\"center\">". $zeile['mail'] . "</td>";
        echo "<td align=\"center\">". $zeile['age'] . "</td>";
        echo "<td align=\"right\">". $zeile['rank'] . "</td>";
        echo "<td align=\"right\">". $zeile['prime'] . "</td>";
        echo "<td align=\"right\">". $zeile['gametime'] . "</td>";
        echo "<td align=\"right\">". $zeile['msg'] . "</td>";
        echo "<td align=\"right\">". $zeile['status'] . "</td>";
  ->    echo "<td>". "<a href=\"update.php?id=\"".$zeile['id'].">update"."</a>"."</td>";

Any ideas? Thank you !

Siva · Accepted Answer · 2019-01-24 11:44:16Z

1

Try with

echo '<td><a href="update.php?id='.$zeile["id"].'">update</a></td>';

answered Jan 24, 2019 at 11:44

Siva

1,5271 gold badge19 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Fabian Rehme Over a year ago

works ! Thank you bud !!!

mickmackusa Over a year ago

Please always explain your solutions... even when they are simple/obvious to you or most people.

akhil · Accepted Answer · 2019-01-24 11:52:49Z

0

You can simply use curly braces for this purpose. like below

echo "<td><a href='update.php?id={$zeile['id']}'>update</a></td>";

or you can use,

echo "<td><a href='update.php?id=".$zeile['id']."'>update</a></td>";

answered Jan 24, 2019 at 11:52

akhil

1067 bronze badges

2 Comments

Fabian Rehme Over a year ago

works ! Thank you so much ! Its much better with the braces !

akhil Over a year ago

yeah. with curly braces its looks neat.

Collectives™ on Stack Overflow

How to convert html code to php when inserting in database [duplicate]

2 Answers 2

2 Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Linked

Related