Basic insertion on database.

rajeshkr

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

[upl-file uuid=8b4cca77-d398-4c53-a05a-aac40279e825 size=100kB]REGISTRATION FORM (2).jpg[/upl-file]

johanafm

name="security_code[]"

Oh, and validate your html code.

bradgrafelman

Just to elaborate a bit more:

Appending square brackets ([]) to the names of form entities will cause PHP to create an array. In other words, submitting multiple elements with a name of "bar[]" will turn $_POST['bar'] into an array that you can iterate over.
In your code above, all of the fields have the same name - "security_code." Doing so would make it impossible to discern which piece of data came from which SQL column. Use descriptive names instead.
I'm a bit confused on what your overall goal is. You populated the form based on data retrieved from a SQL table. Thus... haven't you already inserted it? Hopefully you aren't working with a DB schema that requires you to duplicate all of that data for some reason...

EDIT: Also, when posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

rajeshkr

Hi,

  <?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="slno" type="text" value="<?php echo $f1; ?>" style="width:20px;"/></td>
   <td ><input id="album_name" name="album_name" value="<?php echo $f2; ?>" type="text" style="width:150px;"/></td>
   <td ><input id="paper_used" name="paper_used" type="text" value="<?php echo $f3; ?>" style="width:85px;"/></td>
   <td ><input id="finishing" name="finishing"  value="<?php echo $f4; ?>" type="text" style="width:90px;"/></td>
   <td ><input id="price"  value="<?php echo $f5; ?>" name="price" type="text" style="width:25px;"/></td>
   <td ><input id="vat"  value="<?php echo $f6; ?>" name="vat" type="text" style="width:35px;"/></td>
   <td ><input id="total_amt" name="total_amt"  value="<?php echo $f7; ?>" type="text" style="width:50px;"/></td>


  </tr>
  <?php
$i++;

}


?>
 <tr>
<td ><input id="slno" name="slno" type="text" value="26" style="width:20px;"/></td>
<td><input id="album_name" name="album_name" value="" type="text" style="width:150px;"/></td>
   <td ><input id="paper_used" name="paper_used" type="text" value="" style="width:85px;"/></td>
   <td ><input id="finishing" name="finishing"  value="" type="text" style="width:90px;"/></td>
   <td  ><input id="price"  value="" name="price" type="text" style="width:25px;"/></td>
   <td ><input id="vat"  value="" name="vat" type="text" style="width:35px;"/></td>
   <td ><input id="total_amt" name="total_amt"  value="" type="text" style="width:50px;"/></td>    

  </tr> 
  <tr>
<td ><input id="slno" name="slno" value="27" type="text" style="width:20px;"/></td>
<td><input id="album_name" name="album_name" value="" type="text" style="width:150px;"/></td>
   <td ><input id="paper_used" name="paper_used" type="text" value="" style="width:85px;"/></td>
   <td ><input id="finishing" name="finishing"  value="" type="text" style="width:90px;"/></td>
   <td  ><input id="price"  value="" name="price" type="text" style="width:25px;"/></td>
   <td ><input id="vat"  value="" name="vat" type="text" style="width:35px;"/></td>
   <td ><input id="total_amt" name="total_amt"  value="" type="text" style="width:50px;"/></td>


  </tr> 
  <tr>
<td ><input id="slno" name="slno" value="28" type="text" style="width:20px;"/></td>
<td><input id="album_name" name="album_name" value="" type="text" style="width:150px;"/></td>
   <td ><input id="paper_used" name="paper_used" type="text" value="" style="width:85px;"/></td>
   <td ><input id="finishing" name="finishing"  value="" type="text" style="width:90px;"/></td>
   <td  ><input id="price"  value="" name="price" type="text" style="width:25px;"/></td>
   <td ><input id="vat"  value="" name="vat" type="text" style="width:35px;"/></td>
   <td ><input id="total_amt" name="total_amt"  value="" type="text" style="width:50px;"/></td>


  </tr> 
  <tr>
<td ><input id="slno" name="slno" value="29" type="text" style="width:20px;"/></td>
<td><input id="album_name" name="album_name" value="" type="text" style="width:150px;"/></td>
   <td ><input id="paper_used" name="paper_used" type="text" value="" style="width:85px;"/></td>
   <td ><input id="finishing" name="finishing"  value="" type="text" style="width:90px;"/></td>
   <td  ><input id="price"  value="" name="price" type="text" style="width:25px;"/></td>
   <td ><input id="vat"  value="" name="vat" type="text" style="width:35px;"/></td>
   <td ><input id="total_amt" name="total_amt"  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

dalecosp

You need to have unique NAME attributes for all of them. If your HTML looks like that above, the first 28 entries will be overwritten.

Typically you'd have something like

<tr>
<td ><input id="slno" name="slno" value="28" type="text" style="width:20px;"/></td>
<td><input id="album_name28" name="album_name28" value="" type="text" style="width:150px;"/></td>
   <td ><input id="paper_used28" name="paper_used28" type="text" value="" style="width:85px;"/></td>
   <td ><input id="finishing28" name="finishing28"  value="" type="text" style="width:90px;"/></td>
   <td  ><input id="price28"  value="" name="price" type="text" style="width:25px;"/></td>
   <td ><input id="vat28"  value="" name="vat28" type="text" style="width:35px;"/></td>
   <td ><input id="total_amt28" name="total_amt28"  value="" type="text" style="width:50px;"/></td>


  </tr> 
  <tr>
<td ><input id="slno" name="slno" value="29" type="text" style="width:20px;"/></td>
<td><input id="album_name29" name="album_name29" value="" type="text" style="width:150px;"/></td>
   <td ><input id="paper_used29" name="paper_used29" type="text" value="" style="width:85px;"/></td>
   <td ><input id="finishing29" name="finishing29"  value="" type="text" style="width:90px;"/></td>
   <td  ><input id="price29"  value="" name="price29" type="text" style="width:25px;"/></td>
   <td ><input id="vat29"  value="" name="vat29" type="text" style="width:35px;"/></td>
   <td ><input id="total_amt29" name="total_amt29"  value="" type="text" style="width:50px;"/></td>


  </tr>

rajeshkr

hi,
I change my code accordingly but this show error, going to else part
here is my code..
<?php
require_once("config.php");
$query_for_result=mysqli_query($con,"SELECT * FROM items ORDER BY id ASC");
$num=mysqli_num_rows($query_for_result);
mysqli_close($con);

?>
<table width="50%" align="center" border="0" cellspacing="0" cellpadding="5" style="font-family:Verdana, Arial, Helvetica, sans-serif; background:#87bb2f; -moz-border-radius: 14px; border-radius: 14px; font-size:12px; color:#000000; border:solid #d6d4d5; border-width:1px; margin-top:-1px;"> <tr>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Sl.No..</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Item</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Paper</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Finish</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Price</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Vat</td>
<td valign="top" style="font-size:11px; background:#87bb2f; font-weight:bold;" align="center" >Total Amount</td>

</tr>

<?php

$i=0;

while($row = mysqli_fetch_assoc($query_for_result))
{
$f1=$row['id'];
$f2=$row['album_name'];
$f3=$row['paper_used'];
$f4=$row['finishing'];
$f5=$row['price'];
$f6=$row['vat'];
$f7=$row['total_amt'];

$id=$i+1;

?>
<tr>
<td valign="top" style="font-size:11px; " align="center" ><input id="slno" name="slno[]" type="text" value="<?php echo $f1; ?>" style="width:20px;"/></td>
<td valign="top" style="font-size:11px; " align="center" ><input id="album_name" name="album_name[]" value="<?php echo $f2; ?>" type="text" style="width:150px;"/></td>
<td valign="top" style="font-size:11px; " align="center" ><input id="paper_used" name="paper_used[]" type="text" value="<?php echo $f3; ?>" style="width:85px;"/></td>
<td valign="top" style="font-size:11px; " align="center" ><input id="finishing" name="finishing[]" value="<?php echo $f4; ?>" type="text" style="width:90px;"/></td>
<td valign="top" style="font-size:11px; " align="center" ><input id="price" value="<?php echo $f5; ?>" name="price[]" type="text" style="width:25px;"/></td>
<td valign="top" style="font-size:11px; " align="center" ><input id="vat" value="<?php echo $f6; ?>" name="vat[]" type="text" style="width:35px;"/></td>
<td valign="top" style="font-size:11px; " align="center" ><input id="total_amt" name="total_amt[]" value="<?php echo $f7; ?>" type="text" style="width:50px;"/></td>

</tr>
<?php
$i++;

}

</table>

<?php

if(isset($POST['submit']))
{
require_once("config.php");
foreach($POST['slno'] as $k => $Sl_No)
{
if(!empty($Sl_No))
{
$customer_id="1";
$customer_name="Mr.Rajesh";
$customer_user_name="rkr";
$date=date('d-m-Y');
$time=date('hⓂi:A');
$Sl_No = mysqli_real_escape_string(trim($POST['slno'][$k]));
$album_name = mysqli_real_escape_string(trim($POST['album_name'][$k]));
$paper_used = mysqli_real_escape_string(trim($POST['paper_used'][$k]));
$finishing = mysqli_real_escape_string(trim($POST['finishing'][$k]));
$price = mysqli_real_escape_string(trim($POST['price'][$k]));
$vat = mysqli_real_escape_string(trim($POST['vat'][$k]));
$total_amount = mysqli_real_escape_string(trim($_POST['total_amt'][$k]));

$values[] = "('$customer_id','$customer_name','$customer_user_name','$Sl_No','$album_name','$paper_used','$finishing','$price','$vat','$total_amount','$date','$time')";
}
}
$sql = "INSERT INTO mytable
(customer_id, customer_name, customer_user_name, sl_no, album_name, paper, finish, price, vat, total_amt, date, time)
values ";
$sql .= implode(",",$values);
mysqli_query($con,$sql) or die(mysqli_connect_error());
}
else
{
echo "error";
}

sneakyimp

You should also stop using the mysql extension and use mysqli instead. (see my signature).

Derokorian

sneakyimp;11039201 wrote:
You should also stop using the mysql extension and use mysqli instead. (see my signature).

(S)He is using mysqli .... (at least in the most recent post)

sneakyimp

rajeshkr;11039165 wrote:
hi,
I change my code accordingly but this show error, going to else part
here is my code..

You need to use the code formatting tags or your code is very hard to read.

You also don't mention what sort of error you have gotten.

Rather than trying to do everything at once and complaining when it doesn't work, you should try everything a step at a time to make sure each step is doing what you want it to.

Try looking at your SQL code to see if it works. Also, this doesn't look correct:

mysqli_query($con,$sql) or die(mysqli_connect_error());

If a query fails, you should be looking at [man]mysqli_error[/man] instead.

sneakyimp

EDIT: double submit accidentally.

rajeshkr

Hi,
The error is , it always going into this part of code,
else
{
echo "error";
}

thanks

Weedpacket

And, by looking at your code (because you didn't use the forum's markup tags I can't be bothered to see what [font=monospace]if[/font] statement that [font=monospace]else[/font] corresponds to), can you tell us under what conditions that part of the code might be reached?

Derokorian

I see no element in the form you posted named 'submit' therefore $_POST['submit'] will never be set.