Contoh Menginputkan Data Ke Database
1. index.php<html>
<body>
<h2>Tambah Mahasiswa</h2>
<form method = "post" action="dua.php">
<br>
Masukan NIM : <br>
<input type="text" name="nim" minlength="4" maxlength="7"><br>
Masukan Nama : <br>
<input type="text" name="nama" minlength="5"><br>
Masukan Prodi : <br>
<select name = "prodi">
<option value="informatika">informatika</option>
<option value="elektro">elektro</option>
<option value="kimia">kimia</option>
<option value="industri">industri</option>
</select><br>
Masukan No. Telpon : <br>
<input type="number" name="no_telp"><br>
Masukan Alamat : <br>
<textarea name="alamat"></textarea><br>
<input type="submit" value="masuk">
</form>
</body>
</html>
2. dua.php
<?php
include "connect.php";
$nim = $_POST ['nim'];
$nama = $_POST ['nama'];
$prodi = $_POST ['prodi'];
$no_telp = $_POST ['no_telp'];
$alamat = $_POST ['alamat'];
$query = "insert into mhs (nim,nama,prodi,no_telp,alamat)
values('$nim', '$nama', '$prodi', '$no_telp', '$alamat')";
if($db->query($query) == true){
echo "berhasil simpan";
}else{
echo "gagal";
}
?>
3. conect.php
<?php
$db = new mysqli("localhost","root","","1400018135");
?>
0 komentar: