Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2018
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 1.68 KB | None | 0 0
  1. <html>
  2.     <head>
  3.         <title>Tutorial</title>
  4.     </head>
  5.     <body>
  6.         <?php
  7.         $servername = "mysql.ct8.pl";
  8.         $username = "m2969_tutorial";
  9.         $password = "Tutorial123";
  10.         $dbname = "m2969_tutorial";
  11.         $conn = new mysqli($servername, $username, $password, $dbname);
  12.         if ($conn->connect_error) {die("Connection failed: " . $conn->connect_error);}
  13.         $sql = "SELECT id, dane1, dane2, dane3, dane4, dane5 FROM test ORDER BY id DESC LIMIT 100"; //tu musisz dodać co ma odczytać
  14.         $result = $conn->query($sql);
  15.         if ($result->num_rows > 0) {
  16.             echo '<table cellspacing="0" border="1" rules="rows" bordercolor="black">';
  17.             echo '<tr>
  18.                     <td width="100px" bgcolor="silver" align="center">ID:</td>
  19.                     <td width="100px" bgcolor="gray" align="center">Dane1:</td>
  20.                     <td width="100px" bgcolor="silver" align="center">Dane2:</td>
  21.                     <td width="100px" bgcolor="gray" align="center">Dane3:</td>
  22.                     <td width="100px" bgcolor="silver" align="center">Dane4:</td>
  23.                     <td width="100px" bgcolor="gray" align="center">Dane5:</td> //i tutaj
  24.                 </tr>';
  25.             while($row = $result->fetch_assoc()) {
  26.                 echo '<tr>
  27.                         <td bgcolor="silver" align="center">' . $row["id"]. '</td>
  28.                         <td bgcolor="gray" align="center">' . $row["dane1"].'</td>
  29.                         <td bgcolor="silver" align="center">' . $row["dane2"]. "</td>
  30.                         <td bgcolor="gray" align="center">' . $row["dane3"]. "</td>
  31.                         <td bgcolor="silver" align="center">' . $row["dane4"]. "</td>
  32.                         <td bgcolor="gray" align="center">' . $row["dane5"]. "</td> //i tutaj, wtedy powinno poprawnie działać wszystko :)
  33.                     </tr>";
  34.             }
  35.             echo "</table>";
  36.         } else {
  37.             echo "0 results";
  38.         }
  39.         $conn->close();
  40.         ?>
  41.     </body>
  42. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement