|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
connect MS Access
I want use MS Access to store database , can PHP support MS Access ?
|
|
#2
|
|||
|
|||
|
RE: connect MS Access
Sure, you can connect to MSAccess with the ODBC functions....
|
|
#3
|
|||
|
|||
|
RE: connect MS Access
Use ODBC,I want show all content of a field but when I call function odbc_fetch_rows(...) then appear a warning :
odbc_result(): supplied argument is not a valid ODBC result resource in E:wwwphpscriptodbcconnect.php on line 76 -------------------- These are my codes : <? ... $dsn = "anDB"; $user = "sa"; $password = "sa"; $table = "Author"; $sql = "SELECT name FROM $table"; $conn = odbc_connect($dsn, $username, $password) or die(odbc_error()); $result = odbc_exec($conn, $sql) or die(odbc_error()); if ($num_fields = odbc_num_fields($result) != 0) while ($row = odbc_fetch_row($result)) { 76:$Dn=odbc_result($row,"name"); echo $Dn; }//end while odbc_free_result($result); odbc_close($conn); ... ?> |
![]() |
| Viewing: Codewalkers Forums > PHP Related > PHP Coding > connect MS Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|