Project 3
koneksi.php
<?php
$koneksi = mysqli_connect("localhost","root","","db_praktek") ;
function tambah($data){
global $koneksi;
$nama = $_POST['nama'];
$jenkel = $_POST['jenkel'];
$query = mysqli_query($koneksi, "INSERT INTO projecttiga (nama,jenkel) VALUES ('$nama','$jenkel')");
return mysqli_affected_rows($koneksi);
}
?>
form.php
<?php
require 'koneksi.php';
if (isset($_POST['submit'])) {
if (tambah($_POST)>0){
header("location: hasil.php");
}else{
echo "gagal";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title></title>
</head>
<body>
<form method="POST">
<label>Nama : </label>
<input type="text" name="nama">
<br>
<label>Jenis Kelamin : </label>
<input type="radio" name="jenkel" value="laki">Laki-laki
<input type="radio" name="jenkel" value="perempuan">Perempuan
<br>
<input type="submit" name="submit">
<input type="reset" name="reset">
</form>
</body>
</html>
.png)
hasil.php
<?php
require 'koneksi.php';
$sql = mysqli_query($koneksi, "SELECT * FROM projecttiga ORDER BY id DESC LIMIT 1") ;
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title></title>
</head>
<body>
<table border="2">
<tr>
<th>Nama</th>
<th>Jenis Kelamin</th>
</tr>
<?php
foreach ($sql as $row) {
?>
<tr>
<td><?php echo $row ["nama"]; ?></td>
<td><?php echo $row ["jenkel"]; ?></td>
</tr>
<?php } ?>
</table>
</body>
</html>
.png)
.png)
Komentar
Posting Komentar