一般是用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

首選 PDO
其次 mysqli

pdo是不是就是pdbc啊

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);

物件導向能不用堅決不用

PHP Data Objects (PDO)
php 內建的資料庫抽象層

PHP Data Objects (PDO)
php 內建的資料庫抽象層

那php下用odbc流行嗎

Linux 中也用 ODBC 嗎？

Linux 中也用 ODBC 嗎？

也可以的，不過sql server的話，PDO_SQLSRV和PDO_ODBC應該用哪個啊，估計是odbc效能強

PDO_SQLSRV

ODBC 是通用介面，會忽視資料庫的個性特徵

