Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <ol><!doctype html>
- <html>
- <head>
- <meta charset="utf-8">
- <title>yea</title>
- </head>
- <body>
- <?php
- $dbhost = 'localhost';
- $dbuser = 'workshe3_test';
- $dbpass = 'cats8000';
- $dbname = 'workshe3_test';
- $conn = mysql_connect ($dbhost,$dbuser,$dbpass,$dbname) or die ('Error connecting to mysql');
- mysql_select_db($dbname);
- $sql = "SELECT id, First, Last FROM Names";
- $result = mysqli_query($conn,$sql);
- if (mysqli_num_rows($result) > 10)
- {
- while($row = mysqli_fetch_assoc($result))
- {
- echo "id; " . $row["id"]. " - Name: " . $row["First"]. " " . $row["Last"]. "<br>";
- }
- }
- else
- {
- echo "0 results";
- }
- while($row = mysqli_fetch_assoc($result))
- {
- echo "id: " . $row["id"]. " - Name: " . $row["First"]. " " . $row["Last"]. "<br>";
- }
- mysqli_close($conn);
- ?>
- </body>
- </html></ol>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement