What are the differences between mysqli connect and mysqli pconnect

Question

What is the main difference between them? Can anyone explain me with any sample code?

thank you!!

Answer 1

Hello,

mysqli_pconnect() function is used for making a persistence connection with the database that does not terminate when the script ends.

mysqli_connect() function searches any existing persistence connection first and if no persistence connection exists, then it will create a new database connection and terminate the connection at the end of the script.

Sample code:

$DBconnection = mysqli_connect("localhost","username","password","dbname"); // Check for valid connection if (mysqli_connect_errno()) { echo "Unable to connect with MySQL: " . mysqli_connect_error(); }

mysqli_pconnect() function is depreciated in the new version of PHP, but you can create persistence connection using mysqli_connect with the prefix p.

Thank You!!