{"id":543,"date":"2010-11-04T14:03:11","date_gmt":"2010-11-04T14:03:11","guid":{"rendered":""},"modified":"2010-11-04T14:03:11","modified_gmt":"2010-11-04T14:03:11","slug":"543","status":"publish","type":"post","link":"https:\/\/www.poloo.org\/?p=543","title":{"rendered":"\u4e00\u4e2a\u7b80\u5355\u7684 php\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b MysqlDB"},"content":{"rendered":"

\u53d1\u5e03\u4e00\u4e2a\u7b80\u5355\u7684 MysqlDB \u7c7b\u3002\u5c01\u88c5\u4e86\u5e38\u7528\u76843\u4e2a\u65b9\u6cd5\u3002select(), query(), insert()\u3002\u5176\u4e2d\u5bf9\u4e8e insert() \u65b9\u6cd5\u7684\u8fd4\u56de\u7ed3\u679c\u662f\u4e2a\u6570\u7ec4\u3002\u683c\u5f0f\u5982\uff1aarray(‘return’=>false,’id’=>NULL)<\/p>\n


<?php
\/**
* class MysqlDB
*\/<\/p>\n

class MysqlDB
{
    private $host = NULL;
    private $user = NULL;
    private $password = NULL;
    private $dbName = NULL;
    private $charset = NULL;<\/p>\n

    public function MysqlDB($host, $user, $password, $dbName, $charset = 'UTF8')
    {
        $this->host        = $host;
        $this->user        = $user;
        $this->password    = $password;
        $this->dbName    = $dbName;
        $this->charset    = $charset;
    }<\/p>\n

    private function connect()
    {
        $connectId = mysql_connect($this->host,$this->user,$this->password);
        if (!$connectId)
        {
            if(DEBUG) {
                die('Could not connect: '.mysql_error());
            }
            return NULL;
        }
        return $connectId;
    }<\/p>\n

    public function select($sql)
    {
        if(strlen($sql) == 0) {
            return NULL;
        }<\/p>\n

        $connectId = $this->connect();
        if($connectId == NULL) {
            return NULL;
        }<\/p>\n

        mysql_query(\"SET NAMES $this->charset\", $connectId);<\/p>\n

        mysql_select_db($this->dbName, $connectId);<\/p>\n

        $queryResult = mysql_query($sql, $connectId);
        if(!$queryResult) {
            return NULL;
        }<\/p>\n

        $result = array();
        while($row = mysql_fetch_array($queryResult))
        {
            $result[] = $row;
        }<\/p>\n

        mysql_close($connectId);<\/p>\n

        return $result;
    }<\/p>\n

    public function insert($sql)
    {
        $result = array('return'=>false, 'id'=>NULL);<\/p>\n

        if(strlen($sql) == 0) {
            return $result;
        }<\/p>\n

        $connectId = $this->connect();
        if($connectId == NULL) {
            return $result;
        }<\/p>\n

        mysql_query(\"SET NAMES $this->charset\", $connectId);<\/p>\n

        mysql_select_db($this->dbName, $connectId);<\/p>\n

        $queryResult = mysql_query($sql, $connectId);
        if(!$queryResult) {
            return $result;
        } else {
            $result['return'] = true;
        }<\/p>\n

        $lastInsertId = mysql_insert_id();
        mysql_close($connectId);
        if($lastInsertId == 0) {
            return $result;
        } else {
            $result['id'] = $lastInsertId;
        }<\/p>\n

        return $result;
    }<\/p>\n

    public function query($sql)
    {
        if(strlen($sql) == 0) {
            return false;
        }<\/p>\n

        $connectId = $this->connect();
        if($connectId == NULL) {
            return false;
        }<\/p>\n

        mysql_query(\"SET NAMES $this->charset\", $connectId);<\/p>\n

        mysql_select_db($this->dbName, $connectId);<\/p>\n

        $result = mysql_query($sql, $connectId);<\/p>\n

        mysql_close($connectId);<\/p>\n

        if(!result) {
            return false;
        } else {
            return true;
        }
    }
}<\/p>\n

?><\/p>\n

<\/code>
\u70b9\u51fb\u4e0b\u8f7d\u6b64\u6587\u4ef6<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u53d1\u5e03\u4e00\u4e2a\u7b80\u5355\u7684 MysqlDB \u7c7b\u3002\u5c01\u88c5\u4e86\u5e38\u7528\u76843\u4e2a\u65b9\u6cd5\u3002selec...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-543","post","type-post","status-publish","format-standard","hentry","category-Php"],"_links":{"self":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts\/543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=543"}],"version-history":[{"count":0,"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts\/543\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}