PDO: SELECT

1
CREATE TABLE `books` (
2
  `id` int(11) NOT NULL auto_increment,
3
  `title` varchar(150) NOT NULL,
4
  `author` varchar(150) NOT NULL,
5
  `description` varchar(255) NOT NULL,
6
  `on_sale` tinyint(1) NOT NULL,
7
  PRIMARY KEY  (`id`)
8
);

1
INSERT INTO `books` (`id`, `title`, `author`, `description`, `on_sale`) VALUES (1, 'PHP AJAX', 'Andreas', 'This is good book for learning AJAX', 1);
2
INSERT INTO `books` (`id`, `title`, `author`, `description`, `on_sale`) VALUES (2, 'PHP Eclipse ', 'George', 'Nice book', 0);
3
INSERT INTO `books` (`id`, `title`, `author`, `description`, `on_sale`) VALUES (3, 'PHP Prado', 'Junyian', '-', 1);
4
INSERT INTO `books` (`id`, `title`, `author`, `description`, `on_sale`) VALUES (4, 'PHP Zend Framework', 'Ozulian', 'great', 0);
5
INSERT INTO `books` (`id`, `title`, `author`, `description`, `on_sale`) VALUES (5, 'PHP Web Services', 'Bobi', '', 0);
6
INSERT INTO `books` (`id`, `title`, `author`, `description`, `on_sale`) VALUES (6, 'PHP API', 'Hugo', '', 1);
7
INSERT INTO `books` (`id`, `title`, `author`, `description`, `on_sale`) VALUES (7, 'PHP SEO', 'Monteo', '', 1);

1
<?php
2
$host   = "localhost";
3
$db  = "test";
4
$user  = "root";
5
$pass  = "admin";
6

7
$conn = new PDO("mysql:host=$host;dbname=$db",$user,$pass);
8

9
$sql = "SELECT * FROM books";
10
$q   = $conn->query($sql) or die("failed!");
11
while($r = $q->fetch(PDO::FETCH_ASSOC)){
12
  echo $r['title'];
13
}
14

15
?>