类写错了,如何只读一组数据
程序员文章站
2022-05-21 16:31:41
...
类写错了,怎么只读一组数据
class_img.php
class_img.php
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 {
echo "";
}
else{
echo "有".$row."组数据受到影响";相关文章
相关视频
上一篇: PHP从数据库掏出很多数据,循环输出在html页面的表格里
下一篇: .htaccess的伪静态规则