Re: Queries close session

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Adept-Hosting.Net Administration wrote:
I am using the following script to maintain a login session on some
pages:

<?php
session_start();
if(empty($_SESSION['username'])) {
die('An error has ocurred. It may be that you have not
logged in,
or that your session has expired.
Please try <a href="index.php">logging in</a> again or contact the <a href="mailto:email@address";>system
administrator</a>');
}
?>


The sessions are stable and work fine EXCEPT when I run another PHP
script on the web page such as:

the script below does not call session_start()- you must call session_start() on each request that you need the session data, normally people put all their session check/start-up stuff in a seperate file and then include that when needed:

<?

require "db_connect.inc";
require "session.inc";

// do you queries and output the results etc!



<?php // Make a MySQL Connection require "db_connect.inc";

// Retrieve all the data from the "example" table
$result = mysql_query("SELECT * FROM members WHERE Status='Inactive'") or die(mysql_error());


echo "<table border='1' cellpadding='0' cellspacing='1'
align='center'>";
echo "<tr> <th>Certificate #</th><th>Dan rank</th><th>First Name</th>
<th>Last Name</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; echo $row['Cert_number'];
echo "</td><td>"; echo $row['Dan_rank'];
echo "</td><td>"; echo $row['First'];
echo "</td><td>"; echo $row['Last'];
echo "</td></tr>"; } echo "</table>";


?>

I'm assuming that I am either not maintaining the session properly or
not linking the scripts to the session.

Any pointers on how to accomplish what I'm trying to do?

Thanks,

- Ken


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux