functions.php
Letâs jump right into the project, starting with Example 21-1, functions.php, the include file of main functions. This file contains a little more than just the functions, though, because I have added the database login details here instead of using yet another separate file.
The first half-dozen lines of code define the host, database name,
username, and password of the database to use. It doesnât matter what you
call the database, as long as it already exists (see Chapter 8 for how to create a new database). Also
make sure to correctly assign a MySQL username and password to $dbuser
and $dbpass
. With correct values, the subsequent two
lines will open a connection to MySQL and select the database. The last of
the initial instructions sets the name of the social networking site by
assigning the value âRobinâs Nestâ to the variable $appname
. If you want to change the name, hereâs
the place to do so.
The Functions
The project uses five main functions:
createTable
Checks whether a table already exists and, if not, creates it.
queryMysql
Issues a query to MySQL, outputting an error message if it fails.
destroySession
Destroys a PHP session and clears its data to log users out.
sanitizeString
Removes potentially malicious code or tags from user input.
showProfile
Displays a userâs image and âabout meâ message, if he has one.
All of these should be obvious in their action to you by now, with
the possible exception of showProfile
, which looks for an image of the name ...
Get Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.