PHP连接MYSQL数据库常用方法

蛙仔

于 2021-07-08 13:56:47 发布

阅读量161

点赞数

分类专栏： PHP

本文链接：https://blog.youkuaiyun.com/weixin_43108793/article/details/118571989

版权

PHP 专栏收录该内容

1 篇文章

订阅专栏

<?php

$mySQLi = new MySQLi(DB_ADDRESS,DB_USER_NAME,DB_PASSWORD,'sk',DB_PORT);
//$mySQLi = new MySQLi("127.0.0.1","root","123456",'sk',3306);

if($mySQLi -> connect_errno){
    die('connect error' . $mySQLi -> connect_error);
}

//$mySQLi -> set_charset('utf8');//数据格式

$sql = "select * from ServerConfigInfo";

$res = $mySQLi -> query($sql);

while($row = $res -> fetch_assoc())
{
	......
}
$res -> close();
$mySQLi -> close();

?>