How to connect to Foxpro 2.6 DOS database using php odbc connection.

[dnzone]

The driver that I use in ODBC Data Source Administrator is Microsoft dBase Driver (*.dbf). Is it correct.

 

Below is my code:-

 

$db_conn = odbc_connect("payrhh",'','');	
if (!$db_conn) 
{ 
   echo "error";
}
else
{
   $sql_result=odbc_exec($db_conn, "select * from staff");
   $sql_rows = 0;
   while(odbc_num_rows($sql_result)) 
   {
      echo odbc_fetch_array($sql_result);
   }	
   odbc_free_result($sql_result);
}

 

This is the result that i get

 

ArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayArrayPHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\Inetpub\wwwroot\rhpos\testing.php on line 18

 

can anyone help me.

 

[fert]

odbc_fetch_array returns an array, so use the print_r function to display the results