| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST1146/Resources/Examples/Week/13/lab/ |
Upload File : |
<?php
$servername = "localhost";
$username = "root";
$password = "bogus";
$dbname = "myDB";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$id = 4;
$sql = "
SELECT *
FROM myguests
WHERE id = ".$id."
";
?>
<h2>One guest</h2>
$sql = <pre><?=$sql?></pre>
<?php
$result = $conn->query($sql);
if ($result->num_rows > 0) {
?>
$result = <pre><?=var_dump($result)?></pre>
<?php
// output data of each row
while($row = $result->fetch_assoc()) {
?>
id: <?=$row["id"]?><br> firstname: <?=$row["firstname"]?><br> lastname: <?=$row["lastname"]?><br> email: <?=$row["email"]?><br> reg_date: <?=$row["reg_date"]?><br>
<?php
}
} else {
echo "0 results";
}
mysqli_close($conn);
?>