MAKING SQL QUERIES {UNDER DEVELOPMENT}

CREATE A MYSQL DATABASE USING MYSQLI

<?php 

$servername ="localhost";

$username="root";

$password="";

//create connection

$conn=n mysql($servername,$username ,$password);

//check connection

if ($conn->connect_error)

{

die("connection fail:".mysqli_connect_error());

}

else

{

echo"yes,connected";

}

//create database

$sql="creat database mydb";

if ($conn->query($sql)== TRUE )

{

echo"Databasse created successfully";

}

else

{

echo"error createing database:".$conn->error;

}$conn->closr();

?>

CREATE A MYSQL TABLE USING MYSQLI

<?php

$servername ="localhost";

$username="root";

$password="";

$dbname="mydb";

//create connection 

$conn= new mysqli($servename ,$password,$dbname );

//check connecion

if ($conn->connect_error )

{die ("connection failed:".mysqli_connect_error ());

}

else

{

echo"yes,connected";

}

//sql to create table 

$sql="create table student (

roll INT(6)UNSIGNED AUTO_INCREMENT PRIMARY KEY,

FIRSTNAME VARCHAR(30) NOT NULL,

LASTNAME VARCHAR(30) NOT NULL,

class int(2)

)

";

if ($conn->query($sql)===TRUE)

{

echo"table created successfully"

}

else
{

echo"error creating table:".$conn->error ;

}

$conn->close ();

?>