Kaskus

Tech

chacha1008Avatar border
TS
chacha1008
minta tolong bgt gan
pas tekan tombol daftar muncul Column count doesn't match value count at row 1
padahal sebelumnya pas insert bisa aja masuk database sekarang error emoticon-Frown
mnta saran?
<?php
$n_sek_baru = "";
$mode_form = isset($_GET['mod']) ? $_GET['mod'] : "";
$id_peserta = isset($_GET['id']) ? $_GET['id'] : "";

$p_tombol = isset($_POST['kirim_daftar']) ? $_POST['kirim_daftar'] : "";

//variabel POST
//$q_daftar = isset($_POST['q_daftar']) ? $_POST['q_daftar'] : NULL;
$p_id_peserta = isset($_POST['id_peserta']) ? $_POST['id_peserta'] : "";
$p_username = isset($_POST['username']) ? $_POST['username'] : "";
$p_password = isset ($_POST['password']) ? md5 ($_POST['password']) : "";
$p_namapeserta = isset($_POST['namapeserta']) ? strtoupper($_POST['namapeserta']) : "";
$p_alamat = isset($_POST['alamat']) ? $_POST['alamat'] : "";
$p_jeniskelamin = isset($_POST['jeniskelamin']) ? $_POST['jeniskelamin'] : "";
$p_tmp_lahir = isset($_POST['tmp_lahir']) ? $_POST['tmp_lahir'] : "";
$p_tgl_lahir = isset($_POST['tgl_lahir']) ? $_POST['tgl_lahir'] : "";
$p_bln_lahir = isset($_POST['bln_lahir']) ? $_POST['bln_lahir'] : "";
$p_thn_lahir = isset($_POST['thn_lahir']) ? $_POST['thn_lahir'] : "";
$p_asalinstitusi = isset($_POST['asalinstitusi']) ? $_POST['asalinstitusi'] : "";
$p_jurusan = isset($_POST['jurusan']) ? $_POST['jurusan'] : "";
$p_bagianpenempatan = isset($_POST['bagianpenempatan']) ? $_POST['bagianpenempatan'] : "";
$p_tglmulai = isset($_POST['tgl_mulai']) ? $_POST['tgl_mulai'] : "";
$p_tglakhir = isset($_POST['tgl_akhir']) ? $_POST['tgl_akhir'] : "";
$upload= isset ($_FILES['upload']) ? $_FILES ['upload'] :"";
$p_submit = "DAFTAR";

/*-------- VARIABEL TAMBAHAN ------------*/
if ($mode_form == "add") {
$pj_bln_lahir = strlen($p_bln_lahir);
$pj_tgl_lahir = strlen($p_tgl_lahir);

if ($pj_bln_lahir < 2) {
$p_bln_lahir = "0".$p_bln_lahir;
}
if ($pj_tgl_lahir < 2) {
$p_tgl_lahir = "0".$p_tgl_lahir;
}

$ttl_gabung = $p_thn_lahir."-".$p_bln_lahir."-".$p_tgl_lahir;
}


if ($p_tombol == "DAFTAR") {
/* PENGECEKAN INPUTAN KOSONG YANG ke-2 sekaligus akses LANGSUNG lewat $_GET */

if ($p_username == "" ||$p_password == "" || $p_namapeserta == "" || $p_alamat == "" || $p_jeniskelamin == "" || $p_tmp_lahir == ""
|| $p_tgl_lahir == 0 || $p_bln_lahir == 0 || $p_thn_lahir == 0 || $p_asalinstitusi == "" || $p_jurusan == ""
|| $p_bagianpenempatan == "" || $p_tglmulai == "" || $p_tglakhir == ""||$upload=="") {

echo "<h4 class='alert_error'>Kesalahan pada pengisian form (Masih kosong)<span id='close'>[<a href='#'>X</a>]</span></h4>";


//definisikan variabel file dan alamat file
$uploaddir='./gambar/';
$alamatfile=$uploaddir.$upload;
//pengecekan data GANDA - jika pengguna gak sengaja merefresh form//
$q_cek_ganda = mysql_query("SELECT * FROM t_peserta WHERE username = '$p_username'");
$j_cek_ganda = mysql_fetch_array($q_cek_ganda);

if ($j_cek_ganda > 0) {
echo "<h4 class='alert_error'>Data Ganda Gara2 Auto Refresh<span id='close'>[<a href='#'>X</a>]</span></h4>";
}
else {
//INTINYA... INSERT Data Pendaftar ke tabel "t_peserta" */
$q_submit = mysql_query("INSERT INTO t_peserta VALUES
('','$p_username','$p_password', '$p_namapeserta', '$p_alamat', '$p_jeniskelamin', '$p_tmp_lahir',
'$ttl_gabung','$p_asalinstitusi', '$p_jurusan', '$p_bagianpenempatan',
'$p_tglmulai', '$p_tglakhir', '$upload')");
if ($q_submit) {
echo "<h4 class='alert_success'>Data berhasil ditambahkan. $n_sek_baru. <a href='../formulir_daftar.php?dari=umum&username=$p_username' target='_blank'>Cetak Formulir</a><span id='close'>[<a href='#'>X</a>]</span></h4>";
} else {
echo "<h4 class='alert_error'>".mysql_error()."<span id='close'>[<a href='#'>X</a>]</span></h4>";
}
}

}
}

/*-------- ACTION --------------*/



?>



<article class="module width_full">
<header><h3>Data Calon Peserta</h3></header>
<div class="module_content">
<form action="?p=daftar_form&mod=add" method="post" name="form_daftar">
<input type="hidden" name="id_peserta" value="<?php echo $id_peserta; ?>">
<table class="tbl_form">
<tr><td>Username</td>
<td><input type="text" size="15" name="username" class="form-control" value="<?php echo $p_username; ?>"></td></tr>
<tr><td>Password</td>
<td><input type="password" size="15" name="password" class="form-control" value="<?php echo $p_password; ?>"></td></tr>
<tr><td>Nama Peserta</td>
<td><input type="text" size="35" name="namapeserta" class="form-control" value="<?php echo $p_namapeserta; ?>"></td></tr>
<tr><td>Alamat</td>
<td><input type="text" size="35" name="alamat" class="form-control" value="<?php echo $p_alamat; ?>"></td></tr>

<tr><td>Jenis Kelamin</td>
<td><select name="jeniskelamin" value="<?php echo $p_jeniskelamin; ?>" >
<option>Laki-laki</option>
<option>Perempuan</option>
</select></td>
</tr>
<?php cCmbTglLahir($p_tmp_lahir, $p_tgl_lahir, $p_bln_lahir, $p_thn_lahir);
?>
<tr><td>Upload Foto</td>
<td><input type="file" id="uploadImage" name="gambar" accept="image/*" value="<?php echo $upload; ?>"></td></tr>
</table>
</div>
</article>
<article class="module width_full">
<header><h3>Data Institusi</h3></header>
<div class="module_content">
<table class="tbl_form">
<tr><td>Asal Institusi</td>
<td><input type="text" size="35" name="asalinstitusi" class="form-control" value="<?php echo $p_asalinstitusi; ?>"></td></tr>
<tr><td>Jurusan</td>
<td><input type="text" size="35" name="jurusan" class="form-control" value="<?php echo $p_jurusan; ?>"></td></tr>
</table>
</div>
</article>
<article class="module width_full">
<header><h3>Data Pilihan</h3></header>
<div class="module_content">
<table class="tbl_form">
<?php
cCmbBagianpenempatan($p_bagianpenempatan);
?>

<tr><td>Tanggal Mulai</td>
<td><select type="text" name="tgl" class="form-control" placeholder="Tanggal" required >
<?php for($tgl=1; $tgl<=31; $tgl++) {
echo "<option value=$tgl>$tgl</option>";
}
?></td>
<td><select type="text" name="bln" class="form-control" placeholder="Bulan" required >
<?php $nama_bln=array(1=>"Jan","Feb","Mar","Apr","Mei","Jun","Jul","Agt","Sep","Okt","Nov","Des");
echo "<option value=0>Bulan:</option>";
for ($bln=1; $bln<=12; $bln++) {
echo "<option value=$bln>$nama_bln[$bln]</option>";
}
?>
<td><select type="text" name="thn" class="form-control" placeholder="Tahun" required >
<?php
$thn_sekarang=date("Y");
for($thn=2015; $thn<=$thn_sekarang;$thn++) {
echo "<option value=$thn>$thn</option>";
}
?>
</td>
</tr>
<tr><td> Tanggal Akhir</td>
<td><select type="text" name="tgl" class="form-control" placeholder="Tanggal" required >
<?php for($tgl=1; $tgl<=31; $tgl++) {
echo "<option value=$tgl>$tgl</option>";
}
?></td>
<td><select type="text" name="bln" class="form-control" placeholder="Bulan" required >
<?php $nama_bln=array(1=>"Jan","Feb","Mar","Apr","Mei","Jun","Jul","Agt","Sep","Okt","Nov","Des");
echo "<option value=0>Bulan:</option>";
for ($bln=1; $bln<=12; $bln++) {
echo "<option value=$bln>$nama_bln[$bln]</option>";
}
?>
<td><select type="text" name="thn" class="form-control" placeholder="Tahun" required >
<?php
$thn_sekarang=date("Y");
for($thn=2015; $thn<=$thn_sekarang;$thn++) {
echo "<option value=$thn>$thn</option>";
}
?>
</td>
</td>
</tr>


</table>
</div>
</article>

<article class="module width_full">
<header><h3>Konfirmasi Data Pendaftar</h3></header>
<div class="module_content">
<table class="tbl_form"><tr><td>
<input type="checkbox" name="data_ok"> <label for="data_ok">Dengan ini saya menyatakan bahwa, Data yang saya isikan di Formulir
ini adalah Benar adanya sesuai dengan bukti-bukti yang ada</label><br><br>
<center><input type="submit" name="kirim_daftar" value="<?php echo $p_submit; ?>" id="tombol"></center>
</td></tr></table>
</form>
</div>
</article>
</html>

Diubah oleh chacha1008 20-12-2015 01:57
0
841
2
GuestAvatar border
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
Programmer Forum
KASKUS Official
20.2KThread4.9KAnggota
Urutkan
Terlama
GuestAvatar border
Komentar yang asik ya
Ikuti KASKUS di
© 2025 KASKUS, PT Darta Media Indonesia. All rights reserved.