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 |
How many open modes available when a file open in PHP?
What is the advantage of runtime polymorphism?
How can we know that a session is started or not?
3 Answers Rushmore Consultancy,
What is the functionality of the functions strstr() and stristr()?
How do I make a reset button in html?
What is the purpose of the '.myi' file extension? What do thes file contain?
What is the name of the scripting engine that powers PHP?
What are the functions to be used to get the image's properties (size, width and height)?
how many type of url?
Why did you choose this particular career path?
What is the use of the function 'imagetypes()'?
how to change the div background color on every refresh..guys can u help me out.