PDO操作笔记

1,插入数据。

            $sql = 'INSERT INTO '.$dbMessage['tablePrefix'].'movie (movie_id,name,type,area,actor,director,screenTime,intro,img) VALUES (NULL,:name,:type,:area,:actor,:director,:screenTime,:intro,:img)';
准备。            $stmt = $db->prepare($sql);
赋值            $stmt->bindParam(':name',$ArrCon[0]);
执行            $stmt->execute()

2，查询一行值：
sql            $sql = 'SELECT movie_id,img FROM '.$dbMessage['tablePrefix'].'movie WHERE name = :name';
准备            $stmt = $db->prepare($sql);
赋值            $stmt->bindParam(':name',$ArrCon[0]);
执行            $stmt->execute();
拿到一行            $movieName = $stmt->fetch(PDO::FETCH_ASSOC);

3，删除操作
//                 $sql = 'DELETE FROM '.$dbMessage['tablePrefix'].'movie WHERE movie_id = '.$movieName['movie_id'];
//                 $db->exec($sql);