part 3
KONEKSI
<?php
$host = mysqli_connect ("localhost","root","");
if($host){
echo "koneksi host berhasil.<br>";
}else{
echo "koneksi host gagal.<br>";
}
$db = mysqli_select_db ($host, "tiga");
if($db){
echo "koneksi ke DB berhasil.<br>";
}else{
echo "koneksi ke DB gagal.<br>";
}
?>
FORMULIR
<!DOCTYPE html>
<html>
<head>
<title>Undangan</title>
</head>
<body>
<form method="post" action="tampil.php">
<label>Nama : </label><input type="text" name="nama"><br>
<label>Jenis Kelamin : </label><input type="text" name="jk"><br>
<input type="submit" value=kirim><br>
<input type="reset" name="reset">
</form>
</body>
</html>
TAMPILAN
<?php
include "koneksi.php";
$nama = $_POST['nama'];
$jk = $_POST['jk'];
$input = "insert into siswa (nama,jk) values ('$nama','$jk')";
$hasil=mysqli_query($host, $input);
if ($hasil) {
echo "Proses input data berhasil";
}else{
echo "Proses input data gagal";
}
?>
<?php
require ("koneksi.php");
$code = mysqli_query($host, "SELECT * FROM siswa ");
?>
<!DOCTYPE html>
<html>
<head>
<title>Tabel</title>
</head>
<body>
<h2 align="center">ISI</h2>
<table border="5" align="center">
<tr>
<th>No</th>
<th>ID</th>
<th>Nama</th>
<th>Jenis Kelamin</th>
</tr>
<?php $i = 1; ?>
<?php
foreach ($code as $row) { ?>
<tr> <td> <?php echo $i; ?></td>
<td> <?php echo $row["id"]; ?></td>
<td> <?php echo $row["nama"]; ?></td>
<td> <?php echo $row["jk"]; ?></td>
</tr>
<?php $i++; ?>
<?php } ?>
</table>
</body>
</html>
.png)
Komentar
Posting Komentar