Как решить проблему «Notice: Trying to get property of non-object»?

Question

[Дима Tect]

Notice: Trying to get property of non-object in /home/site/public_html/../../accounts.php on line 112

100 public function getAccountsAllData($data = array()) {
101		$sql = "SELECT COUNT(*) AS count FROM `accounts`";
102		if(!empty($data)) {
103			$count = count($data);
104			$sql .= " WHERE";
105			foreach($data as $key => $value) {
106				$sql .= " $key = '" . $this->db->escape($value) . "'";
107				
108				$count--;
109				if($count > 0) $sql .= " AND";
110			}
111		}
112		$query = $this->db->query($sql);
113		$d = $query->row['count'];
114		return $d;
115	}

Answer 1

[ThunderCat]

Больше похоже на ошибку в вашей нумерации, при пустом/ошибочном запросе $query будет не объектом.
На всякий случай проверьте

...
var_dump($this->db);
$query = $this->db->query($sql);
var_dump($query);
...

Comments

[Дима Tect]

Notice: Undefined variable: sql in /home/site/public_html/appsystem/controllers/account/login.php on line 80

79            $s = $this->db;
80            $query = $this->db->query($sql);
81            $s .= $query;
82	        $result = $s;

Warning: mysqli_query(): Empty query in /home/site/public_html/core_php/database/mysql.php on line 30

29  public function query($sql) {
30		$resource = mysqli_query($this->link, $sql);
31		
32		$this->count++;
34		
35		if ($resource) {
36			if (is_resource($resource)) {
37				$i = 0;
38				$data = array();
39				
40				while($result = mysqli_fetch_assoc($resource)) {
41					$data[$i] = $result;
42					$i++;
43				}
44				
45				mysqli_free_result($resource);
46				
47				$query = new stdClass();
48				$query->row = isset($data[0]) ? $data[0] : array();
49				$query->rows = $data;
50				$query->num_rows = $i;
51				
52				unset($data);
53				return $query;	
54			} else {
55				return true;
56			}
57		}
58  	}

После того, как я указал переменную sql мне выдало ошибку
Warning: mysqli_query() expects parameter 2 to be string, array given in /home/site/public_html/core_php/database/mysql.php on line 30

Notice: Array to string conversion in /home/site/public_html/core_php/database/mysql.php on line 57