Creating a new database & Table in mysql Databases

Problems:
Write down the procedure of creating database and table in MySQL database. 2015,2010,2014,2017,2018

<?php
$server_name = "localhost:3308";
$db = "tufan";
$user_name = "root";
$pass = "";

//Create Connection
$conn = new mysqli($server_name,$user_name,$pass,$db);

//Check Connectio
if(!$conn){
die ("Database problem!!!");
}
else{
echo "Connection Ok";
}

//create a database named DB
$a="CREATE DATABASE NEWDB";
if($conn->query($a)===TRUE){
echo "Database Create successful";
}
else{
echo "error";
}
$conn->close();

// Create a table
$sql= "CREATE TABLE boss(
id INT(3) PRIMARY KEY,FastName VARCHAR(12) NOT NULL,LastName VARCHAR(10) NOT NULL)";

if($conn->query($sql)===TRUE){
echo "Table create ok";
}else{
echo "faild";
}
$conn->close();
?>

💬আরো পড়ুন এবং জানুন💬

• Create a password field in HTML form
• Basic Forms | HTML Input
• PHP Calculating GPA
• Write the php code to calculate the display GPA in the web browser
• How to Insert Data Into MySQL Database Table & Retrieving data form database Using PHP
• How to Insert and retrieving data from MySQL database using Program
• Creating a new database & Table in mysql Databases

See More...