Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
- <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
- <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
- </head>
- <body>
- <?php
- if(isset($_POST['update'])) {
- $dbhost = 'localhost';
- $dbuser = 'root';
- $dbpass = '';
- $dbname = "s86884_jonatan2";
- $conn = mysql_connect($dbhost, $dbuser, $dbpass, $dbname);
- if(! $conn ) {
- die('Could not connect: ' . mysql_error());
- }
- $ID_Cena = $_POST['ID_Cena'];
- $Aktualna_Od = $_POST['Aktualna_Od'];
- $Aktualna_Do = $_POST['Aktualna_Do'];
- $Cena = $_POST['Cena'];
- $sql = "UPDATE tcena SET Aktualna_Od =DATE'$Aktualna_Od', Aktualna_Do =DATE'$Aktualna_Do', Cena = '$Cena'
- WHERE ID_Cena = $ID_Cena ";
- mysql_select_db('s86884_jonatan2');
- $retval = mysql_query( $sql, $conn );
- if(! $retval ) {
- die('Could not update data: ' . mysql_error());
- }
- echo "Updated data successfully\n";
- mysql_close($conn);
- }else {
- ?>
- <form method = "post" action = "<?php $_PHP_SELF ?>">
- <table width = "400" border =" 0" cellspacing = "1"
- cellpadding = "2" align = center>
- <tr>
- <td width = "100">ID_Cena: </td>
- <td><input name = "ID_Cena" type = "text"
- id = "ID_Cena"></td>
- </tr>
- <tr>
- <td width = "100">Aktualna_Od: </td>
- <td><input name = "Aktualna_Od" type = "text"
- id = "Aktualna_Od"></td>
- </tr>
- <tr>
- <td width = "100">Aktualna_Do: </td>
- <td><input name = "Aktualna_Do" type = "text"
- id = "Aktualna_Do"></td>
- </tr>
- <tr>
- <td width = "100">Cena</td>
- <td><input name = "Cena" type = "text"
- id = "Cena"></td>
- </tr>
- <tr>
- <td width = "100"> </td>
- <td> </td>
- </tr>
- <tr>
- <td width = "100"> </td>
- <td>
- <input name = "update" type = "submit"
- id = "update" value = "Update">
- </td>
- </tr>
- </table>
- </form>
- <?php
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement