PHP之PDO於MYSQL之[新增][修改][刪除]

[新增]

$sql = "INSERT INTO table_name(col1,col2,......coln) VALUES($var1,$var2,......$varn)";

$result = $db->exec($sql);

[修改]

$sql = "UPDATE dbname SET col1='$var1',col2='$var2',......coln='$varn' WHERE ......";
$result = $db->prepare($sql);
$result->execute();

[刪除]

$sql = "DELETE FROM dbname WHERE id=".$id."";
$result = $db->exec($sql);

[$db->prepare另外用法]

$sql = "UPDATE table_name SET col1=? WHERE col2=? AND col3=?";
$result = $db->prepare($sql);
$result->execute(array($var1,$var2,$var3));