PDO 的应用 数据操作

使用PDO 进行数据循环添加

如下：

$subject_id='2';$goods_id=array(               0=>12,               1=>13,               2=>14,               3=>15,               4=>16    );$str=array();foreach ($goods_id as $key => $newgoods_id) {    $newsubject_id=$subject_id;    $str[]= "('','$newsubject_id','$newgoods_id','','','')";}$db = new PDO('mysql:host=localhost;dbname=yhjs-test','root','root');$db->query('set names utf8');$sql="insert into ecs_subject_goods values  ".implode(',', $str);$count = $db->exec($sql);echo $count;

使用PDO 进行数据 查询（select）

$db = new PDO('mysql:host=localhost;dbname=yhjs-test', 'root', 'root');$db->query('set names utf8');$sql = "select *  from ecs_subject_goods";$res = $db->query($sql)->fetchAll(PDO::FETCH_ASSOC);print_r($res) ;

---

---