$pdo = new PDO();
$resultDataInsert = $pdo->exec("INSERT INTO `Person` (`name` ,`address`,`age`)VALUES ('小二', '阿里巴巴',24)");
$prepareDataInsert = $pdo->prepare("INSERT INTO `Person` (`name` , `address`,`age`)VALUES ('小小二', '阿里巴巴',28)"); $prepareDataInsertResult = $prepareDataInsert->execute();
使用占位符进行数据插入
$dataInsertParam = array("大小二", "阿里巴巴", 29); $placeHolderDataInsert = $pdo->prepare("INSERT INTO Person (name, address, age) values (?, ?, ?)"); $placeHolderDataInsertResult = $placeHolderDataInsert->execute($dataInsertParam);
$namedPlaceHolderData = array(':name' => '二小', ':address' => '阿里巴巴', ':age' => 23); $namedPlaceHolderDataInsert = $pdo->prepare("INSERT INTO Person (address, name, age) value (:address, :name, :age)"); $namedPlaceHolderDataInsertResult = $namedPlaceHolderDataInsert->execute($namedPlaceHolderData);
$resultDataQueryAssoc = $pdo->query("select name , address as adr,age from Person;"); $resultDataQueryAssoc->setFetchMode(PDO::FETCH_ASSOC); while ($row = $resultDataQueryAssoc->fetch()) { echo $row['name']; echo $row['adr']; echo $row['age']; }
$resultDataUpdate = $pdo->exec("UPDATE `Person` set age=100 where name='小二';");