# For loop: php to mysql db

**URL:** <https://forum.kirupa.com/t/for-loop-php-to-mysql-db/255873>\
**Category:** programming\
**Created:** [March 27, 2008, 8:11pm UTC](https://forum.kirupa.com/t/for-loop-php-to-mysql-db/255873 "2008-03-27T20:11:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Utech22](https://avatars.discourse-cdn.com/v4/letter/u/f17d59/32.png) [@Utech22](https://forum.kirupa.com/u/Utech22)\
**Post date:** [March 27, 2008, 8:11pm UTC](https://forum.kirupa.com/t/for-loop-php-to-mysql-db/255873/1 "2008-03-27T20:11:02Z")

</div>

I have an input where user can input the amount of dates to add (default is 1);  
[COLOR=blue]$event\_no = 1;[/COLOR]  
[COLOR=darkorange][\_\_\_] [BUTTON]CLICK TO DISPLAY # OF DATES [/BUTTON][/COLOR] for example the user puts 2  
EVENT 1 [MONTH] | [DAY] | [YEAR]  
EVENT 2 [MONTH] | [DAY] | [YEAR]

```php
<?php ##SOME CODE TAKEN OUT.. IT IS JUST 3 INPUTS MONTH,DAY AND YEAR
 
 
##---FOR LOOP TO DISPLAY THE AMOUNT OF Things TO ADD
for ($events=0;$events<$event_no;$events++)
{
##INCEREMENT EVENTS NUMBER [event 1, event 2...]
?> Event <?php echo $events+1; ?>
 
 <select name="months" >
     <option value="<?php echo $monthArray; ?>"><?php echo $monthArray;?> </option>
 </select>
 
 <select name="day">
    <option value="<?php echo $dayArray; ?>"><?php echo $dayArray; }?></option>
 </select>
 
<select name="year">
   <option value="<?php echo $yearArray; ?>"><?php echo $yearArray; }?> </option>
</select>
<?php
}
?>

```

I want the data to be added to the database event\_no times, that is  
if the user adds 2 set of dates and save it the 2 sets save to the database.  
with the code I have only one is saved

```php
 
if isset($_POST['add'])
{
       for ($events=1;$events=<$event_no;$events++)
       {
           ...(INSERT INTO DATABASE MONTH,DAY,YEAR VALUES ('$month','day','year'));
       }
}

```

[COLOR=red]SO BASICALLY IF THE USER ADDS 4 DATES TO DISPLAY,[/COLOR]  
[COLOR=red]THEN ENTER THE 4 DATE HE WANTS AND CLICK SAVE,[/COLOR]  
[COLOR=red]THE 4 DATES SHOULD BE SAVED.[/COLOR]