 |
1楼
巨大八爪鱼
2015-11-5 18:05
<?php $filename = 'D:\Codes\Databases\Access\test.accdb'; $dbh = new PDO("odbc:driver={microsoft access driver (*.mdb, *.accdb)};dbq=$filename"); $sql = 'SELECT * FROM Items'; $stmt = $dbh->prepare($sql); $stmt->execute(); foreach ($stmt as $row) { print_r($row); echo '<br>'; }
|
 |
2楼
巨大八爪鱼
2015-11-5 18:05
輸出: Array
(
[ItemID] => 1
[0] => 1
[ItemName] => Android
[1] => Android
[TimeCreated] => 2015-11-05 13:01:11
[2] => 2015-11-05 13:01:11
)
Array
(
[ItemID] => 2
[0] => 2
[ItemName] => PHP
[1] => PHP
[TimeCreated] => 2015-11-05 13:01:16
[2] => 2015-11-05 13:01:16
)
|