Connecting to a MySQL Server in PHP

Q

How To Connect to MySQL from a PHP Script in PHP?

✍: FYIcenter.com

A

If you want access the MySQL server, you must create a connection object first by calling the mysql_connect() function in the following format:

$con = mysql_connect($server, $username, $password);

If you are connecting to a local MySQL server, you don't need to specify username and password. If you are connecting to a MySQL server offered by your Web hosting company, they will provide you the server name, username, and password.

The following script shows you how to connect to a local MySQL server, obtained server information, and closed the connection:

<?php
  $con = mysql_connect('localhost');
  print(mysql_get_server_info($con)."\n");
  print(mysql_get_host_info($con)."\n");
  mysql_close($con); 
?>

If you run this script, you will get something like this:

5.0.2-alpha
localhost via TCP/IP

 

Working with MySQL Database in PHP

⇒⇒PHP Tutorials

2016-10-20, 674👍, 0💬