What is the difference between mysqli connect and mysql connect

What are the differences between mysqli connect and mysqli pconnect. What is the main difference between them? Can anyone explain me with any sample code? Your comment on this question: Your name to display optional : Email me at this address if a comment is added after mine: Email me if a comment is added after mine Privacy: Your email address will only be used for sending these notifications.

Your answer Your name to display optional : Email me at this address if my answer is selected or commented on: Email me if my answer is selected or commented on Privacy: Your email address will only be used for sending these notifications. Thank You!! Your comment on this answer: Your name to display optional : Email me at this address if a comment is added after mine: Email me if a comment is added after mine Privacy: Your email address will only be used for sending these notifications.

What are the differences in die and exit in PHP? What is a Stored Procedure? Explain with appropriate Example? What is SQL certification? How much time it will take to learn SQL? How much do SQL jobs pay? What is MySQL architecture?

Ask a Question. Formatting: Spelling, grammar or punctuation errors. Personal Attack: Disrespectful content about a person. Insincere Question: Question not seeking real answers. Incorrect Topics: Broad or inaccurate topics. Spam: Link or advertisement for a product. The view that "mysqli connection is a permanent connection, but mysql is a non-permanent connection" is wrong. According to the php manual: mysqli in php5. You need to add the "p:" mark in front of the hostname of the connection parameter to establish a persistent connection.

Persistent connection support was introduced in PHP 5. Unlike the mysql extension, mysqli does not provide a separate function for opening persistent connections. Active 1 year, 2 months ago.

Viewed 78k times. Which connection is better and how are they fundamentally different when connecting? Improve this question. Peter Mortensen 29k 21 21 gold badges 97 97 silver badges bronze badges. Show 1 more comment. Active Oldest Votes. They're not interchangeable. There are different extensions to access MySQL databases. Improve this answer. Francois Deschenes Francois Deschenes So are they interchangeable with v4.

Add a comment. They are not interchangeable.