469,579 Members | 1,830 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

How to save a into database?

suriacute85
Hi, I'm very new in web programming. i have afew question here.
1. i have a table which have a data, in 3 lines. now i want to save the data in the 3 lines into the database access. can i do that? if yes, will anyone shows me how to do that? this what i means ;
[html]
<table width="816" height="158" border="2" cellpadding="0" cellspacing="1">
<tr>
<td width="109"><div align="center"><strong>Jenis Beras </strong></div></td>
<td width="100"><div align="center"><strong>Pulang Barang</strong></div></td>
<td width="126"><div align="center"><strong>Tidak Hantar</strong></div></td>
<td width="68"><div align="center"><strong>Jumlah</strong></div></td>
<td width="139"><div align="center"><strong>Sebab Pemulangan </strong></div></td>
<td width="239"><p align="center"><strong>Lain-lain sebab </strong></p> </td>
</tr>
<tr>
<td height="28"><select id="JenBeras1" name="JenBeras1" style="">
<option value="NULL" selected="selected">KOD BERAS</option>
<option value="1">FBB010 </option>
<option value="2">FBE010</option>
<option value="3">FBE050</option>
<option value="4">FBK010</option>
<option value="5">FBK050</option>
<option value="6">FBR005</option>
<option value="7">FBR010</option>
<option value="8">FBR050</option>
<option value="9">FCD010</option>
<option value="10">FCD025</option>
<option value="11">FFB005</option>
<option value="12">FFB010</option>
<option value="13">FFB050</option>
<option value="14">FFE005</option>
<option value="15">FFE010</option>
</select></td>
<td><input class="inputbg" id="QtyPulangBrg1" name="QtyPulangBrg1" size="10" value="" maxlength="5" type="text" /></td>
<td><input class="inputbg" id="QtyTidakHantar1" name="QtyTidakHantar1" size="10" value="" maxlength="5" type="text" /></td>
<td><input name="jumlah1" type="text" id="jumlah1" size="10" maxlength="5" /></td>
<td><select name="sebab1" id="sebab1">
<option selected="selected">SEBAB PEMULANGAN</option>
<option value="01">BERKUTU</option>
<option value="02">BAG PECAH/ BOCOR</option>
<option value="03">KUALITI TIDAK BAIK/ROSAK</option>
<option value="04">BATAL ORDER</option>
<option value="05">SHORT SUPLLY</option>
<option value="06">BARANG KURANG LAKU</option>
<option value="07">KEDAI TUTUP</option>
<option value="08">SALAH TURUN BARANG</option>
<option value="09">TIADA STOK</option>
<option value="10">TAMAT TEMPOH</option>
<option value="11">LAIN-LAIN : SILA NYATAKAN</option>
</select></td>
<td><input class="inputbg" id="sebablain1" name="sebablain1" size="60" value="" maxlength="100" type="text" /></td>
</tr>
<tr>
<td height="26"><select id="JenBeras2" name="JenBeras2" style="">
<option value="NULL" selected="selected">KOD BERAS</option>
<option value="1">FBB010</option>
<option value="2">FBE010</option>
<option value="3">FBE050</option>
<option value="4">FBK010</option>
<option value="5">FBK050</option>
<option value="6">FBR005</option>
<option value="7">FBR010</option>
<option value="8">FBR050</option>
<option value="9">FCD010</option>
<option value="10">FCR025</option>
<option value="11">FFB005</option>
<option value="12">FFB010</option>
<option value="13">FFB050</option>
<option value="14">FFE005</option>
<option value="15">FFE010</option>
</select></td>
<td><input class="inputbg" id="QtyPulangBrg2" name="QtyPulangBrg2" size="10" value="" maxlength="5" type="text" /></td>
<td><input class="inputbg" id="QtyTidakHantar2" name="QtyTidakHantar2" size="10" value="" maxlength="5" type="text" /></td>
<td><input name="jumlah2" type="text" id="jumlah2" size="10" maxlength="5" /></td>
<td><select name="sebab2" id="sebab2">
<option selected="selected">SEBAB PEMULANGAN</option>
<option value="01">BERKUTU</option>
<option value="02">BAG PECAH/ BOCOR</option>
<option value="03">KUALITI TIDAK BAIK/ROSAK</option>
<option value="04">BATAL ORDER</option>
<option value="05">SHORT SUPLLY</option>
<option value="06">BARANG KURANG LAKU</option>
<option value="07">KEDAI TUTUP</option>
<option value="08">SALAH TURUN BARANG</option>
<option value="09">TIADA STOK</option>
<option value="10">TAMAT TEMPOH</option>
<option value="11">LAIN-LAIN : SILA NYATAKAN</option>
</select></td>
<td><input class="inputbg" id="sebablain2" name="sebablain2" size="60" value="" maxlength="100" type="text" /></td>
</tr>
<tr>
<td height="24"><select id="JenBeras3" name="JenBeras3" style="">
<option value="NULL" selected="selected">KOD BERAS</option>
<option value="1">FBB010</option>
<option value="2">FBE010</option>
<option value="3">FBE050</option>
<option value="4">FBK010</option>
<option value="5">FBK050</option>
<option value="6">FBR005</option>
<option value="7">FBR010</option>
<option value="8">FBR050</option>
<option value="9">FCD010</option>
<option value="10">FCR025</option>
<option value="11">FFB005</option>
<option value="12">FFB010</option>
<option value="13">FBB050</option>
<option value="14">FFE005</option>
<option value="15">FFE010</option>
</select></td>
<td><input class="inputbg" id="QtyPulangBrg3" name="QtyPulangBrg3" size="10" value="" maxlength="5" type="text" /></td>
<td><input class="inputbg" id="QtyTidakHantar3" name="QtyTidakHantar3" size="10" value="" maxlength="5" type="text" /></td>
<td><input name="jumlah3" type="text" id="jumlah3" size="10" maxlength="5" /></td>
<td><select name="sebab3" id="sebab3">
<option selected="selected">SEBAB PEMULANGAN</option>
<option value="01">BERKUTU</option>
<option value="02">BAG PECAH/ BOCOR</option>
<option value="03">KUALITI TIDAK BAIK/ROSAK</option>
<option value="04">BATAL ORDER</option>
<option value="05">SHORT SUPLLY</option>
<option value="06">BARANG KURANG LAKU</option>
<option value="07">KEDAI TUTUP</option>
<option value="08">SALAH TURUN BARANG</option>
<option value="09">TIADA STOK</option>
<option value="10">TAMAT TEMPOH</option>
<option value="11">LAIN-LAIN : SILA NYATAKAN</option>
</select></td>
<td><input class="inputbg" id="sebablain3" name="sebablain3" size="60" value="" maxlength="100" type="text" /></td>
</tr>
</table>
[/html]
that's all the codes contain for table. so, how do i save all data into one table in the database? is the dtabase sholud modify also?
please help me...
Nov 19 '07 #1
1 1501
stepterr
157 100+
Take a look at this tutorial. It will walk you through the steps you need to take, even the access database

http://www.codefixer.com/tutorials/form_to_database.asp
Nov 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Angie | last post: by
2 posts views Thread by buran | last post: by
6 posts views Thread by Sanjay | last post: by
6 posts views Thread by Josetta | last post: by
3 posts views Thread by =?Utf-8?B?YzY3NjIyOA==?= | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.