PDO: Хранимые процедуры и связанные значения

1
<?php
2
// configuration
3
$dbtype    = "sqlite";
4
$dbhost   = "localhost";
5
$dbname    = "test";
6
$dbuser    = "root";
7
$dbpass    = "admin";
8

9
// database connection
10
$conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
11

12
// new data
13

14
// query
15
$sql = "SELECT * FROM books";
16
$q = $conn->prepare($sql);
17
$q->execute();
18

19
$q->bindColumn(1, $id);
20
$q->bindColumn(2, $title);
21
$q->bindColumn(3, $author);
22

23
while($q->fetch())
24
{
25
echo "$title, $author <br/>";
26
}
27

28
?>

1
// query
2
$sql = "INSERT INTO books (title,author) values(?,?)";
3

4
$q = $conn->prepare($sql);
5
$q->bindColumn(1, $title);
6
$q->bindColumn(2, $title);
7

8
$q->execute();