Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2015
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. <?php
  2. if($result = $db->query("SELECT userID, name FROM user ")) {
  3. while($row = $result->fetch_assoc()) {
  4. echo '<form method="POST" action="viewDetails.php"> ';
  5.  
  6. echo $row['userID'], '. ';
  7. echo $row['name'];
  8. echo '<input type="submit" name="submit" value="View More Details"><br>';
  9. echo '</form>';
  10. }
  11. }else{
  12. die($db->error);
  13. } ?>
  14.  
  15. <?php
  16. require "include/connection.php";
  17. //error_reporting(0);
  18. ?>
  19.  
  20. <DOCTYPE html>
  21. <html>
  22. <head>
  23. </head>
  24.  
  25. <body>
  26. <?php
  27. if(!isset($_POST['selected'])){
  28. if($result = $db->query("SELECT * FROM user WHERE name='".$_POST['selected']."' ")) {
  29. while($row = $result->fetch_assoc()) {
  30.  
  31. echo $row['name'], '&nbsp;-&nbsp;&nbsp; ';
  32. echo $row['email'], '&nbsp;-&nbsp;&nbsp; ';
  33. echo $row['address'], '<br>';
  34.  
  35. }
  36. }else{
  37. die($db->error);
  38. }
  39. }
  40. ?>
  41. </body>
  42. </html>
  43.  
  44. echo '<input type="hidden" name="userid" value="'.$row['userID'].'"><br>';
  45.  
  46. "SELECT * FROM user WHERE id=".$_POST['userid'].""
  47.  
  48. echo '<input type="hidden" name="userid" value="'.$row['userID'].'"><br>'
  49. echo '<input type="hidden" name="name" value="'.$row['name'].'"><br>'
  50. echo '<input type="hidden" name="email" value="'.$row['email'].'"><br>'
  51. echo '<input type="hidden" name="address" value="'.$row['address'].'"><br>'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement