1#@!#!123s

: / home / ksclnmuac / public_html / alumni / application / models / admin /

Filename : LocationManagement.php

back

<?php

/**
 * Description of User
 *
 * @author Softpro India Pvt. Ltd.
 */
class LocationManagement extends CI_Model {

    //put your code here

    function getStates() {
        $this->db->select("*");
        $this->db->from("tbl_state");
        $this->db->order_by("state", "ASC");
        return $this->db->get();
    }

    function getCities($state = '') {
        $this->db->select("*");
        $this->db->from("tbl_city");
        if ($state != '') {
            $this->db->where("state", $state);
        }
        $this->db->order_by("city","ASC");
        return  $this->db->get();
    }
    function getCountries(){
        $this->db->select("*");
        $this->db->from("tbl_countries");
        $this->db->order_by("country_name", "ASC");
        return $this->db->get();
    }

}