how to completely end sessions..

i do having this problems.. once log out the data from database still come out but the table structure already invisible..

how to completely disconnect from database when session end..

Expand|Select|Wrap|Line Numbers

 <?php
 
define('INCLUDE_CHECK',true);
 
require 'connect.php';

require 'functions.php';

// Those two files can be included only if INCLUDE_CHECK is defined
 
// select record from mysql 

$sql="SELECT * FROM $tbl_name";

$result=mysql_query($sql);
 
session_name('Login');

session_set_cookie_params(2*7*24*60*60);

session_start();
 
?>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
 
<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Administrator Control Panel only!</title>
 
    <link rel="stylesheet" type="text/css" href="demo.css" media="screen" />
 
</head>
 
<body>
 
<div id="main">

  <div class="container">

    <h1>Registered Administrator Only!</h1>

    <h2>Login to view this resource!</h2>

    </div>
 
    <div class="container">

<?php

    if($_SESSION['id'])

    echo '
 
<table width="100%" border="0" cellspacing="1" cellpadding="0">

<tr>

<td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">

<tr>
 
<td colspan="8" bgcolor="#FFC600"><strong><center>Delete Temporary User & Password Here!</center></strong> </td>

</tr>

<tr>

<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>

<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>

<td align="center" bgcolor="#FFFFFF"><strong>Pass</strong></td>

<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>

<td align="center" bgcolor="#FFFFFF"><strong>IP Address</strong></td>

<td align="center" bgcolor="#FFFFFF"><strong>Date</strong></td>

<td align="center" bgcolor="#FFFFFF">&nbsp;</td>

<td align="center" bgcolor="#FFFFFF">&nbsp;</td>

</tr>';

    else echo '<h1>Unauthorize Area</h1>';

    ?>
 
<?php

while($rows=mysql_fetch_array($result)){

?>

<tr>

<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>

<td bgcolor="#FFFFFF"><? echo $rows['usr']; ?></td>

<td bgcolor="#FFFFFF"><? echo $rows['pass']; ?></td>

<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>

<td bgcolor="#FFFFFF"><? echo $rows['regIP']; ?></td>

<td bgcolor="#FFFFFF"><? echo $rows['dt']; ?></td>

<td bgcolor="#FFFFFF"><a href="update.php?id=<? echo $rows['id']; ?>">update</a></td>

<td bgcolor="#FFFFFF"><a href="delete_ac.php?id=<? echo $rows['id']; ?>"><font color="#FF0000">delete</font></a></td>

</tr>
 
<?
 
// close while loop 

}
 
// close connection; 

mysql_close();
 
?> 

</table></td>

</tr>

</table>
 
</div>
 
</body>

</html>

thank you...

Oct 7 '10 #1

Subscribe Post Reply

1658

dlite922

1,584

Expert 1GB

Where do you log out? Where's the code that destroys the session?

I don't understand what session has to do with the database.

You can destroy a variable using unset() if you like.

mysql_close() will close the connection, It won't get rid of the data you have already put in to a variable, like $result.

Dan

Oct 7 '10 #2

bulp

Thank You Dan for the response.. :)

my bad.. sorry this is the login and log out code..

Expand|Select|Wrap|Line Numbers

 <?php
 
define('INCLUDE_CHECK',true);
 
require 'connect.php';

require 'functions.php';

// Those two files can be included only if INCLUDE_CHECK is defined
 
session_name('Login');

// Starting the session
 
session_set_cookie_params(2*7*24*60*60);

// Making the cookie live for 2 weeks
 
session_start();
 
if($_SESSION['id'] && !isset($_COOKIE['Remember']) && !$_SESSION['rememberMe'])

{

    // If you are logged in, but you don't have the Remember cookie (browser restart)

    // and you have not checked the rememberMe checkbox:
 
    $_SESSION = array();

    session_destroy();
 
    // Destroy the session

}
 
if(isset($_GET['logoff']))

{

    $_SESSION = array();

    session_destroy();
 
    header("Location: index.php");

    exit;

}

should i create the logout button into the data page that i paste earlier ?

Oct 7 '10 #3

rythmic

Hi!

Here is the problem. You check whether a user is logged in or not, but no matter the response you still echo the table data.

Echoing the table data should also be constrained by the if($_SESSION['id']) statement

Your code should look like this:

Expand|Select|Wrap|Line Numbers

  
 <?php
 
    define('INCLUDE_CHECK',true);
 
    require 'connect.php';

    require 'functions.php';

    // Those two files can be included only if INCLUDE_CHECK is defined
 
    // select record from mysql 

   $sql="SELECT * FROM $tbl_name";

   $result=mysql_query($sql);
 
   session_name('Login');

   session_set_cookie_params(2*7*24*60*60);

   session_start();
 
   ?>
 
   <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

   <html xmlns="http://www.w3.org/1999/xhtml">
 
   <head>

   <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

   <title>Administrator Control Panel only!</title>
 
       <link rel="stylesheet" type="text/css" href="demo.css" media="screen" />
 
   </head>
 
   <body>
 
   <div id="main">

     <div class="container">

       <h1>Registered Administrator Only!</h1>

       <h2>Login to view this resource!</h2>

       </div>
 
       <div class="container">

   <?php

       if($_SESSION['id'])

       echo '
 
   <table width="100%" border="0" cellspacing="1" cellpadding="0">

   <tr>

   <td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">

   <tr>
 
   <td colspan="8" bgcolor="#FFC600"><strong><center>Delete Temporary User & Password Here!</center></strong> </td>

   </tr>

   <tr>

   <td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>

   <td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>

   <td align="center" bgcolor="#FFFFFF"><strong>Pass</strong></td>

   <td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>

   <td align="center" bgcolor="#FFFFFF"><strong>IP Address</strong></td>

   <td align="center" bgcolor="#FFFFFF"><strong>Date</strong></td>

   <td align="center" bgcolor="#FFFFFF">&nbsp;</td>

   <td align="center" bgcolor="#FFFFFF">&nbsp;</td>

   </tr>';

       else echo '<h1>Unauthorize Area</h1>';

       ?>
 
   <?php

   if($_SESSION['id']){ // you can put it here to not execute the while loop at all for non-logged in users

   while($rows=mysql_fetch_array($result)){

   ?>

   <tr>

   <td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>

   <td bgcolor="#FFFFFF"><? echo $rows['usr']; ?></td>

   <td bgcolor="#FFFFFF"><? echo $rows['pass']; ?></td>

   <td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>

   <td bgcolor="#FFFFFF"><? echo $rows['regIP']; ?></td>

   <td bgcolor="#FFFFFF"><? echo $rows['dt']; ?></td>

   <td bgcolor="#FFFFFF"><a href="update.php?id=<? echo $rows['id']; ?>">update</a></td>

   <td bgcolor="#FFFFFF"><a href="delete_ac.php?id=<? echo $rows['id']; ?>"><font color="#FF0000">delete</font></a></td>

   </tr>
 
   <?
 
   // close while loop 

   }

   // Rythmic input!!!: end if-statement

   } // here you could include an else statment if you want something displayed to non-logged in users
 
   // close connection; 

   mysql_close();
 
   ?> 

  </table></td>

  </tr>

  </table>
 
   </div>
 
   </body>

 </html>

as a side note maybe you should also consider a stronger check than just checking that an id exists to determine whether a user may view your resource or not.

Oct 10 '10 #4

bulp

rythmic...

thanks for the response but ur code seems totally block the access to data.. i mean even when im log in.. the data didnt show at all..

Oct 21 '10 #5

by: Yoyoma_2 | last post by:

Hello, i'me having a wierd problems with sessions. PHP 4.3.3, Register globals is on, and the sessions module is installed. if i have a page like this: <? session_start(); $_SESSION="blue";...

PHP

How to differentiate multiple sessions?

by: jing_li | last post by:

Hi, you all, I am a newbee for php and I need your help. One of my coworker and I are both developing a webpage for our project using php. We have a copy of the same files in different location...

PHP

Now you see it, now you don't sessions

by: Eagleprof | last post by:

Hi, This one has me completely stumped. I have a simple site where I'm using sessions to keep track of some information across multiple pages. The trouble is, when I go to a page that displays...

PHP

trouble with arrays + sessions

by: LMachado1 | last post by:

I just started with php and I'm trying to make a simple interface as follows: - user is asked to input an integers, for example: how many students do you want to enter? - user is then shown a...

PHP

Tabbed browsing and sessions

by: Peter Chant | last post by:

Am I right in assuming that when I connect from one browser, using several tabs to a database produced in mysql/php/apache only uses one session for all tabs? I have been loosing records from my...

PHP

Sessions randomly lost using state server

by: AndersBj | last post by:

Hi all, I have a web application that uses State Server for session handling. The web application randomly loses all session variables. The sessions are not always lost, sometimes I can use the...

ASP.NET

PHP sessions - user login webpage - preventing autologout due to inactivity

by: Dave Smithz | last post by:

Hi there, I have a website where users can log into. This users sessions as I believe most people use when implementing a login section of a website (each php page first checks a valid parameter...

PHP

URL masking when using PHP sessions.

by: news | last post by:

We have a huge PHP e-commerce site that relies totally on PHP sessions and cookies. We need to create a demo version of the site for potential clients to use that does NOT show the original URL in...

PHP

Lost sessions issue

by: AlonR | last post by:

Hi, We're experiencing random user sessions losses on our web applications, and are researching for any useful information which may shed light on this problem. Environment: In our...

.NET Framework

sessions

by: Jon Slaughter | last post by:

Any pitfalls or stuff I need to worry about when working with sessions? I want to write a log file and hit counter along with a login interface and I'm trying to learn this stuff. ...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

how to completely end sessions..

Similar topics