|
php ve access
Jul 23,2007 00:00
by
mustaYfa
// Connection
$conn = new COM("ADODB.Connection") or die("ADODB başlatılamıyor");
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=rehber.mdb"); // Recordset
$rs = $conn->Execute("SELECT * FROM adres"); // Alan isimlerini döküyoruz
echo " | Veriler |
|---|
";
echo " ";
echo " " . $rs->Fields[0]->name . " | ";
echo " " . $rs->Fields[1]->name . " | ";
echo " " . $rs->Fields[2]->name . " | ";
echo " " . $rs->Fields[3]->name . " | ";
echo " " . $rs->Fields[4]->name . " | ";
echo " " . $rs->Fields[5]->name . " | ";
echo " "; // Verileri döküyoruz
while (!$rs->EOF)
{
echo " ";
echo " " . $rs->Fields[0]->value . " | ";
echo " " . $rs->Fields[1]->value . " | ";
echo " " . $rs->Fields[2]->value . " | ";
echo " " . $rs->Fields[3]->value . " | ";
echo " " . $rs->Fields[4]->value . " | ";
echo " " . $rs->Fields[5]->value . " | ";
echo " ";
$rs->MoveNext();
}
echo "
"; // Kapanış
$rs->Close();
$conn->Close(); $rs->Release();
$conn->Release(); $rs = null;
$conn = null; ?>
|