Ski Areas
connect_error) {
echo "Oh, boy. Not connected.
";
die($conn->connect_error);
}
else
echo "Connection OK!
";
// finding ONE result
echo "
Finding one result
";
$myQuery = "SELECT elevation FROM eastern WHERE name='Loon'";
$result = $conn->query($myQuery);
// always check if you get a result
if (!$result) {
echo "Not in the database!
";
die($conn->error);
} else {
$obj = $result->fetch_object();
echo "Elevation of Loon is: $obj->elevation
";
}
echo "
Finding multiple results
";
// finding multiple results
$myQuery = "SELECT * FROM eastern";
$result = $conn->query($myQuery);
if (!$result) {
echo "More errors!
";
die($conn->error);
} else
for ($i = 0; $i < $result->num_rows; ++$i) {
$result->data_seek($i);
echo 'Name: ', $result->fetch_assoc ()['name'], '
';
$result->data_seek($i);
echo 'Elevation: ' , $result->fetch_assoc()['elevation'] , '
';
}
?>