PHP|Débutant :: Forums

  $bd = 'C:\\inetpub\wwwroot\bon_commande_10\bede\commande_lettre.mdb';
  $conn = new COM("ADODB.Connection") or die("Cannot start ADO");
 
  // Microsoft Access connection string.
  $conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$bd");
  // SQL statement to build recordset.
  $rs = $conn->Execute("SELECT * FROM tb_formulaire_2010");
  //echo "test" . $rs->EOF;
  //exit();
   //Display all the values in the records set
  while (!$rs->EOF) {
    echo "<tr>";
    echo "<td bgcolor=\"#999999\">" . $rs->Fields["id"]->value . "</td>";
    echo "<td>" . $rs->Fields["bd_ecole"]->value . "</td>";
    echo "<td>" . $rs->Fields["bd_ville"]->value . "</td>";
    echo "<td>" . $rs->Fields["bd_province"]->value . "</td>";
    echo "<td>" . $rs->Fields["bd_nom"]->value . "</td>";

    echo "<td><span class=\"gris\">1er anneé : </span>" . $rs->Fields["bd_annee1"]->value . "<br />";
        echo "<span class=\"gris\">2e année : </span>" . $rs->Fields["bd_annee2"]->value . "<br />";
        echo "<span class=\"gris\">3e année : </span>" . $rs->Fields["bd_annee3"]->value . "<br />";
      echo "<span class=\"gris\">4e année : </span>" . $rs->Fields["bd_annee4"]->value . "<br />";
        echo "<span class=\"gris\">5e année : </span>" . $rs->Fields["bd_annee5"]->value . "<br />";
        echo "<span class=\"gris\">6e année : </span>" . $rs->Fields["bd_annee6"]->value . "</td>";

    echo "</tr>";
    $rs->MoveNext();
  }
  $rs->Close();
?>