Untitled

<!DOCTYPE html>
<html>
<body>
<?php
$servername="localhost";
$username="root";
$password="";
$dbname="student99";
$conn=new mysqli($servername,$username,$password,$dbname);
if($conn->connect_error)
{
	die("connection failed:".$conn->connection_error);
}
// echo "Connection Successful";
// $sql="CREATE DATABASE STUDENT99";
// if($conn->query($sql)==true)
// {
// 	echo "<br><br>Database Created";
// }
// else
// {
// 	echo "<br>Go Check Your CODE !<br><br>".$conn->error;
// }


// $sql="CREATE TABLE student (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
// firstname VARCHAR(10),
// lastname VARCHAR(10) )";

// if($conn->query($sql) === TRUE) {
//     echo "Table MyGuests created successfully";
// }
// else{
//     echo "Error creating table: " . $conn->error;}

$sql="INSERT INTO student(firstname,lastname) VALUES ('jay','sharma');";
$sql .="INSERT INTO student(firstname,lastname) VALUES ('gaurav','goswami');";
$sql .="INSERT INTO student(firstname,lastname) VALUES ('jai','jprakash');";
if ($conn->multi_query($sql) === TRUE) {
    echo "New records created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

    $conn->close();
?>
</body>
</html>