<p>//实例化PDO类 连接数据库 参数是 mysql:host=localhost;dbname=lamp 用户名 密码
$pdo = new PDO('mysql:host=localhost;dbname=lamp', 'root', '');</p><p>//查询语句
</p><p>$sql = "select * from lamp_login";
$stmt = $pdo->query($sql);</p><p>//增 删 改</p><p>$pdo->exec($sql);
</p><p>PDO::FETCH_OBJ相当于mysql_fetch_object</p><pre dir="ltr">object(<em>stdClass</em>)[<em>3</em>]
<em>public</em> 'id' <span>=></span><small>string</small><span>'1'</span><em>(length=1)
public</em> 'username' <span>=></span><small>string</small><span>'user1'</span><em>(length=5)
public</em> 'password' <span>=></span><small>string</small><span>'123'</span><em>(length=3)</em>PDO::FETCH_BOTH相当于mysql_fetch_array
array<em>(size=6)</em> 'id' <span>=></span><small>string</small><span>'2'</span><em>(length=1)</em> 0 <span>=></span><small>string</small><span>'2'</span><em>(length=1)</em> 'username' <span>=></span><small>string</small><span>'user2'</span><em>(length=5)</em> 1 <span>=></span><small>string</small><span>'user2'</span><em>(length=5)</em> 'password' <span>=></span><small>string</small><span>'234'</span><em>(length=3)</em> 2 <span>=></span><small>string</small><span>'234'</span><em>(length=3)</em>
PDO::FETCH_NUM相当于mysql_fetch_row
array<em>(size=3)</em> 0 <span>=></span><small>string</small><span>'3'</span><em>(length=1)</em> 1 <span>=></span><small>string</small><span>'user3'</span><em>(length=5)</em> 2 <span>=></span><small>string</small><span>'345'</span><em>(length=3)</em>
PDO::FETCH_ASSOC相当于mysql_fetch_assoc
array<em>(size=3)</em> 'id' <span>=></span><small>string</small><span>'4'</span><em>(length=1)</em> 'username' <span>=></span><small>string</small><span>'zhouyao'</span><em>(length=7)</em> 'password' <span>=></span><small>string</small><span>'123456'</span><em>(length=6)</em>
版权声明：本文为博主原创文章，未经博主允许不得转载。
以上就介绍了MySQL PDO连接与操作，包括了方面的内容，希望对PHP教程有兴趣的朋友有所帮助。
