public static function showMessages() { $db = Db::getConnection(); $query = 'SELECT * FROM messages'; $result = $db->prepare($query); $result->execute(); $row = $result->rowCount(); if ($row) { $arrayOfChunk = array(); $query = 'SELECT * FROM messages JOIN users ON users.user_id=messages.user_id ORDER BY message_date'; $result = $db->prepare($query); $result->execute(); $rows = $result->rowCount(); for ($j = 0; $j < $rows; $j++) { $chunkRow = $result->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT, $j); $chunkRow['user_message'] = stripslashes($chunkRow['user_message']); if ($chunkRow['is_visible']) { $arrayOfChunk[] = $chunkRow; } else { continue; } } return $arrayOfChunk; } return false; }
public static function fetchCities() { $db = Db::getConnection(); $arrayOfCities = array(); $query = "SELECT * FROM cities WHERE region_id='" . $_GET['region_id'] . "'"; $result = $db->prepare($query); $result->execute(); $rows = $result->rowCount(); for ($j = 0; $j < $rows; $j++) { $chunkRow = $result->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT, $j); $arrayOfCities[] = $chunkRow; } print_r(json_encode($arrayOfCities)); }