MEMBUAT APLIKASI DARI DASAR HINGGA MAHIR
File 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, "praktik");
if($db){
echo "koneksi ke DB berhasil.<br>";
}else{
echo "koneksi ke DB gagal.<br>";
}
?>
File formulir.php
<!DOCTYPE html>
<html>
<head>
<title>Undangan</title>
</head>
<body>
<form method="post" action="vikas.php">
<label>Nama : </label><input type="text" name="nama"><br>
<input type="submit" value=kirim>
</form>
</body>
</html>
FIle vikas.php
<?php
include "koneksi.php";
$nama = $_POST['nama'];
$input = "insert into lat (nama) values ('$nama')";
$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 lat ORDER BY id DESC LIMIT 5 ");
?>
<!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>
</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>
</tr>
<?php $i++; ?>
<?php } ?>
</table>
</body>
</html>
OUTPUT :
MEMBUAT FILE KONEKSI
.png)
Komentar
Posting Komentar