Cara Membuat Tabel Nilai Menggunakan PHP - Hai sobat, pada kesempatan kali ini saya akan membahas tentang Cara Membuat Tabel Nilai Menggunakan PHP
Pertama - tama siapkan dulu bahan - bahannya :
- Text Editor (Notepad++,Sublime Text 3,dsb)
- XAMPP
- Buatlah database dengan nama db_nilai
- Lalu buat tabel dengan nama tbl_nilai
- Buat difolder htdocs dengan nama nilai
- Buat file php dengan nama index.php
<html> <head> <title>INPUT DATA NILAI</title> </head> <body> <fieldset> <legend> <h1>Input Data Nilai</h1> </legend> <FORM ACTION="proses.php" METHOD="POST"> <table> <tr> <td>Nama</td> <td>:</td> <td><input type="text" name="nama" placeholder="Nama Anda"></td> </tr> <tr> <td>NIS</td> <td>:</td> <td><input type="text" name="nis" placeholder="NIS Anda"></td> </tr> <tr> <td>Matematika</td> <td>:</td> <td><input type="number" name="matematika" placeholder="Nilai Matematika"></td> </tr> <tr> <td>B. Indonesia</td> <td>:</td> <td><input type="number" name="bindonesia" placeholder="Nilai B. Indonesia"></td> </tr> <tr> <td>B. Inggris</td> <td>:</td> <td><input type="number" name="binggris" placeholder="Nilai B. Inggris"></td> </tr> <tr> <td>Produktif</td> <td>:</td> <td><input type="number" name="produktif" placeholder="Nilai Produktif"></td> </tr> <tr> <td><input type="submit" name="submit" value="Submit"></td> <td></td> <td><a href="tampil.php">Tampil</a></td> </table> </FORM> </fieldset> <center>Copyright © Khidir Zahid. All right Reserved.</center> </body> </html>
- Buat file php baru dengan nama koneksi.php
<?php mysql_connect("localhost","root","") or die("Koneksi Gagal"); mysql_select_db("db_nilai") or die("Database Tidak Ditemukan"); ?>
- Buat file php lagi dengan nama proses.php
<?php include('koneksi.php'); $nama = addslashes ($_POST['nama']); $nis = addslashes($_POST['nis']); $matematika = addslashes($_POST['matematika']); $bindonesia = addslashes ($_POST['bindonesia']); $binggris = addslashes ($_POST['binggris']); $produktif = addslashes ($_POST['produktif']); $ratarata = addslashes ($matematika+$bindonesia+$binggris+$produktif)/4; if ($ratarata >= 90) { $grade = "A"; } elseif ($ratarata >=80) { $grade = "B"; } elseif ($ratarata >=75) { $grade = "C"; } elseif ($ratarata <=70) { $grade = "Remedial"; } $query = mysql_query("insert into tbl_nilai (id,nama,nis,matematika,bindonesia,binggris,produktif,ratarata,grade) values ('','$nama','$nis','$matematika','$bindonesia','$binggris','$produktif','$ratarata','$grade')") or die(mysql_error()); if ($query) { header('location:index.php?message=success'); } ?>
- Buat file php dengan nama tampil.php
<?php include('koneksi.php'); ?> <html> <head> <title>TAMPIL DATA NILAI</title> </head> <body> <h1>Tampil Data Nilai</h1> <a href="index.php"> + Tambah Data</a> <table border="2" cellpadding="0" cellspacing="0"> <thead> <tr> <td text align="center" width="50" height="50">No.</td> <td text align="center" width="100" height="50">Nama</td> <td text align="center" width="100" height="50">NIS</td> <td text align="center" width="100" height="50">Matematika</td> <td text align="center" width="100" height="50">B. indonesia</td> <td text align="center" width="100" height="50">B. inggris</td> <td text align="center" width="100" height="50">Produktif</td> <td text align="center" width="100" height="50">Rata - rata</td> <td text align="center" width="100" height="50">Grade</td> <td text align="center" width="100" height="50">Action</td> </tr> </thead> <tbody> <?php $query = mysql_query("select * from tbl_nilai"); $no = 1; while ($data = mysql_fetch_array($query)) { ?> <tr> <td text align="center" width="50" height="50"><?php echo $no; ?></td> <td text align="center" width="100" height="50"><?php echo strip_tags($data['nama']); ?></td> <td text align="center" width="100" height="50"><?php echo strip_tags($data['nis']); ?></td> <td text align="center" width="100" height="50"><?php echo strip_tags($data['matematika']); ?></td> <td text align="center" width="100" height="50"><?php echo strip_tags($data['bindonesia']); ?></td> <td text align="center" width="100" height="50"><?php echo strip_tags($data['binggris']); ?></td> <td text align="center" width="100" height="50"><?php echo strip_tags($data['produktif']); ?></td> <td text align="center" width="100" height="50"><?php echo strip_tags($data['ratarata']); ?></td> <td text align="center" width="100" height="50"><?php echo strip_tags($data['grade']); ?></td> <td text align="center" width="100" height="50"> <a href="edit.php?id=<?php echo $data['id']; ?>">Edit</a> || <a href="hapus.php?id=<?php echo $data['id']; ?>">Hapus</a> </td> </tr> <?php $no++; } ?> </tbody> </table> <center>Copyright © Khidir Zahid. All right Reserved.</center> </body> </html>
- Buat file php dengan nama hapus.php
<?php include('koneksi.php'); $id = $_GET['id']; $query = mysql_query("delete from tbl_nilai where id='$id'") or die(mysql_error()); if ($query) { header('location:tampil.php?message=delete'); } ?>
- Buat file php dengan nama edit.php
<?php include('koneksi.php'); ?> <html> <head> <title>FORM EDIT NILAI</title> </head> <body> <fieldset> <legend> <h3>Edit Data Nilai</h3> </legend> <?php $id = $_GET['id']; $query = mysql_query("select * from tbl_nilai where id='$id'") or die(mysql_error()); $data = mysql_fetch_array($query); ?> <form action="proses_ubah.php" method="post"> <input type="hidden" name="id" value="<?php echo $id; ?>" /> <table border="0" cellpadding="5" cellspacing="0"> <tbody> <tr> <td text align="left">Nama</td> <td>:</td> <td><input type="text" name="nama" maxlength="20" required="required" placeholder="" value="<?php echo $data['nama']; ?>" /></td> </tr> <tr> <td text align="left">NIS</td> <td>:</td> <td><input type="text" name="nis" maxlength="20" required="required" placeholder="" value="<?php echo $data['nis']; ?>" /></td> </tr> <tr> <td text align="left">Matematika</td> <td>:</td> <td><input type="number" name="matematika" maxlength="20" required="required" placeholder="" value="<?php echo $data['matematika']; ?>" /></td> </tr> <tr> <td text align="left">B. Indonesia</td> <td>:</td> <td><input type="number" name="bindonesia" maxlength="20" required="required" placeholder="" value="<?php echo $data['bindonesia']; ?>" /></td> </tr> <tr> <td text align="left">B. Inggris</td> <td>:</td> <td><input type="number" name="binggris" maxlength="20" required="required" placeholder="" value="<?php echo $data['binggris']; ?>" /></td> </tr> <tr> <td text align="left">Produktif</td> <td>:</td> <td><input type="number" name="produktif" maxlength="20" required="required" placeholder="" value="<?php echo $data['produktif']; ?>" /></td> </tr> <tr> <td align="right" colspan="3"><input type="submit" name="submit" value="Update" /></td> </tr> </tbody> </table> </form> </fieldset> <a href="tampil.php">Lihat Data</a> <center>Copyright © Khidir Zahid. All right Reserved.</center> </body> </html>
- Terakhir buat file php dengan nama proses_ubah.php
<?php include('koneksi.php'); $id = $_POST['id']; $nama = $_POST['nama']; $nis = $_POST['nis']; $matematika = $_POST['matematika']; $bindonesia = $_POST['bindonesia']; $binggris = $_POST['binggris']; $produktif = $_POST['produktif']; $query = mysql_query("update tbl_nilai set nama='$nama', nis='$nis', matematika='$matematika', bindonesia='$bindonesia', binggris='$binggris', produktif='$produktif' where id='$id'") or die(mysql_error()); if ($query) { header('location:tampil.php?message=success'); } ?>
