
20-09-2002, 03:22 PM
|
 |
Novice Webmaster
|
|
Join Date: Sep 2002
Location: kl
Posts: 27
Rep Power: 0
|
|
mcm mane nak insert array dalm database
mcm nie aku nak masuukan value tuk checkbox dalm databse...
nie contoh coding aku
<td width="693" height="1">
<p><b>: </b><input type="checkbox" name="CE[]" value="CE01">CE01 <input type="checkbox" name="CE[]" value="CE02">CE02
<input type="checkbox" name="CE[]" value="CE03">CE03 <input type="checkbox" name="CE[]" value="CE04">CE04
<input type="checkbox" name="CE[]" .
user leh klik bykla..ni aku pendekan..
ni pulak coding php aku.
<?php
$user = "chempaka";
$pwd = "kasih";
$db = "TMS";
$host = "chempaka";
$conn = mysql_connect($host,$user,$pwd);
mysql_select_db("TMS", $conn) or die(mysql_errno() . ": " . mysql_error() . "<br>");
?>
<p>
<?php
#this is processed when the form is submitted
#setup SQL statement
$CE=array();
$ce_txt=",";
for ($i=0;$i<count($CE);$i++)
{
$ce_txt.=$CE.",";
}
$SQL = "INSERT into maklumat_cidb (no_pendaftaran,gred,bulan,tahun,hari,id_syarikat, kategori_ce) VALUES
('$no_pendaftaran','$gred','$bulan','$tahun','$har i','$id','$ce_txt')";
echo $SQL;
?>
mslh aku skrg dalam database dia tak masuk valur tuk checkbox tp mcm ni ,array,array,
ni kalu aku pilih dua la...
so...tlgla selesaikan mslh aku.....tq
|