通常是用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

