NEWBIE HELP

tready · May 24th, 2006, 01:47 AM

Hi,

I generally script in ASP but I have a friend who needs a simple login script. I was wondering if someone could show me how to re-write my script in php.

Code:

Dim conn, sql, filepath
Set conn = Server.CreateObject("ADODB.Connection")
FilePath = "C:\inetpub\wwwroot\sample\cig-bin\test.mdb"

SQL = "SELECT * FROM ADMIN WHERE "
SQL = SQL & "Username ='" & request.form("txtuser") & "' "
SQL = SQL & "AND Pword ='" & request.form("txtpword") & "';"

set rsTemp = conn.execute (SQL)

If Not rsTemp.EOF Then
  'Login action
Else
  'Bad login action
End If

rsTemp.Close
Set rsTemp = Nothing

conn.Close
Set conn = Nothing

Can someone convert this to php?

ciderpunx · May 24th, 2006, 06:41 AM

Okey dokey, I don't have msaccess here (check http://uk.php.net/odbc_connect for odbc stuff)

This is the would do the same thing if you were connecting to a mysql database:

<?php
// stuff we need from the request
$txtuser = $_REQUEST['txtuser'] ;
$txtpword = $_REQUEST['txtpword'];

// set up our db connection
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("database_name",$db) || die("Problem connecting to database");

// get our SQL ready
$sql = "SELECT * FROM ADMIN WHERE ";
$sql .= "username='$txtuser' AND password='$txtpword'";

// run the query
$results = mysql_query($sql);

// do stuff according to what cam back
if (mysql_num_rows($results)==1 && $results)
   login_action();
else
   auth_error();
?>

Cheers
Charlie

--
Don't Stand on your head - you'll get footprints in your hair
                                           http://charlieharvey.org.uk
                                              http://charlieharvey.com