01.<meta charset="UTF-8">
02.<?php
03.include('db.php');
04.$name_id = mysqli_real_escape_string($con,$_GET['name_id']);
05.$sql = "SELECT * FROM tablename WHERE name_id='$name_id' ";
06.$result = mysqli_query($con, $sql) or die ("Error in query: $sql " . mysqli_error());
07.$row = mysqli_fetch_array($result);
08.extract($row);
09.?>
10.<html>
11.<body>
12.<form action="new.php" method="post" name="updateuser" >
13. <table>
14. <tr>
15. <td><b>แก้ไขข้อมูล</b></td>
16. </tr>
17. <tr>
18. <td>name_id : </td>
19. <td><input type="text" name="name_id" value="<?php echo $name_id; ?>" disabled='disabled' ></td>
20. </tr>
21. <tr>
22. <td>name :</td>
23. <td><input name="name" type="text" id="name" value="<?=$name;?>" ></td>
24. </tr>
25. <tr>
26. <td>surname :</td>
27. <td><input name="surname" type="text" id="surname" value="<?=$surname;?>" ></td>
28. </tr>
29. <tr>
30. <td>job_name :</td>
31. <td><input type="text" name="job_name" list="job_name">
32. <datalist id="job_name">
33. <option value="job1">
34. <option value="job2">
35. </datalist>
36. </td>
37. </tr>
38. <tr>
39. <td></td>
40. <td><input type="submit" name="Update" value="ยืนยัน" ></td>
41. </tr>
42. </table>
43.</form>
44.</body>
45.</html>
