<?php

    $server = "localhost";
    $user = "root";
    $pass = "";

    $conn = new mysqli ($server, $user, $pass);

    if ($conn->connect_error){
        die ("Connetion Failed" . $conn->connect_error);
    }


    if (!mysqli_select_db($conn,"zumorito")){
        $sql = "CREATE DATABASE zumorito";

        $conn->query($sql) or die ("Cannot create database!!! " . $conn->error);

        $conn2 = new mysqli ($server, $user, $pass, "zumorito");

        $sql2 = "CREATE TABLE tbl_auto (
            id int unsigned auto_increment primary key,
            firstname varchar(20),
            lastname varchar(20),
            email varchar(20),
            reg_date timestamp)";

        if ($conn2->query($sql2) === TRUE){

            $stmt = $conn2->prepare ("INSERT INTO tbl_auto (firstname, lastname, email) values (?, ?, ?)");
            $stmt->bind_param ('sss', $fname, $lname, $email);

            $fname = "John Kenneth";
            $lname = "Duran";
            $email = "jkduran546@gmail.com";
            $stmt->execute() or die ("Cannot insert data! " . $conn2->error);

            $stmt->close();
            $conn2->close();

            echo "Data successfully inserted!!!<br><br>";
        }


    echo "All worked!!!";
    }


    $conn->close();

 ?>