INTERVIEW QUESTIONS PROGRAMMING LANGUAGES PHP DETAILS

Question: Difference between mysql_connect and mysql_pconnect.

Answer: There is a good page in the php manual on the subject, in short mysql_pconnect() makes a persistent connection to the database which means a SQL link that do not close when the execution of your script ends.

There is a good page in the php manual on the subject, in short mysql_pconnect() makes a persistent connection to the database which means a SQL link that do not close when the execution of your script ends. Source: CoolInterview.com

test Source: CoolInterview.com

mysql_connect()provides only for the databasenewconnection
while using mysql_pconnect , the function would first try to
find a (persistent) link that's already open with the same
host, username and password. If one is found, an identifier
for it will be returned instead of opening a new connection...
the connection to the SQL server will not be closed when the
execution of the script ends. Instead, the link will remain
open for future use. Source: CoolInterview.com

That mean's You have a multiple page and same connection that time only one time connection create with pconnection.
other wise connection. Source: CoolInterview.com

* mysql_pconnect() will try to find a connection that's already open, with the same host, username and password. If one is found, this will be returned instead of opening a new connection
* The connection will not be closed when the execution of the script ends (mysql_close() will not close connection opened by mysql_pconnect()). It will stay open for future use
Source: CoolInterview.com

mysql_pconnect — Open a persistent connection to a MySQL server

mysql_pconnect() acts very much like mysql_connect() with two major differences.

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.

Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mysql_close() will not close links established by mysql_pconnect()).

This type of link is therefore called 'persistent'.

mysql_connect — Open a connection to a MySQL Server

Opens or reuses a connection to a MySQL server. Source: CoolInterview.com

mysql_connection must be closed, we can't use this to connect another database means it is suitable for only one database accessing..
mysql_pconnect means opens a persistent connection, with this we use same host name, username, and password. we can access different databases at a time in the same program. we can't close the connection. Source: CoolInterview.com

How can we close mysql_pconnect(). Source: CoolInterview.com

mysql_pconnect() acts very much like mysql_connect() with two major differences.

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.

Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mysql_close() will not close links established by mysql_pconnect()).

This type of link is therefore called 'persistent'. Source: CoolInterview.com

what will happen if we dont close the mysql_close()in mysql_connect(),then what is the difference between pconnct and connect. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question