Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <body>
- <h2>Usuwanie Rekordu</h2>
- <form action="usuw2.php" method="post">
- <table>
- <tr>
- <td>ID:</td>
- <td><input type="text" name="ID" id="ID" ></td>
- </tr>
- <tr>
- <td>Nacja:</td>
- <td><input type="text" name="Nacja" id="Nacja" ></td>
- </tr>
- <tr>
- <td>LiczbaPkt:</td>
- <td><input type ="text" name="LiczbaPkt" id="LiczbaPkt"></td>
- </tr>
- <tr>
- <td><input name="delete" type="submit" id="dodaj"
- value="Usun Rekord"></td>
- </tr>
- </table>
- </form>
- </body>
- </html>
- <?php
- // php code to Delete data from mysql database
- if(isset($_POST['delete']))
- {
- $hostname = "localhost";
- $username = "root";
- $password = "";
- $databaseName = "kluby ranking";
- // get id to delete
- $ID=$_POST["ID"];
- $Nacja=$_POST["Nacja"];
- $LiczbaPkt=$_POST["LiczbaPkt"];
- // connect to mysql
- $connect = mysqli_connect($hostname, $username, $password, $databaseName);
- // mysql delete query
- $query = "DELETE FROM `europa` WHERE `ID ,Nacja, LiczbaPkt` = $ID,$Nacja,$LiczbaPkt";
- $result = mysqli_query($connect, $query);
- if($result)
- {
- echo 'Data Deleted';
- }else{
- echo 'Data Not Deleted';
- }
- mysqli_close($connect);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement