CRUD DataBase menggunakan PHP

 

1.Buat SCRIPT form pesan

<h1>FORM PESAN</h1>

<form method="post" action="">

    Nama <br>

    <input type="text" name="nama"><br>

    Email <br>

    <input type="email" name="email"><br>

    Pesan <br>

    <textarea name="pesan"></textarea><br>

    <input type="submit" value="Kirim"><br>

</form>

<?php

$koneksi = mysqli_connect("localhost","root","","db_smk");

if($_SERVER["REQUEST_METHOD"] == "POST") {

    $nama = $_POST['nama'];

    $email = $_POST['email'];

    $pesan = $_POST['pesan'];

    $perintah = "INSERT INTO tb_pesan VALUES('', '$nama', '$email', '$pesan')";

    $query = mysqli_query($koneksi, $perintah);

    if($query==1){

        echo "Berhasil";

    } else {

        echo "Gagal";

    }

} else {

    echo "Silahkan masukan pesan";

}

?>

2. Mysql > cd c://xammpp/mysql/bin

- > use db_smk

- >CREATE TABLE tb_pesan(id_pesan - int( 11 ) auto Increment,

      nama_varchar(100) not null , email varchar (100) not null,

      pesan text,

      primary key (id_pesan));