1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | <?php class Test { private static $link; public $statement = "SELECT * FROM table"; public function Test() { $this->link = new mysqli("127.0.0.1", "username", "password", "database", "port"); } public function poll() { $query = $this->link->query(self::statement); while( $row = $query->fetch_assoc() ) { $rows[] = $row; } return $rows; } } |