I am new to php. i need the login required for admin pages. but i have to used ms access database using odbc (odbc.php) for odbc db connection. i am able to connect to db but, the login code (login.php) of which is show below. Unfortunatly isnot working. i modified the code from here [
webmasterworld.com...]
here is my odbc connection
odbc.PHP
<?php $odbc= odbc_connect('store','','') or die('Could Not Connect to ODBC Database!'); ?>
here is login page not working Login.php
<?php require_once('odbc.php');
session_start();
// Get the data collected from the user
$logon_name =$_POST["logon_name"];
$logon_password =$_POST["logon_password"];
//$odbc->open($odbc);
$strSQL = "SELECT logon_name, logon_password FROM USERACCESS2 WHERE logon_name = '$logon_name' AND logon_password = '$logon_password'";
//$rs = $odbc->execute($strSQL);
$rs = odbc_exec($odbc, $strSQL);
if ($rs->Fields["logon_name"]->value && $rs->Fields["logon_name"]->value == $logon_name)
if ($rs->Fields["logon_password"]->value && $rs->Fields["logon_password"]->value == $logon_password)
{
$_SESSION["authenticatedUser"] = $logon_name;
// Relocate to the logged-in page
header("Location: loggedon.php");
}
else
{
$_SESSION["message"] = "login Error as $logon_name. " ;
header("Location: admin.php");
}
?>
also i would like check login on other admin page as well. your help would really appreciate. thanks
