WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Oct 08, 2016 pm 04:04 PM

mysqli擴展庫是mysql擴展庫的改進版本，在mysql擴展庫的基礎(chǔ)上提高了穩(wěn)定性和效率，mysqli擴展庫有兩套東西，一套就是面向過程的mysqli另一套是面向?qū)ο蟮膍ysqli。操作方式大體和mysql擴展庫大體一致，這次還是先抽取出來一個操作mysql的工具類，和調(diào)用的類。

1.mysqli擴展庫操作數(shù)據(jù)庫工具類

<span style="color: #000000;">php
 </span><span style="color: #008000;">//</span><span style="color: #008000;">數(shù)據(jù)庫操作類</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.下面是具體的調(diào)用工具類的代碼

<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

本站聲明

本文內(nèi)容由網(wǎng)友自發(fā)貢獻，版權(quán)歸原作者所有，本站不承擔相應法律責任。如您發(fā)現(xiàn)有涉嫌抄襲侵權(quán)的內(nèi)容，請聯(lián)系admin@php.cn