Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2019
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.41 KB | None | 0 0
  1. $sql = "SELECT * FROM res WHERE email = '$email'";
  2. $result = mysqli_query($conn, $sql);
  3. if (mysqli_num_rows($result) > 0) {
  4. // Fetching data
  5. while ($row = mysqli_fetch_array($result)) {
  6.  
  7. // Get User ID
  8. $_SESSION['user_id'] = $row['id'];
  9. $user_id = $_SESSION['user_id'];
  10. $url = $row['files'];
  11. // Get Files
  12. $_SESSION['files'] = $row['files'];
  13. $file = $_SESSION['files'];
  14. $edit = [
  15. 'id' => $row['id'],
  16. 'files' => $row['files']
  17. ];
  18. ?>
  19. <ul class="list-style">
  20. <li>
  21. <!-- Get Data of Specific id -->
  22. <?php echo "
  23. <div class='col-md-6'>
  24. $row[name] &nbsp;&nbsp;&nbsp;&nbsp;
  25. </div>
  26. <div class='col-md-6'>
  27. <a class='btn btn-primary' href='edit.php?'.http_build_query($edit, null, '&', PHP_QUERY_RFC3986).'>Edit</a>
  28. <a class='btn btn-danger' href='delete.php?id=$row[id]'>X</a>
  29. </div><br/>";
  30. ?>
  31. </li>
  32. </ul>
  33. <?php
  34. }
  35. }
  36. ?>
  37.  
  38. include("config.php");
  39. if (isset($_GET['edit'])) {
  40. // $id = $_GET['edit'];
  41. $id = $_GET['id'];
  42. $files = $_GET['files'];
  43. $sql = "SELECT * FROM res WHERE id = '$id'";
  44. $result = mysqli_query($conn, $sql);
  45. $row = mysqli_fetch_array($result);
  46. }
  47.  
  48. if (isset($_POST['name'])) {
  49. $name = $_POST['name'];
  50. $email = $_POST['email'];
  51. $phone = $_POST['phone'];
  52. $id = $_POST['id'];
  53. $sql2 = "UPDATE res SET name='$name', email='$email', phone_number='$phone' WHERE id = '$id'";
  54. $result2 = mysqli_query($conn, $sql2);
  55. echo "<meta http-equiv='refresh' content='0;url=list.php'>";
  56. }
  57.  
  58. $edit = [
  59. 'id' => $row['id'],
  60. 'files' => $row['files']
  61. ];
  62. echo '<a href="edit.php?'.http_build_query($edit, null, '&', PHP_QUERY_RFC3986).'">Link</a>';
  63.  
  64. $id = $_GET['id'];
  65. $files = $_GET['files'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement