0

Hi i'am try to insert multiple data on a single submit, but i'm a total noob to Arrays, can any one help me out here... one of the members send me this out, but still i can figure it out how to insert the fields onto my database. it inserts but doesnt get the valuee.. Please help!

if(isset($_POST['save']))
	{
	unset($_POST['save']);
	$i = count($_POST['id']); $x = 0;
	for($x=0; $x <$i;$x++){
		foreach($_POST as $data =>$d){
		echo $data.'-'.$d[$x].'<br/>';
		$insert = mysql_query("insert into tbl_grades");
		//sql statement here (example): insert into table name (value of $data) values( value of$d[$x]) -- 
[B]//HOW DO I MAKE MY SQL QUERY TO SAVE THIS OUT, I KNOW THIS IS MY PROBLEM IN THE QUERY....[/B]

HTML CODE:S/

<input name="id[]" type="hidden" value="<?php echo $row['id'];?>" />
 1st<input name="fg[]" type="text" id="fg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/>
 2nd<input name="sg[]" type="text" id="sg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/>
 3rd<input name="tg[]" type="text" id="tg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/>
4th <input name="forg[]" type="text" id="forg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/> ---- sub_id stands for subject id

Edited by lastgame2007: n/a

2
Contributors
4
Replies
5
Views
5 Years
Discussion Span
Last Post by lastgame2007
0

I tried answering this a few times, but then I thought, how are you producing the form fields? I'm assuming using a while... loop. Show more of this code.

IDs for form attributes shouldn't be array items. NAME attributes - OK.

0

yes im looping it together with the values i wanted.

sir, can you help me with this,

i can't get the value of what im trying to save....

0

Yawn...

You're not helping yourself here...

this is my code how i make the loop, together with the subject id i wanted to save..

<?php
	$query = mysql_query("select * from students, stud_subject, tc_handle,acad_year where
			tc_handle.sub_id = '$_GET[view]' and 
			tc_handle.acad_id=acad_year.acad_id and
			acad_year.acad_id='$g_year[acad_id]' and
			stud_subject.acad_id=acad_year.acad_id and
			students.id = stud_subject.id and
			stud_subject.sub_id = tc_handle.sub_id and 
			stud_subject.acad_id='$g_year[acad_id]'");
while ($row = mysql_fetch_array($query)){
?>
<?php
	$f_name = $row['lastname'].' ,&nbsp;'.$row['firstname'].'&nbsp;'.$row['middlename'].'<br>';
	echo '<p class="name">'.$f_name.'<p class="x">';
	
?>
<form action="tc_addall.php" method="post">
 <p class="oo">
 <input name="id[]" type="hidden" value="<?php echo $row['id'];?>" />
 1st<input name="fg[]" type="text" id="fg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/>
 2nd<input name="sg[]" type="text" id="sg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/>
 3rd<input name="tg[]" type="text" id="tg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/>
4th <input name="forg[]" type="text" id="forg[]" size="1" value="<?php  $g_sub['sub_id'];?>"/>
 </p>

<?php }?>
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.