CoolInterview.com - World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • INTERVIEW QUESTIONS LANGUAGES PHP DETAILS
    Question :
    Difference between mysql_connect and mysql_pconnect?

    Posted by: SUNIL on 5/27/2008

    Contact SUNIL Contact SUNIL
    Category PHP Interview Questions
    Rating (0.4) By 1976 users
    Added on 5/27/2008
    Views 2197
    Rate it!
    Answers:

    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.



    Posted by: neha chaudhary    

    Contact neha chaudhary Contact neha chaudhary

    test



    Posted by: ritesh    

    Contact ritesh Contact ritesh

    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.



    Posted by: jay h thakkar    

    Contact jay h thakkar Contact jay h thakkar

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



    Posted by: Taher    

    Contact Taher Contact Taher

    * 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



    Posted by: Rajesh    

    Contact Rajesh Contact Rajesh

    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.



    Posted by: shruti patrawala    

    Contact shruti patrawala Contact shruti patrawala

    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.



    Posted by: Venkata Rajesh Kumar Kona    

    Contact Venkata Rajesh Kumar Kona Contact Venkata Rajesh Kumar Kona

    How can we close mysql_pconnect().



    Posted by: Nibohs    

    Contact Nibohs Contact Nibohs

    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'.



    Posted by: SHIJITH    

    Contact SHIJITH Contact SHIJITH

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



    Posted by: praveen    

    Contact praveen Contact praveen

    msql-conect("local host","root","")
    msql-select-db(xxx)



    Posted by: mukesh    

    Contact mukesh Contact mukesh

    mysql_pconnect()



    Posted by: raushan    

    Contact raushan Contact raushan

    Mysql_connect-opens a connection to a mysql server

    Mysql_Pconnect-open a persistent connection,which means a sql link that do not close when the execution
    of your script ends.



    Posted by: shashi das    

    Contact shashi das Contact shashi das

    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'.
    more info:datamining.portalfever.com



    Posted by: PortalFever    

    Contact PortalFever Contact PortalFever

    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'.
    more info:datamining.portalfever.com



    Posted by: jitender verma    

    Contact jitender verma Contact jitender verma

    Mysql_Pconnect-open a persistent connection,which means a sql link that do not close when the execution
    of your script ends.



    Posted by: awanish    

    Contact awanish Contact awanish

    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()?
    Because above three function usefully 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

    User Options
    Sponsored Links


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

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

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


    Cache = 0 Seconds