Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $con=mysqli_connect("localhost","root","","database");
- $query = "SELECT id,Titolo,Data FROM tabella ORDER BY id DESC";
- $dati=mysqli_query($con,$query);
- $riga=mysqli_num_rows($dati);
- while($row=mysqli_fetch_array($dati)){
- ?>
- <tr>
- <td class="first col-xs-8 col-sm-6 col-md-5 col-lg-6"><?php print $row['Titolo']; ?></td>
- <td class="hidden-xs hidden-sm col-md-3 col-lg-3">
- <?php
- $temp1= explode(" ", $row['Data']);
- $temp2= explode("-", $temp1[0]);
- $data_formattata=$temp2[2]."/".$temp2[1]."/".$temp2[0];
- print $data_formattata;
- ?>
- <td class="col-xs-3 col-sm-4 col-md-3 col-lg-2 align-right">
- <a href="#mdAdd1" data-toggle="modal" class="edit"><span class="fa fa-pencil" data-toggle="tooltip" data-placement="top" title="Modifica"></span></a>
- <a href="delete.php?id='.$row['id'].'" class="remove"><span class="fa fa-remove" data-toggle="tooltip" data-placement="top" title="Elimina"></span></a>
- </td>
- </tr>
- <?php } ?>
- <?php
- $con=mysqli_connect("localhost","root","","database");
- $id = $_GET['id'];
- $query = "DELETE FROM tabella WHERE id=".$id."";
- $result = mysqli_query($con, $query);
- //header("Location: view.php");
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement