Before we look at how to invoke stored programs using
PHP and the
mysqli extension, let’s
look at how we perform operations in PHP involving simple SQL
statements. These operations will form the foundation for using stored
programs in PHP. If you already feel very familiar with
mysqli, you might want to skip forward to
"Calling Stored Programs
with mysqli,” later in this chapter.
mysqli extension ships
as standard with PHP 5.0 and above, but you may need to enable it.
You do this by ensuring that
ext_mysqi is listed in the extensions
section of your php.ini file. The
ext_mysqli extension should be included in
your default php.ini file, but may be commented
out. In Windows, it can be found in the Windows extension section.
The relevant line will look something like this:
On Unix or Linux, the line should look like:
To connect to MySQL we first create an object representing a
connection using the
mysqli call takes arguments
containing the hostname, username, password, database, and port
) call will contain any error code associated with the
) will contain the error text.
In Example 13-1 we
create an object—
$mysqli—representing a MySQL connection,
and check for any error condition.
# Create a connection <?php $mysqli ...