CRUD DataBase Menggunkan PHP

1.Buat SCRIPT form pesan

<h1>FROM PESAN</h1>

<form method ="POST"action ="proses_pesan.php">

Nama<hr>

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

email<hr>

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

Pesan<br>

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

<br>

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

</form>

<?php

if( $_SERVER["REQUEST_METHOD"]=="post")

{

    $name=$_POST['name'];

    $email=$_POST['email'];

    $pesan=$_POST['pesan'];

    $koneksi=mysqli_connect("localhost",

    "root","", "db_smk");

    $perintah="INSERT INTO tb_pesan VALUES('','$nama',

'$email','$pesan')";

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

      if(query==1)

      {echo"berhasil";}else{echo"tidak berhasil";}

   

}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));