number of rows loop help

michaelowen

hello,

I am having a user validation which will dictate how many rows of information they will be prompted to enter, but i'm having problems with the loop.

Right now, i'm passing the number of rows as $row, and want to repeat the following code in a form for $row times.

<table border="2" width="100%"><tr><td>
<form method="post" action="<?php echo $PHP_SELF?>" onSubmit="return Validator(this);">

  First Name: <input type="Text" name="first" size="10">

  Last Name: <input type="Text" name="last" size="10">

&nbsp;&nbsp;Age:&nbsp;<input type="Text" name="age" size="5">

</form>

</td></tr></table>

Where would i place the loop to have the $row repeat this row to submit $row of entries?

THANKS!
-Michael

LordShryku

<?php
for($i=0;$i<$row;$i++) {
?>
<table border="2" width="100%"><tr><td>
<form method="post" action="<?php echo $PHP_SELF?>" onSubmit="return Validator(this);">

<table width="100%" border="0">
<tr><td>

  First Name: <input type="Text" name="first" size="10">

  Last Name: <input type="Text" name="last" size="10">

  Age: <input type="Text" name="age" size="5">

<input type="Submit" name="submit" value="enter information">

</form>

</td></tr></table> 
<?php
}
?>

michaelowen

thank you so much, but i'm having a problem passing the $row variable from the original validation form.

here is what i have in regards to this variable:

(from include.php):

<tr>
<td>Number of Entries:</td>
<td><input type=\"text\" name=\"$rows\" size=\"5\"></td>
</tr>

FORWARDING:

header ("Location: http://www............/runner.php?clubname=".$clubname."&rows=".$rows."");

FINAL CALL:

<?php
for($i=0;$i<$rows;$i++) {
?>

Am I not converting this properly? Not calling properly?

THank you so much,

-Michael

Tracer

If register globals is set to OFF, then it would be $POST[row] or $GET[row] And $POST[clubname] or $GET[clubname], not $row and $clubname on the following page...

michaelowen

the clubname is passing properly in this manner, however the number of rows is not.

Is this command correct in the original form?

<tr>
<td>Number of Entries:</td>
<td><input type=\"text\" name=\"$rows\" size=\"5\"></td>
</tr>

do i need to declare this as anything further for it to properly show up when i call it as:

header ("Location: http://www............/runner.php?clubname=".$clubname."&rows=".$rows."");

Thanks.

-Michael

Tracer

It should be

not $rows.....

michaelowen

This posting does not post correctly to the DB....what do i need to do to get this to each display as seperate entries ($rows of entries) with only the ONE submit button?

here is my table:

<table border="2" width="100%"><tr><td>
<form method="post" action="<?php echo $PHP_SELF?>" onSubmit="return Validator(this);">

<?php
for($i=0;$i<$rows;$i++) {
?>
<table width="100%" border="0">
<tr><td>

  Verify Club Name (check box):       <INPUT TYPE="text" NAME="$club" value="<?php echo $clubname ?>"></b>

  First Name: <input type="Text" name="first" size="10">

  Last Name: <input type="Text" name="last" size="10">

  Age: <input type="Text" name="age" size="5">

  Sex: <SELECT NAME="sex">
<OPTION VALUE="">
<OPTION VALUE="Male">Male
<OPTION VALUE="Female">Female
</SELECT>

  Race: <SELECT NAME="race">
<OPTION VALUE="">
<OPTION VALUE="tba">tba
<OPTION VALUE="tba">tba
<OPTION VALUE="tba">tba
</SELECT><br><br>
<hr><br>

</td></tr>
</table>
<?php
}
?>

</form><input type="Submit" name="submit" value="enter information">
</td></tr></table>

thank you very much for all your help!

-=Michael

Tracer

Once again...make sure you remove this...

Verify Club Name (check box): <INPUT TYPE="text" NAME="$club" value="<?php echo $clubname ?>"></b>

It should be "club" , not $club....If you use $club, then your passign the variable

$$club....

michaelowen

thank you so much!

do you know what i'm doing wrong in regards to looping the rows to submit this with one SUBMIT button to submit all the seperate rows?

-Michael

Tracer

In order to Re-USe the same variable names...and have just one submit button, you will need to use an ARRAY....

I recommend reading up on arrays at both php.net and this site before doing so...But the basic form element would look soemthing like:
<input type=text name=MyArray[]>

Instead of
<input type=text name=MyVar>

and most likely, you will need some kind of multi-dimensional array.....(Which can get messy)...

Why not just list them all on one page and place an "Edit" button beside it to change each listing?

michaelowen

i am going to use the edit/delete in another function later, however what's happening in this step is that a captain is going to sign on (using validation) and then say how many entries he wants to sign up.....that is where the row variable key.

So basically there would be nothing to edit at this point.

is that what you meant?

Tracer

Maybe you can do something liek this then...

echo "<Input type=text name=club".$row.">";

So you get variables passed to the next page like $club1, $club2

Then you can use a while loop to perform your SQL inserts...

while($count <= $rows)
{
DO YOUR SQL INSERT

$count++;
}

michaelowen

i'm having problems with the multi-array, but wehn i do this i pass all the info, but it puts the word "ARRAY" in the db, and no other info:

<table border="2" width="100%"><tr><td>
<form method="post" action="<?php echo $PHP_SELF?>" onSubmit="return Validator(this);">

First Name: <input type="Text" name="first[$i]" size="10">

Last Name: <input type="Text" name="last[$i]" size="10">

Age: <input type="Text" name="age[$i]" size="5">

</td></tr>

<?
}
?>

</table>

thanks!
-Michael

Tracer

Try

<table border="2" width="100%"><tr><td>
<form method="post" action="<?php echo $PHP_SELF?>" onSubmit="return Validator(this);">
<table width="100%" border="0">
<?
$row = 5;
for ($i = 0; $i < $row; $i++) {
echo"
<tr><td>
First Name: <input type=\"Text\" name=\"first[$i]\" size=\"10\">
Last Name: <input type=\"Text\" name=\"last[$i]\" size=\"10\">
Age: <input type=\"Text\" name=\"age[$i]\" size=\"5\">
</td></tr>";
}
?>
<input type="Submit" name="submit" value="enter information">
</form>
</table>

michaelowen

This is still posting "Array" to the database one time (no matter how many rows).

any ideas?

-Michael

Tracer

To access the variable on the next page it should be

$first[0]
$first[1]
$first[2]

etc etc

michaelowen

thank you.

Wouldn't I need a loop insert since the number of entries is a variable as well?

for example:

foreach($first as $value)
{
$sql = "INSERT INTO runner (first,last,age,sex,race) VALUES ('$first','$last','$age','$sex','$race')";
}

-Michael

Tracer

yup...
Should look something like this...


while ($count <= $_POST[row])
{
$sql = "YOUR SQL YourVar[$count]......";
$count++
}

Obvisouly you need to insert your own SQL statements....and the $row var needs to be passed from the previous page as a hidden input