PHP-exercise-01-rest-api-mvc-PROSAGA-码农传奇

This is an MVC designed RESTful API build on PHP framework Phalcon 3.4.0.

It simulates stock management of an online store.
A store manager can add, search for, update and delete products data and avatars using this API.

Setup and Usage

After setting up MySQL server and Apache server, clone this repo to Apache server’s /htdocs directory.
Create a new database on MySQL server called, for example, myproducts and change the configure file config.php according to what you have created.
```
[
'host' => 'localhost',
'username' => 'root',
'password' => '',
'dbname' => 'myproducts'
]
```

Create a new table on the database and name it products.

CREATE TABLE `products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`detail` varchar(500) COLLATE utf8_bin DEFAULT NULL,
`price` float DEFAULT NULL,
`image_url` varchar(120) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`)
);

Start to use this API by sending HTTP request using curl.

API Overview

Action	HTTP Method	Endpoint URL	Sample `curl` Command	Notice
登録 (add new products)	POST	/api/products	curl -i -X POST -F “name=iphone8” -F “detail=smartphones designed and marketed by Apple Inc.” -F “price=74000” -F “image=@/Users/shiiyan/Downloads/iphone8-spgray-select-2018_AV1.png” http://localhost/exercise-01-rest-api-mvc/api/products	File is transferred using format `multipart/form-data`. Binary files are required.
検索 (retrieve all products)	GET	/api/products	curl -i -X GET http://localhost/exercise-01-rest-api-mvc/api/products
検索 (search for products with their name “i”)	GET	/api/products/search/{name}	curl -i -X GET http://localhost/exercise-01-rest-api-mvc/api/products/search/i	One may need to change permission for folder `/uploads` in order to download images.
検索 (search for product with its id)	GET	/api/products/search/{id:[0-9]+}	curl -i -X GET http://localhost/exercise-01-rest-api-mvc/api/products/search/1	`id` should be an integer
変更 (update product data based on its id)	PUT	/api/products/{id:[0-9]+}	curl -i -X PUT -d ‘{“name”:”iphone 8”}’ http://localhost/exercise-01-rest-api-mvc/api/products/1
削除 (delete product based on its id)	DELETE	/api/products/{id:[0-9]+}	curl -i -X DELETE http://localhost/exercise-01-rest-api-mvc/api/products/1