PHP HOW Connect to a MySQL Database

The free MySQL Database is very often used with PHP. www.phpsu.com

Connecting to a MySQL Database

Before you can access and work with data in a database, you must create a connection to the database. www.phpsu.com

In PHP, this is done with the mysql_connect() function. welcome to phpsu.com

Syntax

mysql_connect(servername,username,password); 
http://www.phpsu.com
 

Note: There are more available parameters, but the ones listed above are the most important. Visit our full PHP MySQL Reference for more details.

welcome to phpsu.com

Example

In the following example we store the connection in a variable ($con) for later use in the script. The "die" part will be executed if the connection fails:

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  } phpsu.com 

// some code phpsu.com is a free phpscool 

?> 
phpsu is a phpschool
 

Closing a Connection

The connection will be closed as soon as the script ends. To close the connection before, use the mysql_close() function. phpsu is a phpschool

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  } 
phpsu.com
 

// some code phpsu提供的php教程 

mysql_close($con);
?> 
phpsu提供的php教程