How to create MySql database connection in php example

How to create MySql database connection in php example

Whenever you want to save some important data on the database you just need a connection between your project to MySQL. The tutorial takes you through establishing a connection using PHP  to MySQL in your project.

How to connect to MySQL using PHP:

Let's start, The function to connect to MySQL is called mysqli_connect. This function returns a resource which is a point to the database connection.


Top 50 MySQL Interview Questions and Answers

Before you create a connection between php and MySQL you need some information regarding database server and store in your configuration file. for example:

$servername = "servername";
$username = "username";
$password = "password";
$database= "database";

After collect these information you need to create a config.php file, this file you can use in your all file of your project where you want database connection.


Finally create config file:

$servername = "localhost";
$username = "root";
$password = "";
$database = "mydatabase";
// Create connection
$connection = mysqli_connect($servername, $username, $password, $database);
// Check connection
if (!$connection) {
    die("Connection failed: " . $connection->connect_error);
function close_db(){

Related posts

Write a comment