php按钮添加mysql,PHP添加按钮以查看整个记录MySQL的所有内容

Currently I have a query running that brings up all the contents of the 'products' table and the 'user' associated with the products. It prints on a table. I want to create a button, that brings up the entire records.

Please note that I must only be able to view the selected record only.. How would I go about this?

echo "

user_id	user_name	selected_product

while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))

echo "

" . $row['user_id'] . "";

echo "

" . $row['user_name'] . "";

echo "

" . $row['selected_product'] . "";

So a button should appear for each record that is returned as a result. When I click this button another window should appear which shows the entire contents (for this record only) and the user associated.

How does the button know which record its associated with.

解决方案

View Details

This will take you to another page.

Use get method tho get the id into php variable.

$userId = $_GET['id'];

And now use sql query to fetch all the data from the database for single user.

$userResult = mysql_query("SELECT * FROM userTable WHERE user_id = ".$userId);