Linux中国论坛 » PHP & Perl & python 程序开发 » 用PHP自己写的数据库操作类,very simple

lydr 发表于 2006-12-14 23:46

用PHP自己写的数据库操作类,very simple

[color=#0000bb]<?php
[/color][color=#ff8000]/**
* db_mysql.php
*
* MySQL database support
*
*
* @author: nbxmedia <nbxmedia@163.com>
* @version: $Id$
*/

[/color][color=#007700]class [/color][color=#0000bb]DB_class
[/color][color=#007700]{
    var [/color][color=#0000bb]$database [/color][color=#007700]= [/color][color=#dd0000]""[/color][color=#007700];
    var [/color][color=#0000bb]$link [/color][color=#007700]= [/color][color=#0000bb]0[/color][color=#007700];
    [/color][color=#ff8000]//useless thing.....
    [/color][color=#007700]var [/color][color=#0000bb]$server [/color][color=#007700]= [/color][color=#dd0000]"localhost"[/color][color=#007700];
    var [/color][color=#0000bb]$username [/color][color=#007700]= [/color][color=#dd0000]"root"[/color][color=#007700];
    var [/color][color=#0000bb]$password [/color][color=#007700]= [/color][color=#dd0000]""[/color][color=#007700];
    [/color][color=#ff8000]//connect to db
    [/color][color=#007700]function [/color][color=#0000bb]connect[/color][color=#007700]()
    {
        [/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]link [/color][color=#007700]= @[/color][color=#0000bb]mysql_pconnect[/color][color=#007700]([/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]server[/color][color=#007700], [/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]username[/color][color=#007700], [/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]password[/color][color=#007700]);
        if(![/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]link[/color][color=#007700])die([/color][color=#dd0000]"<b>Could not connect to mysql server:</b>"[/color][color=#007700].[/color][color=#0000bb]mysql_error[/color][color=#007700]());
        if(!@[/color][color=#0000bb]mysql_select_db[/color][color=#007700]([/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]database[/color][color=#007700], [/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]link[/color][color=#007700]))die([/color][color=#dd0000]"<b>Could not connect database:</b>"[/color][color=#007700].[/color][color=#0000bb]mysql_error[/color][color=#007700]());
    }

    [/color][color=#ff8000]//query string
    [/color][color=#007700]function [/color][color=#0000bb]query[/color][color=#007700]([/color][color=#0000bb]$string[/color][color=#007700])
    {
        if([/color][color=#0000bb]$string[/color][color=#007700])
        {
            [/color][color=#0000bb]$result [/color][color=#007700]= @[/color][color=#0000bb]mysql_query[/color][color=#007700]([/color][color=#0000bb]$string[/color][color=#007700], [/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]link[/color][color=#007700]);
            if(![/color][color=#0000bb]$result[/color][color=#007700])die([/color][color=#dd0000]"<b>error in sql string '$string':</b>"[/color][color=#007700].[/color][color=#0000bb]mysql_error[/color][color=#007700]());
            return [/color][color=#0000bb]$result[/color][color=#007700];
        }
        else
        {
            die([/color][color=#dd0000]"<b>query string was empty.</b>"[/color][color=#007700]);
        }
    }

    [/color][color=#ff8000]//fetch array
    [/color][color=#007700]function [/color][color=#0000bb]fetch[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700])
    {
        [/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]record [/color][color=#007700]= @[/color][color=#0000bb]mysql_fetch_assoc[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700]);
        return [/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]record[/color][color=#007700];
    }


    [/color][color=#ff8000]//number of query rows
    [/color][color=#007700]function [/color][color=#0000bb]num_rows[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700])
    {
        return @[/color][color=#0000bb]mysql_num_rows[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700]);
    }

    [/color][color=#ff8000]//last id key you insert to db
    [/color][color=#007700]function [/color][color=#0000bb]insert_id[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700]=[/color][color=#dd0000]""[/color][color=#007700])
    {
        return @[/color][color=#0000bb]mysql_insert_id[/color][color=#007700]();
    }

    function [/color][color=#0000bb]free[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700])
    {
        @[/color][color=#0000bb]mysql_free_result[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700]);
        return [/color][color=#0000bb]0[/color][color=#007700];
    }
}
[/color][color=#0000bb]?>[/color]

lydr 发表于 2006-12-14 23:46

[color=#0000bb]<?php
[/color][color=#ff8000]/**
* db_sqlite.php
*
* Sqlite database support
*
*
* @author: nbxmedia <nbxmedia@163.com>
* @version: $Id$
*/

[/color][color=#007700]class [/color][color=#0000bb]DB_class
[/color][color=#007700]{
    var [/color][color=#0000bb]$database [/color][color=#007700]= [/color][color=#dd0000]""[/color][color=#007700];
    var [/color][color=#0000bb]$link[/color][color=#007700];
    [/color][color=#ff8000]//useless thing.....
    [/color][color=#007700]var [/color][color=#0000bb]$server [/color][color=#007700]= [/color][color=#dd0000]""[/color][color=#007700];
    var [/color][color=#0000bb]$username [/color][color=#007700]= [/color][color=#dd0000]""[/color][color=#007700];
    var [/color][color=#0000bb]$password [/color][color=#007700]= [/color][color=#dd0000]""[/color][color=#007700];
    var [/color][color=#0000bb]$result [/color][color=#007700]= [/color][color=#0000bb]false[/color][color=#007700];
    [/color][color=#ff8000]//connect to db
    [/color][color=#007700]function [/color][color=#0000bb]connect[/color][color=#007700]()
    {
        [/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]link [/color][color=#007700]= [/color][color=#0000bb]sqlite_popen[/color][color=#007700]([/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]database[/color][color=#007700], [/color][color=#0000bb]0666[/color][color=#007700], [/color][color=#0000bb]$error[/color][color=#007700]);
        if(![/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]link[/color][color=#007700])die([/color][color=#0000bb]$error[/color][color=#007700]);
    }

     
    [/color][color=#ff8000]//query string
    [/color][color=#007700]function [/color][color=#0000bb]query[/color][color=#007700]([/color][color=#0000bb]$string[/color][color=#007700])
    {
        if([/color][color=#0000bb]$string[/color][color=#007700])
        {
            [/color][color=#0000bb]$result [/color][color=#007700]= @[/color][color=#0000bb]sqlite_query[/color][color=#007700]([/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]link[/color][color=#007700], [/color][color=#0000bb]$string[/color][color=#007700]);
            [/color][color=#ff8000]//if(!$result)die(sqlite_error_string(sqlite_last_error($result)));
            [/color][color=#007700]return [/color][color=#0000bb]$result[/color][color=#007700];
        }
        else
        {
            die([/color][color=#dd0000]"query string was empty."[/color][color=#007700]);
        }
    }
     

    [/color][color=#ff8000]//fetch array
    [/color][color=#007700]function [/color][color=#0000bb]fetch[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700])
    {
        [/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]record [/color][color=#007700]= @[/color][color=#0000bb]sqlite_fetch_array[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700], [/color][color=#0000bb]SQLITE_ASSOC[/color][color=#007700]);
        [/color][color=#ff8000]//$key = array_keys($this->record);
        [/color][color=#007700]return [/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]record[/color][color=#007700];
    }

    [/color][color=#ff8000]//number of query rows
    [/color][color=#007700]function [/color][color=#0000bb]num_rows[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700])
    {
        return @[/color][color=#0000bb]sqlite_num_rows[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700]);
    }

    [/color][color=#ff8000]//last id key you insert to db
    [/color][color=#007700]function [/color][color=#0000bb]insert_id[/color][color=#007700]()
    {
        return @[/color][color=#0000bb]sqlite_last_insert_rowid[/color][color=#007700]([/color][color=#0000bb]$this[/color][color=#007700]->[/color][color=#0000bb]link[/color][color=#007700]);
    }

    function [/color][color=#0000bb]free[/color][color=#007700]([/color][color=#0000bb]$result[/color][color=#007700])
    {
        unset([/color][color=#0000bb]$result[/color][color=#007700]);
        return [/color][color=#0000bb]0[/color][color=#007700];
    }
}
[/color][color=#0000bb]?>[/color]

lydr 发表于 2006-12-14 23:47

[color=#0000bb]<?php
[/color][color=#ff8000]//choose the database type
[/color][color=#0000bb]$db_type [/color][color=#007700]= [/color][color=#dd0000]"mysql"[/color][color=#007700];
require_once([/color][color=#dd0000]"./db_{$db_type}.php"[/color][color=#007700]);
[/color][color=#ff8000]//connect to database
[/color][color=#0000bb]$DB [/color][color=#007700]= new [/color][color=#0000bb]DB_class[/color][color=#007700];
[/color][color=#0000bb]$DB[/color][color=#007700]->[/color][color=#0000bb]server   [/color][color=#007700]= [/color][color=#dd0000]"localhost"[/color][color=#007700];
[/color][color=#0000bb]$DB[/color][color=#007700]->[/color][color=#0000bb]username [/color][color=#007700]= [/color][color=#dd0000]"name"[/color][color=#007700];
[/color][color=#0000bb]$DB[/color][color=#007700]->[/color][color=#0000bb]password [/color][color=#007700]= [/color][color=#dd0000]"pass"[/color][color=#007700];
[/color][color=#0000bb]$DB[/color][color=#007700]->[/color][color=#0000bb]database [/color][color=#007700]= [/color][color=#dd0000]"database"[/color][color=#007700];
[/color][color=#0000bb]$DB[/color][color=#007700]->[/color][color=#0000bb]connect[/color][color=#007700]();


[/color][color=#ff8000]//get general settings in db
[/color][color=#0000bb]$res [/color][color=#007700]= [/color][color=#0000bb]$DB[/color][color=#007700]->[/color][color=#0000bb]query[/color][color=#007700]([/color][color=#dd0000]"select * from do_config where c_id=1"[/color][color=#007700]);
[/color][color=#0000bb]$_CONFIG [/color][color=#007700]= [/color][color=#0000bb]$DB[/color][color=#007700]->[/color][color=#0000bb]fetch[/color][color=#007700]([/color][color=#0000bb]$res[/color][color=#007700]);
[/color][color=#0000bb]$DB[/color][color=#007700]->[/color][color=#0000bb]free[/color][color=#007700]([/color][color=#0000bb]$res[/color][color=#007700]);

[/color][color=#ff8000]//output
[/color][color=#0000bb]print_r[/color][color=#007700]([/color][color=#0000bb]$_CONFIG[/color][color=#007700]);
[/color][color=#0000bb]?>[/color]

yuyang08 发表于 2008-5-28 03:00

支持

提问:我要问百度知道知道不知道知道就知道不知道就不知道不要知道说不知道不知道说知道到头来知道变成不知道不知道还是[url=http://www.200sfw.cn/]传奇2私服IP[/url]不知道天知道地知道百度知道知道[url=http://www.200sfw.cn]传奇2私服[/url]若要问我知道不知道知道不知道也不知道。请加标点符号，眼睛不好慎入～
[url=http://www.200sfw.cn]http://www.200sfw.cn[/url]

查看完整版本: 用PHP自己写的数据库操作类,very simple