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.

Syntax

mysql_connect(host,username,password,dbname);

<?php
$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:

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

Finally…

View original post 37 more words

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s