PRAKTEK 2
source code file "koneksi3.php"
<?php
$host = mysqli_connect("localhost","root","","pwdpbpraktik2");
function tambah($data){
global $host;
$nama = $_POST['nama'];
$kelas = $_POST['kelas'];
$tampil = mysqli_query($host, "INSERT INTO projek (nama, kelas) VALUES ('$nama','$kelas')");
return mysqli_affected_rows($host);
}
?>
source code file "input3.php"
<?php
require 'koneksi3.php';
if (isset($_POST["submit"])) {
if(tambah($_POST)>0){
echo "DATA BERHASIL DITAMBAHKAN";
header("location: index3.php");
}else{
echo "DATA GAGAL DITAMBAHKAN";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form method="POST">
<label>NAMA : </label>
<input type="text" name="nama">
<br>
<label>KELAS : </label>
<select name="kelas">
<option value="X">X</option>
<option value="XI">XI</option>
<option value="XII">XII</option>
</select>
<br>
<br>
<br>
<input type="submit" name="submit">
<input type="reset" value="reset">
</form>
</body>
</html>
source code file "index3.php"
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<h1>TAMPILAN DATA</h1>
<table border="1">
<tr>
<th>ID</th>
<th>NAMA</th>
<th>KELAS</th>
</tr>
<?php
include 'koneksi3.php';
$tampil = mysqli_query($host, "SELECT * FROM projek");
foreach ($tampil as $data) {
?>
<tbody>
<tr>
<td><?php echo $data["id"]; ?></td>
<td><?php echo $data["nama"]; ?></td>
<td><?php echo $data["kelas"]; ?></td>
</tr>
</tbody>
<?php } ?>
</body>
</html>
source code file "form3.php"
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<?php
include 'koneksi3.php';
foreach ($tampil as $data){
?>
<tr>
<td><?php echo $data["id"]; ?></td>
<td><?php echo $data["nama"]; ?></td>
<td><?php echo $data["kelas"]; ?></td>
</tr>
<?php } ?>
</body>
</html>
HASIL TAMPILAN :
