mysql to access

TheBigLebowski

G'day,

Before I throw the comp ou the window. Anyone know how I would rewrite the following for an access database?

$sql = mysql_query("SELECT password FROM user_table WHERE username = '$username'");
$fetch_em = mysql_fetch_array($sql);
$numrows = mysql_num_rows($sql);

Seth Brundle

any use...
http://www.w3schools.com/php/php_db_odbc.asp
http://bryanmills.net:8086/archives/2003/11/microsoft-access-database-using-linux-and-php/
http://aspn.activestate.com/ASPN/Cookbook/PHP/Recipe/163447
http://www.experts-exchange.com/Web/Web_Languages/PHP/PHP_Databases/Q_20973403.html
http://www.databasejournal.com/features/php/article.php/2222651

seamus

Gonna need a little more information.

It's PHP. I've gathered that. Is it running on a Windows box?

amen

it looks like mysql_fetch_array is a function in php (I don't know php) that accepts a sql string and connects to a specified db and run the sql

if this was asp you would need to create a ado recordset and create a command object and get the data that way

I'm sure there must be a php function for accessing an access database

btw how many users will be using the database? Access is not for a multiuser internet environment

seamus

PHP can't directly access an Access database. The database must be set up on the server as an ODBC object, and then PHP can access it using odbc functions, very similar to the mysql functions.

TheBigLebowski

Thanks guys. As you have pointed out, it's PHP. I have ODBC set up to access the Access database. I'm trying to convert code that was written for mysql to use with an access database. This about as far as I got!

$sql = 'SELECT password FROM logins WHERE username = '$username');
$fetch_em = mysql_fetch_array($sql);
$numrows = mysql_num_rows($sql);

The code I'm trying to use is on this page


I have a table in access called logins and it is a windows box.

It's a school project so numbers of users, etc, doesn't matter.

seamus

All the info you need is here:
http://www.php.net/odbc

It's extremely similar except that you functions will be "odbc_.." instead of "mysql_..."