PDO连接数据库

本例是PDO连接Mysql数据库的方法：

连接别的数据库的方法大同小异，只需在php.ini文件中加载“extension=php_pdo.dll“和”extension=php_pdo_mysql.dll(根据需求加载对应的dll文件)“，保存重启服务器即可。

以下是本例代码：

<table border="1">
    <tr>
        <td>id</td>
        <td>fileid</td>
        <td>username</td>
        <td>content</td>
        <td>datetime</td>
    </tr>
<?php
    header("Content-Type:text/html;charset=utf-8");
    $dbms='mysql';
    $dbname='db_tmlog';
    $user='root';
    $pwd='';
    $host='localhost';
    $dsn="$dbms:host=$host;dbname=$dbname";
    mysql_query("set names utf8");
    echo "PDO测试：";
    try{
        $pdo=new PDO($dsn,$user,$pwd);
        echo "PDO连接Mysql成功！";
        $query = "select * from tb_filecomment where username like ?";
        $result = $pdo->prepare($query);
        $result->execute(array('%s%'));
        while($res=$result->fetch(PDO::FETCH_ASSOC)){
?>
    <tr>
        <td><?php echo $res['id'];?></td>
        <td><?php echo $res['fileid'];?></td>
        <td><?php echo $res['username'];?></td>
        <td><?php echo $res['content'];?></td>
        <td><?php echo $res['datetime'];?></td>
    </tr>
<?php
        }
    }catch(Exception $e){
        echo $e->getMessage();
    }

?>
</table>

 查询表某个字段，并存入session方法：

$sql="select * from tb_user where regname=? and regpwd=?";
        $result=$pdo->prepare($sql);
        $result->execute(array($username,$pwd));
        $res=$result->fetch(PDO::FETCH_ASSOC);
        if($res!=""){
            $_SESSION["username"]=$username;
            $_SESSION["pwd"]=$pwd;        
            $_SESSION["turename"]=$res['regrealname'];
            echo "<script>