You will learn the most from this tutorial if you attempt to follow the extra steps on your own before checking this sample solution.
<?php
/**
* Returns the welcome message associated with a message ID.
*
* This message is shown to the user when they first access the index
* page. It is meant as a welcoming message and can be personalised for
* each user.
*
* When writing documentation comments, start with a single line brief
* description, and if necessary provide additional details below.
* You should always document each parameter and the return value of
* a function unless it is an extremely simple function.
*
* @param integer $messageId ID of the message to select.
* @param mysqli $databaseLink Connection to database to query with.
* Must have SELECT access to the WelcomeMessage table.
* @return string Welcome message from the database. Empty string is
* returned if $messageId wasn't found in the database.
*/
function getWelcomeMessage(int $messageId, mysqli $databaseLink): string
{
$result = $databaseLink->query(
"SELECT Message FROM WelcomeMessage WHERE MessageID = $messageId;"
);
if (!empty($databaseLink->error) || $result->num_rows() == 0) {
// An error occurred during the query or there were no matching records.
// Return empty string.
return "";
}
return $result->fetch_assoc()["Message"];
}
?>
<html><body><?php
// Output the message to the user as HTML output.
$databaseLink = new mysqli("localhost", "root", "", "NeatTreats");
echo getWelcomeMessage(1, $databaseLink);
$databaseLink->close();
?></body></html>
Parent topic: Example 1
Top comments (0)