PHP MySQL Connectivity - MySQL Constraints - Phptpoint.com

PHP MySQL Connectivity

/ins>

PHP Mysql connectivity

Use the mysql_connect( ) function to established connection to the MySQL server.

To access the database functionality we have to make a connection to database using Php.
mysql_connect() function is used to establish the connection to mysql server.
four arguments need to be passed to mysql_connect() function.

hostname : if you are working on local system , you can use localhost or you can also provide ip address or server name
username : if there is a existing user , you can provide username. default username is ‘root’.
password : by default password is blank or null.
dbname : it is a optional field . it is basically a name of the database that need to be connected.

Parameter Description
host(Server name) Either a host name(server name) or an IP address
username The MySQL user name
password The password to log in with
dbname Optional. The database to be used when performing queries

 

Note : There are more available parameters, but the ones listed above are the most important.

In the following example we store the connection in a variable ($con) for later use in the script

Here localhost is server name. root is MySQL default user name. default password is blank and database name is my_db. mysql_error( ) function provides mysql connectivity error message.

MySQL Close Connection

after work with the database is done we have to close the connection using mysql_close() function
in which the connection to the database is passed.