How to create RESTful DB Connected api through Apigility (ZF2) ?

Api through Apigility:

Install Apigility:

For installing apigility , open terminal & run this command where you want to install apigility.

curl -sS https://apigility.org/install | php

After that run this command for composer.phar

$ php composer.phar require "zfcampus/statuslib-example:~1.0-dev"

Configure files: 
Now go to this file config/autoload/local.php

 And replace

return array(
    'db' => array(
        'driver' => 'Pdo_Mysql',
        'dsn' => 'mysql:dbname=database_name;host=localhost',
        'username' => 'user_name',
        'password' => 'user_pass',
        'driver_options' => array(
            1002 => 'SET NAMES \'UTF8\'',
        ),
        'adapters' => array(
            'mainadapter' => array(
                'driver' => 'Pdo_Mysql',
                'database' => 'database_name',
                'username' => 'user_name',
                'password' => 'user_pass',
                'hostname' => '127.0.0.1',
                'charset' => 'utf8',
            ),
        ),
    ),

Now go to config/application.config.php 
and edit

array(
    'modules' => array(
        /* ... */
        'StatusLib',
    ),
    /* ... */
)

Create a PHP file data/statuslib.php that returns an array:

<?php
return array(); 

Now create a hash using  http://www.htaccesstools.com/htpasswd-generator/ and put it in data/htpasswd file. Here put a username and password which you want to authenticate.

Run for port 8888:

Run this command in your terminal where public is folder in side apigility folder

php -S localhost:8888 -t public public/index.php

and keep it as it is. Don't stop this command.

Create REST Api:

Go to http://localhost. Then click on 'Admin' and then 'APIs' 

Create new api with name 'Status'.

Now refresh page and click on 'Status'.

Goto Rest Service and click for new one.

Go to DB connected and select 'mainadapter'. put table name 'status' and create DB connected. 

Also create table 'status' in your db.

Make sure your config, data and module folder has write permission.

Now setting all the page according to these images.

 These field names should be accordingly your table fields.

Now go to authorization and do this


Now create a new file
module/Status/src/Status/V1/Rest/Status/StatusResource.php

 
 and add

<?php
namespace Status\V1\Rest\Status;
use StatusLib\MapperInterface;
use ZF\ApiProblem\ApiProblem;
use ZF\Rest\AbstractResourceListener;

class StatusResource extends AbstractResourceListener
{
    protected $mapper;
    public function __construct(MapperInterface $mapper)
    {
        $this->mapper = $mapper;
    }

    /**
     * Create a resource
     *
     * @param  mixed $data
     * @return ApiProblem|mixed
     */
    public function create($data)
    {
        //return new ApiProblem(405, 'The POST method has not been defined');
        return $this->mapper->create($data);
    }

    /**
     * Delete a resource
     *
     * @param  mixed $id
     * @return ApiProblem|mixed
     */
    public function delete($id)
    {
        //return new ApiProblem(405, 'The DELETE method has not been defined for individual resources');
        return $this->mapper->delete($id);
    }

    /**
     * Delete a collection, or members of a collection
     *
     * @param  mixed $data
     * @return ApiProblem|mixed
     */
    public function deleteList($data)
    {
        //return new ApiProblem(405, 'The DELETE method has not been defined for collections');
        return $this->mapper->deleteList($data);
    }

    /**
     * Fetch a resource
     *
     * @param  mixed $id
     * @return ApiProblem|mixed
     */
    public function fetch($id)
    {
        //return new ApiProblem(405, 'The GET method has not been defined for individual resources');
        return $this->mapper->fetch($id);
    }

    /**
     * Fetch all or a subset of resources
     *
     * @param  array $params
     * @return ApiProblem|mixed
     */
    public function fetchAll($params = array())
    {
        //return new ApiProblem(405, 'The GET method has not been defined for collections');
        return $this->mapper->fetchAll();
    }

    /**
     * Patch (partial in-place update) a resource
     *
     * @param  mixed $id
     * @param  mixed $data
     * @return ApiProblem|mixed
     */
    public function patch($id, $data)
    {
       // return new ApiProblem(405, 'The PATCH method has not been defined for individual resources');
        return $this->mapper->update($id, $data);
    }

    /**
     * Replace a collection or members of a collection
     *
     * @param  mixed $data
     * @return ApiProblem|mixed
     */
    public function replaceList($data)
    {
        return new ApiProblem(405, 'The PUT method has not been defined for collections');
    }

    /**
     * Update a resource
     *
     * @param  mixed $id
     * @param  mixed $data
     * @return ApiProblem|mixed
     */
    public function update($id, $data)
    {
        //return new ApiProblem(405, 'The PUT method has not been defined for individual resources');
        return $this->mapper->update($id, $data);
    }
}

 Now create a new file
 module/Status/src/Status/V1/Rest/Status/StatusResourceFactory.php

and add

<?php
namespace Status\V1\Rest\Status;
class StatusResourceFactory
{
    public function __invoke($services)
    {
        return new StatusResource($services->get('StatusLib\Mapper'));
    }
}







Its Done Now.

For testing:

GET /status HTTP/1.1
Accept: application/json

You will get your table data in JSON format

Thanks