CRUD DataBase menggunakan PHP

 1.Buat Sintax From Pesan:

<h1>FORM PESAN</h1>

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

    Nama<br>

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

    Email<br>

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

    Pesan<br>

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

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

    <br>

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

</form>

<?php

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

{

   $nama=$_POST['nama'];

   $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 "gagal";

   }

}

else

{

    echo "silakan masukan pesan";

}

?>

OUTPUT:

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