DaniWeb Forum Index > Web Development > PHP

PHP Sessions

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2008

Posts: 117

Reputation: u8sand is on a distinguished road

Solved Threads: 15

u8sand

Offline

Junior Poster

PHP Sessions

19 Days Ago

Hello guys,
I'm creating my own website-it's coming along very well but I'm stuck. There is a login, so that you can login to your account. Each account has an access of 1-10, if your access is 0 you are not logged in. When you put your username and password it checks all of the accounts in the mySQL database. That all works fine, but along with this is a forum, if you are logged in you can post ext.. in the forum, if your not logged in you can only view it. I made it so you can view it but how would i have a variable that worked through all the pages in my website so the forum could say do they have an access of greater than 0?
So i thought... Sessions

My default.php runs includes the different things which include each other and it all works out so that its always "technically" on default.php.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
// Start the session
session_start();
$_SESSION['Username'] = "";
$_SESSION['Access'] = 0;
?>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Website</title>
</head>
<body>
<table width="100%" height="100%" border="0">
<tr height="1%">
<td>
<?php require "menubar.php"; ?>
</td>
</tr>
<tr height="10%">
<td>
<?php require "logo.php"; ?>
</td>
</tr>
<tr valign="top">
<td>
<?php require "main.php"; ?>
</td>
</tr>
</table>
</body>
</html>
<?php
// Start the session
session_start();
$_SESSION['Username'] = "";
$_SESSION['Access'] = 0;
?>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Website</title>
</head>
<body>
<table width="100%" height="100%" border="0">
<tr height="1%">
<td>
<?php require "menubar.php"; ?>
</td>
</tr>
<tr height="10%">
<td>
<?php require "logo.php"; ?>
</td>
</tr>
<tr valign="top">
<td>
<?php require "main.php"; ?>
</td>
</tr>
</table>
</body>
</html>

I'm not sure if I just don't know how to use Session variables or I'm using them wrong.

here is login.php

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<html>
<body>
<?php
if(strlen($_POST['user']) == 0 || strlen($_POST['pass']) == 0)
{
    echo "
    <center>
    <form action=\"?page=Login\" method=\"post\">
    <table border=\"0\" width=\"75%\">
    <tr>
    <td>
    Username: 
    </td>
    <td>
    <input type=\"text\" name=\"user\" />
    </td>
    </tr>
    <tr>
    <td>
    Password: 
    </td>
    <td>
    <input type=\"password\" name=\"pass\" />
    </td>
    </tr>
    <tr>
    <td>
    <input type=\"submit\" value=\"Login\" />
    <td>
    </tr>
    </table>
    </form>
    </center>
    ";
}
else
{
    $mysql_host = "";
    $mysql_database = "";
    $mysql_user = "";
    $mysql_password = "";
 
    $con = mysql_connect($mysql_host,$mysql_user,$mysql_password);
    if(!$con)
    {
        die('Could not connect: ' . mysql_error());
    }
 
    mysql_select_db($mysql_database,$con);
 
    $result = mysql_query("SELECT * FROM Accounts");
    while($row = mysql_fetch_array($result))
    {
        if($row['Username'] == $_POST['user'] && $row['Password'] == $_POST['pass'])
        {
             $_SESSION['Username'] = $row['Username'];
             $_SESSION['Access'] = $row['Access'];
             echo "<a href=?page=UserCP>You have successfully logged in click here to access User CP.</a>";
        }
    }
}
?>
</body>
</html>
<html>
<body>
<?php
if(strlen($_POST['user']) == 0 || strlen($_POST['pass']) == 0)
{
    echo "
    <center>
    <form action=\"?page=Login\" method=\"post\">
    <table border=\"0\" width=\"75%\">
    <tr>
    <td>
    Username: 
    </td>
    <td>
    <input type=\"text\" name=\"user\" />
    </td>
    </tr>
    <tr>
    <td>
    Password: 
    </td>
    <td>
    <input type=\"password\" name=\"pass\" />
    </td>
    </tr>
    <tr>
    <td>
    <input type=\"submit\" value=\"Login\" />
    <td>
    </tr>
    </table>
    </form>
    </center>
    ";
}
else
{
    $mysql_host = "";
    $mysql_database = "";
    $mysql_user = "";
    $mysql_password = "";

    $con = mysql_connect($mysql_host,$mysql_user,$mysql_password);
    if(!$con)
    {
        die('Could not connect: ' . mysql_error());
    }
    
    mysql_select_db($mysql_database,$con);

    $result = mysql_query("SELECT * FROM Accounts");
    while($row = mysql_fetch_array($result))
    {
        if($row['Username'] == $_POST['user'] && $row['Password'] == $_POST['pass'])
        {
             $_SESSION['Username'] = $row['Username'];
             $_SESSION['Access'] = $row['Access'];
             echo "<a href=?page=UserCP>You have successfully logged in click here to access User CP.</a>";
        }
    }
}
?>
</body>
</html>

Thanks and i hope you guys can help me..

•

Join Date: Sep 2007

Posts: 1,448

Reputation: cwarn23 has a spectacular aura about

Solved Threads: 135

cwarn23

Offline

Nearly a Posting Virtuoso

18 Days Ago

Try making this default.php

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
// Start the session
session_start();
if (empty($_SESSION['Username']) || !isset($_SESSION['Username'])) {
    $_SESSION['Username'] = "";
    $_SESSION['Access'] = 0;
    }
?>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Website</title>
</head>
<body>
<table width="100%" height="100%" border="0">
<tr height="1%">
<td>
<?php require "menubar.php"; ?>
</td>
</tr>
<tr height="10%">
<td>
<?php require "logo.php"; ?>
</td>
</tr>
<tr valign="top">
<td>
<?php require "main.php"; ?>
</td>
</tr>
</table>
</body>
</html>
<?php
// Start the session
session_start();
if (empty($_SESSION['Username']) || !isset($_SESSION['Username'])) {
    $_SESSION['Username'] = "";
    $_SESSION['Access'] = 0;
    }
?>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Website</title>
</head>
<body>
<table width="100%" height="100%" border="0">
<tr height="1%">
<td>
<?php require "menubar.php"; ?>
</td>
</tr>
<tr height="10%">
<td>
<?php require "logo.php"; ?>
</td>
</tr>
<tr valign="top">
<td>
<?php require "main.php"; ?>
</td>
</tr>
</table>
</body>
</html>

And this login.php

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
session_start();
?><html>
<body>
<?php
if(strlen($_POST['user']) == 0 || strlen($_POST['pass']) == 0)
{
    echo "
    <center>
    <form action=\"?page=Login\" method=\"post\">
    <table border=\"0\" width=\"75%\">
    <tr>
    <td>
    Username: 
    </td>
    <td>
    <input type=\"text\" name=\"user\" />
    </td>
    </tr>
    <tr>
    <td>
    Password: 
    </td>
    <td>
    <input type=\"password\" name=\"pass\" />
    </td>
    </tr>
    <tr>
    <td>
    <input type=\"submit\" value=\"Login\" />
    <td>
    </tr>
    </table>
    </form>
    </center>
    ";
}
else
{
    $mysql_host = "";
    $mysql_database = "";
    $mysql_user = "";
    $mysql_password = "";
 
    $con = mysql_connect($mysql_host,$mysql_user,$mysql_password);
    if(!$con)
    {
        die('Could not connect: ' . mysql_error());
    }
 
    mysql_select_db($mysql_database,$con);
 
    $result = mysql_query("SELECT * FROM Accounts");
    while($row = mysql_fetch_array($result))
    {
        if($row['Username'] == $_POST['user'] && $row['Password'] == $_POST['pass'])
        {
             $_SESSION['Username'] = $row['Username'];
             $_SESSION['Access'] = $row['Access'];
             echo "<a href=?page=UserCP>You have successfully logged in click here to access User CP.</a>";
        }
    }
}
?>
</body>
</html>
<?php
session_start();
?><html>
<body>
<?php
if(strlen($_POST['user']) == 0 || strlen($_POST['pass']) == 0)
{
    echo "
    <center>
    <form action=\"?page=Login\" method=\"post\">
    <table border=\"0\" width=\"75%\">
    <tr>
    <td>
    Username: 
    </td>
    <td>
    <input type=\"text\" name=\"user\" />
    </td>
    </tr>
    <tr>
    <td>
    Password: 
    </td>
    <td>
    <input type=\"password\" name=\"pass\" />
    </td>
    </tr>
    <tr>
    <td>
    <input type=\"submit\" value=\"Login\" />
    <td>
    </tr>
    </table>
    </form>
    </center>
    ";
}
else
{
    $mysql_host = "";
    $mysql_database = "";
    $mysql_user = "";
    $mysql_password = "";

    $con = mysql_connect($mysql_host,$mysql_user,$mysql_password);
    if(!$con)
    {
        die('Could not connect: ' . mysql_error());
    }
    
    mysql_select_db($mysql_database,$con);

    $result = mysql_query("SELECT * FROM Accounts");
    while($row = mysql_fetch_array($result))
    {
        if($row['Username'] == $_POST['user'] && $row['Password'] == $_POST['pass'])
        {
             $_SESSION['Username'] = $row['Username'];
             $_SESSION['Access'] = $row['Access'];
             echo "<a href=?page=UserCP>You have successfully logged in click here to access User CP.</a>";
        }
    }
}
?>
</body>
</html>

I will have to macgyver a login tutorial which reminds me I need to upload that other video tutorial tonight. Hope that helps.

Try not to bump 10 year old threads as it can be really annoying.
Like php then read my website at http://syntax.cwarn23.net/
Star-Trek-Atlantis - now that's what I call a movie ^_^
My favourite PC. - MacGyver Fan
Bad english note: dis-iz-2b4u

•

Join Date: Dec 2008

Posts: 117

Reputation: u8sand is on a distinguished road

Solved Threads: 15

u8sand

Offline

Junior Poster

18 Days Ago

worked tyvm, so i knew how to do it but i had to include the session start over every page that uses the session. Thanks.

•

Join Date: Oct 2009

Posts: 141

Reputation: venkat0904 is an unknown quantity at this point

Solved Threads: 14

venkat0904 venkat0904 is online now

Online

Junior Poster

18 Days Ago

ohhh that ws a silly mistake... i didnt notice it at all when i read ur code fr 1st time.. gud job cwarn !!!

•

Originally Posted by u8sand

worked tyvm, so i knew how to do it but i had to include the session start over every page that uses the session. Thanks.

Gimme reputation points if u find my post helpful.
use [code] tags wherever applicable
dont start a new thread unless u cant find the topic already on forum.
mark a thread "solved" as soon as u get a solution