为什么会有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 是通用接口,会忽视数据库的个性特征
本文原创发布php中文网,转载请注明出处,感谢您的尊重!