If Conditions

[daddyb1]

I am trying to get  6 usernames and passwords from a local database via a file I created called database_log.inc.

note 2 columns and 6 rows

How can get each password & username with the current code?

 

here is the code for the log on:

 

<?php

function clean($data)

{

    $data = trim($data);

    $data = stripslashes($data);

    $data = htmlspecialchars($data);

    return $data;

}

 

$user = clean($_POST['username']);

$pass = clean($_POST['password']);

include 'database_log.inc';                              //info from the database separate file

if ($user == "shane" && $pass == "shane")  //password and user name not in the database

 

{

  session_start();

  $_SESSION['username'] = $user;

  $_SESSION['password'] = $pass;

  $_SESSION['ON']="TRUE";

  $lifetime=600;

  setcookie(session_name(),session_id(),time()+$lifetime);

  header( 'Location: inner.php' ) ;

  exit();

}

 

 

else

{

header( 'Location: index.php' );

session_destroy();

exit();

}

 

?>

 

 

 

 

[QuickOldCar]

you should post a few lines of example data within your database_log.inc

 

will have to explode it by it's delimiter for each value

http://php.net/manual/en/function.explode.php

[daddyb1]

table name login

 

username   password

mjerry   jerryjerry

ssimon simonsimon

ablack blackblack

phenry henryhenry

rjames jamesjames

kpowell powellpowell

 

this is the table in the database

[scootstah]

You should use fgets() with some regular expressions. Should git'r'done.

[daddyb1]

@scootstah can you give an example?