The Stream API order by alphabet

<?php

require_once("Rest.inc.php");

    class API extends REST {

        public $data = "";
        const demo_version = false;

        private $db     = NULL;
        private $mysqli = NULL;
        public function __construct() {
            // Init parent contructor
            parent::__construct();
            // Initiate Database connection
            $this->dbConnect();
        }

        /*
         *  Connect to Database
        */
        private function dbConnect() {
            require_once ("../includes/config.php");
            $this->mysqli = new mysqli($host, $user, $pass, $database);
            $this->mysqli->query('SET CHARACTER SET utf8');
        }

        /*
         * Dynmically call the method based on the query string
         */
        public function processApi() {
            $func = strtolower(trim(str_replace("/","",$_REQUEST['x'])));
            if((int)method_exists($this,$func) > 0)
                $this->$func();
            else
                $this->response('Ooops, no method found!',404); // If the method not exist with in this class "Page not found".
        }

        /* Api Checker */
        private function checkConnection() {
            if (mysqli_ping($this->mysqli)) {
                //echo "Responses : Congratulations, database successfully connected.";
                $respon = array(
                    'status' => 'ok', 'database' => 'connected'
                );
                $this->response($this->json($respon), 200);
            } else {
                $respon = array(
                    'status' => 'failed', 'database' => 'not connected'
                );
                $this->response($this->json($respon), 404);
            }
        }

        private function get_posts() {

            include "../includes/config.php";
            $setting_qry    = "SELECT * FROM tbl_fcm_api_key where id = '1'";
            $setting_result = mysqli_query($connect, $setting_qry);
            $settings_row   = mysqli_fetch_assoc($setting_result);
            $api_key    = $settings_row['api_key'];

            if (isset($_GET['api_key'])) {

                $access_key_received = $_GET['api_key'];

                if ($access_key_received == $api_key) {

                    if($this->get_request_method() != "GET") $this->response('',406);
                    $limit = isset($this->_request['count']) ? ((int)$this->_request['count']) : 10;
                    $page = isset($this->_request['page']) ? ((int)$this->_request['page']) : 1;

                    $offset = ($page * $limit) - $limit;
                    $count_total = $this->get_count_result("SELECT COUNT(DISTINCT n.id) FROM tbl_channel n");

                    $query = "SELECT distinct
                                n.id AS 'channel_id',
                                n.category_id,
                                n.channel_name,
                                n.channel_image,
                                n.channel_url,
                                n.channel_description,

                                c.category_name

                            FROM
                                tbl_channel n,
                                tbl_category c

                            WHERE
                                n.category_id = c.cid ORDER BY n.channel_name ASC LIMIT $limit OFFSET $offset";

                    $post = $this->get_list_result($query);
                    $count = count($post);
                    $respon = array(
                        'status' => 'ok', 'count' => $count, 'count_total' => $count_total, 'pages' => $page, 'posts' => $post
                    );
                    $this->response($this->json($respon), 200);

                } else {
                    die ('Oops, API Key is Incorrect!');
                }
            } else {
                die ('Forbidden, API Key is Required!');
            }

        }

        private function get_category_index() {

            include "../includes/config.php";
            $setting_qry    = "SELECT * FROM tbl_fcm_api_key where id = '1'";
            $setting_result = mysqli_query($connect, $setting_qry);
            $settings_row   = mysqli_fetch_assoc($setting_result);
            $api_key    = $settings_row['api_key'];

            if (isset($_GET['api_key'])) {

                $access_key_received = $_GET['api_key'];

                if ($access_key_received == $api_key) {

                    if($this->get_request_method() != "GET") $this->response('',406);
                    $count_total = $this->get_count_result("SELECT COUNT(DISTINCT cid) FROM tbl_category");

                    $query = "SELECT distinct
                                cid,
                                category_name,
                                category_image

                            FROM
                                tbl_category ORDER BY category_name ASC";

                    $news = $this->get_list_result($query);
                    $count = count($news);
                    $respon = array(
                        'status' => 'ok', 'count' => $count, 'categories' => $news
                    );
                    $this->response($this->json($respon), 200);

                } else {
                    die ('Oops, API Key is Incorrect!');
                }
            } else {
                die ('Forbidden, API Key is Required!');
            }

        }

        private function get_category_posts() {

            include "../includes/config.php";
            $setting_qry    = "SELECT * FROM tbl_fcm_api_key where id = '1'";
            $setting_result = mysqli_query($connect, $setting_qry);
            $settings_row   = mysqli_fetch_assoc($setting_result);
            $api_key    = $settings_row['api_key'];

            if (isset($_GET['api_key'])) {

                $access_key_received = $_GET['api_key'];

                if ($access_key_received == $api_key) {

                    $id = $_GET['id'];

                    if($this->get_request_method() != "GET") $this->response('',406);
                    $limit = isset($this->_request['count']) ? ((int)$this->_request['count']) : 10;
                    $page = isset($this->_request['page']) ? ((int)$this->_request['page']) : 1;

                    $offset = ($page * $limit) - $limit;
                    $count_total = $this->get_count_result("SELECT COUNT(DISTINCT id) FROM tbl_channel WHERE category_id = '$id'");

                    $query = "SELECT distinct
                                cid,
                                category_name,
                                category_image

                            FROM
                                tbl_category

                            WHERE
                                cid = '$id'

                            ORDER BY cid DESC";

                    $query2 = "SELECT distinct
                                n.id AS 'channel_id',
                                n.category_id,
                                n.channel_name,
                                n.channel_image,
                                n.channel_url,
                                n.channel_description,

                                c.category_name

                            FROM
                                tbl_channel n,
                                tbl_category c

                            WHERE
                                n.category_id = c.cid AND c.cid = '$id' ORDER BY n.channel_name ASC LIMIT $limit OFFSET $offset";

                    $category = $this->get_category_result($query);
                    $post = $this->get_list_result($query2);
                    $count = count($post);
                    $respon = array(
                        'status' => 'ok', 'count' => $count, 'count_total' => $count_total, 'pages' => $page, 'category' => $category, 'posts' => $post
                    );
                    $this->response($this->json($respon), 200);

                } else {
                    die ('Oops, API Key is Incorrect!');
                }
            } else {
                die ('Forbidden, API Key is Required!');
            }

        }

        private function get_search_results() {

            include "../includes/config.php";
            $setting_qry    = "SELECT * FROM tbl_fcm_api_key where id = '1'";
            $setting_result = mysqli_query($connect, $setting_qry);
            $settings_row   = mysqli_fetch_assoc($setting_result);
            $api_key    = $settings_row['api_key'];

            if (isset($_GET['api_key'])) {

                $access_key_received = $_GET['api_key'];

                if ($access_key_received == $api_key) {

                    $search = $_GET['search'];

                    if($this->get_request_method() != "GET") $this->response('',406);
                    $limit = isset($this->_request['count']) ? ((int)$this->_request['count']) : 10;
                    $page = isset($this->_request['page']) ? ((int)$this->_request['page']) : 1;

                    $offset = ($page * $limit) - $limit;
                    $count_total = $this->get_count_result("SELECT COUNT(DISTINCT n.id) FROM tbl_channel n, tbl_category c WHERE n.category_id = c.cid AND (n.channel_name LIKE '%$search%' OR n.channel_description LIKE '%$search%')");

                    $query = "SELECT distinct
                                n.id AS 'channel_id',
                                n.category_id,
                                n.channel_name,
                                n.channel_image,
                                n.channel_url,
                                n.channel_description,

                                c.category_name

                            FROM
                                tbl_channel n,
                                tbl_category c

                            WHERE n.category_id = c.cid AND (n.channel_name LIKE '%$search%' OR n.channel_description LIKE '%$search%')

                            LIMIT $limit OFFSET $offset";

                    $post = $this->get_list_result($query);
                    $count = count($post);
                    $respon = array(
                        'status' => 'ok', 'count' => $count, 'count_total' => $count_total, 'pages' => $page, 'posts' => $post
                    );
                    $this->response($this->json($respon), 200);

                } else {
                    die ('Oops, API Key is Incorrect!');
                }
            } else {
                die ('Forbidden, API Key is Required!');
            }

        }

        //don't edit all the code below
        private function get_list($query) {
            $r = $this->mysqli->query($query) or die($this->mysqli->error.__LINE__);
            if($r->num_rows > 0) {
                $result = array();
                while($row = $r->fetch_assoc()) {
                    $result[] = $row;
                }
                $this->response($this->json($result), 200); // send user details
            }
            $this->response('',204);    // If no records "No Content" status
        }

        private function get_list_result($query) {
            $result = array();
            $r = $this->mysqli->query($query) or die($this->mysqli->error.__LINE__);
            if($r->num_rows > 0) {
                while($row = $r->fetch_assoc()) {
                    $result[] = $row;
                }
            }
            return $result;
        }

        private function get_object_result($query) {
            $result = array();
            $r = $this->mysqli->query($query) or die($this->mysqli->error.__LINE__);
            if($r->num_rows > 0) {
                while($row = $r->fetch_assoc()) {
                    $result = $row;
                }
            }
            return $result;
        }

        private function get_category_result($query) {
            $result = array();
            $r = $this->mysqli->query($query) or die($this->mysqli->error.__LINE__);
            if($r->num_rows > 0) {
                while($row = $r->fetch_assoc()) {
                    $result = $row;
                }
            }
            return $result;
        }

        private function get_one($query) {
            $r = $this->mysqli->query($query) or die($this->mysqli->error.__LINE__);
            if($r->num_rows > 0) {
                $result = $r->fetch_assoc();
                $this->response($this->json($result), 200); // send user details
            }
            $this->response('',204);    // If no records "No Content" status
        }

        private function get_count($query) {
            $r = $this->mysqli->query($query) or die($this->mysqli->error.__LINE__);
            if($r->num_rows > 0) {
                $result = $r->fetch_row();
                $this->response($result[0], 200);
            }
            $this->response('',204);    // If no records "No Content" status
        }

        private function get_count_result($query) {
            $r = $this->mysqli->query($query) or die($this->mysqli->error.__LINE__);
            if($r->num_rows > 0) {
                $result = $r->fetch_row();
                return $result[0];
            }
            return 0;
        }

        private function post_one($obj, $column_names, $table_name) {
            $keys       = array_keys($obj);
            $columns    = '';
            $values     = '';
            foreach($column_names as $desired_key) { // Check the recipe received. If blank insert blank into the array.
              if(!in_array($desired_key, $keys)) {
                $$desired_key = '';
                } else {
                    $$desired_key = $obj[$desired_key];
                }
                $columns    = $columns.$desired_key.',';
                $values     = $values."'".$this->real_escape($$desired_key)."',";
            }
            $query = "INSERT INTO ".$table_name."(".trim($columns,',').") VALUES(".trim($values,',').")";
            //echo "QUERY : ".$query;
            if(!empty($obj)) {
                //$r = $this->mysqli->query($query) or trigger_error($this->mysqli->error.__LINE__);
                if ($this->mysqli->query($query)) {
                    $status = "success";
                $msg        = $table_name." created successfully";
                } else {
                    $status = "failed";
                $msg        = $this->mysqli->error.__LINE__;
                }
                $resp = array('status' => $status, "msg" => $msg, "data" => $obj);
                $this->response($this->json($resp),200);
            } else {
                $this->response('',204);    //"No Content" status
            }
        }

        private function post_update($id, $obj, $column_names, $table_name) {
            $keys = array_keys($obj[$table_name]);
            $columns = '';
            $values = '';
            foreach($column_names as $desired_key){ // Check the recipe received. If key does not exist, insert blank into the array.
              if(!in_array($desired_key, $keys)) {
                $$desired_key = '';
                } else {
                    $$desired_key = $obj[$table_name][$desired_key];
                }
                $columns = $columns.$desired_key."='".$this->real_escape($$desired_key)."',";
            }

            $query = "UPDATE ".$table_name." SET ".trim($columns,',')." WHERE id=$id";
            if(!empty($obj)) {
                // $r = $this->mysqli->query($query) or die($this->mysqli->error.__LINE__);
                if ($this->mysqli->query($query)) {
                    $status = "success";
                    $msg    = $table_name." update successfully";
                } else {
                    $status = "failed";
                    $msg    = $this->mysqli->error.__LINE__;
                }
                $resp = array('status' => $status, "msg" => $msg, "data" => $obj);
                $this->response($this->json($resp),200);
            } else {
                $this->response('',204);    // "No Content" status
            }
        }

        private function delete_one($id, $table_name) {
            if($id > 0) {
                $query="DELETE FROM ".$table_name." WHERE id = $id";
                if ($this->mysqli->query($query)) {
                    $status = "success";
                $msg        = "One record " .$table_name." successfully deleted";
                } else {
                    $status = "failed";
                $msg        = $this->mysqli->error.__LINE__;
                }
                $resp = array('status' => $status, "msg" => $msg);
                $this->response($this->json($resp),200);
            } else {
                $this->response('',204);    // If no records "No Content" status
            }
        }

        private function responseInvalidParam() {
            $resp = array("status" => 'Failed', "msg" => 'Invalid Parameter' );
            $this->response($this->json($resp), 200);
        }

        /* ==================================== End of API utilities ==========================================
         * ====================================================================================================
         */

        /* Encode array into JSON */
        private function json($data) {
            if(is_array($data)) {
                return json_encode($data, JSON_NUMERIC_CHECK);
            }
        }

        /* String mysqli_real_escape_string */
        private function real_escape($s) {
            return mysqli_real_escape_string($this->mysqli, $s);
        }
    }

    // Initiate Library
    $api = new API;
    $api->processApi();
?>