Connecting to a MySQL Server in PHP
How To Connect to MySQL from a PHP Script in PHP?
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
2016-10-20, 836👍, 0💬
How To Loop through an Array without Using "foreach" in PHP? PHP offers the following functions to a...
How To Run a PHP Script? A standard alone PHP script can be executed directly with the PHP Command L...
Where to find tutorials on how to create Your Own Functions in PHP? A collection of tutorials to ans...
How To Quote Date and Time Values in SQL Statements in PHP? If you want to provide date and time val...
Where to find tutorials on how to work with MySQL Database in PHP? A collection of tutorials to answ...