如何从MySQL表中的特定列获取值，然后将其显示在新页面上[重复]

Question

This question already has an answer here:

• PHP and MySQL Select a Single Value 9 answers

So I have a simple question and I'm stuck with it. I have to use the same logic like in the provided code, but this time I have to make a new page - let's say "article.php", then I have to change the "Delete" button with "Show" button.

This is easy, but I can't do the following thing:

When a user clicks on the "SHOW" button, the link must redirect him into the "article.php" page, and after that to display ALL of the VALUES for the selected COLUMN. How is this going to happen? Using "foreach" cycle again or?... I really don't know how to do it. Any help will be highly appreciated!

<?php

include "app".DIRECTORY_SEPARATOR."config.php";
include "app".DIRECTORY_SEPARATOR."db-connection.php";

$foo_connection = db_connect($host, $user_name, $user_password, $database);

$sql = "SELECT * FROM articles";

$result = mysqli_query($foo_connection, $sql);

if(mysqli_num_rows($result) > 0){

    print "<table>
              <tr>
                <th>Article ID</th>
                <th>Article heading</th>
                <th>Article text</th>
                <th>Article author</th>
                <th>Article published</th>
                <th>Article delete</th>
              </tr>";
    foreach($result as $key => $cols){

        print "<tr>".
                  "<td>".$cols['id']."</td>".
                  "<td>".$cols['heading']."</td>".
                  "<td>".$cols['text']."</td>".
                  "<td>".$cols['author']."</td>".
                  "<td>".$cols['published']."</td>".
                  "<td><a href='app/sql/delete.php?id=".$cols['id']."'>Delete</a></td>".
              "</tr>";
    }
    print "</table>";
}
else {
    print "0 results";
}

mysqli_close($foo_connection);

</div>

Answer 1

In the new page, change the link from:

<a href='app/sql/delete.php?id=".$cols['id']."'>Delete</a>

To:

<a href='app/sql/articledetails.php?id=".$cols['id']."'>Show</a>

Then create a page articledetails.php that displays a single record based on the argument passed in id.

Use a SQL statement that selects just the one row:

$sql = "SELECT * FROM articlesWHERE id = ?";

Then bind the $_GET['id'] value to the SQL statement and execute it. Then display the row as needed.