搜尋
首頁php教程php手册一个功能还算完整的数据库操作类

一个功能还算完整的数据库操作类

Jun 13, 2016 am 10:41 AM
12月mnewphp功能完整操作資料庫類別

 

<ol class="dp-c">
<li class="alt"><span><span><?php     </span></span></span></li>
<li>
<span class="comment">/*  </span> </li>
<li class="alt"><span><span class="comment">*   Author  墨龙  </span> </span></li>
<li><span><span class="comment">*   Time    2010年12月2日 15:50:35   </span> </span></li>
<li class="alt"><span><span class="comment">*/</span><span>    </span></span></li>
<li><span>    </span></li>
<li class="alt">
<span class="vars">$db</span><span> = </span><span class="keyword">new</span><span> mysql(</span><span class="vars">$db_host</span><span>,</span><span class="vars">$db_user</span><span>,</span><span class="vars">$db_password</span><span>,</span><span class="vars">$db_table</span><span>,</span><span class="vars">$db_conn</span><span>,</span><span class="vars">$pre</span><span>,</span><span class="vars">$coding</span><span>);    </span>
</li>
<li><span>    </span></li>
<li class="alt">
<span class="keyword">class</span><span> mysql{    </span>
</li>
<li><span>        </span></li>
<li class="alt">
<span>    </span><span class="keyword">private</span><span>    </span><span class="vars">$db_host</span><span>;    </span>
</li>
<li>
<span>    </span><span class="keyword">private</span><span>    </span><span class="vars">$db_user</span><span>;    </span>
</li>
<li class="alt">
<span>    </span><span class="keyword">private</span><span>    </span><span class="vars">$db_password</span><span>;    </span>
</li>
<li>
<span>    </span><span class="keyword">private</span><span>    </span><span class="vars">$db_table</span><span>;    </span>
</li>
<li class="alt">
<span>    </span><span class="keyword">private</span><span>    </span><span class="vars">$db_conn</span><span>;           </span><span class="comment">//数据库连接标识;   </span><span> </span>
</li>
<li>
<span>    </span><span class="keyword">private</span><span>    </span><span class="vars">$result</span><span>;         </span><span class="comment">//执行query命令的结果资源标识   </span><span> </span>
</li>
<li class="alt">
<span>    </span><span class="keyword">private</span><span>    </span><span class="vars">$sql</span><span>;      </span><span class="comment">//sql执行语句   </span><span> </span>
</li>
<li>
<span>    </span><span class="keyword">private</span><span>    </span><span class="vars">$pre</span><span>;      </span><span class="comment">//数据库表前缀     </span><span> </span>
</li>
<li class="alt">
<span>    </span><span class="keyword">private</span><span>    </span><span class="vars">$coding</span><span>;  </span><span class="comment">//数据库编码,GBK,UTF8,gb2312   </span><span> </span>
</li>
<li><span>        </span></li>
<li class="alt"><span>        </span></li>
<li>
<span>    </span><span class="keyword">function</span><span> __construct(</span><span class="vars">$db_host</span><span>,</span><span class="vars">$db_user</span><span>,</span><span class="vars">$db_password</span><span>,</span><span class="vars">$db_table</span><span>,</span><span class="vars">$db_conn</span><span>,</span><span class="vars">$pre</span><span>,</span><span class="vars">$coding</span><span>){    </span>
</li>
<li class="alt"><span>            </span></li>
<li>
<span>        </span><span class="vars">$this</span><span>->db_host     = </span><span class="vars">$db_host</span><span>;    </span>
</li>
<li class="alt">
<span>        </span><span class="vars">$this</span><span>->db_user     = </span><span class="vars">$db_user</span><span>;    </span>
</li>
<li>
<span>        </span><span class="vars">$this</span><span>->db_password = </span><span class="vars">$db_password</span><span>;    </span>
</li>
<li class="alt">
<span>        </span><span class="vars">$this</span><span>->db_table    = </span><span class="vars">$db_table</span><span>;    </span>
</li>
<li>
<span>        </span><span class="vars">$this</span><span>->db_conn     = </span><span class="vars">$db_conn</span><span>;    </span>
</li>
<li class="alt">
<span>        </span><span class="vars">$this</span><span>->pre         = </span><span class="vars">$pre</span><span>;    </span>
</li>
<li>
<span>        </span><span class="vars">$this</span><span>->coding      = </span><span class="vars">$coding</span><span>;    </span>
</li>
<li class="alt">
<span>        </span><span class="vars">$this</span><span>->connect();    </span>
</li>
<li><span>        </span></li>
<li class="alt"><span>    }    </span></li>
<li><span>        </span></li>
<li class="alt">
<span>    </span><span class="keyword">function</span><span> connect(){    </span>
</li>
<li><span>            </span></li>
<li class="alt">
<span>        </span><span class="vars">$this</span><span>->db_conn = @mysql_connect(</span><span class="vars">$this</span><span>->db_host,</span><span class="vars">$this</span><span>->db_user,</span><span class="vars">$this</span><span>->db_password) </span><span class="keyword">or</span><span> </span><span class="keyword">die</span><span>(</span><span class="vars">$this</span><span>->show_error(</span><span class="string">"数据库链接错误,请检查数据库链接配置!"</span><span>));    </span>
</li>
<li>
<span>        </span><span class="keyword">if</span><span>(!mysql_select_db(</span><span class="vars">$this</span><span>->db_table,</span><span class="vars">$this</span><span>->db_conn)){    </span>
</li>
<li class="alt"><span>                </span></li>
<li>
<span>            </span><span class="func">echo</span><span> </span><span class="string">"没有找到数据表:"</span><span>.</span><span class="vars">$this</span><span>->db_table;    </span>
</li>
<li class="alt"><span>        }    </span></li>
<li>
<span>        mysql_select_db(</span><span class="vars">$this</span><span>->db_t						
</span>
</li>
</ol>
陳述
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn

熱AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover

AI Clothes Remover

用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool

Undress AI Tool

免費脫衣圖片

Clothoff.io

Clothoff.io

AI脫衣器

Video Face Swap

Video Face Swap

使用我們完全免費的人工智慧換臉工具,輕鬆在任何影片中換臉!

熱門文章

熱工具

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

強大的PHP整合開發環境

記事本++7.3.1

記事本++7.3.1

好用且免費的程式碼編輯器

VSCode Windows 64位元 下載

VSCode Windows 64位元 下載

微軟推出的免費、功能強大的一款IDE編輯器

SublimeText3 Linux新版

SublimeText3 Linux新版

SublimeText3 Linux最新版

SublimeText3 英文版

SublimeText3 英文版

推薦:為Win版本,支援程式碼提示!