Menu
Hi,
i have a registration form (screenshot attached). I create two table to store them, one customer_master, send item_details. but i want to know how to get values of these (item) textboxes to insert into the database.
Here is the code by which these fields are generating.
<?php
require_once(“config.php”);
$query_for_result=mysql_query(“SELECT * FROM mytable ORDER BY id ASC”);
$num=mysql_numrows($query_for_result);
mysql_close();
?>
<table> <tr>
<td >Sl.No..</td>
<td >Item</td>
<td >Paper</td>
<td >Finish</td>
<td>Price</td>
<td >Vat</td>
<td >Total Amount</td>
</tr>
<?php
$i=0;
while ($i < $num)
{
$f1=mysql_result($query_for_result,$i,”id”);
$f2=mysql_result($query_for_result,$i,”album_name”);
$f3=mysql_result($query_for_result,$i,”paper_used”);
$f4=mysql_result($query_for_result,$i,”finishing”);
$f5=mysql_result($query_for_result,$i,”price”);
$f6=mysql_result($query_for_result,$i,”vat”);
$f7=mysql_result($query_for_result,$i,”total_amt”);
$id=$i+1;
?>
<tr>
<td><input id=”slno” name=”security_code” type=”text” value=”<?php echo $f1; ?>” style=”width:20px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”<?php echo $f2; ?>” type=”text” style=”width:150px;”/></td>
<td ><input id=”security_code” name=”security_code” type=”text” value=”<?php echo $f3; ?>” style=”width:85px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”<?php echo $f4; ?>” type=”text” style=”width:90px;”/></td>
<td ><input id=”security_code” value=”<?php echo $f5; ?>” name=”security_code” type=”text” style=”width:25px;”/></td>
<td ><input id=”security_code” value=”<?php echo $f6; ?>” name=”security_code” type=”text” style=”width:35px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”<?php echo $f7; ?>” type=”text” style=”width:50px;”/></td>
</tr>
<?php
$i++;
}
?>
<tr>
<td ><input id=”security_code” name=”security_code” type=”text” value=”26″ style=”width:20px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:150px;”/></td>
<td ><input id=”security_code” name=”security_code” type=”text” value=”” style=”width:85px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:90px;”/></td>
<td ><input id=”security_code” value=”” name=”security_code” type=”text” style=”width:25px;”/></td>
<td ><input id=”security_code” value=”” name=”security_code” type=”text” style=”width:35px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:50px;”/></td>
</tr>
<tr>
<td ><input id=”security_code” name=”security_code” value=”27″ type=”text” style=”width:20px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:150px;”/></td>
<td ><input id=”security_code” name=”security_code” type=”text” value=”” style=”width:85px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:90px;”/></td>
<td ><input id=”security_code” value=”” name=”security_code” type=”text” style=”width:25px;”/></td>
<td ><input id=”security_code” value=”” name=”security_code” type=”text” style=”width:35px;”/></td>
<td><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:50px;”/></td>
</tr>
<tr>
<td ><input id=”security_code” name=”security_code” value=”28″ type=”text” style=”width:20px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:150px;”/></td>
<td><input id=”security_code” name=”security_code” type=”text” value=”” style=”width:85px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:90px;”/></td>
<td ><input id=”security_code” value=”” name=”security_code” type=”text” style=”width:25px;”/></td>
<td><input id=”security_code” value=”” name=”security_code” type=”text” style=”width:35px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:50px;”/></td>
</tr>
<tr>
<td ><input id=”security_code” name=”security_code” value=”29″ type=”text” style=”width:20px;”/></td>
<td><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:150px;”/></td>
<td><input id=”security_code” name=”security_code” type=”text” value=”” style=”width:85px;”/></td>
<td ><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:90px;”/></td>
<td ><input id=”security_code” value=”” name=”security_code” type=”text” style=”width:25px;”/></td>
<td ><input id=”security_code” value=”” name=”security_code” type=”text” style=”width:35px;”/></td>
<td><input id=”security_code” name=”security_code” value=”” type=”text” style=”width:50px;”/></td>
</tr>
</table>
I want to store data of all 29 text boxes. but don’t know how to get values of these ?
Thanks