Can anyone help me to connect to sql database to validate login form from...

zulfi1098

New member
...following php code? Can anyone help me to connect to sql database to validate login form from following php code? Anticipated thanks
My sql server address = sql100.freei.me

Username = freei_4163850

Password = zulfi “assume”
Database = freei_4163850_login
Table name = user where user record exist ((username, password, email, name, active are field in table)
<?php
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
$success_page = './movie.html';
$error_page = './error.html';
$database = './usersdb.php';
$crypt_pass = md5($_POST['password']);
$found = false;
$fullname = '';

if(filesize($database) > 0)
{
$items = file($database);
foreach($items as $line)
{
list($username, $password, $email, $name, $active) = explode('|', trim($line));
if ($username == $_POST['username'] && $active != "0" && $password == $crypt_pass)
{
$found = true;
$fullname = $name;
}
}
}
if($found == false)
{
header('Location: '.$error_page);
exit;
}
else
{
session_start();
$_SESSION['username'] = $_POST['username'];
$_SESSION['fullname'] = $fullname;
$rememberme = isset($_POST['rememberme']) ? true : false;
if ($rememberme)
{
setcookie('username', $_POST['username'], time() + 3600*24*30);
setcookie('password', $_POST['password'], time() + 3600*24*30);
}
header('Location: '.$success_page);
exit;
}
}
?>
 
Back
Top