Advertisement
jumpy83

edit row

Mar 16th, 2016
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.73 KB | None | 0 0
  1. <?php
  2. include("dati-mysql.php");
  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="?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>
  19. <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>
  20. </td>
  21. </tr>
  22. <?php } ?>
  23.  
  24. </tbody>
  25. </table>
  26. </div>
  27. </div>
  28. <br class="clearer" />
  29. </div>
  30.  
  31. <div class="modal fade" id="idDialog" role="dialog" aria-labelledby="labelNew" aria-hidden="true">
  32.  
  33. <div class="modal-dialog">
  34. <div class="modal-content">
  35. <div class="modal-header">
  36. <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true" class="fa fa-close"></span><span class="sr-only">Chiudi</span></button>
  37. <h4 class="modal-title" id="labelPrivacy">Form di modifica</h4>
  38. </div>
  39. <div class="modal-body">
  40. <div class="row">
  41.  
  42. <form method="post" action="#">
  43. <?php
  44. include("dati-mysql.php");
  45. if (isset($_GET['id']) && is_numeric($_GET['id']))
  46. {
  47. $id = $_GET['id'];
  48. $query = "SELECT Titolo,Data FROM tabella WHERE id=".$id."";
  49. $result = mysqli_query($con, $query);
  50. $riga=mysqli_fetch_array($result);
  51. $Titolo=$riga['Titolo'];
  52. $Data=$riga['Data'];
  53. }
  54. else{
  55. exit();
  56. }
  57. ?>
  58. <div class="col-xs-12">
  59. <label for="titolo">Titolo</label>
  60. <input type="text" name="titolo" value="<?php echo $riga['Titolo'];?> "class="form-control field" />
  61. </div>
  62. <div class="col-xs-12">
  63. <label for="data">Data</label>
  64. <input type="text" name="data" value="<?php
  65. $temp1= explode(" ", $riga['Data']);
  66. $temp2= explode("-", $temp1[0]);
  67. $data_formattata=$temp2[2]."/".$temp2[1]."/".$temp2[0];
  68. print $data_formattata;
  69. ?>" class="form-control field" />
  70. </div>
  71.  
  72. </div>
  73. </div>
  74. <div class="modal-footer">
  75. <button type="submit" class="btn btn-orange">Salva i dati</button>
  76. </div>
  77. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement