| 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/query/ |
Upload File : |
<?php
require('application.php');
// Get some info from MyDB.
$sql = "SELECT id, firstname, lastname, CONCAT(firstname,' ',lastname) AS fullName FROM MyGuests";
?>
<h2>From MyDB</h2>
$sql = <pre><?=$sql?></pre>
<?php
$result = query_do($sql);
/** /
?>
$result = <pre><?=var_dump($result)?></pre>
<?php
/**/
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
?>
id: <?=$row["id"]?>, firstname: <?=$row["firstname"]?>, lastname: <?=$row["lastname"]?>, fullName: <?=$row["fullName"]?><br>
<?php
}
} else {
echo "0 results";
}
// Get some info from classicmodels. employeeNumber lastName firstName extension
$sql = "SELECT * FROM employees LIMIT 5;";
?>
<h2>From classicmodels</h2>
$sql = <pre><?=$sql?></pre>
<?php
$employeesResult = query_do($sql,'classicmodels');
if ($employeesResult->num_rows > 0) {
// output data of each row
while($row = $employeesResult->fetch_assoc()) {
?>
employeeNumber: <?=$row["employeeNumber"]?>, lastName: <?=$row["lastName"]?>, firstName: <?=$row["firstName"]?>, extension: <?=$row["extension"]?><br>
<?php
}
} else {
echo "0 results";
}
?>