How to Connect PHP to MySQL Database?

 

How to Connect PHP to MySQL Database?

In this tutorial we will be learning about how to connect to MySQL Database Management System with PHP.

Some Points on MySQL

• MySQL uses Standard SQL
• MySQL is free to download
• MySQL is best suitable for Small and Large Applications

Some Points on PHP

• PHP is a server scripting language
• PHP scripts are executed in server and pure HTML is returned back to client.
• PHP files have extension .php
• PHP is easy to Learn and implement
• PHP supports both Structural Programming Paradigm and Object Oriented Programming Paradigm.

---

1. First, Let's create a Database in MySQL

CREATE DATABASE TestDB;

2. Let's create a Table in TestDB

CREATE TABLE testTABLE (
id INT,
Fname VARCHAR(50),
Lname VARCHAR(50),
EmailID VARCHAR(120)
);

3. Let's Connect to TestDB

$mysql_host = "localhost";   //host address may vary. ex : localhost:3302
$mysql_user = "root";         //Given by your hosting provider
$mysql_pass = "";              
$mysql_database  = "TestDB;   //DB you need to connect to

$con = mysqli_connect($mysql_host,$mysql_user,$mysql_pass,$mysql_database);
 if (mysqli_connect_errno()) 
{
        die("Unable to connect to Mysql Server");
}

4. For much easier access let's create a function dbConnect()

//function will return a connection object
function dbConncet($mysql_host,$mysql_user,$mysql_pass,$mysql_database){
    $con = mysqli_connect($mysql_host,$mysql_user,$mysql_pass,$mysql_database);
    if (mysqli_connect_errno()) {
        die("Unable to connect to Mysql Server");
    }
    return $con; 
}

5. Final Code

<?php
function dbConncet($mysql_host,$mysql_user,$mysql_pass,$mysql_database){
    $con = mysqli_connect($mysql_host,$mysql_user,$mysql_pass,$mysql_database);
    if (mysqli_connect_errno()) {
        stop("Unable to connect to Mysql Server");
    }
    return $con; 
}

$SqlConnection=dbConnect("localhost","root","","TestDB"); //If provided value is correct and database is connected then will receive a connection object else displays error
?>

 

If you got any queries, Please free to contact me.

If you like to create your own contents, Please click on the below button and Signup.