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, 2317🔥, 0💬
Popular Posts:
How To Read the Entire File into a Single String in PHP? If you have a file, and you want to read th...
What is EPUB 2.0 Metadata "dc:publisher" and "dc:rights" elements? EPUB 2.0 Metadata "dc:publisher" ...
How to troubleshoot the Orderer peer? The Docker container terminated by itself. You can follow this...
How To Remove Slashes on Submitted Input Values in PHP? By default, when input values are submitted ...
FYIcenter JSON Validator and Formatter is an online tool that checks for syntax errors of JSON text ...