<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ??一站式輕松地調用各大LLM模型接口,支持GPT4、智譜、豆包、星火、月之暗面及文生圖、文生視頻 廣告
                ## 一、概述 * **MySQLi extension** ("i" 意為 improved) * **PDO (PHP Data Objects)** >[danger] MySQLi 和 PDO 有它們自己的優勢: > PDO 應用在 12 種不同數據庫中, MySQLi 只針對 MySQL 數據庫。 > 所以,如果你的項目需要在多種數據庫中切換,建議使用 PDO ,這樣你只需要修改連接字符串和部分查詢語句即可。 使用 MySQLi, 如果不同數據庫,你需要重新編寫所有代碼,包括查詢。 > 兩者都是面向對象, 但 MySQLi 還提供了 API 接口; ![](https://img.kancloud.cn/4c/8b/4c8ba83b1201004466339ec15556e40e_831x332.png) ![](https://img.kancloud.cn/72/ea/72ea5d39c7a23348c7da0f35ef3cfd44_818x306.png) ![](https://img.kancloud.cn/21/bd/21bd2512f41fbee5d84d1b2410e48fdc_821x305.png) ## 二、明細 **連接數據庫** ``` $mysqli = mysqli("localhost","root","password",person); ``` **判斷連接是否成功** ``` // 判斷錯誤碼,只要不為0即為連接失敗 if($mysqli->connect_errno){ die($mysqli->connect_error); //斷開連接并打印錯誤信息 ); ``` **操作數據庫** ``` $mysqli->query("set names utf8"); $result = $mysqli->query("INSERT INTO teacher (firstName,lastName,email,city) VALUES('jimson','zhu','18198936160@163.com','guangdongguangzhou')"); ``` **判斷操作是否成功** ``` if($result){ echo "插入成功"; }else{ echo "插入失敗"; } ``` **關閉數據庫連接** ``` $mysqli->close(); ``` ## 三、實例 增刪改類: ``` function insertData($sql) { $mysqli = mysqli("localhost","root","password",person); if($mysqli->connect_errno){ die($mysqli->connect_error); ); $mysqli->query("set names utf8"); $result = $mysqli->query($sql); if($result){ echo "插入成功"; }else{ echo "插入失敗"; } $mysqli->close(); } $sql = "INSERT INTO teacher (firstName,lastName,email,city) VALUES('中文測試','zhu','18198936160@163.com','guangdongguangzhou')"; insertData($sql); ``` 數據查詢類: ``` function fetchData($sql) { $mysqli = mysqli("localhost","root","password",person); if($mysqli->connect_errno){ die($mysqli->connect_error); ); $mysqli->query("set names utf8"); $result = $mysqli->query($sql); // 判斷查詢結果是否為空 if($result->num_rows){ // 處理查詢結果 // 有以下幾種處理方式 // 方式一:fetch_row() 返回的是一個數組 while($row = $result->fetch_row()){ print_r($row); } // 方式二:fetch_array() while($row = $result->fetch_array(MYSQLI_ASSOC)){ //以下標數組形式查詢 print_r($row); } // 方式三:fetch_all() $row = $result->fetch_all(MYSQLI_ASSOC); echo json_encode($row); // 返回json格式數據,更有利于前端處理 }else{ echo "查詢失敗"; } $mysqli->close(); } $sql = "SELECT * FROM teacher"; fetchData($sql); ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看