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 19-12-2015 18:57
0
841
2
GuestAvatar border
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Urutan
Terbaru
Terlama
GuestAvatar border
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan