Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
Saya mau bertanya gan data tidak bisa input ke data base
setalah saya klik daftar langsung muncul Mohon maaf sistem sedang bermasalah, Gagal menyimpan data, padahal koneksi ke databasnya benar
<?php include_once('config.php');?>
<!DOCTYPE html>
<html>
<head>
<title>LPPM UIM</title>
<link rel="stylesheet" type="text/css" href="asset/style.css">
<!-- link untuk pemanggilan css ada di folder asset/style.css -->
</head>
<body>
<!-- header -->
<?php include_once('content/header.php');?>
<!-- | header | -->
<!-- sidebar -->
<?php include_once('content/sidebar.php');?>
<!-- | sidebar | -->
<!-- prooses input data base -->
<?php
$notif = "";
if (isset($_POST['daftar'])){
$no_daftar = date('dhms');
$nama = $_POST['nama'];
$npm = $_POST['npm'];
$fakultas = $_POST['fakultas'];
$program_studi = $_POST['program_studi'];
$tanggal_lahir = $_POST['tanggal_lahir'];
$jenis_kelamin = $_POST['jenis_kelamin'];
$alamat = $_POST['alamat'];
$telepon = $_POST['telepon'];
$email = $_POST['email'];
$file = $_FILES['file_transkip']['name'];
//rENAME EFFIL
if(isset($_FILES['file_transkip']['name'])){
$ext = pathinfo($_FILES['file_transkip']['name'],PATHINFO_EXTENSION);
$_FILES['file_transkip']['name'] = date('dmyhis').'.'.$ext;
$files = $_FILES['file_transkip']['name'];
$mime_type = array('image/gif','image/jpeg','image/jpg','image/png','image/x-png');
if(in_array($_FILES['file_transkip']['type'], $mime_type)){
$upload = move_uploaded_file($_FILES['file_transkip']['tmp_name'],"upload".DIRECTORY_SEPARATOR.$files);
if($upload){
$query = mysqli_query($con, "INSERT INTO tbl_mahasiswa(
no_daftar,
nama,
npm,
fakultas,
program_studi,
tanggal_lahir,
jenis_kelamin,
alamat,
telepon,
email,
file_transkip,
surat_keterangan)
VALUES(
'$no_daftar',
'$nama',
'$npm',
'$fakultas',
'$program_studi',
'$tanggal_lahir',
'Masih Dalam Proses',
'$alamat',
'$telepon',
'$email',
'$file')
");
if($query){
$notif = "<i style='color:blue'>Anda terdaftar dengan no daftar <b><a href='status.php?no_daftar=$no_daftar&cari=cari' target='_blank'>$no_daftar</a></b></i>";
}else{
$notif = "Mohon maaf sistem sedang bermasalah, Gagal menyimpan data";
}
}else{
$notif = "Mohon maaf sistem sedang bermasalah";
}
}else{
$notif = "Tipe file tidak diijinkan !";
}
}
}
?>
<!-- | prooses input data base | -->
<!-- section -->
<div class="section">
<h1 class="judul">Formulir Pendaftaran Kuliyah Kerja Nyata (KKN)</h1>
<small>
<i style="color: red"><?php echo $notif; ?></i>
</small>
<form action="" method="post" id="form-pendaftaran" class="form-pendaftaran" enctype="multipart/form-data">
<table border="1">
<tr>
<td>Fakultas</td>
<td>
<select name="fakultas" class="input">
<?php
$query = mysqli_query($con , "SELECT * FROM tbl_fakultas");
if(mysqli_num_rows($query)>0){
while ($colom = mysqli_fetch_array($query)) {
echo "<option value='".$colom[0]. "'>".$colom[1]. "</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<td>Program Studi</td>
<td>
<select name="program_studi" class="input">
<?php
$query = mysqli_query($con , "SELECT * FROM program_studi");
if(mysqli_num_rows($query)>0){
while ($colom = mysqli_fetch_array($query)) {
echo "<option value='".$colom[0]. "'>".$colom[1]. "</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<td>Nama</td>
<td>
<input type="text" name="nama" class="input" placeholder="Masukkan Nama Lengkap anda">
</td>
</tr>
<tr>
<td>Npm</td>
<td>
<input type="text" name="npm" class="input" placeholder="Masukkan Npm anda">
</td>
</tr>
<tr>
<td>Tanggal Lahir </td>
<td>
<input type="date" name="tanggal_lahir" class="input">
</td>
</tr>
<tr>
<td>Jenis Kelamin </td>
<td>
<select name="jenis_kelamin" class="input">
<option value="L">Laki-laki</option>
<option value="P">Perempuan</option>
</select>
</td>
</tr>
<tr>
<td>Alamat</td>
<td>
<textarea name="alamat" class="input"></textarea>
</td>
</tr>
<tr>
<td>Telepon</td>
<td>
<input type="number" name="telepon" class="input" placeholder="masukkan no tlp anda">
</td>
</tr>
<tr>
<td>Email</td>
<td>
<input type="email" name="email" class="input" placeholder="Masukkan email yang aktif">
</td>
</tr>
<tr>
<td>Transkip Nilai</td>
<td>
<input type="file" name="file_transkip" class="input">
</td>
</tr>
<tr>
<td>Surat Keterangan Aktif Kuliyah</td>
<td>
<input type="file" name="surat_keterangan" class="input">
</td>
</tr>
<tr>
<td>Surat Pernyataan</td>
<td>
<input type="file" name="surat_pernyataan" class="input">
</td>
</tr>
<tr>
<td>Surat Keterangan Sehat</td>
<td>
<input type="file" name="surat_ks" class="input">
</td>
</tr>
<tr>
<td>Foto Copy BKM</td>
<td>
<input type="file" name="bkm" class="input">
</td>
</tr>
<tr>
<td>Foto Copy KTM</td>
<td>
<input type="file" name="ktm" class="input">
</td>
</tr>
<tr>
<td></td>
<td>
<button name="daftar" class="input">daftar</button>
<input type="reset" value="reset">
</td>
</tr>
</table>
</form>
</div>
<!-- | section | -->
<!-- footer -->
<?php include_once('content/footer.php');?>
<!-- | footer | -->
</body>
</html>
0
5 Jawaban:
ini cofignya bang
<?php
error_reporting(E_ALL);
/* Pengaturan Database */
$host = "localhost";
$username = "root";
$password = "";
$database = "db_sipmaba";
$system_path = dirname(__FILE__);
$app_path = 'http://localhost/lppm';
$con = mysqli_connect($host, $username, $password, $database);
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>
0
Hmmmm mungkin sama seperti ini #newbie #cmiiw ane sudah nda pake mysqli prosedural
sumber https://www.w3schools.com/php/php_mysql_insert.asp
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>
0
inputan di "Values" kurang 1 gan, coba cek lagi
0
atas ane benar nih kurang surat keterangan
0