View Single Post
  #1 (permalink)  
Old 20-09-2002, 03:22 PM
kasih's Avatar
kasih kasih is offline
Novice Webmaster
 
Join Date: Sep 2002
Location: kl
Posts: 27
Rep Power: 0
kasih is on a distinguished road
Exclamation 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
Reply With Quote