Advertisement
Guest User

Untitled

a guest
May 31st, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.25 KB | None | 0 0
  1. <html>
  2.  
  3. <head>
  4. <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
  5. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
  6. <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
  7. <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
  8. </head>
  9.  
  10. <body>
  11. <?php
  12. if(isset($_POST['update'])) {
  13. $dbhost = 'localhost';
  14. $dbuser = 'root';
  15. $dbpass = '';
  16. $dbname = "s86884_jonatan2";
  17.  
  18. $conn = mysql_connect($dbhost, $dbuser, $dbpass, $dbname);
  19.  
  20. if(! $conn ) {
  21. die('Could not connect: ' . mysql_error());
  22. }
  23.  
  24. $ID_Cena = $_POST['ID_Cena'];
  25. $Aktualna_Od = $_POST['Aktualna_Od'];
  26. $Aktualna_Do = $_POST['Aktualna_Do'];
  27. $Cena = $_POST['Cena'];
  28.  
  29. $sql = "UPDATE tcena SET Aktualna_Od =DATE'$Aktualna_Od', Aktualna_Do =DATE'$Aktualna_Do', Cena = '$Cena'
  30. WHERE ID_Cena = $ID_Cena ";
  31. mysql_select_db('s86884_jonatan2');
  32. $retval = mysql_query( $sql, $conn );
  33.  
  34. if(! $retval ) {
  35. die('Could not update data: ' . mysql_error());
  36. }
  37. echo "Updated data successfully\n";
  38.  
  39. mysql_close($conn);
  40. }else {
  41. ?>
  42. <form method = "post" action = "<?php $_PHP_SELF ?>">
  43. <table width = "400" border =" 0" cellspacing = "1"
  44. cellpadding = "2" align = center>
  45.  
  46. <tr>
  47. <td width = "100">ID_Cena: </td>
  48. <td><input name = "ID_Cena" type = "text"
  49. id = "ID_Cena"></td>
  50. </tr>
  51.  
  52. <tr>
  53. <td width = "100">Aktualna_Od: </td>
  54. <td><input name = "Aktualna_Od" type = "text"
  55. id = "Aktualna_Od"></td>
  56. </tr>
  57.  
  58. <tr>
  59. <td width = "100">Aktualna_Do: </td>
  60. <td><input name = "Aktualna_Do" type = "text"
  61. id = "Aktualna_Do"></td>
  62. </tr>
  63.  
  64. <tr>
  65. <td width = "100">Cena</td>
  66. <td><input name = "Cena" type = "text"
  67. id = "Cena"></td>
  68. </tr>
  69.  
  70. <tr>
  71. <td width = "100"> </td>
  72. <td> </td>
  73. </tr>
  74.  
  75. <tr>
  76. <td width = "100"> </td>
  77. <td>
  78. <input name = "update" type = "submit"
  79. id = "update" value = "Update">
  80. </td>
  81. </tr>
  82.  
  83. </table>
  84. </form>
  85. <?php
  86. }
  87. ?>
  88.  
  89. </body>
  90. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement