Guest User

Untitled

a guest
Mar 3rd, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.07 KB | None | 0 0
  1. if(isset($_POST['update']))
  2. {
  3. $dbhost = 'host';
  4. $dbuser = 'user';
  5. $dbpass = 'password';
  6. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  7. if(! $conn )
  8. {
  9. die('Could not connect: ' . mysql_error());
  10. }
  11.  
  12. $name= $_POST['name'];
  13.  
  14. $sql = "UPDATE table SET name='$name' WHERE id='$id'";
  15.  
  16. mysql_select_db('my_db');
  17. $retval = mysql_query( $sql, $conn );
  18. if(! $retval )
  19. {
  20. die('Could not update data: ' . mysql_error());
  21. }
  22. echo "Success">";
  23. mysql_close($conn);
  24. }
  25. else
  26. {
  27. include"db.inc.php";
  28. $id = $_GET["id"];
  29. $order = "SELECT * FROM table where id='$id'";
  30. $result = mysql_query($order);
  31. $row = mysql_fetch_array($result);
  32.  
  33. }
  34. ?>
  35. <form id="update" name="update" method="post" role="form" action="">
  36. <input type="text" id="name" name="name" value="<? echo "$row[name]"?>" />
  37. <input name="update" type="submit" id="update" value="Save">
  38. </form>
  39. <?php
  40. }
  41. ?>
  42.  
  43. if(isset($_POST['update']))
  44. {
  45. $dbhost = 'host';
  46. $dbuser = 'user';
  47. $dbpass = 'password';
  48. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  49. if(! $conn )
  50. {
  51. die('Could not connect: ' . mysql_error());
  52. }
  53.  
  54. $name= $_POST['name'];
  55.  
  56. mysql_select_db('my_db');
  57. $sql = "UPDATE table SET name='$name' WHERE id='$id'";
  58.  
  59.  
  60. $retval = mysql_query( $sql, $conn );
  61. if(! $retval )
  62. {
  63. die('Could not update data: ' . mysql_error());
  64. }
  65. else{
  66. echo "Success";}
  67.  
  68. mysql_close($conn);
  69. }
  70. else
  71. {
  72. include"db.inc.php";
  73. $id = $_GET["id"];
  74. $order = "SELECT * FROM table where id='$id'";
  75. $result = mysql_query($order);
  76. $row = mysql_fetch_array($result);
  77.  
  78. }
  79. ?>
  80. <form id="update" name="update" method="post" role="form" action="">
  81. <input type="text" id="name" name="name" value="<? echo "$row[name]"?>" />
  82. <input name="update" type="submit" id="update" value="Save">
  83. </form>
  84. <?php
  85. }
  86. ?>
  87.  
  88. $id = $_GET["id"];
  89.  
  90. $name= $_POST['name'];
  91.  
  92. <form id="update" name="update" method="post" role="form" action="">
  93. <input type="hidden" id="id" name="id" value="<? echo "$row[id]"?>" />
  94. <input type="text" id="name" name="name" value="<? echo "$row[name]"?>" />
  95. <input name="update" type="submit" id="update" value="Save">
  96.  
  97. $id = $_GET["id"];
  98.  
  99. $name= $_POST['name'];
Add Comment
Please, Sign In to add comment