<?Php
$servername = "localhost";
$username = "root";
$password = "";

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

if(!$conn){
   die("connection failed:".mysqli_connect_error());}

$sql = "CREATE DATABASE Lists";
    echo 'imhere';
$sql = "CREATE TABLE `Lists`.`list` (`name` VARCHAR(80) NOT NULL) ENGINE = MyISAM;";
$sql = "INSERT INTO 'Lists'.'list' ('name') VALUES (\'TSHEPO'\),('\LUNGA'),('\MSANDI'),('\Thwala'),('\Zwane'),('\Tshabalala');";

if(mysqli_query($conn,$sql)){
   echo "database created succesfully";}
else {
"error creating database:".mysqli_error($conn);}

mysqli_close($conn);
?>