This project show you how to create a simple CRUD RESTful API with MySQL database. Fronted side are build using AJAX technique allows web pages to be updated asynchronously by exchanging data with a web server behind the scenes. Backend side uses PHP's PDO for database access.
You can add new records in the database, edit them and delete. Try it now.
Backend part have a few limitation such as quantity of records and autorefreshing (every 20 minutes) the database with the data by default. So new records you are made are not store in the DB constantly.
Show DB.
Keep in mind that the DB is refreshing every 20 minutes.
Refresh DB. Set DB data by default.
All PHP file codes used in this project are available by clicking the button.
show PHP codesGetting one videogame by its id.
{
"id": "1"
}
The form below is to send GET request with id. Write an id you want and click the button to see result.
Create a new videogame.
{
"name": "Combat",
"game_producer": "Sony",
"category": "Horror"
}
Add new videogame in the Database and don't forget fill all fields correctly. Quantity of rows has limitation in 12 records.
Updating always has required to provide the id of data.
{
"id": "1",
"name": "Combat",
"game_producer": "Sony",
"category": "Horror"
}
There is the form to send POST request with updated values. Choose row from the table you want to edit by clicking "insert data in form". After that edit fields with new data and click "update" to see result.
| id | name | game_producer | category | |
|---|---|---|---|---|
| 1 | DOOM | Apple | Shooters | |
| 2 | Warcraft | Real-time strategy | ||
| 3 | Age of Empires | Nintendo | Real-time strategy | |
| 4 | Crash Bandicoot | Sega | Platformer | |
| 5 | Forza Motorsport | Xbox | Simulation | |
| 6 | Gears of War | Bandai | Shooters | |
| 7 | Portal 2 | Casio | Puzzlers | |
| 8 | The Long Dark | Sony | Survival and horror |
Delete one videogame identified by its id.
{
"id": "1"
}
You are free to delete any existing row from database. Click the button "delete" to see result.
Searching by category
{
"search": "category"
}
There are two forms to send request with id. Write an id you want and click the button to see result.
DB data
| id | name | game_producer | category |
|---|