Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Tutorial</title>
- </head>
- <body>
- <?php
- $servername = "mysql.ct8.pl";
- $username = "m2969_tutorial";
- $password = "Tutorial123";
- $dbname = "m2969_tutorial";
- $conn = new mysqli($servername, $username, $password, $dbname);
- if ($conn->connect_error) {die("Connection failed: " . $conn->connect_error);}
- $sql = "SELECT id, dane1, dane2, dane3, dane4, dane5 FROM test ORDER BY id DESC LIMIT 100"; //tu musisz dodać co ma odczytać
- $result = $conn->query($sql);
- if ($result->num_rows > 0) {
- echo '<table cellspacing="0" border="1" rules="rows" bordercolor="black">';
- echo '<tr>
- <td width="100px" bgcolor="silver" align="center">ID:</td>
- <td width="100px" bgcolor="gray" align="center">Dane1:</td>
- <td width="100px" bgcolor="silver" align="center">Dane2:</td>
- <td width="100px" bgcolor="gray" align="center">Dane3:</td>
- <td width="100px" bgcolor="silver" align="center">Dane4:</td>
- <td width="100px" bgcolor="gray" align="center">Dane5:</td> //i tutaj
- </tr>';
- while($row = $result->fetch_assoc()) {
- echo '<tr>
- <td bgcolor="silver" align="center">' . $row["id"]. '</td>
- <td bgcolor="gray" align="center">' . $row["dane1"].'</td>
- <td bgcolor="silver" align="center">' . $row["dane2"]. "</td>
- <td bgcolor="gray" align="center">' . $row["dane3"]. "</td>
- <td bgcolor="silver" align="center">' . $row["dane4"]. "</td>
- <td bgcolor="gray" align="center">' . $row["dane5"]. "</td> //i tutaj, wtedy powinno poprawnie działać wszystko :)
- </tr>";
- }
- echo "</table>";
- } else {
- echo "0 results";
- }
- $conn->close();
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement