PHP 数据对象 （PDO） 扩展为PHP访问数据库定义了一个轻量级的一致接口。
<code><span><span><?php</span><span>try</span> { <span>$dsn</span> = <span>"mysql:host=localhost; port=3306; dbname=wsq_hotel; charset=utf-8"</span>; <span>$user</span> = <span>'root'</span>; <span>$psw</span> =<span>'root'</span>; <span>$pdo</span> = <span>new</span> PDO(<span>$dsn</span>,<span>$user</span>,<span>$psw</span>); <span>$sql</span> = <span>'select goods_prices from wsq_goods_info where goods_id=2'</span>; <span>// $sql = "show database";</span><span>$res</span> = <span>$pdo</span>->query(<span>$sql</span>) <span>or</span> var_dump(<span>$pdo</span>->errorInfo()); <span>// var_dump($res);</span><span>$mon</span> = <span>$res</span>->fetch(PDO::FETCH_ASSOC); <span>echo</span><span>$mon</span>[<span>'goods_price'</span>]; } <span>catch</span> (PDOException <span>$e</span>) { <span>echo</span><span>$e</span>->getMessage(); } <span>?></span></span></code>
PDO操作事务
<code><span>//开启事务</span><span>beginTransacition()</span><span>//回滚</span><span>rollback()</span><span>//提交</span><span>commit()</span><span>//判断是否处于事务之中</span><span>inTransaction()</span></code>
返回最后插入行的ID
PDO::lastInsertID()
<
exec()执行
与query()相比，exec()返回的是受影响行数
<code><span>$sql</span> = <span>"insert into table values('<span>$val</span>')"</span>;<span>if</span>(<span>false</span>===<span>$pdo</span>-><span>exec</span>(<span>$sql</span>)){ <span>echo</span><span>'执行失败'</span>;}</code>
‘).addClass(‘pre-numbering’).hide(); $(this).addClass(‘has-numbering’).parent().append($numbering); for (i = 1; i <= lines; i++) { $numbering.append($('
‘).text(i)); }; $numbering.fadeIn(1700); }); }); </script>9来源gaodai#ma#com搞@代~码$网搞gaodaima代码 以上就介绍了PHP之PDO，包括了方面的内容，希望对PHP教程有兴趣的朋友有所帮助。
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：PHP之PDO
转载请注明原文链接：PHP之PDO
