adding code to db using an array

runnerjp · March 14, 2010

Below is the full code to add races to my db.

<link rel="stylesheet" href="http://www.runningprofiles.com/dad/Form.Send/demo.css" type="text/css" />

<script type="text/javascript" src="http://www.runningprofiles.com/dad/mootools.js"></script>

<script type="text/javascript" src="http://www.runningprofiles.com/dad/Form.Send/demo.js"></script>



<script> 



function addRow() {   

          var tbl = document.getElementById('thetable');   

          var lastRow = tbl.rows.length;   

          var row = tbl.insertRow(lastRow);   

             

          var cell1 = row.insertCell(0);   

                  cell1.setAttribute('align','center') 

          var input = document.createElement('input');   

          input.name = 'date' + lastRow;   

          input.id = 'date' + lastRow;   

          cell1.appendChild(input);  



var cell2 = row.insertCell(1);   

                cell2.setAttribute('align','center') 

          input = document.createElement('input');   

          input.name = 'goals' + lastRow;   

          input.id = 'goals' + lastRow;   

          cell2.appendChild(input);  

             

          var cell3 = row.insertCell(1);   

                cell3.setAttribute('align','center') 

          input = document.createElement('input');   

          input.name = 'venue' + lastRow;   

          input.id = 'venue' + lastRow;   

          cell3.appendChild(input);   

  

var cell4 = row.insertCell(1);    

                cell4.setAttribute('align','center'); 

                 

                input = document.createElement('select');    

                input.name = 'terrain' + lastRow; 

                input.id = 'terrain' + lastRow; 

                 

                var s = "Road/Track/Multi Terrain/Cross Country".split("/"); 

                for(var i=0;i<s.length;i++) { 

                        var o = document.createElement("option"); 

                        o.value = s[i]; 

                        o.text = s[i]; 

                        input.add(o); 

                } 

         

                cell4.appendChild(input); 

        var cell5 = row.insertCell(1);    

                cell5.setAttribute('align','center'); 

                 

                input = document.createElement('select');    

                input.name = 'distance' + lastRow; 

                input.id = 'distance' + lastRow; 

                 

                var s = "3000m/5000m/10,000m/5 Miles/10 Miles/20 Miles/Half Marathon/Marathon /Other".split("/"); 

                for(var i=0;i<s.length;i++) { 

                        var o = document.createElement("option"); 

                        o.value = s[i]; 

                        o.text = s[i]; 

                        input.add(o); 

                } 

         

                cell5.appendChild(input); 

  

} 



    function delRow() {  

          var tbl = document.getElementById('thetable');   

          var lastRow = tbl.rows.length;   

          if (lastRow > 2) tbl.deleteRow(lastRow - 1);   

     } 





</script>

<br />

<center>

Here is a list of you up and coming races. Use the form below to add them so then <b>I</b> know which races you have gone for!



</center>

    <br />

<table width = "99%" class = 'forum'> 

                <tr> 

                    <td> 

                        <table width="100%" class = 'maintable'> 

                            <tr class = 'headline'> 

                            <td width = "12%" bgcolor="#003366"> 

                                    <div align = "center">Date</div></td> 



                                <td width = "14%" bgcolor="#003366"> 

                                   <div align = "center">Terrain</div></td> 



                                <td width = "12%" bgcolor="#003366"> 

                                     <div align = "center">Distance</div>                                   </td> 



                                <td width = "43%" bgcolor="#003366"> 

                                    <div align = "center">Venue

                                    </div></td> 



                                <td width = "19%" bgcolor="#003366"> 

                                    <div align = "center">Goals</div></td> 

                            </tr> 



                        <?php 

//$query="DELETE FROM dad WHERE id = '22' ";

//$result=mysql_query($query);



                                                 $getthreads = 

                                "Select * from races ORDER BY date ASC"; 



                            $getthreads2=mysql_query($getthreads) or die("Could not get threads"); 



                            while ($getthreads3=mysql_fetch_array($getthreads2)) 

                                { 

                                 

                      

                                ?><tr <? if ( $getthreads3['date'] == date("d/m/Y") ) { echo 'bgcolor="#CAD9D9"'; }?> > 

<td width="10%" height="39" align="center" valign="middle"><?php 

                            echo $getthreads3['date'];?> 



                                </td>  

<td width="15%" align="center" valign="middle"> <?php echo $getthreads3['distance']; ?>  

                                </td>   

<td width="15%" align="center" valign="middle"><?php echo $getthreads3['terrain']; ?>  

                       </td><td align = "center" valign = "middle"><?php echo $getthreads3['venue']?> </td> 



                                <td align="center" valign = "middle"> 

<?php echo $getthreads3['goals']?>



</td> 



                       

                                    </tr> 

                            <?php      } 

                        ?> 

                  </table></td> 

                </tr> 

</table>

    



<form id="myForm" action="Form.Send/ajax.form.php" method="post">

    

     <table align="center" style="WIDTH: 100%;BACKGROUND: #C0C0C0; BORDER-COLLAPSE: collapse" id="thetable"> 

   <tbody> 

     <tr> 

       <td> 

         <p align="center">Date</p></td> 

       <td> 

         <p align="center">Distance</p></td> 

       <td> 

         <p align="center">Terrain</p></td>

<td> 

         <p align="center">place</p></td>  

       <td> 

         <p align="center">Goals</p></td> 

    </tr> 

     <tr> 

       <td align="center"> 

        <input  name="date" value="<?php echo date("d/m/Y");?> " /></td> 

       <td align="center">

        <select name="distance">

<option value="3000m">3000m</option>

<option value="5000m">5000m</option>

<option value="10,000m">10,000m</option>

<option value="5 Miles">5 Miles</option>

<option value="10 Miles">10 Miles</option>

<option value="20 Miles">20 Miles</option>

<option value="Half Marathon">Half Marathon</option>

<option value="Marathon">Marathon</option>

<option value="Other">Other</option>

</select>

         </td> 

       <td align="center"> 

       <select name="terrain">

<option value="Road">Road</option>

<option value="Track">Track</option>

<option value="Multi Terrain">Multi Terrain</option>

<option value="Cross Country">Cross Country</option>

</select>

</td> 

       <td align="center"> 

        <input  name="venue" /></td> 

<td align="center"> 

        <input  name="goals" /></td> 

    </tr> 

  </tbody> 

</table> 

<table style="WIDTH: 100%; BORDER-COLLAPSE: collapse"> 

     <tr> 

       <td> 

       <p align="center"> 

          <input type="button" value="Add Anouther" onclick="addRow()" /> 

          <input type="button" value="Subtract Row" onclick="delRow()" /> 

                </p> 

       </td> 

    </tr> 

</table> 



<center>



		<input type="submit" name="button" id="submitter" /></center>

	<span class="clr"><!-- spanner --></span>

	</div>

        

        

        

</form>

    

    <center>

    

    

<div id="log">

	<center><h3>Ajax Response</h3>

	<div id="log_res"><!-- spanner --></center></div>

</div>

</center>

<span class="clr"><!-- spanner --></span>

As you can see there is an option to add a number of rows so you can add more than 1 race... what would i need to do to add all races the user inputs?? a loop of some kind?

runnerjp · March 14, 2010

ver dump gets me

Array

(

[date] => 14/03/2010

[venue] => 1

[goals] => 1

[date2] => 14/03/2010

[venue2] => 2

[goals2] => 2

[date3] => 14/03/2010

[venue3] => 3

[goals3] => 3

[distance] => 5000m

[terrain] => Road

[distance2] => 3000m

[terrain2] => Track

[distance3] => 10,000m

[terrain3] => Cross Country

)

if that helps at all

Sign In

adding code to db using an array

Recommended Posts

runnerjp

Link to comment

Share on other sites

runnerjp

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information