PHP mysqli扩展库-面向对象1

首先需要在php.ini当中启用如下配置。

程序实例(面向对象)

<?php

header("Content-type:text/html;charset=gbk");

//1,创建mysqli数据库对象

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

if($mysqli->connect_error){

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

}

//2,操作数据库

$sql="select * from words";

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

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

foreach ($row as $key=>$val){

echo "---$val";

}

echo "<br/>";

}

//释放内存

$res->free();

//关闭连接

$mysqli->close();

?>

程序实例(面向过程)

<?php

//mysqli扩展库，面向过程编程

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

if(!$mysqli){

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

}

//向数据库发送sql语句

$sql="select * from words";

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

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

foreach ($row as $key=>$val){

echo "--$val";

}

echo "<br/>";

}

//关闭资源

mysqli_free_result($res);

mysqli_close($mysqli);

?>