Moving From One Form to Another With PHP/MySQL

Airdog

Hello, might be a fairly simple (hopefully) solution but...

I've been looking for answers to this problem but I haven't been able to come up with something that works in my situation.

Basically what I want to do is have 4 pages linked in this order and function:

Page 1: Select two teams.

Page 2: Call up those two teams and their season stats. Input the desired values and go to;

Page 3: Call up the two teams' player rosters. Input the desired values and go to;

Page 4: Call up the two teams' goalie rosters. Input the desired values.

Keep in mind that it is updating multiple records each time (at least 2, and in the case of the player rosters, about 40). I can get them all to work independently, but I do not know how to link them all together.

Basically on page one you use an option list and pick two teams and store them as $Team1 and $Team2 to be used in the second form (<form method="GET" action="statsthrough1.php">)

The second page can get the two values just fine (I.e. Toronto and Boston) and display the relevant information.

Part of Page 2 (statsthrough1.php):

mysql_select_db ("xshocke_players",$db);
  $query="SELECT * FROM teams WHERE Team='$Team1' or Team='$Team2' ORDER BY Team";
  $result=mysql_query($query);
  echo "<center><h1> Team Stats Submission </h1></center>";
  if (mysql_num_rows($result) !=0) { 
    echo "<table width=90% align=center>\n";
    echo "<form method=POST>\n";
    echo "<tr><td>Team</td><td>W</td><td>L</td><td>T</td><td>OTL</td><td>GF</td><td>GA</td><td>Shots</td><td>Hits</td><td>PIM</td><td>PPG</td><td>PPA</td><td>PK</td><td>PKT</td></tr>\n";
    while ($r = mysql_fetch_array($result)) {
      $id = $r["id"];
      $Team = $r["Team"];
      $GP = $r["GP"];
      $Wins = $r["Wins"];
      $Losses = $r["Losses"];
      $Ties = $r["Ties"];
      $OTL = $r["OTL"];
      $GF = $r["GF"];
      $GA = $r["GA"];
      $Shots = $r["Shots"];
      $Hits = $r["Hits"];
      $PIM = $r["PIM"];
      $PPScored = $r["PPScored"];
      $PPAttempts = $r["PPAttempts"];
      $PKKilled = $r["PKKilled"];
      $PKTotal = $r["PKTotal"];


  echo "<input type=hidden name=yapp[$id] value='$id'>\n";
  echo "<tr><td><input type=text readonly name=yapp[$id][Team] value='$Team' size=20></td>\n";
  echo "<input type=hidden name=yapp[$id][GP] value='0' size=2>\n";
  echo "<td><input type=text name=yapp[$id][Wins] value='0' size=2></td>\n";
  echo "<td><input type=text name=yapp[$id][Losses] value='0' size=2></td>\n";
  echo "<td><input type=text name=yapp[$id][Ties] value='0' size=2></td>\n";
  echo "<td><input type=text name=yapp[$id][OTL] value='0' size=2></td>\n";
  echo "<td><input type=text name=yapp[$id][GF] value='0' size=3></td>\n";
  echo "<td><input type=text name=yapp[$id][GA] value='0' size=3></td>\n";
  echo "<td><input type=text name=yapp[$id][Shots] value='0' size=5></td>\n";
  echo "<td><input type=text name=yapp[$id][Hits] value='0' size=5></td>\n";
  echo "<td><input type=text name=yapp[$id][PIM] value='0' size=5></td>\n";
  echo "<td><input type=text name=yapp[$id][PPScored] value='0' size=3></td>\n";
  echo "<td><input type=text name=yapp[$id][PPAttempts] value='0' size=3></td>\n";
  echo "<td><input type=text name=yapp[$id][PKKilled] value='0' size=3></td>\n";
  echo "<td><input type=text name=yapp[$id][PKTotal] value='0' size=3></td>\n";


}
echo "<tr><td align=center colspan=15><input type=submit name=submit value=submit></td></tr>\n";
?>
    <?php
echo "</form>";    
echo "</table>";
  } else {
    echo "Couldn't fetch info from the db...";
  }
} else {

  $db=mysql_connect ("localhost", "xshocke_admin", "secret") or die ('I cannot connect to the database because: ' . mysql_error());
  mysql_select_db ("xshocke_players",$db);

  while (list ($key) = each ($HTTP_POST_VARS[yapp])) {  

    $query="UPDATE teams SET ";  

    foreach ($HTTP_POST_VARS[yapp][$key] as $key1 => $value1) {  

      if (!empty($value1)) {  

     //see if the $key1 variable is the correct column then
     //change the code to add the current value and the input value
     if (($key1=="GP")||($key1=="Wins")||($key1=="Losses")||($key1=="Ties")||($key1=="OTL")||($key1=="GF")||($key1=="GA")||($key1=="Shots")||($key1=="Hits")||($key1=="PIM")||($key1=="PPScored")||($key1=="PPAttempts")||($key1=="PKKilled")||($key1=="PKTotal")){
        $query.="$key1=$key1+$value1 ,";

        $query.="Points = (Wins * 2) + OTL + Ties, ";
        $query.="ShootingPct = round(GF / Shots,3), ";
        $query.="GAA = round(GA / GP,2), ";
        $query.="GFA = round(GF / GP,2), ";
        $query.="ShotsAvg = round(Shots / GP,2), ";
        $query.="HitsAvg = round(Hits / GP,2), ";
        $query.="PIMAvg = round(PIM / GP,2), ";

    }

    else{ 

        $query.="$key1='$value1', ";  
    }

   } 


}  
$query=substr($query, 0,-2);  
$query.=" WHERE id=$key";  

echo "$query <br>";
$result=mysql_query($query) or die (mysql_error());  

}

The other pages look much like page 2. And sorry about the big code blocks.

How can I get this to work together? Please help oh wise ones. Just doing a basic action="through3.php" doesn't work (it seems to skip ahead to the next page instead of going through the rest of the one it's already on).

python_q

This is more or less just a shot in the dark, but based off my experience of making a multiple-page form, you need to be absolutely sure to post every single relevant variable to the next page. By the last form, you should have a load of <input type="hidden" name="varname" value="$value"> before the final submit. I'd have to see the full code to see exactly why it is skipping the third page, but this might be the problem.

Drakla

Couldn't you just use sessions to store the data needed between pages?

Or are sessions out of the question?

Airdog

Python:

I think you're on the right track with what you're saying... I'll try and mess around with that.

Drak:

I'll be having to do a login/password system - so maybe sessions will be the best thing. Does it store everything in between, and will it make it easier for me? Can you wise me up to a decent sessions tutorial as there are many on the 'net but some seem to be a little to difficult etc. It would have to be one related to PHP/MySQL.

Thanks for all the help thus far.

Drakla

http://www.php.net/download-docs.php

First thing to do if you haven't done it is download the php manual in chm format and keep it ready to go at all times - basically the function reference is almost like a tutorial itself, especially with the user comments (they might only be in the extended version).

Just write yourself a few little session test scripts - these are the ones I did when I learnt them - they're laughable but you see how easy it is. Just put session_start() at the start of the script (needs to be done before any output as it grabs/creates the session cookie).

You put or get session vars with the $_SESSION superglobal, and then destroy the session when you're done.

session1.php

<?php
//Juming into sessions without actually looking I'll just create a form and
//see if the data is still alive in the pages that follow

if(isset($_REQUEST['name']) )
{
	session_start();
    $_SESSION['name']=$_REQUEST['name'];
	echo "Sessioning up your name - Go to next page now<br>";
	echo "(this is the same page as the last one ";
	echo "by the way, it just looks differently if you've submitted back to itself";
    ?>    

<p><br>
  <a href="session2.php">GO TO NEXT PAGE</a> 
  <?php
}
else
{
?>
</p>
<form name="form1" method="get" action="session1.php">
  <p>
    <input name="name" type="text" id="name">
    &nbsp; Enter your name and I'll allow you to carry it over to another session 
  </p>
  <p>
    <input type="submit" name="Submit" value="Submit">
  </p>
</form>
<p>&nbsp;</p>
<?php
}
?>

and session2.php

<?php
//this is now session2, so I'll get the data, calling session start retrieves the last stuff

session_start();;
//if(isset($_SESSION['name']))
if(session_is_registered("name"))	//same as above line, lady
{

print "This is Session 2 and your name is:";
$name=$_SESSION['name'];
print "<b>$name</b><br><br>";

echo "Reload this page and you'll get nowt because I've just destroyed the session<br>";
}
else
{
	print "There's no session data coming my way";
}
session_destroy();	//might as well do this, as the session is created even if one doesn't exist.
?>
<br>
<a href="session1.php">Back to First Page</a>

Airdog

OK drak,

So basically I'm gonna have to store all of these values and then in the last page do the SQL insert?

Airdog

I'm still having trouble with this issue - it's been on the backburner for awhile and I'm coming back to it now.

Anybody else have any tips for me, or something that could get me on the right track? Do I absolutely have to use sessions, or is there something easier?

If you require any more code or anything like that, I'd be more than happy to oblige - I just didn't want to flood this topic with five pages of code.