Connection between PHP and MYSQL database _ MySQL-mysql tutorial

Links between PHP and MYSQL databases: bitsCN.com among the many functions in MYSQL database, there are two functions used to connect, namely, MysQL-connect () and MySQL _ pconnect (). Syntax:

Int MySQL-connect (string [hostname] (: [Port, string [username], string [password]) int MySQL _ pconnect (string [hostname] (: [Port, string [username], string [password]) after the connection is successful, both functions return a connection number. if the connection fails, return a false value. In the parameter, the host name (hostname) can contain the port number of the database service. The default port number is usually used. If all parameters are specified, the default host name is "localhost". The username is the database administrator. the default host name is "root" and the Password is blank.

When you use MysQL connect () to establish a connection, the established connection is automatically closed after the database operation is completed, unless the connection has been forcibly closed by MySQL-close () before this. MysQL-pconnect () automatically checks whether a connection is established using the same host name, user name, and password. If yes, the connection ID is used directly. In addition, using MySQL-pconnect () is a stable and persistent connection that will not be stopped because of the database operation. And will not be terminated by the function MySQL_commect.

Program example:

<? Php $ connect = MySQL_connect ('localhost', 'username', 'password ');

Echo "$ connect ";

?>

The program running result is: (1 ). This indicates that the program has been connected to the database.

Source: Jingan network http://host.zzidc.com/reprinted note

BitsCN.com