mysqli扩展库是mysql扩展库的改进版本,在mysql扩展库的基础上提高了稳定性和效率,mysqli扩展库有两套东西,一套就是面向过程的mysqli另一套是面向对象的mysqli。操作方式大体和mysql扩展库大体一致,这次还是先抽取出来一个操作mysql的工具类,和调用的类。
1.mysqli扩展库操作数据库工具类
<span style="color: #000000;">php
</span><span style="color: #008000;">//</span><span style="color: #008000;">数据库操作类</span>
<span style="color: #0000ff;">class</span><span style="color: #000000;"> DBUtil{
</span><span style="color: #0000ff;">private</span> <span style="color: #800080;">$host</span>="localhost"<span style="color: #000000;">;
</span><span style="color: #0000ff;">private</span> <span style="color: #800080;">$username</span>="root"<span style="color: #000000;">;
</span><span style="color: #0000ff;">private</span> <span style="color: #800080;">$password</span>="123456"<span style="color: #000000;">;
</span><span style="color: #0000ff;">private</span> <span style="color: #800080;">$dbname</span>="student"<span style="color: #000000;">;
</span><span style="color: #0000ff;">private</span> <span style="color: #800080;">$conn</span><span style="color: #000000;">;
</span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">function</span><span style="color: #000000;"> DBUtil(){
</span><span style="color: #800080;">$this</span>->conn=<span style="color: #0000ff;">new</span> mysqli(<span style="color: #800080;">$this</span>->host, <span style="color: #800080;">$this</span>->username, <span style="color: #800080;">$this</span>->password,<span style="color: #800080;">$this</span>->dbname) or <span style="color: #0000ff;">die</span>(<span style="color: #800080;">$this</span>->conn-><span style="color: #000000;">connect_error);
}
</span><span style="color: #008000;">//</span><span style="color: #008000;">查询</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">function</span> query(<span style="color: #800080;">$sql</span><span style="color: #000000;">){
</span><span style="color: #800080;">$all</span>= <span style="color: #800080;">$this</span>->conn->query(<span style="color: #800080;">$sql</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">return</span> <span style="color: #800080;">$all</span><span style="color: #000000;">;
}
</span><span style="color: #008000;">//</span><span style="color: #008000;">插入,修改,删除</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">function</span> otherOperate(<span style="color: #800080;">$sql</span><span style="color: #000000;">){
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$this</span>->conn->query(<span style="color: #800080;">$sql</span><span style="color: #000000;">)){
</span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$this</span>->conn->affected_rows>0<span style="color: #000000;">){
</span><span style="color: #0000ff;">return</span> "OK"<span style="color: #000000;">;
}</span><span style="color: #0000ff;">else</span><span style="color: #000000;">{
</span><span style="color: #0000ff;">return</span> "ERROOR"<span style="color: #000000;">;
}
}
}
</span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">function</span><span style="color: #000000;"> close(){
</span><span style="color: #800080;">$this</span>->conn-><span style="color: #000000;">close();
}
}
</span>?>
2.下面是具体的调用工具类的代码
<span style="color: #000000;">php
</span><span style="color: #0000ff;">require_once</span> "MySQLUtil.php"<span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">$sql="select * from m_student";
$util=new DBUtil();
$result=$util->query($sql);
while($row=$result->fetch_assoc()){
echo "$row[stuName]"."";
}
$result->free();
$util->close();</span><span style="color: #008000;">*/</span>
<span style="color: #800080;">$sql</span>="update m_student set stuName='杨幂' where id=3"<span style="color: #000000;">;
</span><span style="color: #800080;">$util</span>=<span style="color: #0000ff;">new</span><span style="color: #000000;"> DBUtil();
</span><span style="color: #800080;">$result</span>=<span style="color: #800080;">$util</span>->otherOperate(<span style="color: #800080;">$sql</span><span style="color: #000000;">);
</span><span style="color: #0000ff;">echo</span> <span style="color: #800080;">$result</span><span style="color: #000000;">;
</span><span style="color: #800080;">$util</span>-><span style="color: #000000;">close();
</span>?>
参考阅读:www.manongjc.com/article/1206.html
php免费学习视频:立即使用
踏上前端学习之旅,开启通往精通之路!从前端基础到项目实战,循序渐进,一步一个脚印,迈向巅峰!










