PHP编辑表中的唯一行

Question

I currently have a PHP form that uses AJAX to connect to MySQL and display records matching a user's selection (AJAX: Display MySQL data with value from multiple select boxes)

As well as displaying the data, I also place an 'Edit' button next to each result which displays a form where the data can be edited. My problem is editing unique records since currently I only use the selected values for 'name' and 'age' to find the record. If two (or more) records share the same name and age, I am only able to edit the first result.

Answer 1

Let's assume your file for editing is edit.php. Then, in the file where you generate the edit links, try changing your edit button link as follows:

'<a href="edit.php?id="'.$row['ID'].'">edit</a>'

Then you will be able to access ID variable as

echo $_REQUEST['ID'];

Note that the ID is case sensitive. Let me know how it goes.