Sponsored Links

Interview Questions
Recommended Books












INTERVIEW QUESTIONS PROGRAMMING LANGUAGES PHP DETAILS
Question :

Difference between mysql_connect and mysql_pconnect.

Posted by: SUNIL on 5/27/2013

Contact SUNIL Contact SUNIL

Category PHP Interview Questions
Rating (3.8) By 76 users
Added on 5/27/2013
Views 795
Rate it!

Highly Recommended, Hand Picked PHP Books



Question :

Difference between mysql_connect and mysql_pconnect.


Answer:

Source: CoolInterview.com

There is a good page in the php manual on the subject, in short mysql_pconnect() makes a persistent connection to the database which means a SQL link that do not close when the execution of your script ends.
Source: CoolInterview.com



Posted by: neha chaudhary

Contact neha chaudhary Contact neha chaudhary

Source: CoolInterview.com

test
Source: CoolInterview.com



Posted by: ritesh

Contact ritesh Contact ritesh

Source: CoolInterview.com

mysql_connect()provides only for the databasenewconnection
while using mysql_pconnect , 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...
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.
Source: CoolInterview.com



Posted by: jay h thakkar

Contact jay h thakkar Contact jay h thakkar

Source: CoolInterview.com

That mean's You have a multiple page and same connection that time only one time connection create with pconnection.
other wise connection.
Source: CoolInterview.com



Posted by: Taher

Contact Taher Contact Taher

Source: CoolInterview.com

* mysql_pconnect() will try to find a connection that's already open, with the same host, username and password. If one is found, this will be returned instead of opening a new connection
* The connection will not be closed when the execution of the script ends (mysql_close() will not close connection opened by mysql_pconnect()). It will stay open for future use

Source: CoolInterview.com



Posted by: Rajesh

Contact Rajesh Contact Rajesh

Source: CoolInterview.com

mysql_pconnect ? Open 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'.

mysql_connect ? Open a connection to a MySQL Server

Opens or reuses a connection to a MySQL server.
Source: CoolInterview.com



Posted by: shruti patrawala

Contact shruti patrawala Contact shruti patrawala

Source: CoolInterview.com

mysql_connection must be closed, we can't use this to connect another database means it is suitable for only one database accessing..
mysql_pconnect means opens a persistent connection, with this we use same host name, username, and password. we can access different databases at a time in the same program. we can't close the connection.
Source: CoolInterview.com



Posted by: Venkata Rajesh Kumar Kona

Contact Venkata Rajesh Kumar Kona Contact Venkata Rajesh Kumar Kona

Source: CoolInterview.com

How can we close mysql_pconnect().
Source: CoolInterview.com



Posted by: Nibohs

Contact Nibohs Contact Nibohs

Source: CoolInterview.com

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'.
Source: CoolInterview.com



Posted by: SHIJITH

Contact SHIJITH Contact SHIJITH

Source: CoolInterview.com

what will happen if we dont close the mysql_close()in mysql_connect(),then what is the difference between pconnct and connect.
Source: CoolInterview.com



Posted by: praveen

Contact praveen Contact praveen

If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification Enter the above shown code: *
Inform me about updated answers to this question

Related Questions
View Answer
How do download in php ?
View Answer
How can I maintain the count of how many persons have hit my site?

View Answer
What is difference between require_once(), require(), include().
Becouse above three function usely use to call a file in another file.

View Answer
If you have to work with dates in the following format: "Tuesday, February 14, 2006 @ 10:39 am", how can you convert them to another format, that is easier to use?

View Answer
How do we know browser properties?

View Answer
How i will check that user is, logged in or not. i want to make it a function and i want to use in each page and after login i want to go in current page(same page. where i was working)


View Answer
How can i get ip address?

View Answer
What is difference between mysql_connect and mysql_pconnect




View Answer
What is the difference between echo and print statement?

View Answer
How i can make a chat page in php in simple

View Answer
What is difference between mysql_fetch_array(),mysql_fetch_row() and mysql_fetch_object()
please insert with example.
View Answer
How can I maintain the count of how many persons have hit my site?

View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View ALL PHP Interview Questions & Answers



User Options
India News Network

Latest 20 Questions
What are the Hadoop related Projects at Apache?
What are the modules included in Apache Hadoop Project?
What is Apache Hadoop?
What is a Private Cloud? Do we need one to handle Big Data?
How Can We Cope with the Impact of Big Data?
What skills do Big Data analysts need to have?
What does a Big Data analyst do?
What are some real-world examples of Big Data and how it is used?
What is Big Data Analytics?
Why Big Data is becoming so important?
What is the impact of Big Data on Sports Industry?
What is the impact of Big Data on Real estate Industry?
What is the impact of Big Data on Retail Banking Industry?
What is the impact of Big Data on Retail Industry?
What is the impact of Big Data on Technology Industry?
What is the impact of Big Data on Information Technology Industry?
What is the impact of Big Data on Internet of Things (IoT) Industry?
What is the impact of Big Data on Media Industry?
What is the impact of Big Data on Education Industry?
What is the impact of Big Data on Healthcare Industry?



Fresher Jobs | Experienced Jobs | Government Jobs | Walkin Jobs | Company Profiles | Interview Questions | Placement Papers | Companies In India | Consultants In India | Colleges In India | Exams In India | Latest Results | Notifications In India | Call Centers In India | Training Institutes In India | Job Communities In India | Courses In India | Jobs by Keyskills | Jobs by Functional Areas

Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes

Gate Articles | Gate Books | Gate Colleges | Gate Downloads | Gate Faqs | Gate Jobs | Gate News | Gate Sample Papers | Gate Training Institutes

MBA Articles | MBA Books | MBA Case Studies | MBA Business Schools | MBA Current Affairs | MBA Downloads | MBA Events | MBA Notifications | MBA FAQs | MBA Jobs
MBA Job Consultants | MBA News | MBA Results | MBA Courses | MBA Sample Papers | MBA Interview Questions | MBA Training Institutes

GRE Articles | GRE Books | GRE Colleges | GRE Downloads | GRE Events | GRE FAQs | GRE News | GRE Training Institutes | GRE Sample Papers

IAS Articles | IAS Books | IAS Current Affairs | IAS Downloads | IAS Events | IAS FAQs | IAS News | IAS Notifications | IAS UPSC Jobs | IAS Previous Question Papers
IAS Results | IAS Sample Papers | IAS Interview Questions | IAS Training Institutes | IAS Toppers Interview

SAP Articles | SAP Books | SAP Certifications | SAP Companies | SAP Study Materials | SAP Events | SAP FAQs | SAP Jobs | SAP Job Consultants
SAP Links | SAP News | SAP Sample Papers | SAP Interview Questions | SAP Training Institutes |




Copyright ©2003-2016 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions



Cache = 0.007812 Seconds