Home > Code Snippets > Connect to a MySQL database

Connect to a MySQL database

Description

A simple little function allowing you to connect to a MySQL database.

The code

<?php



/**

 * Edit the database settings to your own.

 * To use, just include the function and 

 * call it using <?php db_connect(); ?>

 *

 * You can then do your database queries

 */



// Edit your database settings

$db_host = "localhost";

$db_user = "username";

$db_pass = "password";

$db_name = "databasename";



function db_connect() {

    global $db_host;

    global $db_user;

    global $db_pass;

    global $db_name;

    $connection = mysql_connect($db_host,$db_user,$db_pass);

    if (!(mysql_select_db($db_name,$connection))) {

        echo "Could not connect to the database";

    }

    return $connection;

}



?>

Get the code

Download the file to your computer: Click here to get the file