protected function fetch($sql)
    {
        try {
            try {
                $stm = Connect::getConn()->prepare($sql);
            } catch (Exception $e) {
                static::$response["status"] = "error";
                static::$response["response"] = $e->getMessage();
                static::$response['code'] = $e->getCode();
               return static::terminate(static::$response);

            }
            try {
                $stm->execute();
            } catch (Exception $e) {
                static::$response["status"] = "error";
                static::$response["response"] = $e->getMessage();
                static::$response['code'] = $e->getCode();
               return static::terminate(static::$response);
            }
        } catch (Exception $e) {
            static::$response["status"] = "error";
            static::$response["response"] = $e->getMessage();
            static::$response['code'] = $e->getCode();
           return static::terminate(static::$response);

        }
        try {
            $data = null;
            // set the resulting array to associative
            $stm->setFetchMode(PDO::FETCH_ASSOC);
            foreach (new RecursiveArrayIterator($stm->fetchAll()) as $k => $v) {
                $data[] = $v;
            }

            if ($data == null) {
                static::$response["status"] = "success";
                static::$response["response"] = Null;
                static::$response['code'] = 300;
               return static::terminate(static::$response);
            }
            static::$response["status"] = "success";
            static::$response["response"] = $data;
            static::$response['code'] = 200;
            return static::terminate(static::$response);


        } catch (PDOException $e) {
            static::$response["status"] = "error";
            static::$response["response"] = $e->getMessage();
            static::$response["code"] = $e->getCode();
           return static::terminate(static::$response);
        }


    }
protected function fetch($sql)
    {
        try {
            try {
                $stm = Connect::getConn()->prepare($sql);
            } catch (Exception $e) {
                static::$response["status"] = "error";
                static::$response["response"] = $e->getMessage();
                static::$response['code'] = $e->getCode();
               return static::terminate(static::$response);

            }
            try {
                $stm->execute();
            } catch (Exception $e) {
                static::$response["status"] = "error";
                static::$response["response"] = $e->getMessage();
                static::$response['code'] = $e->getCode();
               return static::terminate(static::$response);
            }
        } catch (Exception $e) {
            static::$response["status"] = "error";
            static::$response["response"] = $e->getMessage();
            static::$response['code'] = $e->getCode();
           return static::terminate(static::$response);

        }
        try {
            $data = null;
            // set the resulting array to associative
            $stm->setFetchMode(PDO::FETCH_ASSOC);
            foreach (new RecursiveArrayIterator($stm->fetchAll()) as $k => $v) {
                $data[] = $v;
            }

            if ($data == null) {
                static::$response["status"] = "success";
                static::$response["response"] = Null;
                static::$response['code'] = 300;
               return static::terminate(static::$response);
            }
            static::$response["status"] = "success";
            static::$response["response"] = $data;
            static::$response['code'] = 200;
            return static::terminate(static::$response);


        } catch (PDOException $e) {
            static::$response["status"] = "error";
            static::$response["response"] = $e->getMessage();
            static::$response["code"] = $e->getCode();
           return static::terminate(static::$response);
        }


    }
protected function fetch ( $ sql ) { try { try { $ stm = Connect :: getConn ( ) -> prepare ( $ sql ) ; } catch ( Exception $ e ) { static :: $ response [ "status" ] = "error" ; static :: $ response [ "response" ] = $ e -> getMessage ( ) ; static :: $ response [ 'code' ] = $ e -> getCode ( ) ; return static :: terminate ( static :: $ response ) ; } try { $ stm -> execute ( ) ; } catch ( Exception $ e ) { static :: $ response [ "status" ] = "error" ; static :: $ response [ "response" ] = $ e -> getMessage ( ) ; static :: $ response [ 'code' ] = $ e -> getCode ( ) ; return static :: terminate ( static :: $ response ) ; } } catch ( Exception $ e ) { static :: $ response [ "status" ] = "error" ; static :: $ response [ "response" ] = $ e -> getMessage ( ) ; static :: $ response [ 'code' ] = $ e -> getCode ( ) ; return static :: terminate ( static :: $ response ) ; } try { $ data = null ; // set the resulting array to associative $ stm -> setFetchMode ( PDO :: FETCH_ASSOC ) ; foreach ( new RecursiveArrayIterator ( $ stm -> fetchAll ( ) ) as $ k => $ v ) { $ data [ ] = $ v ; } if ( $ data == null ) { static :: $ response [ "status" ] = "success" ; static :: $ response [ "response" ] = Null ; static :: $ response [ 'code' ] = 300 ; return static :: terminate ( static :: $ response ) ; } static :: $ response [ "status" ] = "success" ; static :: $ response [ "response" ] = $ data ; static :: $ response [ 'code' ] = 200 ; return static :: terminate ( static :: $ response ) ; } catch ( PDOException $ e ) { static :: $ response [ "status" ] = "error" ; static :: $ response [ "response" ] = $ e -> getMessage ( ) ; static :: $ response [ "code" ] = $ e -> getCode ( ) ; return static :: terminate ( static :: $ response ) ; } }
Executes a query that returns data

@param $sql
@return array|string
Executes a query that returns data