Not able to insert new rows in a database table

[tarunkhatri]

Hi,

I want to insert multiple rows in a database table, from an submit form. But not able to trouble shoot the problem in my code. Following is the code.

<form action=test_insert.php method="post">
<table>
<?php for($i=0; $i<10; $i++)
{ ?>
 
    <tr>
    <td><input type="text" name="employee_id" value="0" size = "2" ></td>
    <td><input type="text" name="task_no" value="0" size = "2" ></td>
    <td><input type="text" name="discription" value="0" size = "2"></td>
    <td><input type="text" name="mon" value="0" size = "2"></td>
    <td><input type="text" name="tue" value="0" size = "2"></td>
        <td><input type="text" name="wed" value="0" size = "2"></td>
        <td><input type="text" name="thu" value="0" size = "2"></td>
        <td><input type="text" name="fri" value="0" size = "2"></td>
        <td><input type="text" name="sat" value="0" size = "2"></td>
        <td><input type="text" name="sun" value="0" size = "2"></td>
    <td><input type="text" name="total" value="0" size = "2"></td>          
    <td><input type="text" name="week_no" value="0" size = "2"></td>
    </tr>
<?php } ?>
 
</table>
 
<input name="submit" value="Submit" type="submit">
</form>
 
<?php
$conn = pg_connect("host=localhost port=5432 dbname=*** user=postgres password=*****");
 
$query = "insert into public.grid_data (employee_id, task_no, discription, mon, tue, wed, thu, fri, sat, sun, total, week_no)
Values
($employee_id,$task_no,$discription,$mon,$tue,$wed,$thu,$fri,$sat,$sun,$total,$week_no) ";
 
$res = pg_query($conn, $query) or die(pg_last_error());
if($res){echo("Record added for : $employee_id");}
 
?>
 

The 2 errors which I am gettin are. 1. undefined variable for all ( $employee_id, $task_no .....) and
2. Query failed: ERROR: syntax error at or near ","\nLINE 3: (,,,,,,,,,,,) \n ^

Many thanks in advance

[Markus]

You are not defining the variables anywhere in your script.

[tarunkhatri]

I changed my sql query to

$query = "insert into public.grid_data (employee_id, task_no, discription, mon, tue, wed, thu, fri, sat, sun, total, week_no)
Values
('$_POST[employee_id]','$_POST[task_no]','$_POST[discription]','$_POST[mon]','$_POST[tue]','$_POST[wed]','$_POST[thu]','$_POST[fri]','$_POST[sat]','$_POST[sun]','$_POST[total]','$_POST[week_no]') ";

It inserts one row in the table now. But not 10

[Dormilich]

@tarunkhatri
why should it insert 10 rows?

[tarunkhatri]

Because there are 10 rows in the form, in which user is inptting different values. I Just figured out may be I need an array in the input type name of every td, and then a loop at the insert statement.

[Dormilich]

that sounds reasonable.

[88stevie]

They're all the same name though.

having a form with inputs like this:

<input type="text" name="sun" value="0" size = "2">
<input type="text" name="sun" value="0" size = "2">
 

Means that only one sun will be shown.

To acheive what you want you need to name them:

<input type="text" name="sun[]" value="0" size = "2">
<input type="text" name="sun[]" value="0" size = "2">

Then after you POST you must look through them all like sooo..

foreach($_POST['sun'] as $x=>$Value)
{
  $_POST['mon'][$x] // means if $x is 2 it will get mon[2]
}

[tarunkhatri]

Guys, Thank you very much an array at input type name and a loop at insert statement did my job. :)