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

 

<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>