need help with multi-dimen array processing

[Xephon]

ok i am having a hard time trying to think of how to explain what i want to do lol.

here is my ultimate goal (links to pictures of what i want lol):

I am creating a kind of weight lifting blog. I am using smarty as the template engine.

1st page: Asks the users how many different exercises they did
Page 1

2nd page: Asks the names of each exercise and how many sets of each one. The number of exercies printed is dynamically based on what the user entered on page 1
.Page 2

3rd page: Prints out a table.
The names and set numbers come from the info entered on page 2
.Page 3

Then after entering everything on page 3, all the info is stored in an array, and that array is then entered into the database like this

insert into workout (workout_name, set_number, reps, weight, date) values (<some how filled in with for loops and arrays>)

ill show my code even though i know it is 110% wrong and totally incomplete :/

what little i could come up with for the processing part:
enter_workout.php

<?php

 include 'db.php';
 require_once("libs.inc.php");

 if(isset($_SESSION['username']))
 {
     $_SESSION['logged_in'] = 1;
 } else {
     $_SESSION['logged_in'] = 0;
 }

 if(empty($_POST['step']))
 {
     $smarty->assign("step", 1);
     $smarty->display("templates/enter_workout.html");
     exit();
 } else {
     if($_POST['step'] == 2)
     {
         $smarty->assign("step", 2);
         if(isset($_REQUSET['today']))
         {
             $_SESSION['date'] = date("j, n, Y");
         } else {
             $_SESSION['date'] = $_POST['user_date'];
         }
         $_SESSION['workout_night'] = $_POST['workout_night'];
         $_SESSION['number_of_exercises'] = $_POST['number_of_exercises'];
         $i = $_SESSION['number_of_exercises']
         $exercise_names_looper = range(1, $i);
         $smarty->display("templates/enter_workout.html");
         exit();
     }
     if($_POST['step'] == 3)
     {
         $smarty->assign("step", 3);
         $workout_names = array();

         for ($i = 1; $i <= $_SESSION['number_of_exercises']; $i++)
             {
                 $workout_names[$i][names] = $_POST['workout_names'.$i];
                 $workout_names[$i][number_sets_exercise] = $_POST['number_sets_exercise'.$i];
             }
         $_SESSION['workout_names'] = $workout_names;
         $smarty->assign("workout_names", $workout_names);

and the 75% wrong smarty template
enter_workout.html:

{if $smarty.session.logged_in eq 1}
	{if $step eq 1}
           <form method=post action="enter_workout.php?step=2">
           <table width="100%" border=1>
	          <tr>
		         <td>
		         <table width=100%>
			        <tr>
				       <td width=15%>Use today's Date</td>
				       <td width=2%><input type="radio" name=today value=today checked></td>
			        </tr>
                    <tr>
			           <td>Or enter the date</td>
				       <td><input type="radio" name=other_day value=other_Day></td><td>&nbsp;&nbsp;&nbsp;<input type=text name=user_date></td>
			        </tr>
		         </table>
		         </td>
	          </tr>
	          <tr>
		         <td>
		         <table width=100%>
			        <tr>
				       <td width=24%>What workout night is it?</td>
				       <td><input type=text name=workout_night></td>
			        </tr>
			        <tr>
				       <td>How many different exercises?</td>
				       <td><input type=text name=number_of_exercises></td>
			        </tr>
		         </table>
		         </td>
	          </tr>
	          <tr>
                 <td><input type=submit name=submit value=Next> &nbsp; &nbsp; <input type=submit name=submit value=Quit></td
	          </tr>
           </table>
           </form>
	{elseif $step eq 2}
         <form method=post action="enter_workout.php?step=3">
         <table width=100%>
         {section name=i loop=$exercise_names_looper}
	        <tr>
		       <td width=15%>Name of exercise {$i}</td>
		       <td><input type=text name=workout_name{$i}></td>
	        </tr>
	        <tr>
		       <td width=15%>Number of sets for workout  {$i}</td>
		       <td><input type=text name=number_sets_exercise{$i}></td>
	        </tr>
         {/section}
	        <tr>
		       <td><input type=submit name=submit value=Next> &nbsp; &nbsp; <input type=submit name=submit value=Quit></td>
	        </tr>
         </table>
         </form>
	{elseif $step eq 3}
         <form method=post action="enter_workout.php?step=4" >
         <table width=100% border=1>
                <tr bgcolor="#0099FF">
                    <td width=30%>Workout Name</td>
                    <td width=23%>Set Number</td>
                    <td width=23%>Reps</td>
                    <td width=23%>Weight</td>
                </tr>
          //This section is fully off i cannot figure out what do do here, and it is not really updated to match the php, cus i dont know if i can figure out how to do either
                {section name=i loop=$workout_name}
                         {section name=j loop=$number_sets_exercise[i]}
                         <tr>
  	                          <td>{$workout_name[i].name}</td>
                              <td>Set number {j}<input type=hidden name=set_number{$j} value={j}></td>
	                          <td><input type=text name=reps></td>
	                          <td><input type=text name=weight></td>
                         </tr>
//end of messed up section
                         {/section}
                {/section}
                <tr>
                   <td><input type=submit name=submit value=Next> &nbsp; &nbsp; <input type=submit name=submit value=Quit></td
	               <td></td>
	               <td></td>
	               <td></td>
                </tr>
         </table>
         </form>
    {else}
         Incorrect step choice
    {/if}
{else}
	Please login <br />
    <a href=index.php>
{/if}

if you cannot know of a way, or know of a better way then using smarty, then that is fine too, i am just at a complete loss on how to do this. I have spent hours trying to figure this out, and nothing except a huge headache. Arrays are my weakest link when it comes to any sort of programming, i just cannot understand them for some reason, especially multi-dimensional ones.

Sorry to ask for such a large amount of help, but i know i cannot figure it out on my own, i have tried for the last few days, and NOTHING has worked :/

[Xephon]

so can yah tell me how i should set mine up?

i need the following info to evertually make it to the databse through the forms i have shown:

workout night
workout_name
set_number
reps
weight

i workout night can have any number of workout_names in it. Then the workout_names can have any amount of sets in it. The sets consist of any number of reps. And the reps can be done with any amount of weight

i was thinking
http://www.yorokonde.com/help/4.jpg

but i really dont know if have have it structured or written right, and i have no clue how to loop through it to fill it out from my forms, or how to dynaically make the forms in order to fill it out given a random(well not random, but the user picks the amounts, so from a coding perspective the amount is random) amount of exercises and sets.

[Xephon]

still need some help 🙁

[michaelb]

You've given way to much stuff for me to read to figure out exactly what your problem is. Please provide only the relavant information. I skimmed what you have and think what you're saying is how do I get the contents of a 2-d array into a mysql table. If this is what you want to do please post a print_r of your array and describe your database structure. Then someone can help you.

[Xephon]

actually it is a 3d array.

first i wanted to figure out how to make my 2-d array print the tables for the form. The form will fill in the rest of the info for my 3d array

then i want to put the 3d array into my database

the array number of entries in the array varies by what the user puts for the amount of exercies and the amount of sets per exercise.

a sample of the array is like this

$workout night = array( 
    "bench" => array( 
        0 => array('reps' => 5, 'weight' => 185), 
        1 => array('reps' => 4, 'weight' => 195), 
        2 => array('reps' => 3, 'weight' => 205) 
    ), 
    "flies" => array( 
        0 => array('reps' => 5, 'weight' => 45), 
        1 => array('reps' => 5, 'weight' => 45), 
        2 => array('reps' => 5, 'weight' => 45), 
        3 => array('reps' => 5, 'weight' => 45) 
    ) 
);

I dont know how to then put this into a database

the database is structured like this:

create table workout (

workout_night varchar(20) not null,
exercise_name varchar(30) not null,
set_number int(2) not null,
reps int(3) not null,
    weight int(4) not null,
    workout_date datetime not null
);

[michaelb]

ok, I'm not yet clear on where the data for the db columns workout_night, set_number, and workout_date is going to come from, however to put what was in your array into that table try this (untested) snippet:

foreach($workout_night AS $exercise_name => $exercise_stats){
mysql_query("INSERT INTO workout SET exercise_name = '$exercise_name', reps = '$exercise_stats[reps]', weight = '$exercise_stats[weight]'");
}

This may not be a drop-in copy/paste solution because you provided an invalid name for your 3d array, I assumed it was $workout_night in the foreach statement.

[Xephon]

the first page is the php code (enter_workout.php) and the 2nd page is the smarty template (enter_Workout.html)

<?php
     session_start();
     include 'db.php';
     require_once("libs.inc.php");

 if(isset($_SESSION['username']))
 {
     $_SESSION['logged_in'] = 1;
 } else {
     $_SESSION['logged_in'] = 0;
 }

 if(empty($_REQUEST['step']))
 {
     $smarty->assign("step", 1);
     $smarty->display("templates/enter_workout.html");
     exit();
 } else {
     if($_REQUEST['step'] == 2)
     {
         $smarty->assign("step", 2);
         if(isset($_REQUSET['today']))
         {
             $_SESSION['date'] = date("j, n, Y");
         } else {
             $_SESSION['date'] = $_POST['user_date'];
         }
         $_SESSION['workout_night'] = $_POST['workout_night'];
         $_SESSION['number_of_exercises'] = $_POST['number_of_exercises'];
         $i = $_SESSION['number_of_exercises'];
         $exercise_names_looper = range(1, $i);
         $smarty->assign("exercise_names_looper", $exercise_names_looper);
         $smarty->display("templates/enter_workout.html");

         exit();
     }
     if($_REQUEST['step'] == 3)
     {
         $smarty->assign("step", 3);
         $workout_name = array();

         for ($i = 1; $i <= $_SESSION['number_of_exercises']; $i++)
             {
                 $workout_name[$i] = array( "name" => $_POST['workout_name'.$i], "number" => $i);
                 $j = $_POST['number_sets_exercise'.$i];
                 for($k=1; $k <= $j; $k++) {
                 $workout_name[$i][$k] = array("set_number" => $k);
                 }



             }
         $_SESSION['workout_name'] = $workout_name;
         $smarty->assign("workout_name", $workout_name);
         $smarty->display("templates/enter_Workout.html");
     }
}
?>

{if $smarty.session.logged_in != 1}
	{if $step eq 1}
           <form method=post action="enter_workout.php?step=2">
           <table width="100%" border=1>
	          <tr>
		         <td>
		         <table width=100%>
			        <tr>
				       <td width=15%>Use today's Date</td>
				       <td width=2%><input type="radio" name=today value=today checked></td>
			        </tr>
                    <tr>
			           <td>Or enter the date</td>
				       <td><input type="radio" name=other_day value=other_Day></td><td>&nbsp;&nbsp;&nbsp;<input type=text name=user_date></td>
			        </tr>
		         </table>
		         </td>
	          </tr>
	          <tr>
		         <td>
		         <table width=100%>
			        <tr>
				       <td width=24%>What workout night is it?</td>
				       <td><input type=text name=workout_night></td>
			        </tr>
			        <tr>
				       <td>How many different exercises?</td>
				       <td><input type=text name=number_of_exercises></td>
			        </tr>
		         </table>
		         </td>
	          </tr>
	          <tr>
                 <td><input type=submit name=submit value=Next> &nbsp; &nbsp; <input type=submit name=submit value=Quit></td
	          </tr>
           </table>
           </form>
	{elseif $step eq 2}
         <form method=post action="enter_workout.php?step=3">
         <table width=100%>
         {section name=i loop=$exercise_names_looper}
	        <tr>
		       <td width=15%>Name of exercise {$exercise_names_looper[i]}</td>
		       <td><input type=text name=workout_name{$exercise_names_looper[i]}></td>
	        </tr>
	        <tr>
		       <td width=15%>Number of sets for workout {$exercise_names_looper[i]}</td>
		       <td><input type=text name=number_sets_exercise{$exercise_names_looper[i]}></td>
	        </tr>
         {/section}
	        <tr>
		       <td><input type=submit name=submit value=Next> &nbsp; &nbsp; <input type=submit name=submit value=Quit></td>
	        </tr>
         </table>
         </form>
	{elseif $step eq 3}
         <form method=post action="enter_workout.php?step=4" >
         <table width=100% border=1>
                <tr bgcolor="#0099FF">
                    <td width=30%>Workout Name</td>
                    <td width=23%>Set Number</td>
                    <td width=23%>Reps</td>
                    <td width=23%>Weight</td>
                </tr>
                {section name=i loop=$workout_name}
                         {section name=j loop=$workout_name[i]}
                         <tr>
  	                          <td>{$workout_name[i].name}</td>
                              <td>Set number {$workout_name[i][j].set_number}<input type=hidden name=workout{$workout_name[i].number}set_number{$workout_name[i][j].set_number} value={$workout_name[i][j].set_number}></td>
	                          <td><input type=text name=workout{$workout_name[i].number}set{$workout_name[i][j].set_number}reps></td>
	                          <td><input type=text name=workout{$workout_name[i].number}set{$workout_name[i][j].set_number}weight></td>
                         </tr>
                         {/section}
                {/section}
                <tr>
                   <td><input type=submit name=submit value=Next> &nbsp; &nbsp; <input type=submit name=submit value=Quit></td
	               <td></td>
	               <td></td>
	               <td></td>
                </tr>
         </table>
         </form>
    {else}
         Incorrect step choice
    {/if}
{else}
	Please login <br />
    <a href=index.php>
{/if}

my goal is for the code i posted to make an array like this:

$workout_name = array( "Workout_name_1" = array( 1,
                                                 2,
                                                 3
                                                 );
                       "Wrokout_name_2" = array( 1,
                                                 2,
                                                 3,
                                                 4,
                                                 5
                                                 );

where workout_name_1 and workout_name_2 are the names the user picked on the previous form (i.e. Bench press, Incline press), and the arrays asssinged to each, are the set numbers.

The next from is gonna put an array into each set number for the amount of reps, and the weight used per set.