Assalamualaikum Warahmatullahi Wabarakatuh,
Sekarang kita akan membuat form dan aksinya untuk menyimpan data kedalam database, berikut sourcodenya :
tambah_mahasiswa.php
<!DOCTYPE html>
<html>
<head>
<title>Tambah Mahasiswa</title>
</head>
<body>
<h1>Tambah Mahasiswa</h1>
<form method="post" action="action/tambah_mahasiswa.php">
<table>
<tr>
<td>NIM</td>
<td colspan="2"><input type="number" min="0" name="nim" required></td>
</tr>
<tr>
<td>Nama</td>
<td colspan="2"><input type="text" name="nama" required></td>
</tr>
<tr>
<td>Jenis Kelamin</td>
<td><input type="radio" name="jk" value="0" checked> Laki-laki</td>
<td><input type="radio" name="jk" value="1"> Perempuan</td>
</tr>
<tr>
<td>Nomor Telepon</td>
<td colspan="2">
<input type="number" min="0" max="999999999999"
name="no_tlp" placeholder="Ex: 085209451326" required>
</td>
</tr>
<tr>
<td>Alamat</td>
<td colspan="2">
<textarea rows="10" cols="50" name="alamat" required></textarea>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="submit" value="Submit"></td>
<td><a href="index.php">Back</a></td>
</tr>
</table>
</form>
</body>
</html>
<html>
<head>
<title>Tambah Mahasiswa</title>
</head>
<body>
<h1>Tambah Mahasiswa</h1>
<form method="post" action="action/tambah_mahasiswa.php">
<table>
<tr>
<td>NIM</td>
<td colspan="2"><input type="number" min="0" name="nim" required></td>
</tr>
<tr>
<td>Nama</td>
<td colspan="2"><input type="text" name="nama" required></td>
</tr>
<tr>
<td>Jenis Kelamin</td>
<td><input type="radio" name="jk" value="0" checked> Laki-laki</td>
<td><input type="radio" name="jk" value="1"> Perempuan</td>
</tr>
<tr>
<td>Nomor Telepon</td>
<td colspan="2">
<input type="number" min="0" max="999999999999"
name="no_tlp" placeholder="Ex: 085209451326" required>
</td>
</tr>
<tr>
<td>Alamat</td>
<td colspan="2">
<textarea rows="10" cols="50" name="alamat" required></textarea>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="submit" value="Submit"></td>
<td><a href="index.php">Back</a></td>
</tr>
</table>
</form>
</body>
</html>
action/tambah_mahasiswa.php
simpan pada folder action sebagai aksi untuk menyimpan data yang dikirim dari form kedalam database.
<?php
/**
* Created by PhpStorm.
* User: alfig
* Date: 26/11/2018
* Time: 20.22
*/
include "../config/database.php";
$nim = $_POST['nim'];
$nama = $_POST['nama'];
$jk = $_POST['jk'];
$no_tlp = $_POST['no_tlp'];
$alamat = $_POST['alamat'];
$sql = "INSERT INTO tbl_mahasiswa(`nim`, `nama`, `jk`, `no_tlp`, `alamat`) VALUES('$nim', '$nama', '$jk', '$no_tlp', '$alamat')";
if ($mysqli->query($sql)){
echo "data berhasil disimpan. <br />";
echo "<a href='../index.php'>View Data</a>";
}else{
echo "data gagal disimpan : ".$mysqli->error."<br />";
echo "<a href='../index.php'>View Data</a>";
}
$mysqli->close();
Metode untuk mengirim data dari form, kita menggunakan metode "POST" yang nanti akan diterima pada action (tujuan) yang nantinya akan diproses dan kemudian disimpan kedalam database./**
* Created by PhpStorm.
* User: alfig
* Date: 26/11/2018
* Time: 20.22
*/
include "../config/database.php";
$nim = $_POST['nim'];
$nama = $_POST['nama'];
$jk = $_POST['jk'];
$no_tlp = $_POST['no_tlp'];
$alamat = $_POST['alamat'];
$sql = "INSERT INTO tbl_mahasiswa(`nim`, `nama`, `jk`, `no_tlp`, `alamat`) VALUES('$nim', '$nama', '$jk', '$no_tlp', '$alamat')";
if ($mysqli->query($sql)){
echo "data berhasil disimpan. <br />";
echo "<a href='../index.php'>View Data</a>";
}else{
echo "data gagal disimpan : ".$mysqli->error."<br />";
echo "<a href='../index.php'>View Data</a>";
}
$mysqli->close();
Terimakasih.
Posting Komentar