Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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



what is the best function that can be used to connect to mysql database and in what cases that we c..

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

Post New Answer

More PHP Interview Questions

How many open modes available when a file open in PHP?

0 Answers  


What is the advantage of runtime polymorphism?

0 Answers  


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()?

0 Answers  


How do I make a reset button in html?

0 Answers  


What is the purpose of the '.myi' file extension? What do thes file contain?

0 Answers  


What is the name of the scripting engine that powers PHP?

0 Answers  


What are the functions to be used to get the image's properties (size, width and height)?

0 Answers  


how many type of url?

1 Answers  


Why did you choose this particular career path?

0 Answers  


What is the use of the function 'imagetypes()'?

0 Answers  


how to change the div background color on every refresh..guys can u help me out.

3 Answers  


Categories