...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;
}
}
?>
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;
}
}
?>