Sessions tutorial? - Codewalkers

Codewalkers Forums Sponsor:

AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!

March 2nd, 2004, 11:52 PM

SnowStorm

Join Date: Apr 2007

Posts: 374

Time spent in forums: < 1 sec
Reputation Power: 2

Sessions tutorial?

I can't get the sessions tutorial for the login part to work. I dont understand how it works or how it is asking me to select the values at the login_check part of the functions page, could someone help me?

Here is code I am trying to use

php Code:

Original - php Code

 
(functions.php)
<?php
//database settings
$hostName="";
$userName="";
$passWord="";
$dataBase="";
 
//connect to databse
$conn = mysql_connect($hostName,$userName,$passWord) or die("Failed to connect to database!");
mysql_select_db($dataBase,$conn) or die("Failed to select database!");
function secure ()
{
  if(!($_SESSION["id"]) || ($_SESSION["id"] == ""))
  {
    Header("Location: ./login.php");
    exit();
  }
}
function login_check ($forms)
{
  $error = "";
  $username = $forms["username"];
  $password = $forms["password"];
  if (trim($username) == "") $error .= "<li>Your username is empty.</li>";
  if (trim($password) == "") $error .= "<li>Your password is empty.</li>";
  $sql = "SELECT Username,Password FROM userLogin WHERE Username='$username' AND Password='$password'";
  $result = mysql_query($sql) or die(mysql_error());
  $num = mysql_num_rows($result);
  if($num)
  {
    return TRUE;
  }
  else
  {
    return FALSE;
  }
}
 
function login ($forms)
{
  $username = $forms["username"];
  $password = $forms["password"];
  $sql = "SELECT ID FROM userLogin WHERE Username='$username' AND Password='$password'";
  $result = mysql_query($sql) or die(mysql_error());
  $id = mysql_fetch_assoc($result);
  return $id;
}
 
?>
 
(login.php)
<?php
// login.php
session_start();
include ("functions.php");
if($_POST)
{
  $error = login_check($_POST);
  if (trim($error)=="")
  {
    $_SESSION["id"] = login($_POST);
    Header("Location: ./index.php"); // Redirect correct member
    exit();
  }
  else
  {
    print "Error:$error";
  }
}
 
print("<form method="post" action="{$_SERVER['PHP_SELF']}">
Username : <input type="text" name="username"><br>
Password : <input type="password" name="password"><br>
<input type="submit" value="Login">
</form>");
?>

Here is the tutorial link:
http://codewalkers.com/tutorials/32/3.html

Btw it just says Error: 1 when I try this.

March 3rd, 2004, 12:29 AM

System

Join Date: Apr 2007

Posts: 665

Time spent in forums: < 1 sec
Reputation Power: 2

Message Moved

Thread moved from 'PHP Coding' to 'Tutorials' by sliver.

Reason: Help with tutorial code

March 3rd, 2004, 02:34 AM

CodeKadiya

Join Date: Apr 2007

Location: Colombo,Sri Lanka

Posts: 2,313

Time spent in forums: < 1 sec
Reputation Power: 4

RE: Sessions tutorial?

Check these two scripts in your pages.. did you create the table in database and make sure about the MySQL connection.

(login.php)

php Code:

Original - php Code

<?php
// login.php
session_start();
include ("functions.php");
if($_POST['submit'])
{
    $username=$_POST['username'];
    $password=$_POST['password'];
  $error = login_check($username,$password);
  if($error==true)
  {
    $_SESSION['id'] = login($username,$password);
    header("Location: index.php");
  }
  else
    print "Error:$error";
}
?>
<form method="post" action="<?=$_SERVER['PHP_SELF']?>">
Username : <input type="text" name="username"><br>
Password : <input type="password" name="password"><br>
<input type="submit" name="submit" value="Login">
</form>

(functions.php)

php Code:

Original - php Code

 
<?php
session_start();
$hostName="";
$userName="";
$passWord="";
$dataBase="";
 
$conn = mysql_connect($hostName,$userName,$passWord) or die("Failed to connect to database!");
mysql_select_db($dataBase,$conn) or die("Failed to select database!");
 
function secure ()
{
  if(!($_SESSION["id"]) || ($_SESSION["id"] == ""))
    header("Location: login.php");
}
 
function login_check($username,$password)
{
  if (trim($username) == "") $error .= "<li>Your username is empty.</li>";
  if (trim($password) == "") $error .= "<li>Your password is empty.</li>";
  $sql = "SELECT Username,Password FROM userLogin WHERE Username='$username' AND Password='$password'";
  $result = mysql_query($sql) or die(mysql_error());
  $num = mysql_num_rows($result);
  if($num)
      return TRUE
  else
    $error .="<li>Invalid username/password.</li>";
  return $error;
}
 
function login($username,$password)
{
  $sql = "SELECT ID FROM userLogin WHERE Username='$username' AND Password='$password'";
  $result = mysql_query($sql) or die(mysql_error());
  $row= mysql_fetch_array($result);
  $id = $row['ID'];
  return $id;
}
?>

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: