php - Codeigniter RESTful API

Question

我有一个 mysql 数据库，其中有一个表，其中包含多个品牌的汽车。我需要为所有人创建一个 API，所以现在我有这样的东西:

<?php

require(APPPATH.'libraries/REST_Controller.php');

class carcollection extends REST_Controller{

// AUDI
public function audi_get()  
{ 
    $this->load->database();
    $sql = "SELECT car_id, car_brand, car_model FROM `cars` WHERE car_brand LIKE 'Audi' LIMIT 10";
    $query = $this->db->query($sql);
    $data = $query->result();

}

// BMW
public function bmw_get()  
{ 
    $this->load->database();
    $sql = "SELECT car_id, car_brand, car_model FROM `cars` WHERE car_brand LIKE 'BMW' LIMIT 10";
    $query = $this->db->query($sql);
    $data = $query->result();

}

...etc..etc.

到目前为止，这工作得很好，例如，当我输入 http://localhost/myprojects/cars/index.php/api/carcollection/audi 时，我的控制台/浏览器为我提供了正确的数据JSON 格式。当我输入 http://localhost/myprojects/cars/index.php/api/carcollection/ - 我收到错误 {"status":false,"error":"Unknown method ."} - 但我想知道如何才能做到这一点，以便一次获得所有数据？与之前显示的 URL 基本没有改变 SQL 查询...

感谢任何帮助...

Answer 1

您需要包含索引路由:

public function index_get() {
    $this->load->database();
    $sql = "SELECT car_id, car_brand, car_model FROM `cars` LIMIT 10";
    $query = $this->db->query($sql);
    $data = $query->result();
}