sy xterer php n mysql.mmg sengal2 ayam jer ney.pastu dpt plak error cmni.ape mmaksud error nih eh?? kt cni sy bg code utk mereka2 yg expert untuk membantu..huhu..
+++++++++++++++++++++++++++++++++++++++++++++
mysql script
+++++++++++++++++++++++++++++++++++++++++++++
mysql> create table maklumat(lot varchar(20) primary key not null, nama varchar(150) default null, KP varchar(12) default null,
rumah varchar(255) default null, luas float(6,4) default 0.0000, t_Warta date,
t_Bicara date, t_BorangH date, noEft int(20), t_Eft date,
t_BorangK date, bayaran2008 double(10,2) default 0.00, jum double(10,2) default 0.00, jumNilaian
double(10,2) default 0.00, catatan text);
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
display page script (error tuh akn kua kt page nih kalu field KP, luas, rumah dan seterusnya x diisi
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<?php
$host="localhost";
$user="root";
$pass="anysha";
$db_name="test";
$tbl_name="maklumat";
$conn=mysql_connect("$host", "$user", "$pass") or die("cannot connect");
mysql_select_db($db_name, $conn) or die("Unable to select database");
/*TAK SIAP LAGI NEY..CEK BALIK*/
$day1 = $_POST['day1'];
$month1 = $_POST['month1'];
$year1 = $_POST['year1'];
$t_Warta = "$year1-$month1-$day1";
$day2 = $_POST['day2'];
$month2 = $_POST['month2'];
$year2 = $_POST['year2'];
$t_Bicara = "$year2-$month2-$day2";
$day3 = $_POST['day3'];
$month3 = $_POST['month3'];
$year3 = $_POST['year3'];
$t_BorangH = "$year3-$month3-$day3";
$day4 = $_POST['day4'];
$month4 = $_POST['month4'];
$year4 = $_POST['year4'];
$t_Eft = "$year4-$month4-$day4";
$day5 = $_POST['day5'];
$month5 = $_POST['month5'];
$year5 = $_POST['year5'];
$t_BorangK = "$year5-$month5-$day5";
/*insert into data table*/
$lot = $_POST['lot'];
$nama = $_POST['nama'];
$KP = $_POST['KP'];
$rumah = $_POST['rumah'];
$luas = $_POST['luas'];
$noEft = $_POST['noEft'];
$bayaran2008 = $_POST['bayaran2008'];
$jum = $_POST['jum'];
$jumNilaian = $_POST['jumNilaian'];
$catatan = $_POST['catatan'];
if(!isset($lot))$lot="";
if(!isset($name))$name="";
if(!isset($KP))$KP="";
if(!isset($rumah))$rumah="";
if(!isset($luas))$luas="";
if(!isset($noEft))$noEft="";
if(!isset($bayaran2008))$bayaran2008="";
if(!isset($jum))$jum="";
if(!isset($jumNilaian))$jumNilaian="";
$query="INSERT INTO maklumat(lot, nama, KP, rumah, luas, t_Warta,
t_Bicara, t_BorangH, noEft, t_Eft,
t_BorangK, bayaran2008, jum, jumNilaian, catatan) VALUES ('$lot','$nama', '$KP', '$rumah', '$luas', '$t_Warta', '$t_Bicara', '$t_BorangH', '$noEft', '$t_Eft', '$t_BorangK', '$bayaran2008', '$jum', '$jumNilaian', '$catatan')";
$result=mysql_query($query);
if($result){
echo "THANK YOU! 1 new data added";
echo "<br>";
}
else {
echo "Error " .mysql_error();
}
mysql_close();
?>
<html>
<body>
<br>
<h4>LOT NOMBOR:<?php echo $lot; ?><br>
NAMA PEMILIK:<?php echo $nama; ?><br>
NO KP:<?php echo $KP; ?><br>
RUMAH TERLIBAT:<?php echo $rumah; ?><br>
LUAS DIAMBIL:<?php echo $luas; ?><br>
TARIKH WARTA:<?php echo $t_Warta; ?><br>
TARIKH BICaRA:<?php echo $t_Bicara; ?><br>
TARIKH BORANG H:<?php echo $t_BorangH; ?><br>
NOMBOR EFT/CEK:<?php echo $noEft; ?><br>
TARIKH EFT:<?php echo $t_Eft; ?><br>
TARIKH BORANG K:<?php echo $t_BorangK; ?><br>
BAYARAN 2008:<?php echo $bayaran2008; ?><br>
JUMLAH:RM<?php echo $jum; ?><br>
JUMLAH NILAIAN:RM<?php echo $jumNilaian; ?><br>
CATATAN:<?php echo $catatan; ?><br></h4>
</body>
</html>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
panjangnye...
hrp2 fhm la prob sy ni yer..
+++++++++++++++++++++++++++++++++++++++++++++
mysql script
+++++++++++++++++++++++++++++++++++++++++++++
mysql> create table maklumat(lot varchar(20) primary key not null, nama varchar(150) default null, KP varchar(12) default null,
rumah varchar(255) default null, luas float(6,4) default 0.0000, t_Warta date,
t_Bicara date, t_BorangH date, noEft int(20), t_Eft date,
t_BorangK date, bayaran2008 double(10,2) default 0.00, jum double(10,2) default 0.00, jumNilaian
double(10,2) default 0.00, catatan text);
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
display page script (error tuh akn kua kt page nih kalu field KP, luas, rumah dan seterusnya x diisi
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<?php
$host="localhost";
$user="root";
$pass="anysha";
$db_name="test";
$tbl_name="maklumat";
$conn=mysql_connect("$host", "$user", "$pass") or die("cannot connect");
mysql_select_db($db_name, $conn) or die("Unable to select database");
/*TAK SIAP LAGI NEY..CEK BALIK*/
$day1 = $_POST['day1'];
$month1 = $_POST['month1'];
$year1 = $_POST['year1'];
$t_Warta = "$year1-$month1-$day1";
$day2 = $_POST['day2'];
$month2 = $_POST['month2'];
$year2 = $_POST['year2'];
$t_Bicara = "$year2-$month2-$day2";
$day3 = $_POST['day3'];
$month3 = $_POST['month3'];
$year3 = $_POST['year3'];
$t_BorangH = "$year3-$month3-$day3";
$day4 = $_POST['day4'];
$month4 = $_POST['month4'];
$year4 = $_POST['year4'];
$t_Eft = "$year4-$month4-$day4";
$day5 = $_POST['day5'];
$month5 = $_POST['month5'];
$year5 = $_POST['year5'];
$t_BorangK = "$year5-$month5-$day5";
/*insert into data table*/
$lot = $_POST['lot'];
$nama = $_POST['nama'];
$KP = $_POST['KP'];
$rumah = $_POST['rumah'];
$luas = $_POST['luas'];
$noEft = $_POST['noEft'];
$bayaran2008 = $_POST['bayaran2008'];
$jum = $_POST['jum'];
$jumNilaian = $_POST['jumNilaian'];
$catatan = $_POST['catatan'];
if(!isset($lot))$lot="";
if(!isset($name))$name="";
if(!isset($KP))$KP="";
if(!isset($rumah))$rumah="";
if(!isset($luas))$luas="";
if(!isset($noEft))$noEft="";
if(!isset($bayaran2008))$bayaran2008="";
if(!isset($jum))$jum="";
if(!isset($jumNilaian))$jumNilaian="";
$query="INSERT INTO maklumat(lot, nama, KP, rumah, luas, t_Warta,
t_Bicara, t_BorangH, noEft, t_Eft,
t_BorangK, bayaran2008, jum, jumNilaian, catatan) VALUES ('$lot','$nama', '$KP', '$rumah', '$luas', '$t_Warta', '$t_Bicara', '$t_BorangH', '$noEft', '$t_Eft', '$t_BorangK', '$bayaran2008', '$jum', '$jumNilaian', '$catatan')";
$result=mysql_query($query);
if($result){
echo "THANK YOU! 1 new data added";
echo "<br>";
}
else {
echo "Error " .mysql_error();
}
mysql_close();
?>
<html>
<body>
<br>
<h4>LOT NOMBOR:<?php echo $lot; ?><br>
NAMA PEMILIK:<?php echo $nama; ?><br>
NO KP:<?php echo $KP; ?><br>
RUMAH TERLIBAT:<?php echo $rumah; ?><br>
LUAS DIAMBIL:<?php echo $luas; ?><br>
TARIKH WARTA:<?php echo $t_Warta; ?><br>
TARIKH BICaRA:<?php echo $t_Bicara; ?><br>
TARIKH BORANG H:<?php echo $t_BorangH; ?><br>
NOMBOR EFT/CEK:<?php echo $noEft; ?><br>
TARIKH EFT:<?php echo $t_Eft; ?><br>
TARIKH BORANG K:<?php echo $t_BorangK; ?><br>
BAYARAN 2008:<?php echo $bayaran2008; ?><br>
JUMLAH:RM<?php echo $jum; ?><br>
JUMLAH NILAIAN:RM<?php echo $jumNilaian; ?><br>
CATATAN:<?php echo $catatan; ?><br></h4>
</body>
</html>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
panjangnye...
hrp2 fhm la prob sy ni yer..