Mega Code Archive

 

Categories / Php / Code Snippets

 

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); ?>