Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4660 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is var_dump?
How do you put a space in html?
Can we use include ("xyz.php") two times in a php page "index.php"?
Which php mvc framework is best?
How do I check if a given variable is empty?
Which function is used in php to check the data type of any variable?
What is PHP's configuration file called?
What is the difference between pop3 IMAP and MAPI?
What are the uses of php language?
Explain me what is the use of 'print' in php?
Do csrf tokens expire?
What types of loops exist in php?
What is the Default syntax used in PHP?
Explain how is it possible to cast types in php?
How do we get the current session id?
