Advertisement
Guest User

Untitled

a guest
Apr 24th, 2013
5,274
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.13 KB | None | 0 0
  1.  <?php
  2.  
  3. $dbc = mysqli_connect('localhost', 'root', '', 'moja_baza') or die('Error connecting to MySQL server.');
  4.  
  5.               $query = "SELECT * FROM tablica";
  6.             $result = mysqli_query($dbc, $query);
  7.  
  8.  
  9.  
  10. echo "
  11. <table border=\"5\" cellpadding=\"5\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#808080\" width=\"100&#37;\" id=\"AutoNumber2\" bgcolor=\"#C0C0C0\"><tr>
  12. <td width=25>Ime:</td>
  13. <td width=25>Prezime:</td>
  14. <td width=25>Grad:</td>
  15. <td width=25>Drzava:</td>
  16. <td width=25>Obavijesti:</td>
  17. <td width=50>Tekst:</td>
  18. <td width=25>Action:</td>
  19.  
  20. </tr>";
  21.  
  22.  
  23.  echo '<form action="obrisi.php" method="post">';  
  24.  
  25. $i=0;
  26.  
  27. while ($row = mysqli_fetch_array($result) )
  28. {
  29.  
  30. $id = $row['id'];
  31.  
  32. echo "<tr>";
  33. echo "<td>" . $row['Ime'] . "</td>";
  34. echo "<td>" . $row['Prezime'] . "</td>";
  35. echo "<td>" . $row['Grad'] . "</td>";
  36. echo "<td>" . $row['Drzava'] . "</td>";
  37. echo "<td>" . $row['Obavijesti'] . "</td>";
  38. echo "<td>" . $row['Tekst'] . "</td>";
  39. echo  "<td>" . " <input type='submit' id= '$id' . ' value='Delete' >" .  "</td>";
  40. print "</tr>";
  41. }
  42.  
  43. print "</table>";
  44.          
  45.  
  46. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement