$rows = array(); $rs = $this->mysqli->query($sql); echo $this->mysqli->error; while ($row = $rs->fetch_assoc()) { $rows[] = $row; /*foreach($row as $key=>$value) { echo "<br/>".$key." ".$value; }*/ } //echo "Count".count($rows); echo $this->mysqli->error; return $rows; } public function __destruct() { $this->mysqli->close(); } } $db = new myDB(); $mobile = $_GET['mobile']; $pass = md5($_GET['pass']); $sql = "SELECT UserName,Mobile FROM `users` WHERE Mobile='{$mobile}' AND Password='******'"; $data = $db->query_1($sql); //echo "<pre>"; //echo "<br/>".$k." ".$v; //echo "<br/>".$k." " .$v; //echo $first."<br/>"; echo json_encode($data, JSON_FORCE_OBJECT); }