php 使用pdo对mysql数据库增删改查实例?

Question

php 使用pdo对mysql数据库增删改查实例

Answer 1

1234$result&nbsp;=&nbsp;mysql_query("SELECT&nbsp;`id`,&nbsp;`Retail`&nbsp;FROM&nbsp;`table`&nbsp;WHERE&nbsp;`Retail`&nbsp;-&nbsp;`Cost`&nbsp;<&nbsp;30");while($row&nbsp;=&nbsp;mysql_fetch_array($result))&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;mysql_query("UPDATE&nbsp;SET&nbsp;`Retail`='".$row['Retail']&nbsp;+&nbsp;20."'&nbsp;WHERE&nbsp;`id`='".$row['id']."';");}