Membuat Data Pendaftaran - LA PHP 6
1. Membuat halaman awal
form (index.php)
__________________________________________________________________________________
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Input Data - Neva</title>
<style>
table {
border-collapse: collapse;
}
th, td {
border: 1px solid black;
padding: 8px;
}
</style>
</head>
<body>
<body background="https://wallpapercave.com/wp/wp5494102.jpg"></body>
<h2>Data Pendaftaran - Nv</h2>
<form action="simpan.php" method="POST">
<table>
<tr>
<td>Nama:</td>
<td><input type="text" name="nama"></td>
</tr>
<tr>
<td>Kelas:</td>
<td><input type="text" name="kelas"></td>
</tr>
<tr>
<td>NPM:</td>
<td><input type="text" name="npm"></td>
</tr>
<tr>
<td>Alamat:</td>
<td><input type="text" name="alamat"></td>
</tr>
<tr>
<td>Status:</td>
<td><input type="text" name="status"></td>
</tr>
<tr>
<td>Jenis Kelamin:</td>
<td><input type="text" name="jk"></td>
</tr>
<tr>
<td>Hobi:</td>
<td><input type="text" name="hobi"></td>
</tr>
<tr>
<td>Umur:</td>
<td><input type="text" name="umur"></td>
</tr>
<tr>
<td>Agama:</td>
<td><input type="text" name="agama"></td>
</tr>
</table>
<br>
<input type="submit" value="Save">
</form>
</body>
</html>
__________________________________________________________________________________
2. Membuat file koneksi.php untuk mengkoneksikan
ke database xampp
__________________________________________________________________________________
<?php
$host = "localhost";
$user = "root";
$pass = "";
$db = "nevapr";
$conn = new mysqli($host, $user, $pass, $db);
if ($conn->connect_error) {
die("Koneksi Gagal: " . $conn->connect_error);
} else {
echo "Koneksi Berhasil!";
}
?>
__________________________________________________________________________________
-
3.Membuat file simpan.php untuk
menyimpan data inputan ke dalam database
__________________________________________________________________________________
<?php
include 'koneksi.php';
if ($_SERVER["REQUEST_METHOD"] == "POST"){
$nama = isset($_POST['nama']) ? $_POST['nama'] : '';
$kelas = isset($_POST['kelas']) ? $_POST['kelas'] : '';
$npm = isset($_POST['npm']) ? $_POST['npm'] : '';
$alamat = isset($_POST['alamat']) ? $_POST['alamat'] : '';
$status = isset($_POST['status']) ? $_POST['status'] : '';
$jk = isset($_POST['jk']) ? $_POST['jk'] : '';
$hobi = isset($_POST['hobi']) ? $_POST['hobi'] : '';
$umur = isset($_POST['umur']) ? $_POST['umur'] : '';
$agama = isset($_POST['agama']) ? $_POST['agama'] : '';
$sql = "INSERT INTO tabel_neva (nama, kelas, npm, alamat, status, jk, hobi, umur, agama) VALUES ('$nama', '$kelas', '$npm', '$alamat', '$status', '$jk', '$hobi', '$umur', '$agama')";
if ($conn->query($sql) == TRUE) {
echo "Data Berhasil Disimpan Guys";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
$conn->close();
?>
__________________________________________________________________________________
4. Membuat database dixampp dengan nama nevapr dan juga membuat tabel di sqlnya dengan nama tabel_neva lalu paste kan codingan ini di SQL
__________________________________________________________________________________
CREATE TABLE IF NOT EXISTS tabel_neva(
id INT AUTO_INCREMENT PRIMARY KEY,
nama VARCHAR(255) NOT NULL,
kelas VARCHAR(255) NOT NULL,
npm VARCHAR(255) NOT NULL,
alamat VARCHAR(255) NOT NULL,
status VARCHAR(255) NOT NULL,
jk VARCHAR(255) NOT NULL,
hobi VARCHAR(255) NOT NULL,
umur VARCHAR(255) NOT NULL,
agama VARCHAR(255) NOT NULL
);
__________________________________________________________________________________
.png)
Belum ada Komentar untuk "Membuat Data Pendaftaran - LA PHP 6"
Posting Komentar