Salve a tutti,
Volevo listare 2 campi di una tabella Access con PHP, ma non mi funziona...
Allego il Codice e relativo errore.... Grazie mille
CODICE:
<?php
$query="select [COD_AGENTE],[DSC_AGENTE] from AGENTI" ;
$path= "C:/lavoro/bim/" ;
$db_name= "budget.mdb" ;
$dsource=$path.$db_name ;
$cn_string="Provider=Microsoft.Jet.OLEDB.4.0;" ;
$cn_string.="Data Source=$dsource;" ;
if (!file_exists($dsource) ){
die("Il database non esiste") ;
}
$cn= new COM("ADODB.Connection");
$cn->open($cn_string) ;
$rs= new COM("ADODB.Recordset") ;
$rs->Open($query,$cn) ;
while(!$rs->EOF){
echo($rs->Fields['COD_AGENTE']->value." ".$rs->Fields['DSC_AGENTE']->value."
") ;
$rs->MoveNext() ;
}
$rs->Close() ;
$rs->Release() ;
$rs= null ;
$cn->Close() ;
$cn->Release() ;
$cn= null ;
<?php
ERRORE:
open($cn_string) ; $rs= new COM("ADODB.Recordset") ; $rs->Open($query,$cn) ; while(!$rs->EOF){ echo($rs->Fields['COD_AGENTE']->value." ".$rs->Fields['DSC_AGENTE']->value." ") ; $rs->MoveNext() ; } $rs->Close() ; $rs->Release() ; $rs= null ; $cn->Close() ; $cn->Release() ; $cn= null ;