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