Exemplo n.º 1
0
 function getMemberByID($memid)
 {
     $sql = "SELECT * FROM `tbl_member` WHERE `mem_id`=\"{$memid}\" ";
     $objdata = new CLS_MYSQL();
     $objdata->Query($sql);
     if ($objdata->Num_rows() > 0) {
         $rows = $objdata->Fetch_Assoc();
         $this->pro['ID'] = $rows['mem_id'];
         $this->pro['UserName'] = $rows['username'];
         $this->pro['Password'] = $rows['password'];
         $this->pro['FirstName'] = $rows['firstname'];
         $this->pro['LastName'] = $rows['lastname'];
         $this->pro['Birthday'] = $rows['birthday'];
         $this->pro['Gender'] = $rows['gender'];
         $this->pro['Address'] = $rows['address'];
         $this->pro['Phone'] = $rows['phone'];
         $this->pro['Mobile'] = $rows['mobile'];
         $this->pro['Email'] = $rows['email'];
         $this->pro['Joindate'] = $rows['joindate'];
         $this->pro['LastLogin'] = $rows['lastlogin'];
         $this->pro['Gmember'] = $rows['gmem_id'];
         $this->pro['isActive'] = $rows['isactive'];
     }
 }