tlavelle Posted September 7, 2007 Share Posted September 7, 2007 This file has 3 forms in it. Form 1 - presents to all users. Users select a year and submit Form 2 - Is conditional. It only shows if users choose the value '2007' Form 3 - Should present to all users For whatever reason, my session variable for year seems to get lost after a user who selects 2007 in the first form submits the second form. Help? <?php //initialize session session_start(); ?> <html> <head> <basefont face="Arial"> </head> <body> <?php // set server access variables $host = "localhost"; $user = "root"; $pass = ""; $db = "wercbench"; // open connection $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); // select database mysql_select_db($db) or die ("Unable to select database!"); // create form 1 queries $year_query = "SELECT distinct year FROM bench_data"; // execute form 1 queries $year_result = mysql_query($year_query) or die ("Error in query: $query. ".mysql_error()); // grab distinct years from db and stick them in the drop down if (mysql_num_rows($year_result) > 0){ if (!isset($_POST['wercbench1']) and !isset($_POST['year']) || !isset($_POST['wercbench2']) and !isset($_POST['year'])) { echo"<form method=\"POST\" action=\"". $_SERVER['PHP_SELF']. "\" name=\"wercbench1\">"; echo"<table style=\"width: 300;\" border=\"1\" cellpadding=\"2\" cellspacing=\"2\">"; echo"<tbody>"; echo" <tr>"; echo" <td>Select the comparison year and then click next"; echo" </td>"; echo" <td></td>"; echo" </tr>"; echo" <tr>"; echo" <td>"; echo" <select name=\"year\">"; while($row = mysql_fetch_row($year_result)) { echo"<option value=\"" .$row[0]. "\">".$row[0]."</option>"; } echo" </select>"; echo" </td>"; echo" <td></td>"; echo" </tr><tr>"; echo" <td><input type=\"Submit\" value=\"Next\" name=\"wercbench1_next\"></button></td>"; echo" </tr>"; echo" </form>"; } $_SESSION['sess_year']=$_POST['year']; echo $_SESSION['sess_year']; //if 2005 is selected just show the data if(isset($_POST['wercbench1_next']) && ($_SESSION['sess_year']!='2005')){ $industry_result = mysql_query("SELECT distinct comp_desc FROM comp_desc") or die(mysql_error()); echo" <tr>"; echo"<form method=\"POST\" action=\"". $_SERVER['PHP_SELF']. "\" name=\"wercbench2\">"; echo" <td>"; echo" <select name=\"industry\">"; while($row = mysql_fetch_row($industry_result)) { echo"<option value=\"" .$row[0]. "\">".$row[0]."</option>"; } echo" </select>"; echo"</td>"; echo" <td></td>"; echo" </tr>"; echo" <tr>"; echo" <td><input type=\"Submit\" value=\"Next\" name=\"wercbench2_next\"></button></td>"; echo" <td></td>"; echo" </tr>"; echo"</tbody>"; echo"</table>"; echo"</form>"; } $_SESSION['sess_industry']=$_POST['industry']; } else { // no // print status message echo "No rows found!"; } if( (isset($_POST['wercbench2_next']) and ($_SESSION['sess_year']=='2007')) or (isset($_POST['wercbench1_next']) and ($_SESSION['sess_year']=='2005')) ) { $useryear=$_SESSION['sess_year']; //$_SESSION['sess_year']=$_POST['year']; $userindustry=$_SESSION['sess_industry']; //$_SESSION['sess_ind']=$_POST['industry']; $metric_query = "SELECT metric_desc.met_desc, bench_data.median, bench_data.best_pract FROM metric_desc, bench_data where metric_desc.met_key=bench_data.met_key and $useryear=bench_data.year"; $metric_result = mysql_query($metric_query) or die ("Error in query: $query. ".mysql_error()); echo $_SESSION['sess_year']; echo $_SESSION['sess_industry']; echo "<form action=\"results.php\" method=\"post\" name\"wercbench3\">"; echo "<table cellpadding=10 border=1>"; echo "<tr>"; echo "<td>Metric Description</td>"; echo "<td>Average</td>"; echo "<td>Best Practice</td>"; echo "<td>Enter your value here</td>"; echo "</tr>"; while($row = mysql_fetch_row($metric_result)) { echo "<tr>"; echo "<td>".$row[0]."</td>"; echo "<td>" . $row[1]."</td>"; echo "<td>".$row[2]."</td>"; echo "<td><input type=\"text\" name=\"myvalue[]\" value=\"\" /></td>"; echo "</tr>"; } echo "<tr><td colspan=\"3\"> </td><td align=\"center\"><input type=\"submit\" name=\"wercbench3\" value=\"Compare\"></td></tr></table>"; //} // free result set memory mysql_free_result($year_result); //mysql_free_result($industry_result); mysql_free_result($metric_result); //mysql_free_result($metric_result); } // close connection mysql_close($connection); ?> </body> </html> Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted September 7, 2007 Share Posted September 7, 2007 $_SESSION['sess_year']=$_POST['year'] will happen every time the code is run. If you aren't POSTing 'year', then $_POST['year'] == "" and therefore $_SESSION['sess_year'] == "" Quote Link to comment Share on other sites More sharing options...
tlavelle Posted September 7, 2007 Author Share Posted September 7, 2007 Thanks I stuck this in if(isset($_POST['wercbench1_next'])){ $_SESSION['sess_year']=$_POST['year']; echo $_SESSION['sess_year']; } Seemed to fix it Sound correct? Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted September 7, 2007 Share Posted September 7, 2007 that's better. you want to make sure you got POST'ed info. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.