Menu
Community /Pin to ProfileBookmark
@NogDogNov 13.2009 — #string literals in SQL need to be quoted (just like they do in PHP):
I won't guarantee there aren't other problems, that's just the first thing that jumped out at me. You may want to check if the return value from mysql_query() is false, and if it is, error_log() or user_error() the query and the output from mysql_error() to find out what's wrong.@NogDogNov 13.2009 — #Forget the session_register() stuff and just use the $_SESSION array.
If you do a redirect via a PHP header() call, you may need to ensure that the session data is stored:
Not understanding sessions
Hi. I am trying to develop a auto-populated form based in a login script. I got the login authentication to work but when I redirect to new page with form I am unable to get the variables I need to query. I’m a PHP newbie, please help me understand what I’m doing wrong.
[CODE]<?php
session_start();
if(!session_is_registered(myusername)){
header(“location:main_login.php”);
}
//connect to server & db
// username and password sent from form
$myusername=$_SESSION[‘myusername’];
$mypassword=$_SESSION[‘mypassword’];
$sql=”SELECT * FROM $tbl_name WHERE username= $myusername “;
$result=mysql_query($sql);
$login_check = mysql_num_rows($result);
if ($login_check > 0){
extract(mysql_fetch_array($result));
$_SESSION[‘Company’] = $Company;
$_SESSION[‘FName’] = $FName;
$_SESSION[‘LName’] = $LName;
$_SESSION[‘Email’] = $Email;
}
else
{
echo(“Not Working!”);
}
?>
[CODE]
Thanks!:)
Sign in
to post a comment8 Comments(s) ↴
0
@NogDogNov 13.2009 — #string literals in SQL need to be quoted (just like they do in PHP):[code=php]
$sql="SELECT * FROM $tbl_name WHERE username= '$myusername' ";
[/code]I won't guarantee there aren't other problems, that's just the first thing that jumped out at me. You may want to check if the return value from mysql_query() is false, and if it is, error_log() or user_error() the query and the output from mysql_error() to find out what's wrong.
0
@NogDogNov 13.2009 — #Forget the session_register() stuff and just use the $_SESSION array.[code=php]
<?php
session_start();
// do your login stuff, then...
$_SESSION['myusername'] = $valueFromLoginStuff;
[/code]If you do a redirect via a PHP header() call, you may need to ensure that the session data is stored:
[code=php]
session_write_close();
header('Location: http://yoursite.com/landing_page.php');
exit;
[/code]