用mysql还是 mysqli_通常是用mysql还是mysqli

一般是用mysql还是mysqli啊

为什么会有mysqli啊

------解决方案--------------------

新版本的PHP都废弃mysql_系列函数了，显然建议用mysqli 啦。

------解决方案--------------------

mysqli是面向对象，当然也可以面向过程

面向对象

$mysqli=new mysqli("localhost","root","123456","test");

if($mysqli->connect_error){

die("连接失败".$mysqli->conect_error);

}

$sql="select * from user1";

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

while($row=$res->fetch_row()){

foreach($row as $k=>$v){

echo "--$v";

}

echo "";

}

$res->free();

$mysqli->close();

面向过程

$mysqli=mysqli_connect("localhost","root","123456","test");

if(!$mysqli){

die("连接失败".mysqli_connect_error($mysqli));

}

$sql="select * from user1";

$res=mysqli_query($mysqli,$sql);

while($row=mysqli_fetch_row($res)){

foreach($row as $k=>$v){

echo "--$v";

}

echo "";

}

mysqli_free_result($res);

mysqli_close($mysqli);

------解决方案--------------------

首选 PDO

其次 mysqli

相关文章

相关视频