Use ADO in PHP for Windows

In this example, a connection is established, and the Access Database NorthWind is opened with ODBC (the example is provided when Access is installed ). After the SQL statement is executed, the RecordSet object is returned. The example shows the first three fields:

<?
$ Dbc = new COM ("ADODB. Connection ");
$ Dbc-> Provider = "MSDASQL ";
$ Dbc-> Open ("nwind ");
$ Rs = $ dbc-> Execute ("select * from products ");
$ I = 0;
While (! $ Rs-> EOF ){
$ I + = 1;
$ Fld0 = $ rs-> Fields (0 );
$ Fld1 = $ rs-> Fields (1 );
$ Fld2 = $ rs-> Fields (2 );
Print "$ fld0-> value $ fld1-> value $ fld2-> value <BR> ";
$ Rs-> MoveNext ();
}
$ Rs-> Close ();
?>