PHP with microsoft access
Posted: Wed Jul 17, 2002 2:49 pm
I need connect PHP with a microsoft access database , how I do this ?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?php
function query_db($query) {
$db = "database";
$dbusername = "username";
$dbpassword = "password";
if (!$conn = odbc_connect($db,$dbusername,$dbpassword)) {
echo ("Cannot select ODBC database.\n");
};
return odbc_exec($conn, $query);
odbc_close($conn);
}
?>Code: Select all
<?php
include("dbconnect.php");
$query="SELECT * FROM table";
$result = query_db($query);
while (odbc_fetch_row($result)) {
$field = odbc_result($result, "field");
echo "$field<br>";
}
odbc_free_result($result);
?>