php一个mysql操作CRUD类

php一个mysql操作CRUD类

代码如下

<?php

class ConnectionMySQL{

        //主机

        public $host="localhost";

        //数据库的username

        public $name="root";

        //数据库的password

        public $pass="wangqi";

        //数据库名称

        public $database="myweb";

        //编码形式

        //public $ut = "utf-8";


        function __construct(){

            $this->connect();

        }


        function connect(){

            $link=mysql_connect($this->host,$this->name,$this->pass) or die ($this->error());

            mysql_select_db($this->database,$link) or die("没该数据库：".$this->database);

            mysql_set_charset('utf8',$link);

        }

        function mysql_query($sql, $type = '') {

            if(!($query = mysql_query($sql)))

            {

                $this->show('error:', $sql);

            }

            return $query;

        }

        function show($message = '', $sql = '') {

            if(!$sql) echo $message;

            else echo $message.'<br>'.$sql;

        }

        function affected_rows() {

            return mysql_affected_rows();

        }

        function result($query, $row) {

            return mysql_result($query, $row);

        }

        function column_num_rows($query) {

            return mysql_num_rows($query);

        }

        function num_fields($query) {

            return mysql_num_fields($query);

        }



        function free_result($query) {

            return mysql_free_result($query);

        }

        function insert_id() {

            return mysql_insert_id();

        }



        function fetch_row($query) {

            return mysql_fetch_row($query);

        }
        function version() {

            return mysql_get_server_info();

        }

        function close() {

            return mysql_close();

        }

        //insert into data in table

        function mysql_insert($table,$name,$value){

            $insert = $this->mysql_query("insert into $table ($name) value ($value)");

            return $insert;

        }

        //delete  column value data

        function mysql_delete($table,$column,$value){

            $delete = $this->mysql_query("delete from $table where $column='$value'");

            return $delete;

        }





        //assert table  ip data exists 

        function mysql_exists($table, $ip, $value)

        {

            $count = $this->mysql_query("select count(*) from $table where $ip = '$value'");

            return  $count;



        }


        function mysql_update($table, $column, $value)

        {

            $update = $this->mysql_query("update set $table set $column = '$value'");

            return $update;

        }

        function mysql_getdata($query)

        {
            return mysql_fetch_assoc($query);
        }



    }

?>