course mysql arka

#koneksi
<?php
    $host = "localhost"; //host database
    $username = "root"; //username database
    $password = ""; //password database

    $koneksi = new mysqli($host, $username, $password); //membuat koneksi ke server mysql

    if($koneksi->connect_error){
        die("koneksi ke database gagal");
    }
?>

#create-database
<?php
    include "koneksi.php";

    $sql = "CREATE DATABASE profile";

    if($koneksi->query($sql) === TRUE){
        echo "database berhasil dibuat";
    } else {
        echo "database gagal dibuat";
    }
?>

#create-table
<?php
    include "koneksi.php";

    $sql = "CREATE TABLE user
    (
        id int PRIMARY KEY,
        nama varchar(50),
        role varchar(50),
        availability varchar(50),
        age int,
        location varchar(50),
        years_experience varchar(50),
        email varchar(50)
    )";

    if($koneksi->query($sql) == TRUE){
        echo "tabel berhasil dibuat";
    } else {
        echo "tabel gagal dibuat";
    }
?>