Tools, FAQ, Tutorials:
Connecting to a MySQL Server in PHP
How To Connect to MySQL from a PHP Script in PHP?
✍: FYIcenter.com
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
⇐ Information Needed for MySQL Connection in PHP
2016-10-20, 2301🔥, 0💬
Popular Posts:
Where to find tutorials on PHP language? I want to know how to learn PHP. Here is a large collection...
How To Convert a Character to an ASCII Value? If you want to convert characters to ASCII values, you...
How To Get the Minimum or Maximum Value of an Array in PHP? If you want to get the minimum or maximu...
How To Avoid the Undefined Index Error in PHP? If you don't want your PHP page to give out errors as...
How To Move Uploaded Files To Permanent Directory in PHP? PHP stores uploaded files in a temporary d...