Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <?php
- echo "<h2>Lista Autori</h2>";
- echo "<table border='1' style='border-collapse: collapse;border-color: silver;'>";
- echo "<tr style='font-weight: bold;'>";
- echo "<td width='auto' > Autore</td>";
- echo "<td width='auto' > Titolo</td>";
- echo "</tr>";
- //1. Connessione al Database
- $connection = mysql_connect("localhost","root","");
- if(!$connection){
- die("Database connection failed: " . mysql_error());
- }
- //2. Seleziona Database
- $db_select = mysql_select_db("forms1",$connection);
- if (!$db_select) {
- die("Database connection failed: " . mysql_error());
- }
- //3. Interroga Database
- $result = mysql_query("SELECT * FROM demo ORDER BY Autore, Titolo", $connection);
- if (!$result) {
- die("Database query failed: " . mysql_error());
- }
- //4. Use Returned Data
- while ($row = mysql_fetch_array($result))
- {
- echo "<tr>";
- echo "<td width='auto'>" . " " . $row[1] . " " . "</td>";
- echo "<td width='auto'>" . " " . $row[2] . " " . "</td>";
- echo "</tr>";
- }
- mysql_close($connection);
- ?>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement