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

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

报告相同问题?