Advertisement
jumpy83

delete row from table

Mar 14th, 2016
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. <?php
  2. $con=mysqli_connect("localhost","root","","database");
  3. $query = "SELECT id,Titolo,Data FROM tabella ORDER BY id DESC";
  4. $dati=mysqli_query($con,$query);
  5. $riga=mysqli_num_rows($dati);
  6. while($row=mysqli_fetch_array($dati)){
  7. ?>
  8. <tr>
  9. <td class="first col-xs-8 col-sm-6 col-md-5 col-lg-6"><?php print $row['Titolo']; ?></td>
  10. <td class="hidden-xs hidden-sm col-md-3 col-lg-3">
  11. <?php
  12. $temp1= explode(" ", $row['Data']);
  13. $temp2= explode("-", $temp1[0]);
  14. $data_formattata=$temp2[2]."/".$temp2[1]."/".$temp2[0];
  15. print $data_formattata;
  16. ?>
  17. <td class="col-xs-3 col-sm-4 col-md-3 col-lg-2 align-right">
  18. <a href="#mdAdd1" data-toggle="modal" class="edit"><span class="fa fa-pencil" data-toggle="tooltip" data-placement="top" title="Modifica"></span></a>
  19. <a href="delete.php?id='.$row['id'].'" class="remove"><span class="fa fa-remove" data-toggle="tooltip" data-placement="top" title="Elimina"></span></a>
  20. </td>
  21. </tr>
  22. <?php } ?>
  23.  
  24.  
  25. <?php
  26. $con=mysqli_connect("localhost","root","","database");
  27.  
  28. $id = $_GET['id'];
  29.  
  30.  
  31. $query = "DELETE FROM tabella WHERE id=".$id."";
  32. $result = mysqli_query($con, $query);
  33.  
  34.  
  35. //header("Location: view.php");
  36.  
  37.  
  38.  
  39. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement