Advertisement
Guest User

Untitled

a guest
Mar 17th, 2017
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.50 KB | None | 0 0
  1. <?php
  2. $user='root';
  3. $password='user';
  4. $database='mysql';
  5. $pdo=null;
  6.  
  7. try {
  8.     $pdo = new PDO( "mysql:host=localhost;dbname=$database",
  9.         $user, $password );
  10.     $pdo->setAttribute( PDO::ATTR_ERRMODE,
  11.         PDO::ERRMODE_EXCEPTION );
  12.     $statement = $pdo->query('SELECT * from db');
  13.     $statement->setFetchMode(PDO::FETCH_ASSOC);
  14.     while($row = $statement->fetch()) {
  15.         print_r($row);
  16.     }
  17. } catch ( PDOException $e ) {
  18.     print 'Exception!: ' . $e->getMessage();
  19. }
  20. $pdo = null;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement