Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("dati-mysql.php");
- $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="?id=<?php echo $row['id']; ?>#idDialog" 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=<?php echo $row['id']; ?>" onclick="return(confirm('Vuoi eliminare la comunicazione <?php echo $row['Titolo']; ?> del <?php echo $data_formattata ?>'))" class="remove"><span class="fa fa-remove" data-toggle="tooltip" data-placement="top" title="Elimina"></span></a>
- </td>
- </tr>
- <?php } ?>
- </tbody>
- </table>
- </div>
- </div>
- <br class="clearer" />
- </div>
- <div class="modal fade" id="idDialog" role="dialog" aria-labelledby="labelNew" aria-hidden="true">
- <div class="modal-dialog">
- <div class="modal-content">
- <div class="modal-header">
- <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true" class="fa fa-close"></span><span class="sr-only">Chiudi</span></button>
- <h4 class="modal-title" id="labelPrivacy">Form di modifica</h4>
- </div>
- <div class="modal-body">
- <div class="row">
- <form method="post" action="#">
- <?php
- include("dati-mysql.php");
- if (isset($_GET['id']) && is_numeric($_GET['id']))
- {
- $id = $_GET['id'];
- $query = "SELECT Titolo,Data FROM tabella WHERE id=".$id."";
- $result = mysqli_query($con, $query);
- $riga=mysqli_fetch_array($result);
- $Titolo=$riga['Titolo'];
- $Data=$riga['Data'];
- }
- else{
- exit();
- }
- ?>
- <div class="col-xs-12">
- <label for="titolo">Titolo</label>
- <input type="text" name="titolo" value="<?php echo $riga['Titolo'];?> "class="form-control field" />
- </div>
- <div class="col-xs-12">
- <label for="data">Data</label>
- <input type="text" name="data" value="<?php
- $temp1= explode(" ", $riga['Data']);
- $temp2= explode("-", $temp1[0]);
- $data_formattata=$temp2[2]."/".$temp2[1]."/".$temp2[0];
- print $data_formattata;
- ?>" class="form-control field" />
- </div>
- </div>
- </div>
- <div class="modal-footer">
- <button type="submit" class="btn btn-orange">Salva i dati</button>
- </div>
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement