- Beranda
- Komunitas
- Tech
- 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
Urutan
Terbaru
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan