form utk tahun@bulan

coda · #1 (**permalink**) 09-06-2004, 11:52 AM

tlg laaa....dah nak kene submit system nih...tp pobem nih masih xbeh settle.....

coda nak kene wat form utk rekod pembayaran....lebih kurang ginilah coding dia....

<table width="500" border="1">
<tr>
<td><table width="460" border="0" align="center">
<tr>
<td width="454"><div align="center">
<form name="form1" method="post" action="settle.php">
<p><strong><font color="#990000" size="3" face="Sylfaen">REKOD PEMBAYARAN PENYEWA</font></strong></p>
<p align="left"><font color="#990000" size="3" face="Sylfaen"><strong>Sila
Pilih Alamat :</strong>
<select name="alamat">
<option>Kelas A<? echo $row->alamat; ?></option>
<option>JKR 1604/25, Jalan Sultan Azlan Shah, Ipoh.</option>
<option>JKR 1325/50, Jalan Gopeng, Ipoh.</option>
<option>JKR 1114/26, Jalan Kelab Golf, Ipoh.</option>
<option>JKR 1141/4, Jalan Dato` Shaari, Ipoh.</option>
</select>
</font></p>
<p align="left"><font color="#990000" size="3" face="Sylfaen"><strong>Nombor
Kad Pengenalan :</strong>
<input type="text" name="ic" value="<? echo $row->no_ic; ?>">
</font></p>
<p align="left"><font color="#990000" size="3" face="Sylfaen"><strong>Bayaran
bagi Tahun :</strong>
<select name="tahun">
<option>Tahun<? echo $row->tahun; ?></option>
<option>2005</option>
<option>2004</option>
<option>2003</option>
<option>2002</option>
<option>2001</option>
<option>2000</option>
<option>1999</option>
<option>1998</option>
<option>1997</option>
<option>1996</option>
<option>1995</option>
</select>
</font></p>
<p align="left"><font color="#990000" size="3" face="Sylfaen"><strong>Bayaran
bagi Bulan :</strong>
<select name="bulan">
<option>Bulan<? echo $row->bulan?></option>
<option>Januari</option>
<option>Februari</option>
<option>Mac</option>
<option>April</option>
<option>Mei</option>
<option>Jun</option>
<option>Julai</option>
<option>Ogos</option>
<option>September</option>
<option>Oktober</option>
<option>November</option>
<option>Disember</option>
</select>
</font></p>
<p align="left"><font color="#990000" size="3" face="Sylfaen"><strong>Cara
Bayaran :</strong>
<select name="caraBayar">
<option>Cara Bayaran<? echo $row->caraBayar?></option>
<option>Cek</option>
<option>Potongan Gaji</option>
</select>
</font></p>
<p align="left"><font color="#990000" size="3" face="Sylfaen"><strong>Jumlah
Bayaran RM</strong>
<input type="text" name="jumBayar" value="<? echo $row->jumBayar; ?>">
</font></p>
<p align="left"><font color="#990000" size="3" face="Sylfaen"><strong>Nombor
Resit </strong>
<input type="text" name="noResit" value="<? echo $row->noResit; ?>">
</font></p>
<p align="center"><font size="3" face="Sylfaen">
<b><input type="submit" value="HANTAR" name="penyewa"></b>
<b><input type="reset" value="BATAL" name="reset"></b>
</font></p>
</form>
</div></td>
</tr>
</table></td>
</tr>
</table>

tapi...ader poblem laa utk masuk tahun &bulan ke db...penin dah nak citer pon tak reti nih...

lina · #2 (**permalink**) 09-06-2004, 02:23 PM

oooo...try like this
example
Tarikh Lahir :
input name for day = $day
input name for month = $month
input name for year = $year

letak ni kat dalam file yg proses page tu

after request balik sume data tadi
letak ni
$dob = "$year$month$day";

did this help u?

coda · #3 (**permalink**) 09-06-2004, 02:47 PM

emmm cane ek...
bukan gitu makud coda...
coda nak form nih nnt bile user nak keyin...cth

pilih tahun -->2004 then
pilih bulan -->June then
masuk sewa --> rm***

pastu bile user dgn noIC yg same nak keyin sewa utk bulan Julai plak..dia akan buat perkara yg same...

pilih tahun -->2004 then
pilih bulan -->Julai then
masuk sewa --> rm***

tp poblemnye kat db pon penin & nnt nak display balik pon tak bleh sebab coda wat dlm satu table jer...erkkk

lina · #4 (**permalink**) 09-06-2004, 04:15 PM

masalah display ye?

satu table ke satu field?

lina · #5 (**permalink**) 09-06-2004, 04:21 PM

ok klu satu field:

example :

kat form ade tiga select menu

1. year
2. month
3. day

nama field dlm db:
s_dob
20040609

bila nk display.letak code ni

<?php
if (!$b_year)
$dob_year = substr($query_data["s_dob"],0,4);
else
$dob_year = $b_year;

if (!$b_month)
$dob_month = substr($query_data["s_dob"],4,2);
else
$dob_month = $b_month;

if (!$b_day)
$dob_day = substr($query_data["s_dob"],6,2);
else
$dob_day = $b_day;
?>

dpt x?

lina · #6 (**permalink**) 09-06-2004, 05:59 PM

alo coda

coda · #7 (**permalink**) 10-06-2004, 08:47 AM

sorry smlm dah blk laa...

thanks for helping me...
arini br nak try coding yg miss lina kasi tuh....

lina · #8 (**permalink**) 10-06-2004, 09:09 AM

wokey

coda · #9 (**permalink**) 10-06-2004, 09:33 AM

isk cane nih...
mcm tak bleh jer...
takdesesape bleh tolong ker...

lina · #10 (**permalink**) 10-06-2004, 12:50 PM

last try...

try copy file ni..

Register.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body><form method="post" name="form" action="RegisterProcess.php" >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="content">
<tr valign="middle">
<td>Date of Birth<br> </td>
<td>:

<select name="s_day">
<option value="" selected>dd</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="s_month">
<option value="" selected>mm</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select> <select name="s_year">
<option selected>yyyy</option>
<option value="<?php print date("Y")-3; ?>"><?php print date("Y")-3; ?></option>
<option value="<?php print date("Y")-4; ?>"><?php print date("Y")-4; ?></option>
<option value="<?php print date("Y")-5; ?>"><?php print date("Y")-5; ?></option>
<option value="<?php print date("Y")-6; ?>"><?php print date("Y")-6; ?></option>

</select></td>
</tr><tr><td colspan="2"><div align="center">
<input class="inputbutton" type="submit" name="sumbit" value="Submit">
</div></td></tr>
</table> </form>
</body>
</html>

lina · #11 (**permalink**) 10-06-2004, 12:53 PM

utk file RegisterProcess.php

wat cam biasa
masukkan insert sql statement and b4 tuh letak

$s_dob = "$s_year$s_month$s_day";

lina · #12 (**permalink**) 10-06-2004, 12:56 PM

ni plak page utk view data balik

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body><form method="post" name="form" action="RegisterProcess.php" >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
//masukkan sql select statement kat sini utk panggil data tadi
<tr valign="middle">
<?php
if (!$b_year)
$dob_year = substr($query_data["s_dob"],0,4);
else
$dob_year = $b_year;

if (!$b_month)
$dob_month = substr($query_data["s_dob"],4,2);
else
$dob_month = $b_month;

if (!$b_day)
$dob_day = substr($query_data["s_dob"],6,2);
else
$dob_day = $b_day;
?>
<tr valign="middle">
<td colspan ="4"> </td>
</tr>
<tr valign="middle">
<td>Date of Birth<br>
<span class="normaltext2"><em>Tarikh Lahir</em></span></td>
<td colspan ="1">:
<select name="s_day">
<option value="<?php print $dob_day;?>" SELECTED><?php print $dob_day;?></option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="s_month">
<option value="<?php print $dob_month;?>" selected><?php print $dob_month;?></option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
<select name="s_year">
<option value="<?php print $dob_year;?>" SELECTED><?php print $dob_year;?></option>
<option value="<?php print date("Y")-3; ?>"><?php print date("Y")-3; ?></option>
<option value="<?php print date("Y")-4; ?>"><?php print date("Y")-4; ?></option>
<option value="<?php print date("Y")-5; ?>"><?php print date("Y")-5; ?></option>
<option value="<?php print date("Y")-6; ?>"><?php print date("Y")-6; ?></option>
</select></td>
</tr><tr><td colspan="2"><div align="center">
<input class="inputbutton" type="submit" name="sumbit" value="Submit">
</div></td></tr>
</table> </form>
</body>
</html>

coda · #13 (**permalink**) 10-06-2004, 02:00 PM

oke tengkiu..
nak try jap...

hymns · #14 (**permalink**) 11-06-2004, 07:13 PM

ok ke tuu

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)