Advertisement
Guest User

Untitled

a guest
Jan 27th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. <html>
  2. <td><input type="submit" value="Atgal" <a href="#" onclick="history.back();"></a></td>
  3. <?php
  4. //Error report
  5. ini_set('display_errors', true);
  6. error_reporting(-1);
  7.  
  8. //Login
  9. $servername = "localhost";
  10. $username = "PG4104KT";
  11. $password = "jkm_PG4104KT";
  12. $table = "skaityotjas";
  13. //Connect
  14. $conn = new mysqli($servername, $username, $password);
  15.  
  16. //Check connection
  17. if ($conn->connect_error) {
  18. die("Connection failed: " . $conn->connect_error);
  19. }
  20.  
  21. //IF failed
  22. if (!$conn->select_db('PG4104KT')) {
  23. die("Connection failed: " . $conn->connect_error);
  24. }
  25.  
  26. //Istraukimas is mysql
  27. $result = mysqli_query($conn, "SELECT * FROM skaitytojas");
  28.  
  29. //Duomenu ismetimas
  30. echo "<h1>Duomenys</h1>";
  31. while($row = mysqli_fetch_assoc($result)){
  32. echo "id: " . $row["id"]. " Vardas " . $row["vardas"]. " Adresas " . $row["adresas"]. " Telefono nr " . $row["tel"]. "<td><a href='trinti.php?id=".$row["id"]."' > trinti </a></td><br>";
  33. }
  34.  
  35.  
  36.  
  37.  
  38.  
  39.  
  40.  
  41.  
  42.  
  43.  
  44.  
  45.  
  46.  
  47. <html>
  48.  
  49. <?php
  50. //Error report
  51. ini_set('display_errors', true);
  52. error_reporting(-1);
  53. //Login
  54. $servername = "localhost";
  55. $username = "PG4104KT";
  56. $password = "jkm_PG4104KT";
  57. //Connect
  58. $conn = new mysqli($servername, $username, $password);
  59. //Check connection
  60. if ($conn->connect_error) {
  61. die("Connection failed: " . $conn->connect_error);
  62. }
  63.  
  64. if (!$conn->select_db('PG4104KT')) {
  65. die("Connection failed: " . $conn->connect_error);
  66. }
  67. $id = $_GET['id'];
  68. mysqli_query($conn,"DELETE FROM skaitytojas WHERE id=".$id);
  69. header("Location: rezultatai1.php");
  70.  
  71.  
  72. ?>
  73.  
  74. </html>
  75.  
  76.  
  77.  
  78.  
  79.  
  80. ?>
  81.  
  82. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement