Perintah Dasar Pada Program Database

input.php

<form name="form1" method="post" action="input-proses.php">

<p>No: <input name="No" type="text" id="No"></p>

<p>Nama: <input name="Nama" type="text" id="Nama"></p>

<p>Tempat: <input name="Tempat" type="text" id="Tempat"></p>

Tanggal: <select name="Tanggal" id="Tanggal">

            <option selected="selected">1</option>

            <option>2</option>

            </select>

Bulan: <select name="Bulan" id="Bulan">

            <option selected="selected">Januari</option>

            <option>Februari</option>

            </select>

Tahun: <select name="Tahun" id="Tahun">

            <option selected="selected">1990</option>

            <option>1991</option>

            </select>

<p>Alamat: <input name="Alamat" type="text" id="Alamat"></p>

<p>Hobi:

<input type="checkbox" name="hobi1" value="Makan">Makan</p>

<p>Agama: <select name="Agama" id="Agama">

            <option selected="selected">Islam</option>

            <option>Kristen</option>

            </select>

<p>Jenis Kelamin:

<input name="Jekel" value="Laki-Laki" type="radio">Laki-Laki

<input name="Jekel" value="Perempuan" type="radio">Perempuan

<p>Sekolah: <input name="Sekolah" type="text" id="Sekolah"></p>

<p><input type="submit" name="submit" value="Simpan"></p>

</form>

input-proses.php

<?php

mysql_connect("localhost","root","");

mysql_select_db("tekajedua");                  → nama database

$Simpan="INSERT INTO latihan SET No='$_POST[No]', Nama='$_POST[Nama]', Tempat='$_POST[Tempat]'";

mysql_query($Simpan);

echo "Data Berhasil Disimpan";

echo "<br>";

echo "<a href=input.php> Back </a>";

?>

tampil.php

<?php

mysql_connect('localhost','root','');

mysql_select_db('tekajedua');                  → nama database

$tampil="select * from latihan";                → nama tabel

$permintaan=mysql_query($tampil);

while($data=mysql_fetch_array($permintaan)){

echo $data['No'];

echo "&nbsp";

echo $data['Nama'];

echo "&nbsp";

echo $data['Tempat'];

echo "&nbsp";

echo $data['Tanggal'];

echo "&nbsp";

echo $data['Bulan'];

echo "&nbsp";

echo $data['Tahun'];

echo "&nbsp";

}?>

hapus.php

<?php

mysql_connect('localhost','root','');

mysql_select_db('tekajedua');                  → nama database

mysql_query("delete from latihan where No='$_GET[No]'");

                                        (nama table)

header("location:tampil.php");

?>

edit.php

<?php

mysql_connect('localhost','root');

mysql_select_db('tekajedua');

$tampil=$_GET['No'];

$permintaan=mysql_query("select * from latihan where No='$tampil'");

$data=mysql_fetch_array($permintaan);

?>

<form id="form1" name="form1" method="post" action="update.php">

<p>No: <input name="No" type="text" id="No" value="<?php echo $data['No']; ?>"></p>

<p>Nama: <input name="Nama" type="text" id="Nama" value="<?php echo $data['Nama']; ?>"</p>

<p>Tempat: <input name="Tempat" type="text" id="Tempat" value="<?php echo $data['Tempat']; ?>"</p>

<p>Tanggal: <input name="Tanggal" type="text" id="Tanggal" value="<?php echo $data['Tanggal']; ?>"</p>

<p>Bulan: <input name="Bulan" type="text" id="Bulan" value="<?php echo $data['Bulan']; ?>"</p>

<p>Tahun: <input name="Tahun" type="text" id="Tahun" value="<?php echo $data['Tahun']; ?>"</p>

<p><input type="submit" name="submit" value="Update"></p>

<br>

update.php

<?php

mysql_connect('localhost','root','');

mysql_select_db('tekajedua');

$Nomor Daftar = $_POST[‘Nodaftar’];

$Nama = $_POST['Nama'];

$Tempat = $_POST['Tempat'];

$Tanggal = $_POST['Tanggal'];

$Bulan = $_POST['Bulan'];

$Tahun = $_POST['Tahun'];

mysql_query("update latihan set Nodaftar='$Nodaftar', Nama='$Nama', Tempat='$Tempat', Tanggal='$Tanggal', Bulan='$Bulan', Tahun='$Tahun' where Nodaftar='$Nodaftar'");

header("location:tampil.php");

?>

index.html

<FRAMESET ROWS="23%, 80%" BORDERCOLOR="cyan" >

<FRAME SRC="atas.html" NORESIZE>

<FRAMESET COLS="15%, 80%" BORDER="5">

<FRAME SRC="kiri.html" BORDERCOLOR="cyan">

<FRAME SRC="kanan.html" SCROLLING="yes" NAME="isi">

</FRAMESET>

</FRAMESET>

latihan.html

<a href=kanan.html target="isi">Home</a>

<a href=tampil.php target="isi">Result</a>

</center>

</body>

</html>

hapus.php

<?php

mysql_connect('localhost','root','');

mysql_select_db('tekajedua');                  → nama database

mysql_query("delete from latihan where No='$_GET[No]'");

                                        (nama table)

header("location:tampil.php");

?>

edit.php

<?php

mysql_connect('localhost','root');

mysql_select_db('tekajedua');

$tampil=$_GET['No'];

$permintaan=mysql_query("select * from latihan where No='$tampil'");

$data=mysql_fetch_array($permintaan);

?>

<form id="form1" name="form1" method="post" action="update.php">

<p>No: <input name="No" type="text" id="No" value="<?php echo $data['No']; ?>"></p>

<p>Nama: <input name="Nama" type="text" id="Nama" value="<?php echo $data['Nama']; ?>"</p>

<p>Tempat: <input name="Tempat" type="text" id="Tempat" value="<?php echo $data['Tempat']; ?>"</p>

<p>Tanggal: <input name="Tanggal" type="text" id="Tanggal" value="<?php echo $data['Tanggal']; ?>"</p>

<p>Bulan: <input name="Bulan" type="text" id="Bulan" value="<?php echo $data['Bulan']; ?>"</p>

<p>Tahun: <input name="Tahun" type="text" id="Tahun" value="<?php echo $data['Tahun']; ?>"</p>

<p><input type="submit" name="submit" value="Update"></p>

<br>

update.php

<?php

mysql_connect('localhost','root','');

mysql_select_db('tekajedua');

$No = $_POST[No];

$Nama = $_POST['Nama'];

$Tempat = $_POST['Tempat'];

$Tanggal = $_POST['Tanggal'];

$Bulan = $_POST['Bulan'];

$Tahun = $_POST['Tahun'];

mysql_query("update latihan set No='$No', Nama='$Nama', Tempat='$Tempat', Tanggal='$Tanggal', Bulan='$Bulan', Tahun='$Tahun', Alamat='$Alamat', Hobi_1='$Hobi_1', Hobi_2='$Hobi_2', Hobi_3='$Hobi_3', Hobi_4='$Hobi_4', Agama='$Agama', Jenis_Kelamin='$Jenis_Kelamin', Sekolah='$Sekolah' where No='$No'");

header("location:tampil.php");

?>