Tolong Tengok Kan

[amanina 1]

sistem cuti ini tak boleh kira saya da wat pengiraan...

<?php

if(isset($_POST['cmdhantar'])== "HANTAR")

{
$txtid = $_POST['txtid'];
$txtname = $_POST['txtname'];
$txtic = $_POST['txtic'];
$txtjwtn = $_POST['txtjwtn'];
$txtjbtn = $_POST['txtjbtn'];
$txtTahunan = $_POST['txtTahunan'];
$txtHadapan = $_POST['txtHadapan'];
$txtbaki = $_POST['txtbaki'];
$txtdipohon = $_POST['txtdipohon'];
$txtMula = $_POST['txtMula'];
$txtAkhir = $_POST['txtAkhir'];
$txtkomen = $_POST['txtkomen'];
$txtalmt = $_POST['txtalmt'];
$txtfon = $_POST['txtfon'];
$txtDills = $_POST['txtDills'];



if((empty($txtname))||(empty($txtic))||(empty($txtjwtn))||(empty($txtjbtn))||(empty($txtTahunan))||(empty($txtHadapan))||(empty($txtbaki))||(empty($txtdipohon))||(empty($txtMula))||(empty($txtAkhir))||(empty($txtkomen))||(empty($txtalmt))||(empty($txtfon))||(empty($txtDills)))

{
//echo"<br><table border=1 bordercolor=#336699 align=center><tr><td class=style1 align=center bordercolor=#FF0000><br><br><font color=red>Maaf. Maklumat tidak lengkap.Permohonan cuti tidak dapat dilakukan.Sila lengkapkan maklumat untuk memohon cuti.</font></td></tr> ";
//echo "<tr><td class=style1 align=center bordercolor=#ECF0F4 bgcolor=#ECF0F4><br>";

}


else
{


$tmula = date ('d-m-Y',strtotime($txtMula));
$takhir = date ('d-m-Y',strtotime($txtAkhir));

$query = "INSERT INTO mohoncuti(id,mNama,mIc,mJawatan,mJabatan,mTahunan,mHadapan,mBaki,mDipohon,mMula,mAkhir,mKomen,mAlamat,mNofon,mDills) VALUES ('$txtid','$txtname','$txtic','$txtjwtn','$txtjbtn','$txtTahunan','$txtHadapan','$txtbaki','$txtdipohon','$tmula','$takhir','$txtkomen','$txtalmt','$txtfon','$txtDills')";
$result = mysql_query($query) or die(mysql_error());
$txtid=mysql_insert_id();





}

}
else
{
?>
<?php } ?>
<?php

$queryi = "SELECT * FROM mohoncuti where mIc = '$ic' ";
$resulti = mysql_query($queryi) or die(mysql_error());
$datai = mysql_fetch_array($resulti);


$mTahunan = $datai['mTahunan'];
$mHadapan = $datai['mHadapan'];
$mDipohon = $datai['mDipohon'];
$mBaki = $datai['mBaki'];

$mBaki = ($mTahunan + $mHadapan) - $mDipohon ;

?>
<?php

$queryic = "SELECT * FROM daftaruser where Ic = '$ic' ";
$resultic = mysql_query($queryic) or die(mysql_error());
$dataic = mysql_fetch_array($resultic);

$pNama= $dataic['Nama'];
$pIc = $dataic['Ic'];
$pJawatan = $dataic['Jawatan'];
$pJabatan = $dataic['Jabatan'];
$pTahunan = $dataic['Tahunan'];
$pHadapan = $dataic['Hadapan'];

?>

[mrpixel05 1]

Pheww.....

1st : tip: cube klik kt icon <> tuh utk masukkan kod dlm tag
2nd : mmg ko validate kesemua field br leh wat kiraan permohonan cuti tuh...
3rd : erm dah check dah type variable ms wat kiraan tuh ...maybe ade yg ko lupe cast type variable tuh ms wat kiraan ..sbbnya dlm php digalakkan makesure betul2 variable type tuh since spt yg ko tau php adelah language berjns 'loose type' tk mcm java,c...kdg2 bendeaklah nih leh wat kiraan tuh jadi salah....dan satu lg make sure logic conditon statement tuh betul2 tk lari ..maksud aku ....ko kene betul2 make sure yg business logic ko tuh meet condition...
yang ke-4 :nk bg cadangan ...penat tk ko type nih...$_POST['']-->bygkan kalau ko ade 20 value yg ko kene post kt php...so cr senang initerate value POST tuh..cth

[code]

/* Popout last items in $_POST for the 1st very beginning form submit */

array_pop($_POST);

foreach($_POST as $key=>$val){
echo "KEY = ".$key." || VALUE = ".$val."<br/>\n";
so kt cnih kjo leh filter segala jenis benda yg ko nk filter stlh ko check filed tuh empty ke tak...even kat cnih gak ko leh filter segala jenis sql injection attempts...buat satu static class dan wat validation
}

[/code]
yang ke 5 : utk operations databse tuh ...cara senang ko wat satu utility class database connection dan implement abstract class bg oprasi yg selalu kite gunakan di dalam sistem2 simple nih..spt SELECT,DELETE,UPDATE ....so takdelah duk menaip benda yg sama berulang kali ...dgn ini dpt jimatkan masa development...


yang ke 6 : Kalau tk brp phm gak paste kod ko tuh betui2 dan bg sekali html kod ko ...nanti ade org tolong.....my 0.02 sen cadangan ....

Wassalam

[ne7za 26]

tolong bagi tajuk yang sesuai . terima kasih

[EncikMalas 0]

[quote name='amanina' timestamp='1300633944' post='1065273']
sistem cuti ini tak boleh kira saya da wat pengiraan...

<?php

if(isset($_POST['cmdhantar'])== "HANTAR")

{
$txtid = $_POST['txtid'];
$txtname = $_POST['txtname'];
$txtic = $_POST['txtic'];
$txtjwtn = $_POST['txtjwtn'];
$txtjbtn = $_POST['txtjbtn'];
$txtTahunan = $_POST['txtTahunan'];
$txtHadapan = $_POST['txtHadapan'];
$txtbaki = $_POST['txtbaki'];
$txtdipohon = $_POST['txtdipohon'];
$txtMula = $_POST['txtMula'];
$txtAkhir = $_POST['txtAkhir'];
$txtkomen = $_POST['txtkomen'];
$txtalmt = $_POST['txtalmt'];
$txtfon = $_POST['txtfon'];
$txtDills = $_POST['txtDills'];



if((empty($txtname))||(empty($txtic))||(empty($txtjwtn))||(empty($txtjbtn))||(empty($txtTahunan))||(empty($txtHadapan))||(empty($txtbaki))||(empty($txtdipohon))||(empty($txtMula))||(empty($txtAkhir))||(empty($txtkomen))||(empty($txtalmt))||(empty($txtfon))||(empty($txtDills)))

{
//echo"<br><table border=1 bordercolor=#336699 align=center><tr><td class=style1 align=center bordercolor=#FF0000><br><br><font color=red>Maaf. Maklumat tidak lengkap.Permohonan cuti tidak dapat dilakukan.Sila lengkapkan maklumat untuk memohon cuti.</font></td></tr> ";
//echo "<tr><td class=style1 align=center bordercolor=#ECF0F4 bgcolor=#ECF0F4><br>";

}


else
{


$tmula = date ('d-m-Y',strtotime($txtMula));
$takhir = date ('d-m-Y',strtotime($txtAkhir));

$query = "INSERT INTO mohoncuti(id,mNama,mIc,mJawatan,mJabatan,mTahunan,mHadapan,mBaki,mDipohon,mMula,mAkhir,mKomen,mAlamat,mNofon,mDills) VALUES ('$txtid','$txtname','$txtic','$txtjwtn','$txtjbtn','$txtTahunan','$txtHadapan','$txtbaki','$txtdipohon','$tmula','$takhir','$txtkomen','$txtalmt','$txtfon','$txtDills')";
$result = mysql_query($query) or die(mysql_error());
$txtid=mysql_insert_id();





}

}
else
{
?>
<?php } ?>
<?php

$queryi = "SELECT * FROM mohoncuti where mIc = '$ic' ";
$resulti = mysql_query($queryi) or die(mysql_error());
$datai = mysql_fetch_array($resulti);


$mTahunan = $datai['mTahunan'];
$mHadapan = $datai['mHadapan'];
$mDipohon = $datai['mDipohon'];
$mBaki = $datai['mBaki'];

$mBaki = ($mTahunan + $mHadapan) - $mDipohon ;

?>
<?php

$queryic = "SELECT * FROM daftaruser where Ic = '$ic' ";
$resultic = mysql_query($queryic) or die(mysql_error());
$dataic = mysql_fetch_array($resultic);

$pNama= $dataic['Nama'];
$pIc = $dataic['Ic'];
$pJawatan = $dataic['Jawatan'];
$pJabatan = $dataic['Jabatan'];
$pTahunan = $dataic['Tahunan'];
$pHadapan = $dataic['Hadapan'];

?>
[/quote]


pmed aku jika nak suh aku ajarkan & buatkan