Iterations based on calculated values

[Bilbozilla]

Hi there,

I have a problem. I am trying to generate a php script to display a variable number of fields based on a date calculation. I'm not quite sure how to begin.

I have the variable $duration. If $duration is 1, I need 1 entry field. If it is 10, I need 10.

I am still a bit confused with arrays.

For instance, with duration=3, I need it to create fields to enter data.

1. Day 1 Title 1, Description 1
2. Day 2 Title 2, Description 2
3. Day 3 Title 3, Description 3

I have a database table set up called "itinerary' wherein there is an identifying ID which Days 1-3 are linked to. How do I proceed?
tbl_itinerary
(ID, ref_id, day, tite, desc)

When all is said and done, I'll do a select * where the ref_id is known and then sort the days by ascending order.
Then write

[NogDog]

Sounds like a job for a [man]for[/man] loop.

for($ix = 1; $ix <= $duration; $ix++)
{
   echo "<input type='text' name='whatever[$ix]' />";
}

(If you use the "[]" array-type notation in the form field name, then its value will be in a sub-array within the $POST array, e.g $POST['whatever'][1], $_POST['whatever'][2], etc....)

[Bilbozilla]

Thanks for the reminder that I need to be a bit more clear in my requests.

My question was more related to what do I do with the arrays when putting the data into the database?

    for($itin = 1; $itin <= $duration; $itin++) 
{ 
   echo "<td>Day $itin Title: </td><tr><td><input type='text' size=50 MAXLENGTH-125 value=\"Day #$itin Title\" name='title[$itin]' /></td><tr>";
   echo "<input type=\"hidden\" name=\"day\" value=\"day[$itin]\">";
   echo "<input type=\"hidden\" name=\"tourid\" value=\"tourid[$itin]\">";
   echo "<td>Day $itin Description: </td><tr><td><textarea rows=\"4\" cols=\"47\" name='desc[$itin] wrap=\"physical\"' />Enter the description of Day #$itin here.</textarea></td><tr>"; 

}

So now I have day[itin], title[itin], refid[itin], descp['itin'] as arrays.

How do I insert these into my database?

For the sake of coding, I'll have the connection and database coded. Do I use an for loop to write them? How do I write each element into the database?

[Bilbozilla]

Does anybody have some input as to how to accomplish this?

[halojoy]

Bilbozilla;10939222 wrote:

For instance, with duration=3, I need it to create fields to enter data.

1. Day 1 Title 1, Description 1
2. Day 2 Title 2, Description 2
3. Day 3 Title 3, Description 3

I have a database table set up called "itinerary' wherein there is an identifying ID which Days 1-3 are linked to. How do I proceed?
tbl_itinerary
(ID, ref_id, day, tite, desc)

When all is said and done, I'll do a select * where the ref_id is known and then sort the days by ascending order.
Then write

The steps should be:
1. make the form work correctly
2. checkout that values are posted alright in $_POST array
3. insert posted values into database

I have focused on step 1 and step 2.
This is the form and $_POST testing I have used

<?php
error_reporting(E_ALL); // let php help debug
ini_set('display_errors',1); // make sure debug errors are displayed

// dump posted values
if(isset($_POST['submit'])){
    echo '<pre>';
    print_r($_POST);
    echo '</pre>';
}

$duration = 3;
echo'<form method="post">';
echo '<table>';
for($itin = 1; $itin <= $duration; $itin++) 
{ 
   echo "<tr><td>Day $itin Title: </td></tr>
   <tr><td><input type='text' size=50 MAXLENGTH-125 value=\"Day #$itin Title\"
    name='title[$itin]' /></td><tr>";
   echo "<input type=\"hidden\" name=\"day[$itin]\" value=\"day[$itin]\">";
   echo "<input type=\"hidden\" name=\"tourid[$itin]\" value=\"tourid[$itin]\">";
   echo "<tr><td>Day $itin Description: </td></tr>
   <tr><td><textarea rows=\"4\" cols=\"47\" name='desc[$itin]
    wrap=\"physical\"' />Enter the description of Day #$itin here.</textarea></td><tr>"; 
}
echo '<tr><td><input type="submit" name="submit" value="Submit"></td></tr>';
echo '</table>';
echo '</form>';

?>

[Bilbozilla]

Thank you. I wasn't aware of using

    <?php 
error_reporting(E_ALL); // let php help debug 
ini_set('display_errors',1); // make sure debug errors are displayed 

My confusion now arises from my array in tbl_itinerary
(ID, ref_id, day, tite, desc)

I have a day[itin], title[itin], desc[itin], and ref[itin] with values set for each of them.

Do I just to a

for($count=0, $count<$duration+1, $itin++){
    INSERT INTO tbl_itin (day, title, desc, ref_ID) VALUES (day[$count], title[$count], desc[$count], ref[$count]);
}

[johanafm]

Bilbozilla;10939628 wrote:

for($count=0, $count<$duration+1, $itin++){

Not quite.

now           should be
$contr = 0 =>  $count = 1
,          =>  ;
$itin      =>  $count

Bilbozilla;10939628 wrote:

VALUES (day[$count], title[$count]

day        =>  $_POST['day']
title      =>  $_POST['title']
etc

And you should escape your post data or use prepared statements.