return mysql_fetch_assoc($rs);
}
//获取一个数据
public function getOne($sql)
{
$rs = $this->query($sql);
$row = mysql_fetch_row($rs);
return $row[0];
}
//关闭资源
public function close()
{
mysql_close($this->conn);
}
}
$mysql = new Mysql();
//print_r($mysql);
//$sql="INSERT into `t-student` values('','郭建华','男','20120104003')";
$sql = "select * from `t-student`";
$sql2 = "select count(*) from `t-student`";
$row = $mysql->getRow($sql);
print_r($row);
echo "<br>";
print_r($mysql->getOne($sql2));
/*
到此一个简单的sql封装类完成
改进：
insert update操作，都需要大量的拼接字符串
能否给定一个数组，数组键->列，数组值->列的值
然后自然生成insert、update语句
*/
public function getALL($sql)
{
$list = array();
$rs = $this->query($sql);
while ($row = mysql_fetch_assoc($rs)) {
$list[] = $row;
}
return $list;
}
public function getRow($sql)
{
$row = $this->query($sql);
$rs = mysql_fetch_assoc($row);
return $rs;
}
public function getOne($sql)
{
$row = $this->query($sql);
$rs = mysql_fetch_row($row);
return $rs[0];
}
public function close()
{
mysql_close($this->conn);
}
}
$mysql = new Mysql();
$sql = "select count(*) from `t-student`";
$rs = $mysql->getOne($sql);
//print_r($rs);
echo $rs;
