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.
解决方案
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);