Re: Queries close session

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

 



Because the session you are using probably uses a cookie to remember
the session, it is required that you call session_start before you
output anything to the screen(aka: send any headers). So if you place
the session start at the very top of your page before you include any
files or output anything, the session should work.  Beware of any
whitespace before the <?php  tags because that will also send headers.

Calvin

On Mon, 14 Mar 2005 14:55:53 -0700, Adept-Hosting.Net Administration
<admin@xxxxxxxxxxxxxxxxx> 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:
> 
> <?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
> 
>

-- 
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