Failed to connect to MySQL: ".mysqli_connect_error());
} else {
print "Connection successful
\n";
}
$query = << The query failed:".mysqli_error($mysqli));
} else {
$num_results = $result->num_rows;
}
print <<
returned $num_results tuples
EOHeader;
$idx = 1;
while($row = mysqli_fetch_assoc($result)) {
$lname = $row['lastname'];
$fname = $row['firstname'];
$address = $row['address'];
$sex = $row['sex'];
print <<$fname |
$lname |
$address |
$sex |
EOText;
$idx++;
}
print <<
EOFooter;
?>