msaccess database

autocolismo

How can i retrieve information from a msaccess database with php?

odbc_connect('dbname', 'user', 'pass');

so far i think it's ok

but then comes the problem, i don't know what to do to access tables etc...

Can anyone help me?

Psyche

http://www.php.net/manual/en/ref.odbc.php

greg252

Just read in MS SQL book that Access is NOT a complete server and should not be used for such a purpose.

Went on to say, great for development, but if you want to get serious, use MS SQL Server.

Take a look at MYSQL site/crashme area. Look at the warnings for Access.

INTERESTING.

edwardsbc

The basics for ODBC access:

# Connect to the database
include('dbpass.php'); #get the password from somewhere 
# outside the web tree
$h=odbc_connect($datasrc,$dbuser,$dbpwd);
if (!$h) {Die('Database connection failed!');}
#
# Make your query
$sql="SELECT * FROM $tb";
$result=odbc_exec($h,$sql);
if(!$result) {die("Query failed: $sql");}
#
# Do something with the results
while(odbc_fetch_row($result)){
  $value=odbc_result($result,'fieldname');
  echo $value;
  }
# Close the database if you are done
odbc_close($h);

You can also use odbc_fetch_array() or odbc_fetch_into() to put the entire result row into an array.

dannys

Access is not really suited to web serving IMO - it's ok for RADing a quick windows project (small stock control etc) but ask it to serve simultaneous requests and it'll fall over no matter how much hardware you throw at it.

SQLServer is better but cost quite a lot more.

MySQL is of comparable quality to SQLServer and is free (if you've been getting along with Access then SQLServer will probably have way more features than you actually need). MySQL also plays nicely with PHP as well as being multiplatform - you could shift the entire project to Linux or BSD without recoding any of the db stuff.

PgSQL is probably slightly better than MySQL (IMO) but doesn't exist on Windows and is a lot less popular (mostly due to its feeble PR machine).

In short, junk Access and switch to MySQL unless you actually need a feature in SQLServer that MySQL doesn't have.

autocolismo

thanks alot you all for your help.