PHP MySQL Connecting string
It is recommended by PHP.NET to use PDO_MySQL or MySQLI extensions. The old MySQL extension was deprecated in PHP 5.5.0 and was removed in PHP 7
This function takes three parameters, first one is hostname then user-id and them password. We can give the port number along with the hostname also.
MYSQLI MySQLI connection Here is the function to connect to mysql database
The above function will return true or false depending on the success of the connection. So we will add message to the above function like this.
Mysql_connect once establish the connection the link will be present till the script execution is over. It will close it self once the script execution is over or the function mysql_close() is called.
Connecting string with database selection. mysql_select_db() function We can create a connection string and database connections at one go. This is required where all over the script we are using one database so better to select the database just after the connection is established. Here is the code.
PHP MySQL Persistence ConnectionMysql_pconnect works same as mysql_connect with two differences. Mysql_pconnect function keeps the connection live even the script execution is over. It does not close the connection like mysql_connect case where it closes the connection once the script execution is over. The other difference is it tries to find any existing connection exists and return a identifier if exists.The main purpose of using mysql_pconnect function is to maintain a persistence connection to the mysql server. Function mysql_close() can't close persistent connection.
PHP PDO connection to MySQL Database ![]()
This article is written by plus2net.com team.
https://www.plus2net.com
![]() ![]() | ||||||||
| ||||||||