时间:2021-07-01 10:21:17 帮助过:2人阅读
class PicInfo
{
// $sql= "select * from userinfo where username='$name' "; //书写sql
public function PicInfo($sql)
{
require_once("db_config.php"); //包含配置信息.
$result= mysql_query($sql, $conn); // 执行查询语句
$this->picInfo = mysql_fetch_array($result); //返回查询结果到数组
$num_rows = mysql_num_rows($result);
mysql_query("set names UTF8");
mysql_close($conn); //关闭数据库连接
$this->getInfo($num_rows); //调用传递信息的方法.
}
// 获取信息传递给属性的方法
private function getInfo($num_rows){
$this->pid = $this->picInfo["PID"];
$this->b_img = $this->picInfo["B_img"];
$this->m_img = $this->picInfo["M_img"];
$this->s_img = $this->picInfo["S_img"];
$this->indicate = $this->picInfo["Indicate"];
$this->type = $this->picInfo["type"];
$this->row = $this->picInfo['row']=$num_rows;
}
//返回每个属性的public 方法.
public function getRow(){
return $this->row;
}
public function getPid(){
return $this->pid;
}
public function getB_img(){
return $this->b_img;
}
public function getM_img(){
return$this->m_img;
}
public function getS_img(){
return$this->s_img;
}
public function getIndicate(){
return$this->indicate;
}
public function getType(){
return$this->type;
}
}
class edit_img
{
public function edit_img($sql)
{
require_once("db_config.php"); //包含配置信息.
$result= mysql_query($sql,$conn); // 执行查询语句
$row=mysql_affected_rows(); //返回查询结果到数组
if($row<=0)
{
echo "";
}
else{
echo "有".$row."组数据受到影响";