PHP sessions

SiKing · Sep 5, 2005

Hey again. Encountered new problem. Name: sessions. I've tried Google and it led me to about 4 (in total) tutorials. About 2 of which looked as if they were typed by 5 year olds and the other 2 were the opposite. Trying to sound very technological and not speaking a language I understand (in more ways than one) because they were using pear and I need MySql.

Anyway. I basically have a database named 'users' with usernames, passwords, emails, etc. I also have a registration form and a login form which work perfectly. However, I need to introduce 'sessions' and it isn't going to well. I've been told to include 'session_start()' but not one tutorial told me WHERE to put this but still. I want the user to stay 'logged in' and to have their own profile.

Sorry, I've had no sleep and I'm very frustrated with time wasting tutorials but I know I can rely on you lot to help me out and cheer me up. Thanks

user-7256 · Sep 5, 2005

Put it first thing in each page...

<?php

session_start();

//rest of your code here

?>

Make sure it comes first for each page that you use sessions.

SiKing · Sep 5, 2005

Thanks. Do sites like ebay use cookies or sessions (or both)?

aween · Sep 5, 2005

miseria said:
Thanks. Do sites like ebay use cookies or sessions (or both)?

ebay uses cookies, passwords are in MD5();

SiKing · Sep 5, 2005

Oh right. I think I'll stick with sessions anyway. When do I declare the session (if that makes sense)? I have the following

PHP:

$login_check = mysql_num_rows($sql);
if ($login_check == "1") {
include ("membersarea.php");
}

would it be...

PHP:

$login_check = mysql_num_rows($sql);
if ($login_check == "1") {
?SESSION STUFF HERE?
include ("membersarea.php");
}

user-7256 · Sep 5, 2005

As long as session_start() goes before any other headers are sent, then it will work.

To be safe, just put session_start() at the beginning of your PHP in each file that uses sessions.

aween · Sep 5, 2005

PHP:

<?php
session_start();
if(isset($_POST['submit'])) {

// check from database

$login_check = mysql_num_rows($sql); 
if ($login_check == "1") { 
header("Location: members.php");
} else {
header("Location: error.php?e=1234");
}
}

and error.php ?e=1234 redirects it to the badd password as example

SiKing · Sep 5, 2005

Thanks a lot peoples. How do I relate a session to MySQL if it's possible. So that when someone signs in with the session and are redirected to the member's page, is it possible to display their information from the database?

EDIT: Could I use queries with the username they signed in with?

aween · Sep 5, 2005

PHP:

<?php
session_start();
if (isset($_SESSION['username']) && isset($_SESSION['password'])) {
	$password = $_SESSION['password'];
	$username = $_SESSION['username'];
	//
	$query="SELECT * FROM users WHERE username='$usenrame'";
	$sql = mysql_query($query)or die(msql_error());
	$obj = mysql_fetch_object($sql);
	$email = $obj->email;
	$member_id = $obj->id;
	$member_name = $obj->username;
	//
	}
	if (!isset($_SESSION['username']) or !isset($_SESSION['password'])) {
	header("Location : http://namepros.com");
	}
}
?>

name it what ever you want, and include it in all members pages
and then you echo the information from the database like this:

example :

PHP:

echo $email;

SiKing · Sep 5, 2005

Thank you so much

PHP sessions

Registered MemberEstablished Member

VIP Member

Registered MemberEstablished Member

Pro Coder & DesignerVIP Member

Registered MemberEstablished Member

VIP Member

Pro Coder & DesignerVIP Member

Registered MemberEstablished Member

Pro Coder & DesignerVIP Member

Registered MemberEstablished Member

BlackWatch.org

superavia.com

ordinalsworld.xyz

mpjj.com

EESApp.info

AlKhawaneej.io

trygin.com

subsidiary.co.uk

Enfinity.org

DowCoin.com

Similar threads

We're social

BlackWatch.org

superavia.com

ordinalsworld.xyz

mpjj.com

EESApp.info

AlKhawaneej.io

trygin.com

subsidiary.co.uk

Enfinity.org

DowCoin.com

Pinned

Appreciation

Agreement

Answers

Relevance

Reaction

Status

Feeling