pdo增删改查

代码 $pdo->exec(sql)

1.增

$pdo->exec(“insert into admin values (null,’cz’,’cz1314520’)”)

2.删

$pdo->exec(“delete from admin where name=’cz’”);

3.改

$pdo->exec(“update admin set name=’chenzhu’ where Id=1”);

4.查

$pdo->query(“SELECT * from admin”);

自动增长的编号 lastInsetId
echo $pdo->lastInsetId()