PHP 学习1.1

PHP连接MySQL示例

最新推荐文章于 2025-09-04 15:29:44 发布

转载最新推荐文章于 2025-09-04 15:29:44 发布 · 46 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/linsu/p/3469553.html

文章标签：

#php #数据库

1 链接mysql 数据简单测试

<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<?php
$mysqli = new mysqli();
$mysqli->connect("localhost","root","sulin","test");
if($mysqli->errno == 0)
        {
           $sql = "SELECT * FROM table_1";
           $result = $mysqli->query($sql);
           echo "<br/>Result row nums:".$result->num_rows."<br/>";
           while(list($id,$name,$birthday,$remark) = $result->fetch_row())
           {
               echo "$id : $name : $birthday : $remark"."<br/>";
           }
        }
        else
        {
            echo "The Connection is Error!";
            exit();
        }

$mysqli->close();
?>
</body>
</html>

mysql 设置：

ALTER DATABASE test DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE table_1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

SET character_set_client='utf8';
SET character_set_connection='utf8';
SET character_set_results='utf8';

php 和mysql 的字符设置必须一样，否则就是乱码

转载于:https://www.cnblogs.com/linsu/p/3469553.html