php - Error getting results from MySQL database -
this class connecting database when create instance of class gives me error: fatal error: phone call undefined method db::query() in c:\apache24\htdocs\core\db.class.php on line 21.
<?php class db { protected $db_name = "data_db"; protected $db_user = "root"; protected $db_pass = "root"; protected $db_host = "localhost"; public function __construct() { $db = new mysqli($this->db_host, $this->db_user, $this->db_pass, $this->db_name); if ($db->connect_errno) { printf("connection failed: %s\n", $db->connect_error); exit(); } else homecoming $db; } } $db = new db(); $data_row = $db->query("select * `users`"); while($data = $data_row->fetch_assoc()) echo $data["first_name"] . '<br>'; ?> fatal error: phone call undefined method db::query() in c:\apache24\htdocs\core\db.class.php on line 21
constructors don't homecoming custom values, homecoming instance of class. test utilize var_dump( $db ); , output object(db) .... save connection property of object like:
public function __construct() { $this->mysqli = new mysqli($this->db_host, $this->db_user, $this->db_pass, $this->db_name); } $db = new db(); $data_row = $db->mysqli->query("select * `users`"); php
No comments:
Post a Comment