Database

Connect to a fresh MySQL
$serverName = "localhost";
$username = "root";
$password = “";

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

Connect to a MySQL that’s set and ready
$dbName = "StanDB";

$conn = new mysqli($serverName, $username, $password, $dbName);

Check connection
if($conn->connect_error){
	die("Connection failed: ". $conn->connect_error);
}
echo "Connected successfully".NewSpace();

Create a database
$sql = "CREATE DATABASE StanDB";
if($conn->query($sql) === TRUE){
	echo "Database create successfully";
}else{
	echo "Error creating database". $conn->error;
}
Create a table
$sqlCreateTable = "
	CREATE TABLE MyGuests(
		id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
		firstname VARCHAR(30) NOT NULL,
		lastname VARCHAR(30) NOT NULL,
		email VARCHAR(50),
		reg_date TIMESTAMP
	)
";

if($conn->query($sqlCreateTable) === TRUE) {
	echo "Table MyGuests created successfully";
}else{Database

Connect to a fresh MySQL
$serverName = "localhost";
$username = "root";
$password = “";

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

Connect to a MySQL that’s set and ready
$dbName = "StanDB";

$conn = new mysqli($serverName, $username, $password, $dbName);

Check connection
if($conn->connect_error){
	die("Connection failed: ". $conn->connect_error);
}
echo "Connected successfully".NewSpace();

Create a database
$sql = "CREATE DATABASE StanDB";
if($conn->query($sql) === TRUE){
	echo "Database create successfully";
}else{
	echo "Error creating database". $conn->error;
}
Create a table
$sqlCreateTable = "
	CREATE TABLE MyGuests(
		id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
		firstname VARCHAR(30) NOT NULL,
		lastname VARCHAR(30) NOT NULL,
		email VARCHAR(50),
		reg_date TIMESTAMP
	)
";

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

	echo "Error creating table: ". $conn->error;
}
Close connection
$conn->close();