Storing Images in MySQL Revisited

By Quentin Zervaas, 13 March 2010 MySQL PHP Download PDF (1 comment)

Connecting to the Database

Let's now look at some PHP code to connect to the database. We're going to include this in a global PHP script that we'll include from other scripts.

In this code, we first try and connect to the database server. Once that connection is made we try and select our database. If either of these steps fails we output an error message and exit.

Listing 4 Connecting to the database (globals.php)

<?php
    $db = mysql_connect('localhost', 'phpriot_demo', 'phpriot123');
 
    if (!$db) {
        echo "Unable to establish connection to database server";
        exit;
    }
 
    if (!mysql_select_db('phpriot_demo', $db)) {
        echo "Unable to connect to database";
        exit;
    }
?>

We will include this script at the start of every other PHP script used in this article.

• Next: The Upload Form