Insert Multiple Records Using One Form

macgibbo83

I have a database for entering attendance for staff meeting that I would like to update the records for in one form. Below is the code ive written so far which creates the form with 3 seperate text boxes to enter strings for the attendance data and an attempt at inserting that data into the mysql table.

<?php

if (isset($_POST['submitted'])) {

include('connect-mysql.php');

    $number = $_GET['number'];  
    for ($i = 0; $i <= $number; $i++)  
    {  
    $value = $_GET['value']; 
    $text = $_GET['text'];   
    }
$sqlinsert = "INSERT INTO attendance (value, text) VALUES ('$value', '$text')";

IF (!mysqli_query($dbcon, $sqlinsert)) {
	die('error inserting new record');
} //end of nested if statement

$newrecord = "Records added successfully to the database";


} //end of the main if statement 


?>


<html>
<head>
<title>Insert Data into Attendance Record</title>
</head>
<body>

<form method="post" action="insert-data.php">
<input type="hidden" name="submitted" value="true" />

<fieldset>
<table style="width: 400px">
<legend>Attendance</legend>
	<tr>
		<td><label>Early  <input name="value[]" type="text" id="value[]" /></label></td>
                <td><input name="text[]" type="hidden" id="text[]" value="Monday" /><label></td>
	</tr>
        <tr>
		<td><label>Family <input name="value[]"type="text" id="value[]" /></label></td>
                <td><input name="text[]" type="hidden" id="text[]" value="Wednesday" /><label></td>
	</tr>
        <tr>
		<td><label>Evening <input name="value[]"type="text" id="value[]" /></label></td>
                <td><input name="text[]" type="hidden" id="text[]" value="Friday" /><label></td>
	</tr>
                <input type=hidden name=number value=<? echo $number;?>>
</table>	
</fieldset>
<br>
<input type="submit" value"add data" />
</form>

<?php
echo $newrecord 
?>

</body>
</html>

big_nerd

macgibbo83,

We can see what you've done - however what are you attempting to do exactly? As in -- what is the current result and what is the result you would like to achieve?

Also - when posting PHP code we can see syntax highlighting if you use [PHP] and [/PHP] BBCode Tags, it just makes it easier for us to read.

macgibbo83

Ok sorry maybe I didnt explain properly what I was trying to do. I have 3 meetings that happen in the week one Monday, one Wednesday and one Friday. The form ive written is intended to add a record of attendance and the name of the meeting to one table in the database example of database

ID Value Text
1 256 Monday
2 261 Wednesday
3 279 Friday

ID is an autonumber, value is the attendance record, text is the name of the meeting

The form would look like this

Monday: Textbox
Wednesday : Textbox
Friday: Textbox

Submit

I though that because the 'value' and 'text' variables change I thought id need to put them in an array somehow so tried this counter approach which doesnt seem to work would a foreach loop be better?

Current output

ID Value Text
56 0

Only one record id added and the value is 0 whatever number I put into the form

sneakyimp

I'm looking at your form and i see you have 3 text inputs, 3 hidden inputs, and only one number input. You might want to re-examine your form so that you have a visible text input and a visible number input for each meeting.

it's also not clear if you want to continually create new records when people submit this form or whether you want to call up previous results and let a user UPDATE the values for a given meeting.

You need to be a lot clearer about what you are trying to accomplish.

macgibbo83

Ok so i've reworked my code. At the moment I don't want the user to replace values that are already in the database, i'll look at that one later, I just want them to indefinitely add values. This is the new code.

if (isset($_POST['submitted'])) {

include('connect-mysql.php');
    $sql = "";
    foreach($_POST['day'] as $key => $val){
    if($val != "")
    $sql .= "($val,'$key'),";

    $sql = substr($sql,0,-1);
//check to see $sql != ""
        $sqlinsert = "INSERT INTO attendance (value, text) VALUES $sql";

IF (!mysqli_query($dbcon, $sqlinsert)) {
	die("error inserting records");

} //end of nested if statement

$newrecord = "Records added successfully to the database";
}
} //end of the main if statement
?>

<form method="post" action="insert-data.php">
<input type="hidden" name="submitted" value="true" />

<fieldset>
<table style="width:300px">
<legend>Attendance</legend>
	<tr><td><label>Early</td><td><input type="text" name="day[Monday]" value="" /></td></tr>
        <tr><td><label>Family</td><td><input type="text" name="day[Wednesday]" value="" /></td></tr>
        <tr><td><label>Evening</td><td><input type="text" name="day[Friday]" value="" /></td></tr>
</table>	
</fieldset>
<br>
<input type="submit" value"add data" />
</form>
<?php
echo $newrecord;

macgibbo83

This new code outputs the correct data for only one row and not the expected three rows

ID Value Text
60 1000 Monday

Wednesday and Friday values are missing

sneakyimp

Have you checked to see if it's looping? Have you checked to see what sql it generates?