Back to Top

How to connect to MySQL database using PHP

MySQL Connection: Let be Expert

Originally I wrote a post about 1 year ago when I discovered some problems happened with me because of the MySQL connection fails. Now I have more experience with PHP/MySQL.I have decided to visit this topic to connect to MySQL database using PHP.

Let’s start to see one by one

You should use mysql_pconnect instead of mysql_connect because,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’.

You should suppress the error message on failure by prepending a @ to the function name.

You should suppress the error message on failure by prepending a @ to the function name.

Above code is for if any error occurs while the connection is executing and here, I have called one function CustomCriticalError. Let’s see how function works!!

Here, In above function CustomCriticalError, I have logged the error in the file and also to send E-mail and SMS if the connection fails.I have explained all the codes in a comment.

I hope you have enjoyed the concept of MySQL connection.Thanks for reading and feel free to share your thoughts, don’t Forget to Follow us on Twitter or Subscribe us to Get the Latest Updates.

Comments (1)

  1. […] explaining such assured and flexible MySQL Connection which logs error in Email and SMS you want.I am going to explain how you can take backup of […]

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Most Popular Posts

How to use HTML5 download attribute?

Posted on 8 years ago

Bhumi

Getting Started with CodeIgniter

Posted on 12 years ago

Bhumi

Overview of Amazon Web Services (AWS)

Posted on 7 years ago

Bhumi