php编程----简单的MySQL类

数据库的定义

test数据库中test表单：

create table test(
id int(5) not null primary key auto_increment,
name varchar(8) not null,
sex varchar(2) not null,
age int(2) not null,
);

表定义的不太规范，不要介意！

mysql类的定义：(mysql.inc)

<?php

class mysql

{   

       var $link;

       var $insert_re;

       var $get_val;

       function conn_mysql($host,$user,$pass)

       {

              $a=mysql_pconnect($host,$user,$pass) or die("unable conn MySQL");

              $this->link=$a;

       }

 

       function select_db($dbname)

       {

              mysql_select_db($dbname) or die("unbale select database!");

       }

 

       function insert($tbname,$cell,$val)

       {

              if($cell=="" or !isset($cell) or $cell==1)

              {

                     $sql="insert into ".$tbname." values(".$val.")";

                     $re=mysql_query($sql);

                     $this->insert_re=$re;

              }

              else

              {

                     $sql="insert into ".$tbname."(".$cell.") values(".$val.")";

                     $re=mysql_query($sql);

                     $this->insert_re=$re;

              }

       }

 

       function get_values($tbname,$cell,$where)

       {

              unset($this->get_val);     //格式化get_val;

 

              if($cell==1)

              {

                     if($where==1) //没有控制条件时

                     {

                            $sql="select * from ".$tbname;

                            $re=mysql_query($sql);

                            while($row=mysql_fetch_row($re))

                            {

                                   foreach($row as $key=>$val)

                                   {

                                          $this->get_val[]=$val;

                                   }

                            }

                     }

                    

                     else

                     {

                            $sql="select * from ".$tbname." where ".$where; //有控制条件时

                            $re=mysql_query($sql);

                            while($row=mysql_fetch_row($re))

                            {

                                   foreach($row as $key=>$val)

                                   {

                                          $this->get_val[]=$val;

                                   }

                            }

                     }

              }

 

              else

              {

                     if($where==1) //没有控制条件时

                     {

                            $sql="select ".$cell." from ".$tbname;

                            $re=mysql_query($sql);

                            while($row=mysql_fetch_row($re))

                            {

                                   foreach($row as $key=>$val)

                                   {

                                          $this->get_val[]=$val;

                                   }

                            }

                     }

                    

                     else

                     {

                            $sql="select ".$cell." from ".$tbname." where ".$where; //有控制条件时

                            $re=mysql_query($sql);

                            while($row=mysql_fetch_row($re))

                            {

                                   foreach($row as $key=>$val)

                                   {

                                          $this->get_val[]=$val;

                                   }

                            }

                     }

              }

       }

 

}

?>

 

 

综合实例：

<?php

include("mysql.inc");

$sql=new mysql;

$sql->conn_mysql("localhost","root","123");

$sql->select_db("test");

$sql->insert("test","name,sex,age","'dx_andy','男',23");

$sql->get_values("test","name","name='小'");

if(isset($sql->get_val))

{

       print_r($sql->get_val);

}

else echo "对不起，数据库中没有此数据";

echo "<br>";

$sql->get_values("test",1,1);

if($sql->get_val)

{

       print_r($sql->get_val);

}

else echo "对不起，数据库中没有此数据";

echo "<br>";

?>