douliu8327 2016-10-12 10:44
浏览 54
已采纳

php类和从数据库中检索数据的对象

I have some doubts in php classes and objects. Just assume that, database contain member details like member id name,age,dob,address etc, i need to retrive member details by passing member id by php classes and object. Sorry for my english,

<?php
  class members{
  public $var;
  public function displaymembername($var){

  require 'config.php';
  $reg= $this->var;
   $sql = "SELECT  student_name, class_name, reg_no FROM students_profile WHERE student_id='$reg'";
    $result = $conn->query($sql);

  if ($result->num_rows > 0) {

   while($row = $result->fetch_assoc()) {
      echo "Reg no : " . $row["reg_no"]. " - Name: " . $row["student_name"]. " Class " . $row["class_name"]. "<br>";
    }
  }
      return $var;       
    }
}
   $displayname = new members;

  echo $displayname->displaymembername(24);
 ?>

Thanks in advance

  • 写回答

1条回答 默认 最新

  • douxianliu6756 2017-03-18 12:31
    关注

    You can start with changing $reg= $this->var; to `$req=$var´ or assign ´$var´ to ´$this->var´ before using it and see if that works – rypskar Oct 12 '16 at 11:41

    This solves my problem

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 metadata提取的PDF元数据,如何转换为一个Excel
  • ¥15 关于arduino编程toCharArray()函数的使用
  • ¥100 vc++混合CEF采用CLR方式编译报错
  • ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误,如何解决?
  • ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
  • ¥15 c#逐行读取txt文本,但是每一行里面数据之间空格数量不同
  • ¥50 如何openEuler 22.03上安装配置drbd
  • ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
  • ¥15 无线连接树莓派,无法执行update,如何解决?(相关搜索:软件下载)
  • ¥15 Windows11, backspace, enter, space键失灵