Skip to content

Latest commit

 

History

History
31 lines (21 loc) · 1.06 KB

README.md

File metadata and controls

31 lines (21 loc) · 1.06 KB
Raw

Angular MySQL Application

This application is a sample CRUD application built with Angular.js and MySQL and a RESTful API. Based on the sample application angular-cellar by Christophe Coenraets:

https://github.com/ccoenraets/angular-cellar

Uses

  1. Angular.js v1.2.19
  2. MySQL
  3. PHP Slim framework (API)
  4. Bootstrap 3

Set Up

  1. Create a MySQL database named angular-mysql
  2. Run install/angular-mysql.sql to create and populate the users table (includes four dummy users)
  3. Create Apache virtual root and point to /app folder

Notes

The .htaccess file in the /app folder redirects all requests to index.html (needed by Angular application)

API Endpoints

GET         /api/users                  Gets all users
POST        /api/users                  Creates a new user
GET         /api/users/:id              Gets a user by Id
GET         /api/users/search/:query    Searches user by name
PUT         /api/users/:id              Updates a user by Id
DELETE      /api/users/:id              Deletes a user by Id