Code Igniter 3 REST Controller Project With Sqlite

1. Startup Project

This project is extended from the original tutorial at :

https://erthru.medium.com/membuat-restful-api-menggunakan-framework-codeigniter-3-f350755b1274
and
https://erthru.medium.com/membuat-restful-api-menggunakan-framework-codeigniter-3-part-2-163cadb32e3a

The author has provided a completed project codes at:
https://github.com/erthru/restCI
or
https://drive.google.com/file/d/1tYrLlnPb4Gc-9769LyoLOcYcVKf2tYl4/view?usp=sharing

2. Download codes

Download the code from the source at Step 1 above.

3. Upload codes

Upload the zip file to your server, extract the content and rename the folder as "restci".

4. Edit database configuration

Go into restci/application/config/ and edit the file database.php as follows:

'dsn' => '', 'hostname' => '', 'username' => '', 'password' => '', 'database' => './application/db/database.sqlite', 'dbdriver' => 'sqlite3', 'dbprefix' => '', 'pconnect' => FALSE, 'db_debug' => (ENVIRONMENT !== 'production'), 'cache_on' => FALSE, 'cachedir' => '', 'char_set' => 'utf8', 'dbcollat' => 'utf8_general_ci', 'swap_pre' => '', 'encrypt' => FALSE, 'compress' => FALSE, 'stricton' => FALSE, 'failover' => array(), 'save_queries' => TRUE

5. Create Database

note: it is recommended to use DB Browser application to create the database. The application can be downloaded from https://sqlitebrowser.org/dl/

CREATE TABLE "tb_person" ( "id" INTEGER NOT NULL UNIQUE, "name" TEXT, "address" TEXT, "phone" TEXT, PRIMARY KEY("id" AUTOINCREMENT) )

6. Test Web Request

You should get a json output that shows no record in the database.

{"status":200,"error":false,"person":[]}

7. Test POST Request

Use a REST Client like POSTMAN to send POST Request according to the following settings:

Header content-type: application/json Body {"name":"suprianto","address":"jln testing","phone":"123"}

8. You should get a success response as follows:

{ "status": 200 "error": false "message": "Data person ditambahkan." }

9.Repeat Step 7

go to the url {{your serverpath}}/restci/index.php/person
Now you get the following json output:
{"status":200,"error":false,"person":[{"id":1,"name":"suprianto","address":"jln testing","phone":123}]}

10.Optional

If you want to hide the index.php string in the url, you can put .htaccess file in the restci folder. Put the following codes into the file. This requires Apache mod_rewrite enabled.

File: restci/.htaccess

<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule ^(.*)$ index.php/$1 [L] </IfModule> Now you can use the following url {{your serverpath}}//restci/person

11.Appendix

File: restci/application/controllers/TestApi.php

<?php // import library dari REST_Controller require APPPATH . 'libraries/REST_Controller.php'; // extends class dari REST_Controller class TestApi extends REST_Controller{ // constructor public function __construct(){ parent::__construct(); } public function index_get(){ // testing response $response['status']=200; $response['error']=false; $response['message']='Hai from response'; // tampilkan response $this->response($response); } public function user_get(){ // testing response $response['status']=200; $response['error']=false; $response['user']['username']='erthru'; $response['user']['email']='ersaka96@gmail.com'; $response['user']['detail']['full_name']='Suprianto D'; $response['user']['detail']['position']='Developer'; $response['user']['detail']['specialize']='Android,IOS,WEB,Desktop'; //tampilkan response $this->response($response); } } ?>

Sql Command: Person

create table tb_person ( id INT(20) PRIMARY KEY NOT NULL AUTO_INCREMENT, name TEXT, address TEXT, phone TEXT)

File: restci/application/models/PersonM.php

<?php // extends class Model class PersonM extends CI_Model { // response jika field ada yang kosong public function empty_response() { $response['status'] = 502; $response['error'] = true; $response['message'] = 'Field tidak boleh kosong'; return $response; } // function untuk insert data ke tabel tb_person public function add_person($name, $address, $phone) { if (empty($name) || empty($address) || empty($phone)) { return $this->empty_response(); } else { $data = array( "name" => $name, "address" => $address, "phone" => $phone ); $insert = $this ->db ->insert("tb_person", $data); if ($insert) { $response['status'] = 200; $response['error'] = false; $response['message'] = 'Data person ditambahkan.'; return $response; } else { $response['status'] = 502; $response['error'] = true; $response['message'] = 'Data person gagal ditambahkan.'; return $response; } } } // mengambil semua data person public function all_person() { $all = $this ->db ->get("tb_person") ->result(); $response['status'] = 200; $response['error'] = false; $response['person'] = $all; return $response; } // hapus data person public function delete_person($id) { if ($id == '') { return $this->empty_response(); } else { $where = array( "id" => $id ); $this ->db ->where($where); $delete = $this ->db ->delete("tb_person"); if ($delete) { $response['status'] = 200; $response['error'] = false; $response['message'] = 'Data person dihapus.'; return $response; } else { $response['status'] = 502; $response['error'] = true; $response['message'] = 'Data person gagal dihapus.'; return $response; } } } // update person public function update_person($id, $name, $address, $phone) { if ($id == '' || empty($name) || empty($address) || empty($phone)) { return $this->empty_response(); } else { $where = array( "id" => $id ); $set = array( "name" => $name, "address" => $address, "phone" => $phone ); $this ->db ->where($where); $update = $this ->db ->update("tb_person", $set); if ($update) { $response['status'] = 200; $response['error'] = false; $response['message'] = 'Data person diubah.'; return $response; } else { $response['status'] = 502; $response['error'] = true; $response['message'] = 'Data person gagal diubah.'; return $response; } } } } ?>