pdo

来源：互联网发布：九阴绝学声望回收数据编辑：程序博客网时间：2024/05/17 00:13

 查询        $db = new PDO('mysql:host=localhost;dbname=test', 'root', 'root');        $sql="SELECT * FROM users";        $result = $db->query($sql);        foreach ($result as $row)        {            var_dump($row);        }        $db = null;    增、删、改、事务开启        try        {            $db = new PDO('mysql:host=localhost;dbname=test', 'root', 'root');            $db->beginTransaction();            $a = $db->exec("insert into users (id, username, password) values ('', 'Joe', 'Bloggs')");            if($a == false)            {                throw new Exception("sql1执行失败");            }            $b = $db->exec("insert into users (id, username, password,kkk) values ('', 'Joe', 'Bloggs')");            if($b == false)            {                throw new Exception("sql2执行失败");            }            $db->commit();            $db = null;        }        catch (Exception $ex)        {            echo $ex;            $db->rollback();        }

0 0