Failed to connect to MySQL: ".mysqli_connect_error());
} else {
print "Connection successful
\n";
}
$query = <<prepare($query)) {
$stmt->bind_param("s",$fname);
$stmt->execute();
$stmt->bind_result($fname,$lname,$address,$sex);
print <<
EOHeader;
while($stmt->fetch()) {
print <<| $fname |
$lname |
$address |
$sex |
EOText;
}
$stmt->close();
print <<
EOFooter;
}
$query = <<query($query);
print <<
EOHeader;
while($row = $result->fetch_assoc()) {
$fname = $row["firstname"];
$lname = $row["lastname"];
$address = $row["address"];
$sex = $row["sex"];
print <<| $fname |
$lname |
$address |
$sex |
EOText;
}
print <<
EOFooter;
?>