Skip to content

MySQL – Connection

Access MySQL from PHP

How to Access MySQL from PHP ?

  • by

In this tutorial, we are going to access MySQL database from PHP. Accessing MySQL from PHP is very simple and easy to implement. PHP contains built-in functions to connect the MySQL database and to access the data. Those functions are,

  • mysqli_connect – To connect the database by using the specified configuration.
  • mysqli_query – To execute a query to get resource id.
  • mysqli_fetch_row – To read row data with the reference of the resource id. There are many MySQL fetch functions in PHP to read table rows.

I have added an example code for accessing MySQL database from PHP. I used the database table named animals on which the create, read, update and delete (CRUD) functionalities are going to be performed.

Access MySQL from PHP
Read More »How to Access MySQL from PHP ?