- Beranda
- Programmer Forum
[HELP] CRUD: Tidak Meng-Insert Ke Table
...
TS
pseodolokian
[HELP] CRUD: Tidak Meng-Insert Ke Table
Para Suhu ane mau minta bantuan maklum ane masih newbie di dunia per-codingan. jadi gini ane kan buat form validasi. tampilannya seperti ini :
nah ini source code form validasinya :
ini source code untuk proses inputnya :
nah.. setelah ane jalanin formnya, dan di klik submit hanya keluar notif "Data Belum Tersimpan" dan data tdk meng-insert di table sepertinya script querynya tdk berjalan..., mohon bantuannya para suhu ane ud coba tanya Mbah Google tapi Mbah Google belum mau ngasih Ilham ke ane..
* Nanti hasil dari insert table untuk kolom Jenis Dokumen dan kolom Keberlakuan akan seperti ini :
Spoiler for form:
nah ini source code form validasinya :
Quote:
<?php
require_once('db_connect.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-5559-1" />
<title>Input Internal Document</title>
<--style type="text/css">
@import url("css/style.css");
</style-->
<head>
<body>
<div style="font-size:20px; font-family:Arial; font:style:normal; color:#FF7F00;"><b> FORM HASIL REVIEW KEBIJAKAN INTERNAL PERSEROAN</b></div>
<tr>
<td>
<table width="100%" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td width="300" height="16" background="images/longmenuleft.gif"></td>
<td height="16" background="images/longmenuright.gif"></td>
</tr>
</table>
<div style="font-size:16px; font-family:Arial; font-style:italic; color:#FF7F00; text-align:right;"><b> Internal Document Legal Regulation & Policy</b></div>
</tr>
<form name="input_data" action="insert.php" method="post">
<table border="0" cellpadding="8" cellspacing="4" bordercolor="#003300" align="center">
<tbody>
<tr>
<td width="146">Topik/Judul Kebijakan</td>
<td width="3">:</td>
<td width="425"><input type="text" name="topik" maxlength="100" id="topik" size="65" /></td>
</tr>
<tr>
<td>User<br />(Department)</td>
<td>:</td>
<td><input type="text" name="user" maxlength="100" id="user" size="65" /></td>
</tr>
<tr>
<td>Nama PIC</td>
<td>:</td>
<td><input type="text" name="pic" maxlength="100" id="pic" size="65" /></td>
</tr>
<tr>
<td>Nomor Ekstensi & HP</td>
<td>:</td>
<td><input type="text" name="ekstensi" maxlength="20" id="ekstensi" size="65" /></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><input type="text" name="email" maxlength="50" id="email" size="65" /></td>
</tr>
</tbody>
</table>
<tr> </tr>
<table width="647" border="0" cellpadding="8" cellspacing="4" bordercolor="#003300" align="center">
<tbody>
<tr>
<!--td-->
<th width="45%" align="left"><div style="font-size:15px; font-family:Arial; color:#FF7F00; text-decoration:underline;">Jenis Dokumen</div></th>
<!--/td-->
<th align="left" width="50%"><div style="font-size:15px; font-family:Arial; color:#FF7F00; text-decoration:underline;">Keberlakuan</div></th>
</tr>
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Keputusan Direksi" />
<label for="dokumen[]">Keputusan Direksi<br />
</label>
</td>
<td align="left" width="50%"><input name="berlaku[]" type="checkbox" id="berlaku[]" value="Antar Subdir" />
<label for="dokumen[]">Antar Subdir<br />
</label>
</td>
</tr>
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Keputusan Direktur"/>
<label for="dokumen[]">Keputusan Direktur<br />
</label>
</td>
<td align="left" width="50%"><input name="berlaku[]" type="checkbox" id="berlaku[]" value="Internal Subdir" />
<label for="dokumen[]">Internal Subdir<br />
</label>
</td>
</tr>
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Instruksi Direksi"/>
<label for="dokumen[]">Instruksi Direksi<br />
</label>
</td>
<td align="left" width="50%"><input name="berlaku[]" type="checkbox" id="berlaku[]" value="Eksternal"/>
<label for="dokumen[]">Eksternal<br />
</label>
</td>
</tr>
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Instruksi Direktur"/>
<label for="dokumen[]">Instruksi Direktur<br />
</label>
</td>
<td align="left" width="50%">Masa Jangka Waktu / Tanggal<br />Berlaku Kebijakan :
<br />
<select name="tgl" id="tgl">
<?php
for($i=1;$i<=31;$i++)
{
echo "<option> $i </option>";
}
?>
</select>
<select name="bln" id="bln">
<?php
for($i=1;$i<=12;$i++)
{
echo "<option> $i </option>";
}
?>
</select>
<input name="thn" type="text" id="thn" size="5" maxlength="4"/>
</td>
</tr>
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Syarat dan Ketentuan"/>
<label for="dokumen[]">Syarat dan Ketentuan<br />
</label>
</td>
<!--td align="left" width="50%"-->
<!--select name="tgl" id="tgl"-->
<!--?php
for($i=1;$i<=31;$i++)
{
echo "<option> $i </option>";
}
?>
</select>
<select name="tgl" id="tgl"-->
<!--?php
for($i=1;$i<=12;$i++)
{
echo "<option> $i </option>";
}
?>
</select>
<input name="thn" type="text" id="thn" size="5" maxlength="4"/>
</td>
</tr-->
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Legal Opini"/>
<label for="dokumen[]">Legal Opini<br />
</label>
</td>
</tr>
<tr> </tr>
</tbody>
</table>
<table border="0" cellpadding="8" cellspacing="4" bordercolor="#003300" align="center">
<tbody>
<tr>
<td width="146">Lain-lain</td>
<td width="3" align="left">:</td>
<td width="425"><input type="text" name="lain" maxlength="100" id="lain" size="65" /></td>
</tr>
<tr>
<td>Exposure Form<br />
of Business</td>
<td>:</td>
<td><textarea name="exp" cols="50" rows="4" placeholder="di isi ringkasan business preview/exposure dari user (menampilkan date)" required></textarea> </td>
</tr>
<tr>
<td>Review Legal</td>
<td>:</td>
<td><textarea name="rev" cols="50" rows="4" placeholder="Di isi respon dari team legal (menampilkan date – untuk dapat memastikan berapa kali review dan korespondensi untuk melengkapi dokumen pendukung.
" required></textarea></td>
<tr>
<td>Catatan</td>
<td>:</td>
<td><textarea name="catat" cols="50" rows="4" placeholder="Di isi oleh GM Legal Advisory and Policy
Dokumen ini dinyatakan sah tanpa tanda tangan dari Pejabat bersangkutan Sesuai dengan SOP pemberian Legal Advisory di Corporate Counsel Group" required></textarea> </td>
</tr>
<tr>
<td align="center" colspan="3"><input type="submit" name="Submit" value="Submit" id="Submit" />
<input type="reset" name="Cancel" value="Cancel" id="Cancel" /> </td>
</tr>
</tbody>
</table>
</form>
<!--a href="view.php">Lihat Data</a> || <a href="logout.php">Logout</a-->
</body>
</head>
require_once('db_connect.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-5559-1" />
<title>Input Internal Document</title>
<--style type="text/css">
@import url("css/style.css");
</style-->
<head>
<body>
<div style="font-size:20px; font-family:Arial; font:style:normal; color:#FF7F00;"><b> FORM HASIL REVIEW KEBIJAKAN INTERNAL PERSEROAN</b></div>
<tr>
<td>
<table width="100%" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td width="300" height="16" background="images/longmenuleft.gif"></td>
<td height="16" background="images/longmenuright.gif"></td>
</tr>
</table>
<div style="font-size:16px; font-family:Arial; font-style:italic; color:#FF7F00; text-align:right;"><b> Internal Document Legal Regulation & Policy</b></div>
</tr>
<form name="input_data" action="insert.php" method="post">
<table border="0" cellpadding="8" cellspacing="4" bordercolor="#003300" align="center">
<tbody>
<tr>
<td width="146">Topik/Judul Kebijakan</td>
<td width="3">:</td>
<td width="425"><input type="text" name="topik" maxlength="100" id="topik" size="65" /></td>
</tr>
<tr>
<td>User<br />(Department)</td>
<td>:</td>
<td><input type="text" name="user" maxlength="100" id="user" size="65" /></td>
</tr>
<tr>
<td>Nama PIC</td>
<td>:</td>
<td><input type="text" name="pic" maxlength="100" id="pic" size="65" /></td>
</tr>
<tr>
<td>Nomor Ekstensi & HP</td>
<td>:</td>
<td><input type="text" name="ekstensi" maxlength="20" id="ekstensi" size="65" /></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><input type="text" name="email" maxlength="50" id="email" size="65" /></td>
</tr>
</tbody>
</table>
<tr> </tr>
<table width="647" border="0" cellpadding="8" cellspacing="4" bordercolor="#003300" align="center">
<tbody>
<tr>
<!--td-->
<th width="45%" align="left"><div style="font-size:15px; font-family:Arial; color:#FF7F00; text-decoration:underline;">Jenis Dokumen</div></th>
<!--/td-->
<th align="left" width="50%"><div style="font-size:15px; font-family:Arial; color:#FF7F00; text-decoration:underline;">Keberlakuan</div></th>
</tr>
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Keputusan Direksi" />
<label for="dokumen[]">Keputusan Direksi<br />
</label>
</td>
<td align="left" width="50%"><input name="berlaku[]" type="checkbox" id="berlaku[]" value="Antar Subdir" />
<label for="dokumen[]">Antar Subdir<br />
</label>
</td>
</tr>
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Keputusan Direktur"/>
<label for="dokumen[]">Keputusan Direktur<br />
</label>
</td>
<td align="left" width="50%"><input name="berlaku[]" type="checkbox" id="berlaku[]" value="Internal Subdir" />
<label for="dokumen[]">Internal Subdir<br />
</label>
</td>
</tr>
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Instruksi Direksi"/>
<label for="dokumen[]">Instruksi Direksi<br />
</label>
</td>
<td align="left" width="50%"><input name="berlaku[]" type="checkbox" id="berlaku[]" value="Eksternal"/>
<label for="dokumen[]">Eksternal<br />
</label>
</td>
</tr>
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Instruksi Direktur"/>
<label for="dokumen[]">Instruksi Direktur<br />
</label>
</td>
<td align="left" width="50%">Masa Jangka Waktu / Tanggal<br />Berlaku Kebijakan :
<br />
<select name="tgl" id="tgl">
<?php
for($i=1;$i<=31;$i++)
{
echo "<option> $i </option>";
}
?>
</select>
<select name="bln" id="bln">
<?php
for($i=1;$i<=12;$i++)
{
echo "<option> $i </option>";
}
?>
</select>
<input name="thn" type="text" id="thn" size="5" maxlength="4"/>
</td>
</tr>
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Syarat dan Ketentuan"/>
<label for="dokumen[]">Syarat dan Ketentuan<br />
</label>
</td>
<!--td align="left" width="50%"-->
<!--select name="tgl" id="tgl"-->
<!--?php
for($i=1;$i<=31;$i++)
{
echo "<option> $i </option>";
}
?>
</select>
<select name="tgl" id="tgl"-->
<!--?php
for($i=1;$i<=12;$i++)
{
echo "<option> $i </option>";
}
?>
</select>
<input name="thn" type="text" id="thn" size="5" maxlength="4"/>
</td>
</tr-->
<tr>
<td><input name="dokumen[]" type="checkbox" id="dokumen[]" value="Legal Opini"/>
<label for="dokumen[]">Legal Opini<br />
</label>
</td>
</tr>
<tr> </tr>
</tbody>
</table>
<table border="0" cellpadding="8" cellspacing="4" bordercolor="#003300" align="center">
<tbody>
<tr>
<td width="146">Lain-lain</td>
<td width="3" align="left">:</td>
<td width="425"><input type="text" name="lain" maxlength="100" id="lain" size="65" /></td>
</tr>
<tr>
<td>Exposure Form<br />
of Business</td>
<td>:</td>
<td><textarea name="exp" cols="50" rows="4" placeholder="di isi ringkasan business preview/exposure dari user (menampilkan date)" required></textarea> </td>
</tr>
<tr>
<td>Review Legal</td>
<td>:</td>
<td><textarea name="rev" cols="50" rows="4" placeholder="Di isi respon dari team legal (menampilkan date – untuk dapat memastikan berapa kali review dan korespondensi untuk melengkapi dokumen pendukung.
" required></textarea></td>
<tr>
<td>Catatan</td>
<td>:</td>
<td><textarea name="catat" cols="50" rows="4" placeholder="Di isi oleh GM Legal Advisory and Policy
Dokumen ini dinyatakan sah tanpa tanda tangan dari Pejabat bersangkutan Sesuai dengan SOP pemberian Legal Advisory di Corporate Counsel Group" required></textarea> </td>
</tr>
<tr>
<td align="center" colspan="3"><input type="submit" name="Submit" value="Submit" id="Submit" />
<input type="reset" name="Cancel" value="Cancel" id="Cancel" /> </td>
</tr>
</tbody>
</table>
</form>
<!--a href="view.php">Lihat Data</a> || <a href="logout.php">Logout</a-->
</body>
</head>
ini source code untuk proses inputnya :
Quote:
<?php
require_once('db_connect.php');
$topik = $_POST['topik'];
$user = $_POST['user'];
$pic = $_POST['pic'];
$ekstensi = $_POST['ekstensi'];
$email = $_POST['email'];
$thn = $_POST['thn'];
$bln = $_POST['bln'];
$tgl = $_POST['tgl'];
$tglkebijakan = $thn."-".$bln."-".$tgl;
$lainlain = $_POST['lain'];
$efb = $_POST['exp'];
$review = $_POST['rev'];
$catat = $_POST['catat'];
$dokumen_array = $_POST['dokumen'];
foreach($dokumen_array as $jns_dokumen)
{
$source.=$jns_dokumen.",";
}
$dokumen=substr($source,0,-1);
$query="insert into nb_dokumen (id_dok,topik,user,pic,no_hp,email,jenis_dok,tgl_kebijakan,lain,efb,review,catat) values ('','$topik','$user','$pic','$ekstensi','$email','$dokumen','$tglkebijakan','$lainlain','$efb','$review','$catat')";
$hasil=mysql_query($query);
if ($hasil)
{
echo "[removed]alert('Data Tersimpan');location.href='index.php';[removed]";
}
//}
else
{
echo "[removed]alert('Data Belum Tersimpan');location.href='index.php'[removed]";
}
//}
?>
require_once('db_connect.php');
$topik = $_POST['topik'];
$user = $_POST['user'];
$pic = $_POST['pic'];
$ekstensi = $_POST['ekstensi'];
$email = $_POST['email'];
$thn = $_POST['thn'];
$bln = $_POST['bln'];
$tgl = $_POST['tgl'];
$tglkebijakan = $thn."-".$bln."-".$tgl;
$lainlain = $_POST['lain'];
$efb = $_POST['exp'];
$review = $_POST['rev'];
$catat = $_POST['catat'];
$dokumen_array = $_POST['dokumen'];
foreach($dokumen_array as $jns_dokumen)
{
$source.=$jns_dokumen.",";
}
$dokumen=substr($source,0,-1);
$query="insert into nb_dokumen (id_dok,topik,user,pic,no_hp,email,jenis_dok,tgl_kebijakan,lain,efb,review,catat) values ('','$topik','$user','$pic','$ekstensi','$email','$dokumen','$tglkebijakan','$lainlain','$efb','$review','$catat')";
$hasil=mysql_query($query);
if ($hasil)
{
echo "[removed]alert('Data Tersimpan');location.href='index.php';[removed]";
}
//}
else
{
echo "[removed]alert('Data Belum Tersimpan');location.href='index.php'[removed]";
}
//}
?>
nah.. setelah ane jalanin formnya, dan di klik submit hanya keluar notif "Data Belum Tersimpan" dan data tdk meng-insert di table sepertinya script querynya tdk berjalan..., mohon bantuannya para suhu ane ud coba tanya Mbah Google tapi Mbah Google belum mau ngasih Ilham ke ane..
* Nanti hasil dari insert table untuk kolom Jenis Dokumen dan kolom Keberlakuan akan seperti ini :
Spoiler for table:
Diubah oleh pseodolokian 26-08-2014 07:54
0
6.1K
Kutip
26
Balasan
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
20.2KThread•4.3KAnggota
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru