what is the best function that can be used to connect to
mysql database and in what cases that we can use below
functions ?
1. mysql_connect()
2. mysql_pconnect()
please give your answer with all pros and cons
Answer / p.sivasankar
1>>mysql_connect() — Open a connection to a MySQL Server
Description:
resource mysql_connect ([ string $server [, string
$username [, string $password [, bool $new_link [, int
$client_flags ]]]]] )
Opens or reuses a connection to a MySQL server
2>>mysql_pconnect — Open a persistent connection to a MySQL
server
Description:
resource mysql_pconnect ([ string $server [, string
$username [, string $password [, int $client_flags ]]]] )
Establishes 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'
Is This Answer Correct ? | 7 Yes | 0 No |
I am writing an application in php that outputs a printable version of driving directions. It contains some long sentences, and I am a neat freak, and would like to make sure that no line exceeds 50 characters. How do I accomplish that with php?
How to differentiate isset and empty
6 Answers A1 Technology, Dass Infotech, Microface,
Does exist in php?
Explain the changes in php versions?
difference of move(), and copy() function in php?
What is advanced php programming?
What is a php session?
What is pdo in php why use?
Tell me how do you execute a php script from the command line?
What is the difference between explode() and split() functions?
Explain me what is the importance of "method" attribute in a html form?
What is "print" in php?