数据库的定义
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>";
?>