A really quick one...

FourthChapter

Just wondering, how do you delete a session for a logout script?

also how do i edit this:

		<?php
if( (!$usernameedit) or (!$passwordedit) )

{  }
else
{ $conn = @mysql_connect("host", "username", "password")
     or die("could not connect");
	$db = @mysql_select_db("database", $conn)
     or die("could not select database");
	$sql = "insert into table (username,password) values (\"$username\",password(\"$password\") )";
	$result = @mysql_query($sql,$conn)
		 or die("could not execute query");
	if($result) { echo("Password for $username changed");
}
}
?>

so it changes the value password, and doesnt add a new user?

Thanks Very Much

Matt

benbox

for logging out:

<?
session_start() ; // if not already (you need this to logout)
session_unregister("username") ;
session_unregister("password") ;

// you can also do this to unset the 'now normal' (after unregistering session vars)..
unset($username) ;
unset($password) ;

FourthChapter

lol ok, i kinda screwed mine up abit:

How do i add the session vars

$ip, $username, $password, $now

to the session?

DO i need to start a new session on each page?

Thanks v much (soz im a kinda newb to sessions)

Matt

benbox

hi,

yes you need to start the session on every page... one thing to need to note is that it needs to be at the very top of the page above any other code...

i.e.

<?
session_start() ;

//page content....

?>

to set variables in a session:

<?
session_start() ;

$username = "whatever" ;
session_register("username") ;
$password = "whatever" ;
session_register("password") ;
?>

when you are setting a session variable it doesnt have to be at the top of the file, it can be anywhere, unlike session_start() ;

FourthChapter

Thanks very much!

does any one know about how to delete rows in a table?

and seperatly

to delete values in a row?

Thanks Very Much

Matt

Weedpacket

You need to use session_start() on every page you use sessions.

After that, the easiest way to add a session variable is to go

$_SESSION['[i]variable_name[/i]'] = "some value";

to use it:

echo $_SESSION['[i]variable_name[/i]'];

and to destroy it:

$_SESSION['[i]variable_name[/i]']=null;

...but most of this is covered in the PHP manual's chapter on sessions, along where [man]session_destroy[/man] is also mentioned, so I guess you must already know it.

benbox

oh yeah forgot bout session_destroy() ... use this after unsetting all the vars etc when logging out...

do delete rows , do something like this:

<?
mysql_query("DELETE * FROM tablename WHERE field = 'something' ") ;

// and to update/delete
mysql_query("UPDATE tablename SET field = null WHERE field = 'whatever'")  ;
// or you could set it as '' (i.e. nothing between the '')

FourthChapter

What im tryin to do is create a logout.php script that will delete the PHP_SESSID from the SQL Database (in the colum 'seid') of the user (in colum 'username') that is logging out.

Sent to logout.php are the variables:

logout.php?username=Bob&PHPSESSID=653fe3072a0caac07da826225e9ec8fb

so when logout.php is selected, i want it to delete the value for PHPSESSID (from the colum 'seid') for the username that is with it.

How do i do this? sorry for my poor language lol!

Thanks Very Much

Matt

benbox

if you havent set the phpsessid field to not null...

mysql_query("UPDATE tablename SET PHPSESSID = null WHERE username = '$username' ") ;

FourthChapter

So this is my entire logout.php script

<?php
if( (!$usn) or (!$PHPSESSID) )

{
echo ("logout failed");
}
else
{ $conn = @mysql_connect("host", "username", "password")
     or die("could not connect");
	$db = @mysql_select_db("database", $conn)
     or die("could not select database");
	$sql = "UPDATE tablename SET seid = null WHERE username = '$usn' ") )";                //THIS LINE
	$result = @mysql_query($sql,$conn)
		 or die("could not execute query");
	if($result) { echo("Logged Out!");
}
}
?>

theres an error on line 12????

any ideas?

Thanks very much

Matt

Weedpacket

Look at the syntax highlighting on that line.

what's ") )"; supposed to be? Just "; I presume...