Difference between mysql_connect and mysql_pconnect in php?
Answers were Sorted based on User's Feedback
Answer / md amanullah
mysql_connect opens a normal connections to mysql database.
mysql_pconnect opens a persistant connection i.e. if there
is any connection open in the script it will use that
connection not making a new connection each time. at very
high traffic enviornment mysql_connect provides better
performance.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / aatit
The following are the differences -
- A new connection is established to the database by using
mysql_connect, where as mysql_pconnect opens a persistant
connection to the database.
- mysql_connect can be used to close the connection, where as
mysql_pconnect can not close the connection.
- Database is opened every time when the page is loaded by
mysql_connect. Whereas by using mysql_pconnect, database need
not be connected every time.
| Is This Answer Correct ? | 4 Yes | 0 No |
What does isset() function?
What does addslashes do in php?
With a heredoc syntax, do I get variable substitution inside the heredoc contents?
How many escape sequences are recognized in double-quoted strings in php?
How to Define a Constant in PHP? Is $ symbol necessary?
What is the actually used php version?
Is empty in php?
Which Scripting Engine PHP uses?
Where are the persistent cookies stored on your computer?
How to set a page as a home page in a php based site?
I created a cookie with the value like '1A2A',now i want to update this value regularly (about 20 times in a minute) with the value '1A2A3A' , 3A is the new value,new value will vary on the request it may be 3A or 4A or 100A ,some times the cookie is updating with new value but not every time.Can any body suggest the solution
how many types of error in PHP.