FoxPro 9

dbonilla

I need heeeeeeeeeelllllllllllllppppppppppppp.... I need to know how to connect to a foxpro 9 table (.dbf) or database container (.dbc), period. Can some one help me. I would like to know the whole process. Here is my error message:

Warning: Wrong parameter count for odbc_connect() in D:\Program Files\xampp\htdocs\chapter 03\foxprotest.php on line 3

Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in D:\Program Files\xampp\htdocs\chapter 03\foxprotest.php on line 7

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in D:\Program Files\xampp\htdocs\chapter 03\foxprotest.php on line 9

Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in D:\Program Files\xampp\htdocs\chapter 03\foxprotest.php on line 15

David :queasy:

AIS4U

dbonilla:

Well, you didn't post your connection code, so it is pretty hard to try and guess what may or may not be working.

You might try some modification to this code based upon your database, etc. and see what happens.

<?php
$conn = new COM("ADODB.Connection");
$conn->Open('Provider=VFPOLEDB.1;
Data Source="c:\wwwroot\trans\trans.DBC";Collating Sequence=HUNGARY;');
// SQL statement to build recordset.
$rs = $conn->Execute("SELECT * FROM courier ORDER BY Name");
echo "<p>List of couriers:</p><hr>";
// Display all the values in the records set
while (!$rs->EOF) { 
    $fv = $rs->Fields("Name");
    echo $fv->value."<br>\n";
    $rs->MoveNext();
} 
$rs->Close(); 
?>

You could also try using PHPCodeGenie: http://phpcodegenie.sourceforge.net/

Good Luck

dbonilla

Yeah sorry about that...here it is.

connect to a DSN "test1"

$connect = odbc_connect("data99","","");

query the users table for name and surname

$query = "SELECT Pick_up_ad, Delivery_a FROM test1";

perform the query

$result = odbc_exec($connect, $query);

fetch the data from the database

while(odbc_fetch_row($result)){
$name = odbc_result($result, 1);
$surname = odbc_result($result, 2);
print("$Pich_up_ad $Delivery_a\n");
}

close the connection

odbc_close($connect);
?>

Do i need the ADOdb Database Abstraction Library for PHP ???
Funny that you be using that select statement because i am working on a project for a NYC messenger company.

Thanks
Dave

AIS4U

dbonilla:

Do i need the ADOdb Database Abstraction Library for PHP ???

Yes you do. Guess I just assumed you already had it.

I think you can get it here:http://php.weblogs.com/adodb/

dbonilla

Thank you... and yes I did assume that...

David.