i have class manage users , working fine until had add more columns table , modify 2 names. 1 of modified names, function returns column content not working, colum fill data it's not printing when call function.
i rechecked many times code, looking bad typed name or something, seems fine, can't find problem...
this class:
require_once('aet.php'); class staff { private $aet; private $not_working_column; private $working_column; public function __construct() { $this->aet = new aet(); } private function generate($staff) { $this->not_working_column = $staff->not_working_column; $this->working_column = $staff->working_column; } private function addinformation($stmt) { $i = 0; $stmt->bind_result($not_working_column, $working_column); while ($stmt->fetch()) { $arraystaff[$i] = new staff(); $arraystaff[$i]->setnotworkingcolum($not_working_column); $arraystaff[$i]->setworkingcolumn($working_column); $i++; } } public function stafffromemail($email) { $mysqli = $this->aet->getaetsql(); if ($stmt = $mysqli->prepare("select * staff email = ? limit 1")) { $stmt->bind_param('s', $email); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows == 0) { $exit = false; } else { $arraystaff = $this->addinformation($stmt); $this->generate($arraystaff[0]); $exit = true; } } return $exit; } public function setnotworkingcolum($not_working_column) { $this->not_working_column = $not_working_column; } public function getnotworkingcolum() { return $this->not_working_column; } public function setworkingcolumn($working_column) { $this->working_column = $working_column; } public function getworkingcolumn() { return $this->working_column; } }
and in form users can update info
<div class="item"> <div class="input"> <input type="text" placeholder="" name="staff_info[]" value="<?php echo $staff->getnotworkingcolum(); ?>" /> </div> </div> <div class="item"> <div class="input"> <input type="text" placeholder="" name="staff_info[]" value="<?php echo $staff->getworkingcolumn(); ?>" /> </div> </div>
i've made video https://www.youtube.com/watch?v=9s_uw7ik_xy
my fault, while changing name of column missed one:
public function setpersonalphone($personal_phone) { $this->phone = $personal_phone; }
should be:
public function setpersonalphone($personal_phone) { $this->personal_phone = $personal_phone; }
Comments
Post a Comment