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, 674👍, 0💬
What Is HTML? HTML (HyperText Markup Language) is the standard markup language for creating Web page...
Where to find tutorials on how to use PHP built-in functions to manage arrays? A collection of tutor...
How To Use an Array as a Stack in PHP? A stack is a simple data structure that manages data elements...
How To Control Padding Spaces within a Table Cell? Cell padding spaces are spaces between cell inner...
How To Run a PHP Script? A standard alone PHP script can be executed directly with the PHP Command L...