Advertisement
Guest User

Untitled

a guest
Dec 17th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.16 KB | None | 0 0
  1. <html>
  2. <head>
  3. <style type="text/css">
  4. td{
  5. border-style:solid;
  6. border-width:2px;
  7. }
  8. </style>
  9. <meta charset="utf-8">
  10.  
  11. <?php
  12.  
  13. $connect = new mysqli('localhost', 'root', '', '3tia');
  14.  
  15. if($connect->connect_error)
  16. {
  17. echo "wystapil blad : "." ".$connect->connect_error;
  18.  
  19. echo "kod bledu: "." ".$connect->connect_errno;
  20. }else{
  21. if(ISSET($GET['parametr']))
  22. {
  23.  
  24. $query2 = "SET CHARSET utf8";
  25.  
  26. if($GET['parametr']='wyswietl')
  27. {
  28.  
  29.  
  30. $query="SELECT * FROM pytania";
  31. $connect->query($query2);
  32. $result = $connect->query($query);
  33.  
  34. echo <<<alias
  35. <table style='border-style: solid; border-width: "3px";' >
  36. <tr>
  37. <td>Lp</td>
  38. <td>Treść</td>
  39. <td>Odpa</td>
  40. <td>Odpb</td>
  41. <td>Odpc</td>
  42. <td>Odpd</td>
  43. <td>Odpowiedz</td>
  44. <td>Kategoria</td>
  45. <td>Rok</td>
  46. <td>Usuń</td>
  47. </tr>
  48.  
  49. alias;
  50. while($row=$result->fetch_object())
  51. {
  52. echo "<tr>";
  53. //while($i<1)
  54. // {
  55. echo "<td>";
  56. echo $row->id;
  57. echo "</td>";
  58. echo "<td>";
  59. echo $row->tresc;
  60. echo "</td>";
  61. echo "<td>";
  62. echo $row->odpa;
  63. echo "</td>";
  64. echo "<td>";
  65. echo $row->odpb;
  66. echo "</td>";
  67. echo "<td>";
  68. echo $row->odpc;
  69. echo "</td>";
  70. echo "<td>";
  71. echo $row->odpd;
  72. echo "</td>";
  73. echo "<td>";
  74. echo $row->odpowiedz;
  75. echo "</td>";
  76. echo "<td>";
  77. echo $row->kategoria;
  78. echo "</td>";
  79. echo "<td>";
  80. echo $row->rok;
  81. echo "</td>";
  82. echo <<< html1
  83.  
  84. <td>
  85.  
  86. <form method='GET'>
  87. <input type='hidden' name='iddel' value="$row->id">
  88. <input type='submit' value='usuń'>
  89. </form>
  90.  
  91. </td>
  92.  
  93. html1;
  94. echo "<tr>";
  95. }
  96. echo "</table>";
  97. }
  98. }
  99. }
  100.  
  101. $connect->close();
  102.  
  103.  
  104.  
  105. ?>
  106.  
  107.  
  108.  
  109. </head>
  110. <body>
  111. <a href="test.php?parametr=wyswietl">wyswietlanie</a>
  112. <a href="form_dodaj.html">dodaj</a>
  113. </body>
  114.  
  115. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement