2015년 10월 21일 수요일

[PHP] MySQL class in PHP.NET

Heres a easy to use MySQL class for any website

<?php
    class mysql_db {
        //+======================================================+
        function sql_connect($sqlserver, $sqluser, $sqlpassword, $database) {
            $this->connect_id = mysql_connect($sqlserver, $sqluser, $sqlpassword);
            if($this->connect_id) {
                if (mysql_select_db($database)) {
                    return $this->connect_id;
                } else {
                    return $this->error();
                }
            } else {
                return $this->error();
            }
        }
        //+======================================================+
        function error() {
            if(mysql_error() != '') {
                echo '<b>MySQL Error</b>: '.mysql_error().'<br/>';
            }
        }
        //+======================================================+
        function query($query) {
            if ($query != NULL) {
                $this->query_result = mysql_query($query, $this->connect_id);
                if(!$this->query_result) {
                    return $this->error();
                } else {
                    return $this->query_result;
                }
            } else {
                return '<b>MySQL Error</b>: Empty Query!';
            }
        }
        //+======================================================+
        function get_num_rows($query_id = "") {
            if ($query_id == NULL) {
                $return = mysql_num_rows($this->query_result); 
            } else {
                $return = mysql_num_rows($query_id);
            }
            if (!$return) {
                $this->error();
            } else {
                return $return;
            }
        }
        //+======================================================+
        function fetch_row($query_id = ""){
            if($query_id == NULL){
                $return = mysql_fetch_array($this->query_result); 
            }else{
                $return = mysql_fetch_array($query_id);
            }
            if(!$return){
                $this->error();
            }else{
                return $return;
            }
        }    
        //+======================================================+
        function get_affected_rows($query_id = "") {
            if($query_id == NULL) {
                $return = mysql_affected_rows($this->query_result); 
            } else {
                $return = mysql_affected_rows($query_id);
            }
            if(!$return) {
                $this->error();
            } else {
                return $return;
            }
        }
        //+======================================================+
        function sql_close(){
            if($this->connect_id){
                return mysql_close($this->connect_id);
            }
        }
        //+======================================================+    
    }
    /* Example */
    $DB = new mysql_db();
    $DB->sql_connect('sql_host', 'sql_user', 'sql_password', 'sql_database_name');
    $DB->query("SELECT * FROM `members`");
    $DB->sql_close();
?>




댓글 없음:

댓글 쓰기