Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // initialize base variables for PDO connection
- $host = 'localhost';
- $user = 'root';
- $password = '';
- $dbname = 'pdolab';
- // initialize DSN
- $dsn = 'mysql:host=' . $host . ';dbname=' . $dbname;
- // initialize PDO connection
- $pdo = new PDO($dsn, $user, $password);
- // PDO query
- $statement = $pdo->query('SELECT * FROM posts');
- while ($row = $statement->fetch(PDO::FETCH_ASSOC)) {
- echo $row['title'] . '<br>';
- }
Add Comment
Please, Sign In to add comment