Guest User

Untitled

a guest
Jan 16th, 2018
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. <?php
  2.  
  3. $db_username = ''; //username
  4. $db_password = ''; //password
  5. //path to database file
  6. $database_path = $_SERVER["DOCUMENT_ROOT"] . "\access\accessdatabase.accdb";
  7. //check file exist before we proceed
  8. if (!file_exists($database_path)) {
  9. die("Access database file not found !");
  10. }
  11.  
  12. //create a new PDO object
  13. $database = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=$database_path; Uid=$db_username; Pwd=$db_password;");
  14. $sql = "SELECT * FROM userdetails";
  15. $result = $database->query($sql);
  16. while ($row = $result->fetch()) {
  17. echo '<pre>';
  18. print_r($row);
  19. echo '</pre>';
  20. }
  21.  
  22.  
  23. ?>
Add Comment
Please, Sign In to add comment