CREATE DATABASE database_name

DROP DATABASE database_name

CREATE TABLE table_name (
	id INT(11) AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(30) NOT NULL,
    last_name VARCHAR(30) NULL
)

DROP TABLE table_name

<?php 

	// // BUAT KONEKSI TANPA DATABASE
	// $connection = new mysqli('localhost', 'root', '');

	// BUAT KONEKSI DENGAN DATABASE
	$connection = new mysqli('localhost', 'root', '', 'sagu');

	if(!$connection->connect_error){
		echo "Koneksi BERHASIL";
	} else {
		echo "Koneksi GAGAL";
	}

?>

<?php 

	// INTEGRASI KONEKSI
	require_once('connection.php');

	// FUNGSI CREATE TABLE
	$sql = "CREATE TABLE students(
				id INT(11) AUTO_INCREMENT PRIMARY KEY,
				first_name VARCHAR(30) NOT NULL,
				last_name VARCHAR(30) NULL,
				email VARCHAR(50) NULL
			)";
			
	$connection->query($sql);

?>

<?php 

	// INTEGRASI KONEKSI
	require_once('connection.php');

	// FUNGSI SQL INSERT DATA
	$sql = "INSERT INTO tutors(first_name, last_name) VALUES ('Janzen','Faidiban')";

	// FUNGSI MENGIRIM DATA KE DATABASE
	$connection->query($sql);

?>