How can I get an ID from a SQL filled table?

Question

I made a table which is filled with SQL data. When I click on a row, it takes me to a different page (using javascript). On this page I want to show all the data from the clicked row only. How can I get the ID from a table filled with SQL data? Im talking about the ID of the SQL row.

echo "<table>"; 
                                            echo "<tr>";
                                            echo "<th>".'Stof'."</th>";
                                            echo "<th>".'Score'."</th>";
                                            echo "<th>".'Datum'."</th>";
                                            echo "</tr>";
                                            foreach ($result as $pers) {
                                                echo "<tr data-href='detail.php'>";
                                                echo "<td>".$pers->stofid."</td>
                                                <td>".$pers->melden."</td>
                                                <td>".$pers->datum."</td>";
                                                echo "</tr>";
                                            }
                                            echo "</table>";

The data-href is my page reference, and it works.

Kamil Kiełczewski · Accepted Answer · 2018-11-18T13:13:40.333

1

To show ID in table add this before last line in your foreach statement:

echo "<td>".$pers->id."</td>"

And don't forget to add th element in your table tr section (above foreach)

echo "<th>id</th>";

And if you wanna pass that ID to next page (detail.php) then change first line in your foreach statement into this:

echo "<tr data-href='detail.php?persId=".$pers->id."'>";

edited Nov 18 '18 at 13:13

answered Nov 18 '18 at 13:02

Kamil Kiełczewski

85,173
29
368
345

where would I put this? – Jop Rill Nov 18 '18 at 13:04
put this on last line in your foreach – Kamil Kiełczewski Nov 18 '18 at 13:05
This isn't a complete solution, and will change the way the table looks. – wizzwizz4 Nov 18 '18 at 13:06
@KamilKiełczewski That last suggestion might actually be better than my answer. I still maintain that adding a column might not be required, but... Good suggestion. – wizzwizz4 Nov 18 '18 at 13:24
@meephparganmanpoelermakisto798 this is separate question - ask(or find) it in StackOverflow . At strarting point you can find info about: how to read url parameter in php - here https://stackoverflow.com/questions/11480763/how-to-get-parameters-from-a-url-string – Kamil Kiełczewski Nov 18 '18 at 14:57

score 1 · Answer 2 · answered Nov 18 '18 at 13:05

Unless you put the id in the table somewhere, it's not possible. I recommend doing the following:

echo "<table>"; 
echo "<tr>";
echo "<th>".'Stof'."</th>";
echo "<th>".'Score'."</th>";
echo "<th>".'Datum'."</th>";
echo "</tr>";
foreach ($result as $pers) {
    echo "<tr data-href='detail.php' data-id='".$pers->id."'>";
    echo "<td>".$pers->stofid."</td>
          <td>".$pers->melden."</td>
          <td>".$pers->datum."</td>";
    echo "</tr>";
}
echo "</table>";

That way, you can change whatever JavaScript code turns your data-href into a link into code that generates detail.php?id=34526 (using the data-id value also. Then detail.php can, if it receives an id $_GET parameter, only show details from that row. (Make sure the user's allowed to read the row with that id, or you'll be introducing a security vulnerability!)

I can't help more without seeing the bit of JavaScript. – wizzwizz4 Nov 18 '18 at 13:06 — wizzwizz4, Nov 18 '18 at 13:06

How can I get an ID from a SQL filled table?

2 Answers2