How to connect to MySQL database using PHP

Zend Tutorial

Use the PHP mysql_connect() function to open a new connection to the MySQL server.

Before we can access data in a database, we must open a connection to the MySQL.

In PHP, this is done with the mysql_connect() function.



$username = “your_name”;
$password = “your_password”;
$hostname = “localhost”;

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die(“Unable to connect to MySQL”);
echo “Connected to MySQL<br>”;

All going well, you should see “Connected to MySQL” when you run this script. If you can’t connect to the server, make sure your password, username and hostname are correct.

Once you’ve connected, you’re going to want to select a database to work with. Let’s assume the database is called ‘examples’. To start working in this database, you’ll need the mysql_select_db() function:

//select a database to work with
$selected = mysql_select_db(“examples”,$dbhandle)
or die(“Could not select examples”);


View original post 37 more words


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s