TUTORIAL DATABASE
1.
Aktifkan xampp
2.
Ketikan localhost/phpmyadmin pada web browser
3.
Buat database dengan nama panggilan (misal
riaaris)
4.
Buat kolom
5
Isi nama kolom
6.
Kalau sudah klik save
Kolom sudah jadi, selanjutnya kita
buat script input.php, input-proses.php, tampil.php, hapus.php, edit.php, dan
update.php
7.
Buka notepad lalu ketikan script input dibawah
ini
<form
name="form1" method="post"
action="input-proses.php">
<head><center><h1><marquee><font
face="Arial">FORMULIR PENDAFTARAN PESERTA DIDIK BARU SMKN
NGADIROJO</font></marquee></h1></center></head>
<body
bgcolor="purple"><center><h2><font
face="ravie">isi formulir dibawah
ini</font></h2></center></body>
<center><table
border="10"></center>
<tr><td>NAMA</td><td><input
name="nama" type="text"
id="nama"></td></tr>
<tr><td>ALAMAT</td><td><input
name="alamat" type="text"
id="alamat"></td></tr>
<tr><td>TEMPAT</td><td><input
name="tempat" type="text"
id="tempat"></td></tr>
<tr><td>TANGGAL</td><td><select
name="tgl" id="tgl">
<option selected="selected">1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select></td></tr>
<tr><td>BULAN</td><td><select
name="bln" id="bln">
<option selected="selected">januari</option>
<option>februari</option>
<option>maret</option>
<option>april</option>
<option>mei</option>
<option>juni</option>
<option>juli</option>
<option>agustus</option>
<option>september</option>
<option>oktober</option>
<option>november</option>
<option>desember</option>
</select></td></tr>
<tr><td>TAHUN</td><td><select
name="thn" id="thn">
<option
selected="selected">1993</option>
<option>1994</option>
<option>1995</option>
<option>1996</option>
<option>1997</option>
<option>1998</option>
<option>1999</option>
</select></td></tr>
<tr><td>JENIS
KELAMIN</td><td><input name="jk"
value="laki-laki" type="radio">LAKI-LAKI
<input name="jk"
value="perempuan"
type="radio">PEREMPUAN</td></tr>
<tr><td>AGAMA</td><td><select
name="agama" id="agama">
<option
selected="selected">islam</option>
<option>kristen</option>
<option>hindu</option>
<option>budha</option>
<option>katholik</option>
</select></td></tr>
<tr><td>JURUSAN1</td><td><select
name="jurusan1" id="jurusan1">
<option
selected="selected">TKJ</option>
<option>TOKR</option>
<option>AKUNTANSI</option>
<option>ATPH</option>
<option>APSP</option>
<option>KR</option>
</select></td></tr>
<tr><td>JURUSAN2</td><td><select
name="jurusan2" id="jurusan2">
<option
selected="selected">ATPH</option>
<option>AKUNTANSI</option>
<option>APSP</option>
<option>KR</option>
</select></td></tr>
<p><tr><th
colspan="2"><input type="submit"
name="submit"
value="simpan"></th></tr></p>
</table>
8.
Simpan di Local Disk C-xampp-htdocs-kemudian
buat folder(misal riaa)
9. Buat
script input-proses.php
<?php
mysql_connect("localhost","root","");
mysql_select_db("riaaris");
$simpan="INSERT INTO duasembilan SET nama='$_POST[nama]',
alamat='$_POST[alamat]', tempat='$_POST[tempat]',
tgl='$_POST[tgl]', bln='$_POST[bln]', thn='$_POST[thn]', jk='$_POST[jk]',
agama='$_POST[agama]', jurusan1='$_POST[jurusan1]',
jurusan2='$_POST[jurusan2]'";
mysql_query($simpan);
echo "data berhasil disimpan";
echo "<br>";
echo "<a href=input.php>back</a>";
?>
10.Simpan pada folder riaa tadi
11. Buat
script tampil.php
<?php
mysql_connect('localhost','root','');
mysql_select_db('riaaris');
$tampil="select * from
duasembilan order by nopend asc";
$permintaan=mysql_query($tampil);
$nourut =1;
while($data=mysql_fetch_array($permintaan)){
echo "NO :";
echo "$nourut";
echo " ";
echo "<br>";
echo "NO PENDAFTARAN
:";
echo $data['nopend'];
echo " ";
echo "<br>";
echo "NAMA :";
echo $data['nama'];
echo " ";
echo "<br>";
echo "ALAMAT :";
echo $data['alamat'];
echo " ";
echo "<br>";
echo "TEMPAT :";
echo $data['tempat'];
echo " ";
echo "<br>";
echo "TANGGAL :";
echo $data['tgl'];
echo " ";
echo "<br>";
echo "BULAN :";
echo $data['bln'];
echo " ";
echo "<br>";
echo "TAHUN :";
echo $data['thn'];
echo " ";
echo "<br>";
echo "JENIS KELAMIN
:";
echo $data['jk'];
echo " ";
echo "<br>";
echo "AGAMA :";
echo $data['agama'];
echo " ";
echo "<br>";
echo "JURUSAN1 :";
echo $data['jurusan1'];
echo " ";
echo "<br>";
echo "JURUSAN2 :";
echo $data['jurusan2'];
echo " ";
echo "<br>";
echo "<a
href=hapus.php?nopend=$data[nopend]>hapus</a><br>";echo
"<a
href=edit.php?nopend=$data[nopend]>ubah</a><br>";
$nourut++;
} ?>
<p>
<a
href=input.php>KEMBALI KE INPUT DATA</a>
12.
Simpan pada folder riaa
13.
Buat script hapus.php
<?php
mysql_connect('localhost','root','');
mysql_select_db('riaaris');
mysql_query("delete from
duasembilan where nopend='$_GET[nopend]'");
header("location:tampil.php");
?>
14.
Simpan pada folder riaa
15.
Buat script edit.php
<?php
mysql_connect('localhost','root');
mysql_select_db('riaaris');
$tampil = $_GET['nopend'];
$permintaan = mysql_query("select * from
duasembilan where nopend='$tampil'");
$data=mysql_fetch_array($permintaan);
?>
<form id="form1" name="form1"
method="post" action="update.php">
<p>NO PENDAFTARAN: <input
name="nopend" type="text" id="nopend"
value="<?php echo $data['nopend']; ?>"</p>
<p>NAMA: <input name="nama"
type="text" id="nama" value="<?php echo
$data['nama']; ?>"</p>
<p>ALAMAT: <input name="alamat"
type="text" id="alamat" value="<?php echo
$data['alamat']; ?>"</p>
<p>TEMPAT: <input name="tempat"
type="text" id="tempat" value="<?php echo
$data['tempat']; ?>"</p>
TANGGAL:
<select name="tgl"
id="tgl">
<option
selected="selected">1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
BULAN:
<select name="bln"
id="bln">
<option
selected="selected">januari</option>
<option>februari</option>
<option>maret</option>
<option>april</option>
<option>mei</option>
<option>juni</option>
<option>juli</option>
<option>agustus</option>
<option>september</option>
<option>oktober</option>
<option>november</option>
<option>desember</option>
</select>
TAHUN:
<select name="thn"
id="thn">
<option
selected="selected">1993</option>
<option>1994</option>
<option>1995</option>
<option>1996</option>
<option>1997</option>
<option>1998</option>
<option>1999</option>
</select>
<p>JENIS KELAMIN: <select
name="jk" type="text" id="jk"
value="<?php echo $data['jk']; ?>"</p>
<input
name="jk" value="laki-laki"
type="radio">LAKI-LAKI
<input
name="jk" value="perempuan"
type="radio">PEREMPUAN
<p>AGAMA: : <select name="agama"
type="text" id="agama" value="<?php echo
$data['agama']; ?>"</p>
<option>islam</option>
<option>Kristen</option>
<option>Katolik</option>
<option>Budha</option>
<option>Hindu</option>
</select>
<p>JURUSAN1: <select
name="jurusan1" type="text" id="jurusan1" value="<?php
echo $data['jurusan1']; ?>"</p>
<option
selected="selected">TKJ</option>
<option>TOKR</option>
<option>AKUNTANSI</option>
<option>ATPH</option>
<option>APSP</option>
<option>KR</option>
</select>
<p>JURUSAN2: <select
name="jurusan2" type="text" id="jurusan2"
value="<?php echo $data['jurusan2']; ?>"</p>
<option
selected="selected">ATPH</option>
<option>AKUNTANSI</option>
<option>APSP</option>
<option>KR</option>
</select></td></tr>
<p><input type="submit"
name="submit" value="ubah data"></p>
<br>
<br>#no tidak dapat diubah, karena sebagai
primary key
116.
Simpan pada folder riaa tadi
117.
Buat folder update.php
<?php
mysql_connect('localhost','root');
mysql_select_db('riaaris');
$nopend = $_POST[nopend];
$nama = $_POST[nama];
$alamat = $_POST[alamat];
$tempat = $_POST[tempat];
$tgl = $_POST[tgl];
$bln = $_POST[bln];
$thn = $_POST[thn];
$jk = $_POST[jk];
$agama = $_POST[agama];
$jurusan1 = $_POST[jurusan1];
$jurusan2 = $_POST[jurusan2];
mysql_query("update
duasembilan set nopend='$nopend', nama='$nama', tempat='$tempat', tgl='$tgl',
bln='$bln', thn='$thn', jk='$jk', agama='$agama', jurusan1='$jurusan1',
jurusan2='$jurusan2' where nopend='$nopend'");
header("location:tampil.php");
?>
18. Simpan di folder riaa tadi
19. Kemudian cek hasil input.php. Caranya buka web browser ketikan localhost/(nama folder tadi)/input.php. Enter
19. Kemudian cek hasil input.php. Caranya buka web browser ketikan localhost/(nama folder tadi)/input.php. Enter
20.
Isikan formulir pendaftaran diatas kemudian klik
SIMPAN
21.
Setelah itu cek hasil input data diatas caranya
ketikan localhost/(nama folder tadi)/tampil.php. Enter
22.
Kemudian kita coba edit data tersebut dengan
meng klik ubah
Contoh: kita ubah tanggal, bulan dan jenis tahun apakah akan
berubah atau tidak, Maka otomatis data akan berubah seperti pada gambar di
bawah ini
SEKIAN TUTORIAL DARI SAYA SEMOGA BERMANFAAT
Tidak ada komentar:
Posting Komentar