Connection to the MySQL Server using PHP

Sudheesh.R

Before  access data in a database, we must open a database connection to the MySQL server.

In PHP, using  the mysqli_connect() function.

mysqli_connect(host,username,password,dbname);

mysqli_connect() function
<?php
// Create a connection
$con=mysqli_connect(“example.com”,”user01″,”password”,”my_db”);// Check connection
if (mysqli_connect_errno())
{
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}
?>
… Read more

Create Database using MySQL and PHP

Sudheesh.R

The CREATE DATABASE statement is using to create a database table in MySQL.

The following example creates a database named “my_db”:

CREATE DATABASE
<?php

$con=mysqli_connect(“example.com”,”user01″,”password”);
// Check connection
if (mysqli_connect_errno())
{
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}

// Create database
$sql=”CREATE DATABASE my_db”;
if (mysqli_query($con,$sql))
{

… Read more