参数绑定与值绑定的小案例

摘要：<?phpheader("Content-type:text/html;charset=utf-8");$type='mysql';$host='127.0.0.1';$dbname='phpstudy';$charset='utf8';$user='root';$pwd=''

<?php

header("Content-type:text/html;charset=utf-8");

$type='mysql';

$host='127.0.0.1';

$dbname='phpstudy';

$charset='utf8';

$user='root';

$pwd='';

$dsn="$type:host=$host;dbname=$dbname;charset=$charset";

try{

    $pdo = new PDO($dsn,$user,$pwd);

}catch(PDOException $e){

    exit($e->getMessage());

}

$sql='select * from phpstudy where status=:status';

$stmt=$pdo->prepare($sql);

$status=1;

$stmt->bindParam('status',$status);

$stmt->execute();

$rows=$stmt->fetchAll(PDO::FETCH_ASSOC);

?>

<table border='1'>

    <caption>表格</caption>

    <tr>

        <th>id</th>

        <th>用户名</th>

        <th>真实姓名</th>

        <th>网名</th>

        <th>日期</th>

        <th>状态</th>

    </tr>

    <?php  foreach($rows as $row) : ?>

    <tr>

        <td><?php echo $row['id']?></td>

        <td><?php echo $row['user']?></td>

        <td><?php echo $row['name']?></td>

        <td><?php echo $row['netname']?></td>

        <td><?php echo date('Y/m/d',$row['time'])?></td>

        <td><?php echo $row['status']?'正常':'禁用'?></td>

    </tr>

    <?php endforeach?>

</table>

参数绑定必须用变量传值
值绑定不仅可以用变量传值，也可以直接将值写进去

批改老师：韦小宝批改时间：2018-12-19 17:34:33
老师总结：写的很不错！课后记得要多练习才可以哦！继续加油吧！