เพิ่มความสามารถ RESTful Services ใน CodeIgniter อย่างง่าย

/api/v1

--
-- Table structure for table `tbl_provinces`
--

CREATE TABLE IF NOT EXISTS `tbl_provinces` (
  `province_id` int(5) NOT NULL,
  `province_code` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `province_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `province_name_eng` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `geo_id` int(5) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tbl_provinces`
--

INSERT INTO `tbl_provinces` (`province_id`, `province_code`, `province_name`, `province_name_eng`, `geo_id`) VALUES
(1, '10', 'กรุงเทพมหานคร', 'Bangkok', 2),
(2, '11', 'สมุทรปราการ', 'Samut Prakan', 2),
(3, '12', 'นนทบุรี', 'Nonthaburi', 2),
(4, '13', 'ปทุมธานี', 'Pathum Thani', 2),
(5, '14', 'พระนครศรีอยุธยา', 'Phra Nakhon Si Ayutthaya', 2),
(6, '15', 'อ่างทอง', 'Ang Thong', 2),
(7, '16', 'ลพบุรี', 'Loburi', 2),
(8, '17', 'สิงห์บุรี', 'Sing Buri', 2),
(9, '18', 'ชัยนาท', 'Chai Nat', 2),
(10, '19', 'สระบุรี', 'Saraburi', 2),
(11, '20', 'ชลบุรี', 'Chon Buri', 5),
(12, '21', 'ระยอง', 'Rayong', 5),
(13, '22', 'จันทบุรี', 'Chanthaburi', 5),
(14, '23', 'ตราด', 'Trat', 5),
(15, '24', 'ฉะเชิงเทรา', 'Chachoengsao', 5),
(16, '25', 'ปราจีนบุรี', 'Prachin Buri', 5),
(17, '26', 'นครนายก', 'Nakhon Nayok', 2),
(18, '27', 'สระแก้ว', 'Sa Kaeo', 5),
(19, '30', 'นครราชสีมา', 'Nakhon Ratchasima', 3),
(20, '31', 'บุรีรัมย์', 'Buri Ram', 3),
(21, '32', 'สุรินทร์', 'Surin', 3),
(22, '33', 'ศรีสะเกษ', 'Si Sa Ket', 3),
(23, '34', 'อุบลราชธานี', 'Ubon Ratchathani', 3),
(24, '35', 'ยโสธร', 'Yasothon', 3),
(25, '36', 'ชัยภูมิ', 'Chaiyaphum', 3),
(26, '37', 'อำนาจเจริญ', 'Amnat Charoen', 3),
(27, '39', 'หนองบัวลำภู', 'Nong Bua Lam Phu', 3),
(28, '40', 'ขอนแก่น', 'Khon Kaen', 3),
(29, '41', 'อุดรธานี', 'Udon Thani', 3),
(30, '42', 'เลย', 'Loei', 3),
(31, '43', 'หนองคาย', 'Nong Khai', 3),
(32, '44', 'มหาสารคาม', 'Maha Sarakham', 3),
(33, '45', 'ร้อยเอ็ด', 'Roi Et', 3),
(34, '46', 'กาฬสินธุ์', 'Kalasin', 3),
(35, '47', 'สกลนคร', 'Sakon Nakhon', 3),
(36, '48', 'นครพนม', 'Nakhon Phanom', 3),
(37, '49', 'มุกดาหาร', 'Mukdahan', 3),
(38, '50', 'เชียงใหม่', 'Chiang Mai', 1),
(39, '51', 'ลำพูน', 'Lamphun', 1),
(40, '52', 'ลำปาง', 'Lampang', 1),
(41, '53', 'อุตรดิตถ์', 'Uttaradit', 1),
(42, '54', 'แพร่', 'Phrae', 1),
(43, '55', 'น่าน', 'Nan', 1),
(44, '56', 'พะเยา', 'Phayao', 1),
(45, '57', 'เชียงราย', 'Chiang Rai', 1),
(46, '58', 'แม่ฮ่องสอน', 'Mae Hong Son', 1),
(47, '60', 'นครสวรรค์', 'Nakhon Sawan', 2),
(48, '61', 'อุทัยธานี', 'Uthai Thani', 2),
(49, '62', 'กำแพงเพชร', 'Kamphaeng Phet', 2),
(50, '63', 'ตาก', 'Tak', 4),
(51, '64', 'สุโขทัย', 'Sukhothai', 2),
(52, '65', 'พิษณุโลก', 'Phitsanulok', 2),
(53, '66', 'พิจิตร', 'Phichit', 2),
(54, '67', 'เพชรบูรณ์', 'Phetchabun', 2),
(55, '70', 'ราชบุรี', 'Ratchaburi', 4),
(56, '71', 'กาญจนบุรี', 'Kanchanaburi', 4),
(57, '72', 'สุพรรณบุรี', 'Suphan Buri', 2),
(58, '73', 'นครปฐม', 'Nakhon Pathom', 2),
(59, '74', 'สมุทรสาคร', 'Samut Sakhon', 2),
(60, '75', 'สมุทรสงคราม', 'Samut Songkhram', 2),
(61, '76', 'เพชรบุรี', 'Phetchaburi', 4),
(62, '77', 'ประจวบคีรีขันธ์', 'Prachuap Khiri Khan', 4),
(63, '80', 'นครศรีธรรมราช', 'Nakhon Si Thammarat', 6),
(64, '81', 'กระบี่', 'Krabi', 6),
(65, '82', 'พังงา', 'Phangnga', 6),
(66, '83', 'ภูเก็ต', 'Phuket', 6),
(67, '84', 'สุราษฎร์ธานี', 'Surat Thani', 6),
(68, '85', 'ระนอง', 'Ranong', 6),
(69, '86', 'ชุมพร', 'Chumphon', 6),
(70, '90', 'สงขลา', 'Songkhla', 6),
(71, '91', 'สตูล', 'Satun', 6),
(72, '92', 'ตรัง', 'Trang', 6),
(73, '93', 'พัทลุง', 'Phatthalung', 6),
(74, '94', 'ปัตตานี', 'Pattani', 6),
(75, '95', 'ยะลา', 'Yala', 6),
(76, '96', 'นราธิวาส', 'Narathiwat', 6),
(77, '97', 'บึงกาฬ', 'buogkan', 3);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_provinces`
--
ALTER TABLE `tbl_provinces`
  ADD PRIMARY KEY (`province_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_provinces`
--
ALTER TABLE `tbl_provinces`
  MODIFY `province_id` int(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=78;

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
require(APPPATH.'libraries/REST_Controller.php');
 
class Provinces extends REST_Controller
{
    public function index_get()
    {
        $this->response($this->db->get('tbl_provinces')->result());				
        // ดึงรายการทั้งหมด
    }
 
    public function index_post()
    {
        // สร้างรายการใหม่
    }
 
    public function index_put()
    {
        // แก้ไขรายการ
    }
 
    public function index_delete()
    {
        // ลบรายการ
    }
}

/api/v1/provinces

$this->response($this->db->get('tbl_provinces')->result());

$this->response($this->db->get('tbl_provinces')->result(),200); // HTTP 200 OK

/api/v1/provinces/1

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
require(APPPATH.'libraries/REST_Controller.php');
 
class Provinces extends REST_Controller
{
	public function index_get()
	{
		echo "<pre>";
		print_r($this->uri->segment_array());
		echo "</pre>";
		exit;
	}

}

Array
(
    [1] => api
    [2] => v1
    [3] => provinces
    [4] => 1
)

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
require(APPPATH.'libraries/REST_Controller.php');
 
class Provinces extends REST_Controller
{
	public function index_get()
	{
		if($this->uri->segment(4)){
			$query =  $this->db->get_where("tbl_provinces",array('province_id'=>$this->uri->segment(4)));
		}else{
			$query =  $this->db->get('tbl_provinces');
		}
		$this->response($query->result());
	}

}

/api/v1/provinces?fields=province_id,province_name

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
require(APPPATH.'libraries/REST_Controller.php');
 
class Provinces extends REST_Controller
{
	public function index_get()
	{
		if($this->get('fields') && $this->get('fields')!=""){
			$this->db->select($this->get('fields'));
		}
		if($this->uri->segment(4)){
			$query =  $this->db->get_where("tbl_provinces",array('province_id'=>$this->uri->segment(4)));
		}else{
			$query =  $this->db->get('tbl_provinces');
		}
		$this->response($query->result());		
	}

}

/api/v1/provinces/1?fields=province_id,province_name

/api/v1/provinces/?fields=province_id,province_name&limit=5

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
require(APPPATH.'libraries/REST_Controller.php');
 
class Provinces extends REST_Controller
{
	public function index_get()
	{
		if($this->get('fields') && $this->get('fields')!=""){
			$this->db->select($this->get('fields'));
		}
		if($this->get('limit') && $this->get('limit')!=""){			
			$this->db->limit((int) $this->get('limit'));
		}		
		if($this->uri->segment(4)){
			$query =  $this->db->get_where("tbl_provinces",array('province_id'=>$this->uri->segment(4)));
		}else{
			$query =  $this->db->get('tbl_provinces');
		}		
		$this->response($query->result());
	}

}

/api/v1/provinces/?fields=province_id&limit=5&page=2

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
require(APPPATH.'libraries/REST_Controller.php');
 
class Provinces extends REST_Controller
{
	public function index_get()
	{
		if($this->get('fields') && $this->get('fields')!=""){
			$this->db->select($this->get('fields'));
		}
		if($this->get('limit') && $this->get('limit')!=""){	
			if($this->get('page') && $this->get('page')!=""){	
				$offset_page = ((int) $this->get('page')-1)*(int) $this->get('limit');
				$this->db->limit((int) $this->get('limit'),$offset_page);
			}else{
				$this->db->limit((int) $this->get('limit'));
			}
		}		
		if($this->uri->segment(4)){
			$query =  $this->db->get_where("tbl_provinces",array('province_id'=>$this->uri->segment(4)));
		}else{
			$query =  $this->db->get('tbl_provinces');
		}		
		$this->response($query->result());
	}

}

/api/v1/provinces/?limit=5&sort=province_id desc,province_name asc

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
require(APPPATH.'libraries/REST_Controller.php');
 
class Provinces extends REST_Controller
{
	public function index_get()
	{
		if($this->get('fields') && $this->get('fields')!=""){
			$this->db->select($this->get('fields'));
		}
		if($this->get('sort') && $this->get('sort')!=""){	
			$this->db->order_by($this->get('sort'));
		}				
		if($this->get('limit') && $this->get('limit')!=""){	
			if($this->get('page') && $this->get('page')!=""){	
				$offset_page = ((int) $this->get('page')-1)*(int) $this->get('limit');
				$this->db->limit((int) $this->get('limit'),$offset_page);
			}else{
				$this->db->limit((int) $this->get('limit'));
			}
		}		
		if($this->uri->segment(4)){
			$query =  $this->db->get_where("tbl_provinces",array('province_id'=>$this->uri->segment(4)));
		}else{
			$query =  $this->db->get('tbl_provinces');
		}		
		$this->response($query->result());
	}

}

$this->db->db_debug = false;

$this->response(NULL, REST_Controller::HTTP_BAD_REQUEST);

$this->response(NULL, 400);

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
require(APPPATH.'libraries/REST_Controller.php');
 
class Provinces extends REST_Controller
{
	public function index_get()
	{
		$this->db->db_debug = false;		
		if($this->get('fields') && $this->get('fields')!=""){
			$this->db->select($this->get('fields'));
		}
		if($this->get('sort') && $this->get('sort')!=""){	
			$this->db->order_by($this->get('sort'));
		}				
		if($this->get('limit') && $this->get('limit')!=""){	
			if($this->get('page') && $this->get('page')!=""){	
				$offset_page = ((int) $this->get('page')-1)*(int) $this->get('limit');
				$this->db->limit((int) $this->get('limit'),$offset_page);
			}else{
				$this->db->limit((int) $this->get('limit'));
			}
		}		
		if($this->uri->segment(4)){
			$query =  $this->db->get_where("tbl_provinces",array('province_id'=>$this->uri->segment(4)));
		}else{
			$query =  $this->db->get('tbl_provinces');
		}		
		if($query){
			$this->response($query->result());				
		}else{
			$this->response(NULL, REST_Controller::HTTP_BAD_REQUEST);
		}	

	}

}

/api/v1/provinces/?fields=provinc