README

$create_test_table = $pdo->query( "CREATE TABLE if not exists test ( id int(11) unsigned NOT NULL AUTO_INCREMENT, firstname varchar(200) DEFAULT NULL, lastname varchar(200) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;");

$insert = $pdo->query("INSERT INTO test(firstname,lastname) VALUES(:f,:l)", array("f"=>"Jeb","l"=>"Barger")); echo $insert;

// 获取整个表 $persons = $pdo->query("SELECT * FROM test LIMIT 1000"); print_r($persons);

// 1. 读取友好方法
$pdo->bind("FirstName","Jeb"); $pdo->bind("LastName","Barger"); $person = $pdo->query("SELECT * FROM test WHERE firstname = :FirstName AND lastname = :LastName"); print_r($person);

// 2. 绑定更多参数 $pdo->bindMore(array("FirstName"=>"Jeb","LastName"=>"Barger")); $person = $pdo->query("SELECT * FROM test WHERE firstname = :FirstName AND lastname = :LastName"); print_r($person);

// 3. 或者直接将参数传递给方法 $person = $pdo->query("SELECT * FROM test WHERE firstname = :FirstName",array("FirstName"=>"Jeb")); print_r($person);

// 获取一行 $person = $pdo->row("SELECT * FROM test WHERE firstname = :FirstName", array("FirstName"=>"Jeb")); print_r($person);

// 获取单个值 $pdo->bind("FirstName","Jeb"); $firstname = $pdo->single("SELECT firstname FROM test WHERE firstname = :FirstName"); print_r($firstname);

// 删除 - 返回行数 $delete = $pdo->query("DELETE FROM test WHERE Id = :id", array("id"=>"1")); echo $delete;

// 更新 - 返回行数 $update = $pdo->query("UPDATE test SET firstname = :f WHERE Id = :id", array("f"=>"Jeb","id"=>"1")); echo $update;

// 插入 - 返回行数 $insert = $pdo->query("INSERT INTO test(firstname,lastname) VALUES(:f,:l)", array("f"=>"Vivek","l"=>"test")); echo $insert;

// 获取样式作为第三个参数 - 关于PDO获取样式的更多信息： https://php.ac.cn/manual/en/pdostatement.fetch.php $person_num = $pdo->row("SELECT * FROM test WHERE firstname = :FirstName", array("FirstName"=>"Jeb"), PDO::FETCH_NUM); print_r($person_num);