2021-06-01

php中的phpstrom连接数据库代码

<?php
header("Content-Type:text/html;charset=utf-8");
try {
    //header("Content-Type:text/html;charset=utf8");
    $con=new PDO('mysql:host=localhost:3306/mysql?useUnicode=true&character=Encoding=utf8;dbname=mn01','root','123456');
    $con->query("set names 'utf8'");
    $sql01="insert into mk values ('小尼姑','女')";
    $ca01=$con->query($sql01);
    $sql="select * from mk";
    $cn=$con->query($sql);
    $ca=$cn->fetchAll();
    echo $ca['name'];
    if($ca)
    {
        print_r($ca);
        echo "查询成功";
    }
    else
    {
        echo "查询失败";
    }
    echo "连接成功";

}catch(PDOException $e)
{
    echo $e->getMessage();
} finally {
   $con=null;
   echo "关闭数据库";
}
?>

接数据库