<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、智譜、豆包、星火、月之暗面及文生圖、文生視頻 廣告
                # 數據庫操作 - 新增db.class.php調用 使用全部方法,需要以對象方式調用 <http://www.hmoore.net/logoove/we7/678561> ``` <pre class="calibre14">``` <span class="token1">require_once</span><span class="token2">(</span>DEDEINC<span class="token2">.</span><span class="token4">'/Db.class.php'</span><span class="token2">)</span><span class="token2">;</span> $db <span class="token">=</span> <span class="token5">new</span> <span class="token1">Db</span><span class="token2">(</span>$GLOBALS<span class="token2">[</span><span class="token4">'cfg_dbhost'</span><span class="token2">]</span><span class="token2">,</span>$GLOBALS<span class="token2">[</span><span class="token4">'cfg_dbuser'</span><span class="token2">]</span><span class="token2">,</span>$GLOBALS<span class="token2">[</span><span class="token4">'cfg_dbpwd'</span><span class="token2">]</span><span class="token2">,</span><span class="token4">'3306'</span><span class="token2">,</span>$GLOBALS<span class="token2">[</span><span class="token4">'cfg_dbname'</span><span class="token2">]</span><span class="token2">,</span>$GLOBALS<span class="token2">[</span><span class="token4">'cfg_dbprefix'</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> ``` ``` - 單條數據 ``` <pre class="calibre14">``` global $dsql<span class="token2">;</span> $row <span class="token">=</span> $dsql<span class="token">-</span><span class="token">></span><span class="token1">GetOne</span><span class="token2">(</span><span class="token4">"SELECT * FROM hx_arctype WHERE id= $id"</span><span class="token2">)</span><span class="token2">;</span> 新寫法 global $db<span class="token2">;</span> $row <span class="token">=</span>$db<span class="token">-</span><span class="token">></span><span class="token1">get</span><span class="token2">(</span><span class="token4">'arctype'</span><span class="token2">,</span><span class="token1">array</span><span class="token2">(</span><span class="token4">'id'</span><span class="token">=</span><span class="token">></span>$id<span class="token2">)</span><span class="token2">)</span><span class="token2">;</span> ``` ``` - 多條數據 ``` <pre class="calibre14">``` $sql <span class="token">=</span> <span class="token4">"Select * from #@__arctype"</span><span class="token2">;</span> $dsql<span class="token">-</span><span class="token">></span><span class="token1">SetQuery</span><span class="token2">(</span>$sql<span class="token2">)</span><span class="token2">;</span> $dsql<span class="token">-</span><span class="token">></span><span class="token1">Execute</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> <span class="token5">while</span><span class="token2">(</span>$row <span class="token">=</span> $dsql<span class="token">-</span><span class="token">></span><span class="token1">GetArray</span><span class="token2">(</span><span class="token2">)</span><span class="token2">)</span><span class="token2">{</span> $row1<span class="token2">[</span><span class="token2">]</span><span class="token">=</span> <span class="token2">[</span><span class="token4">'id'</span><span class="token">=</span><span class="token">></span>$row<span class="token2">[</span><span class="token4">'id'</span><span class="token2">]</span><span class="token2">,</span><span class="token4">'typename'</span><span class="token">=</span><span class="token">></span>$row<span class="token2">[</span><span class="token4">'typename'</span><span class="token2">]</span><span class="token2">]</span><span class="token2">;</span> <span class="token2">}</span> $n<span class="token">=</span> $dsql<span class="token">-</span><span class="token">></span><span class="token1">GetTotalRow</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> 總記錄數 新寫法 global $db<span class="token2">;</span> $db<span class="token">-</span><span class="token">></span><span class="token1">getall</span><span class="token2">(</span><span class="token4">'arctype'</span><span class="token2">)</span><span class="token2">;</span> ``` ``` - 插入刪除修改 ``` <pre class="calibre16">``` $sql <span class="token">=</span> <span class="token4">"insert into hx_arctype (typename) VALUES ('測試')"</span><span class="token2">;</span> $dsql<span class="token">-</span><span class="token">></span><span class="token1">ExecNoneQuery</span><span class="token2">(</span>$sql<span class="token2">)</span><span class="token2">;</span> $id <span class="token">=</span> $dsql<span class="token">-</span><span class="token">></span><span class="token1">GetLastID</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span>插入id $sql <span class="token">=</span> <span class="token4">"delete from hx_arctype where id=12"</span><span class="token2">;</span> $dsql<span class="token">-</span><span class="token">></span><span class="token1">ExecNoneQuery</span><span class="token2">(</span>$sql<span class="token2">)</span><span class="token2">;</span> $sql <span class="token">=</span> <span class="token4">"update hx_arctype set typename='12' where id=13"</span><span class="token2">;</span> $dsql<span class="token">-</span><span class="token">></span><span class="token1">ExecNoneQuery</span><span class="token2">(</span>$sql<span class="token2">)</span><span class="token2">;</span> 新寫法 global $db<span class="token2">;</span> $db<span class="token">-</span><span class="token">></span><span class="token1">insert</span><span class="token2">(</span><span class="token4">'demo'</span><span class="token2">,</span><span class="token1">array</span><span class="token2">(</span><span class="token2">)</span><span class="token2">)</span><span class="token2">;</span> $id <span class="token">=</span> $db<span class="token">-</span><span class="token">></span><span class="token1">insertid</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span>插入id $db<span class="token">-</span><span class="token">></span><span class="token1">update</span><span class="token2">(</span><span class="token4">'demo'</span><span class="token2">,</span><span class="token2">[</span><span class="token4">'num +='</span><span class="token">=</span><span class="token">></span><span class="token3">1</span><span class="token2">]</span><span class="token2">,</span><span class="token2">[</span><span class="token4">'id'</span><span class="token">=</span><span class="token">></span><span class="token3">1</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> $db<span class="token">-</span><span class="token">></span><span class="token1">delete</span><span class="token2">(</span><span class="token4">'demo'</span><span class="token2">,</span><span class="token2">[</span><span class="token4">'id'</span><span class="token">=</span><span class="token">></span><span class="token3">1</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> $db<span class="token">-</span><span class="token">></span><span class="token1">delete</span><span class="token2">(</span><span class="token4">'demo'</span><span class="token2">,</span> <span class="token4">"id IN ('"</span><span class="token2">.</span><span class="token1">implode</span><span class="token2">(</span><span class="token4">"','"</span><span class="token2">,</span> $deleteid<span class="token2">)</span><span class="token2">.</span><span class="token4">"')"</span><span class="token2">)</span><span class="token2">;</span><span class="token6">//多選刪除</span> ``` ```
                  <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>

                              哎呀哎呀视频在线观看