<?php
$servername = "localhost";
$username = "root";
$password = "13081999";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
$sql = "CREATE DATABASE IF NOT EXISTS myDB";
if($conn->query($sql)==TRUE){
	echo DBsuccessfully;
}else{
echo erro;
}

$sql="CREATE TABLE  IF NOT EXISTS `mydb`.`film` ( `idfilm` INT(11) NOT NULL , `tenfilm` VARCHAR(45) NOT NULL , `idCategory` INT(11) NULL , `ngayphathanh` DATE NOT NULL , PRIMARY KEY (`idfilm`)) ENGINE = InnoDB ;";
if($conn->query($sql)==TRUE){
	echo DBsuccessfully;
}else{
echo $conn->error;
}

$sql = "CREATE TABLE IF NOT EXISTS `mydb`.`category` ( `IdCategory` INT NOT NULL , `ten` VARCHAR(11) NOT NULL , PRIMARY KEY (`IdCategory`)) ENGINE = InnoDB;";
if($conn->query($sql)==TRUE){
	echo DBsuccessfully;
}else{
echo $conn->error;
}
$sql = "CREATE TABLE if not exists `mydb`.`dienvien` ( `iddienvien` INT(11) NOT NULL , `ten` VARCHAR(45) NOT NULL , `ngaysinh` DATE NOT NULL , `gioitinh` VARCHAR(45) NOT NULL , PRIMARY KEY (`iddienvien`)) ENGINE = InnoDB;";
if($conn->query($sql)==TRUE){
	echo DBsuccessfully;
}else{

echo $conn->error;

}


$sql="CREATE TABLE If not exists`mydb`.`film_dienvien` ( `idfilm` INT NOT NULL , `iddienvien` INT NOT NULL , PRIMARY KEY (`idfilm`, `iddienvien`)) ENGINE = InnoDB";

if($conn->query($sql)==TRUE){
	echo DBsuccessfully;
}else{

echo $conn->error;


}
$sql="CREATE TABLE if not exists `mydb`.`khachhang` ( `idkhachhang` INT(11) NOT NULL , `ten` VARCHAR(45) NOT NULL , `ngaysinh` DATE NOT NULL , `gioitinh` VARCHAR(45) NOT NULL , PRIMARY KEY (`idkhachhang`)) ENGINE = InnoDB;";
if($conn->query($sql)==TRUE){
	echo DBsuccessfully;
}else{

echo $conn->error;
}

$sql = "Create table if not exists `mydb`.`tichket` (`idkhachhang` INT(11) NOT NULL,`idfilm` INT(11)NOT NULL ,`giave` INT(11) , `giochieu` TIMESTAMP(6) NOT NULL,PRIMARY KEY (`idfilm`, `idkhachhang`));";

if($conn->query($sql)==TRUE){
	echo DBsuccessfully;
}else{

echo $conn->error;
}
/*for($i=1;$i<=10;$i++){
$sql ="insert into `mydb`.`film`  values ($i,\"film$i\",$i,2019/8/$i)";

if($conn->query($sql)==True){
	echo $i;
}else
	echo $conn->error
}
}
*/
for($i=1;$i<=10;$i++){
$sql ="insert into `mydb`.`dienvien`  values ($i,\"diven$i\",$i,2019/8/$i),\" nu\"";

if($conn->query($sql)==True){
	echo $i;
}else
	echo $conn->error
}
}




?>