Praktik ke 2
Code koneksi.php
<?php
$conn = mysqli_connect("localhost", "root", "", "praktik2");
?>
Code index.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title> Input output database</title>
</head>
<body>
<form method="post" action="tampilan.php">
<label> nama : </label>
<input type="text" name="nama"><br><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>
<input type="submit" value="kirim" name="proses">
<input type="reset" value="reset">
</form>
</body>
</html>
Code tampilan.php
<?php
include "koneksi.php";
if(isset($_POST['proses'])){
mysqli_query($conn, "insert into projek2 set
NAMA = '$_POST[nama]',
KELAS = '$_POST[kelas]'");
echo "*Data baru telah tersimpan";
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<h1> TAMPILKAN DATA </h1>
<table border="1">
<tr>
<th>ID</th>
<th>NAMA</th>
<th>KELAS</th>
</tr>
<?php
include 'koneksi.php';
$tampil = mysqli_query($conn, "SELECT * FROM projek2 order by ID desc limit 1");
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
}
?>
</table>
</body>
</html>
Komentar
Posting Komentar