Showing posts with label PHP odbc_do. Show all posts
Showing posts with label PHP odbc_do. Show all posts

Friday, 5 June 2015

PHP: Display an Access database using PHP and ODBC

<?php
$odbcdsn = "sampledb";
$odbcuser = "";
$odbcpass = "";
$sqlquery = "SELECT * FROM tblsample";
if(!($odbcdb = odbc_connect($odbcdsn , $odbcuser , $odbcpass)))
die("cant open the dsn");
if(!($odbcrs = odbc_do($odbcdb , $sqlquery)))
die("cannot execute sql query");
odbc_result_all($odbcrs);
?>