Advertisement
miraage

Untitled

Mar 15th, 2012
307
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.38 KB | None | 0 0
  1. <?php
  2.  
  3. $dbh = new PDO('mysql:host=127.0.0.1;dbname=test', 'user', 'password', array(
  4.     PDO::ATTR_EMULATE_PREPARES => true,
  5.     PDO::MYSQL_ATTR_INIT_COMMAND => 'set names utf8',
  6. ));
  7.  
  8. $stmt = $dbh->prepare('SELECT * FROM `pages` WHERE `id` = :page');
  9. $stmt->bindValue(':page', $_GET['page'], PDO::PARAM_INT);
  10. $stmt->execute();
  11.  
  12. $result = $stmt->fetch(PDO::FETCH_ASSOC);
  13.  
  14. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement