对于GET方式的参数化查询,可以使用PDO预处理语句来实现。具体步骤如下:
1. 连接数据库
```
$dsn = 'mysql:host=localhost;dbname=mydb';
$username = 'username';
$password = 'password';
try {
$pdo = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
}
```
2. 准备查询语句
```
$sql = 'SELECT * FROM books WHERE id = :id LIMIT 0,1';
```
3. 准