Guest User

Untitled

a guest
Feb 10th, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.56 KB | None | 0 0
  1. <html>
  2.  
  3. <head>
  4. <title></title>
  5. </head>
  6.  
  7. <body>
  8. <?php
  9.  
  10. if(isset($_POST['update'])) {
  11.  
  12.  
  13. $dbhost = 'localhost';
  14. $dbuser = '***';
  15. $dbpass = '******';
  16.  
  17. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  18.  
  19. if(! $conn ) {
  20. die('Could not connect: ' . mysqli_error());
  21. }
  22.  
  23. $Userid = $_POST['UserID'];
  24. $TableID = $_POST['tableID'];
  25. $Life_points = $_POST['Life_points'];
  26. $xp_points = $_POST['xp_points'];
  27.  
  28. $sql = "UPDATE points"." SET TableID = $TableID". "WHERE UserID= $UserID"."WHERE life_points= $Life_points"."WHERE xp_points= $xp_points" ;
  29.  
  30. mysqli_select_db('womath');
  31.  
  32. $retval = mysqli_query( $sql, $conn );
  33.  
  34. if(! $retval ) {
  35. die('Could not update data: ' . mysqli_error());
  36. }
  37. echo "Updated data successfullyn";
  38.  
  39. mysqli_close($conn);
  40. }
  41. else {
  42.  
  43.  
  44. ?>
  45. <form method = "post" action = "<?php $_PHP_SELF ?>">
  46. <table width = "400" border =" 0" cellspacing = "1"
  47. cellpadding = "2">
  48.  
  49. <tr>
  50. <td width = "100">UserID</td>
  51. <td><input name = "UserID" type = "int"
  52. id = "UserID"></td>
  53. </tr>
  54. <tr>
  55. <td width = "100">TableID</td>
  56. <td><input name = "TableID" type = "int"
  57. id = "TableID"></td>
  58. </tr>
  59. <tr>
  60. <td width = "100">life_points</td>
  61. <td><input name = "life_points" type = "int"
  62. id = "life_points"></td>
  63. </tr>
  64.  
  65. <tr>
  66. <td width = "100">xp_points</td>
  67. <td><input name = "xp_points" type = "int"
  68. id = "xp_points"></td>
  69. </tr>
  70.  
  71. <tr>
  72. <td width = "100"> </td>
  73. <td> </td>
  74. </tr>
  75.  
  76. <tr>
  77. <td width = "100"> </td>
  78. <td>
  79. <input name = "update" type = "submit"
  80. id = "update" value = "Update">
  81. </td>
  82. </tr>
  83.  
  84. </table>
  85. </form>
  86. <?php
  87. }
  88. ?>
  89.  
  90. </body>
  91. </html>
Add Comment
Please, Sign In to add comment