Simple Login using Ms Access ODBC

[Yew12]

I am trying to create a simple login for my webpage, but Im a bit of a novice and cannot see where Im going wrong any help would be much appreciated.

I'm using an access database and ODBC.

The code I have got is below;

[PHP]<?php

$tbl_name="tblC ustomer";

$connstr = "DRIVER={Micros oft Access Driver (*.mdb)}; DBQ=" . realpath("2Poin tB.mdb").";";
$conn=odbc_conn ect($connstr,'' ,'') or die(Print "connect error: ".odbc_error()) ;

$username=$_POS T['username'];
$password=$_POS T['password'];

$username = stripslashes($u sername);
$password = stripslashes($p assword);

$sql="SELECT * FROM $tbl_name WHERE username='$user name' and password='$pass word'";
$stmt=odbc_prep are($conn, $sql) or die (Print "odbc prepare error".odbc_err or());
$result=odbc_ex ec($stmt) or die (Print "result error ".odbc_error()) ;

$count=odbc_num _rows($result);

if($count==1){

session_registe r("username") ;
session_registe r("password") ;
header("locatio n:/wfolder/Logon2.php");
}
else {
echo "Wrong Username or Password";
}

odbc_close($stm t);

?>[/PHP]

Thanks

[ronverdonk]

Assuming you have a separate login script/form that you have not shown here.

I am unable to guess about "where Im going wrong " and I really don't want to, so: what is the problem you encounter? Any error messages? What exactly does not work? What have you debugged so far in your code?

Ronald

[Yew12]

Sorry I will try to clarify,

I have one HTML page with two input boxes on and it passes the variables username and password to this php script where I want to check to see if they are valid and if so send them to another page, if not then display message "Wrong Login".

Any other questions just ask.

[ronverdonk]

I understand how it is supposed to work, but I asked you how you know it does not work and what problems you have! Like an error messgae, system hang, nothing at all, sql error, etc.

A more general remark on the code: do not use session_registe r, it is deprecated.

If you want your script to work regardless of register_global s, you need to instead use the $_SESSION array as $_SESSION entries are automatically registered. If your script uses session_registe r(), it will not work in environments where the PHP directive register_global s is disabled.

Ronald

[Yew12]

I get the result error. with out a odbc error number.

[ronverdonk]

Your problem is in this statement[php]$result=odbc_ex ec($stmt) or die (Print "result error ".odbc_error()) ;[/php]This statement says: prepare and execute an sql statement. You have already prepared, so you must use[php]$result=odbc_ex ecute($stmt) or die (Print "result error ".odbc_error()) ;[/php]So:
odbc_exec — Prepare and execute a SQL statement
odbc_execute — Execute an already prepared statement

Ronald

[Yew12]

Thanks very much, but unfortunatly i still get an 07001.

[ronverdonk]

I cannot find the 7001 error code in the MySQL documentaiton, so why don't you just add the odbc error message to your output like[php]$result=odbc_ex ecute($stmt) or die (Print "result error ".odbc_error(). '-'.odbc_errormsg ());[/php]so you can see the error reason.

Ronald

[Yew12]

Thanks, added it in the error reads

result error 07001-[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.

I have tried looking checking that the names are right and everything but still no luck.

Also thanks for helping a novice you are helping more that you think.

[ronverdonk]

Means you have not changed your odbc_exec into the odbc_execute statement. I.e. odbc_exec requires 2 parameters, odbc_execute requires 1 parameter.

And you really must use odbc_execute because you have already prepared the sql statement in the odbc_prepare!

Ronald