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
- 4742 Views
- I also Faced
- E-Mail Answers
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 |
How to convert strings to upper or lower cases?
How do you debug php?
How to protect special characters in query string?
What are the Merits and De-Merits of CURL library ?
How to check whether cookies are disbled or not in the browser ? If that is the case how do you handle the sessions ?
How we get ip address of client, previous reference page etc?
what are the rules to be followed at the time of declaring a variable?,what is the purpose of var_dump()function in php,syntax of ternary operator()in php,difference between drop a table and truncate a table...
How can I make a script that can be bilingual (supports english, german)?
What is basic php?
What is php dependency injection?
difference of move(), and copy() function in php?
What are the differences between GET and POST methods in form submitting?
PHP 
