Cara Membuat Form Input Sederhana Pada PHP
1. Membuat Database terlebih dahulu dengan Mysql pada Xampp
Nama Database "indonesia" dengan Nama Table "kota"
Cara Membuat Database :
create database indonesia;
create table kota value(kode varchar(5) notnull, nm_kota varchar(10) notnull, luas double, primary key(kode));
2. Setelah tulis Coding di bawah ini dengan notepad,
<form action ="" method="post">
kode <input type="textbox" name="kode" maxlength="20">
Nama Kota <input type="textbox" name="kota" maxlength="20">
luas <input type="textbox" name="luas" maxlength="20">
<input type="submit" name="proses" value="proses">
<input type="reset" name="batal" value="batal">
</form>
<?php
//include "namafile.php";
mysql_connect("localhost","root","");
mysql_select_db("indonesia");
$kode = $_POST["kode"];
$kota = $_POST["kota"];
$luas = $_POST["luas"];
$sql = mysql_query("insert into kota value('$kode','$kota','$luas')") or die (mysql_error());
if($sql)
{
echo"sukses";
}else{
echo"gagal";
}
?>
3. Run dengan Browser
4. Selamat Mencoba Kawan.........
Index.php
<body>
<a href="tambah.php">Tambah Data </a>
<h2> Data Pegawai PT Maju Jaya Perkasa </h2>
<table border="1" cellpadding="1" cellspacing="2" width="60%" bgcolor="#0099FF">
<tr><td>No </td>
<td>NIP</td>
<td>Nama</td>
<td>Alamat</td>
<td colspan="2">Aksi</td>
</tr>
<?php
include"koneksi.php";
$q="SELECT *FROM pegawai ORDER BY nip DESC";//Mengurutkan berdasarkan Angka terbesar (ascd)
$sql=mysql_query($q);
$no=1;
while ($data=mysql_fetch_array($sql))
{ echo " <tr > <td> $no </td>
<td> $data[nip] </td>
<td> $data[nama] </td>
<td> $data[alamat] </td>
<td> <form action=edit.php method=post >
<input type=hidden value=$data[nip] name=nip >
<input type=submit value=Edit >
</form> </td>
<td>
<form action='delete.php' method=post >
<input type=hidden value=$data[nip] name=nip >
<input type=submit value=Delete >
</form> </td>
</tr>";
$no++;
}
?>
</table>
</body>
Koneksi.php
<?php
$host="localhost";
$user="root";
$pass="";
$db="majujaya";
$d=mysql_connect($host,$user,$pass) or die (mysql_error());
$konek=mysql_select_db($db,$d) or die (mysql_error());
?>
proses.php
<?php
include"koneksi.php";
$nip=$_POST['nip'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$d=mysql_query("insert into pegawai values('$nip','$nama','$alamat')");
if($d)
{
echo "Data Sukses <br>";
echo"<a href=index.php>Halaman Utama</a>";
}
else
{ echo "Gagal Simpan Data<br>";
echo "<a href=index.php>Halaman Utama</a>";
}
?>
Tambah.php
<h3> Tambah Data Pegawai </h3>
<form action = "proses.php" method = "post">
<table>
<tr><td>NIP</td><td><input type="text" name = "nip" size = "10"/></td>
<tr><td>Nama</td><td><input type="text" name="nama" size="40" /></td>
<tr><td valign="top">Alamat</td><td><textarea name="alamat" /></textarea></td>
<tr><td colspan="2"><input type="submit" value ="proses">
<input type="reset" value="Batal">
</td>
</table>
</form>
<a href="index.php">Menu Utama</a>
Delete.php
<?php
include "koneksi.php";
$nip=$_POST["nip"];
$que=mysql_query("delete from pegawai where nip ='$nip'");
if ($que)
{echo "Data Sukses di Hapus";
}
else
{echo "data gagal di hapus";
}
?>
<br>
<a href="index.php">Menu Utama</a>
edit.php
<?php
include "koneksi.php";
$nip=$_POST["nip"];
$que=mysql_query("select * from pegawai where nip = '$nip'");
$data = mysql_fetch_array($que);
$nipl=$data["nip"];
$nama=$data["nama"];
$alamat=$data["alamat"];
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859>-l" /
<title>Edit Data</title>
</head>
<body>
<form action="" method="post">
<table>
<tr><td>NIP</td><td><input type="hidden" value="<?php echo $nipl;?>" name= "nipl" /><?php echo $nipl;?></td></tr>
<tr><td>Nama Pegawai</td><td><input type="text" value="<?php echo $nama;?>" name="nama"/> </td></tr>
<tr><td valign="top">alamat</td><td><textarea name="alamat" /><?php echo $alamat;?> </textarea></td></tr>
<tr><td colspan="2">
<input type="submit" value="Edit" name="edit" />
<input type="reset" value="Batal" name="batal" />
</table>
</font>
<a href="index.php">Halaman Utama</a>
</body>
</html>
<?php
$nip=$_POST['nipl'];$nama=$_POST['nama'];$alamat=$_POST['alamat'];
$sql=mysql_query("update pegawai set nip='$nip', nama='$nama', alamat='$alamat' where nip='$nip'");
if(sql) {echo "Data Sukses Di Input";}else{echo "Eror";}
?>