Postingan lainnya
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