mysql 資料庫連接類

mysql教程 資料庫教程串連類
 /*
 提供一款簡單實用的mysql php教程資料庫連接代碼哦，如果你正是php 入門者可以進來看看這款資料庫代碼是不是你要找的吧。
 */

class mysql{
    private $host;
    private $user;
    private $pass;
    private $dbname;
    function __construct($host,$user,$pass,$dbname){
        $this->host=$host;
        $this->user=$user;
        $this->pass=$pass;
        $this->dbname=$dbname;
        $this->connect();
    }
    function connect(){
        $link=mysql_connect($this->host,$this->user,$this->pass)or die(mysql_error());
        if(mysql_select_db($this->dbname,$link)){
            echo "串連成功";
        }else{
           
            echo "失敗";
        }
        mysql_query("set names utf8");
       
    }
    function query($sql){
        $run=mysql_query($sql);
        return $run;    
    }
    function fn_insert($biaoming,$zdname,$value){
        $this->query("insert into $biaoming ($zdname) values ($value)");
    }
   
}

//此款資料庫連接類調用方法

$db=new mysql('localhost','root','','test');
$sql ="select * from bb ";
$query = $db->query( $sql );
while ( $rs = mysql_fetch_array( $query ) )
{
 echo '....';
}

//再利用這個類來儲存資料

$db->fn_insert('test','names',''111cn.net'');