Simple php CRUD backend repository to handle bundle information.
launch and login to mysql
create database CREATE DATABASE tappx;
go to database use tappx;
update database.php
and type your mysql username and pasword on the corresponding variables
create table
CREATE TABLE bundles(
id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
creation_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
username VARCHAR(40) NOT NULL,
bundle VARCHAR(60) NOT NULL,
company VARCHAR(60) NOT NULL,
email VARCHAR(40) NOT NULL,
active BOOL NOT NULL default 0,
category varchar(10) NOT NULL
);
- clone this repo
- run
php -S localhost:8000
Ready to go!
To use with the frontend, see frontend local usage
- database.php: contains information on how to do queries and what are post/get calls. Also manages database connection
- index.php: gets data from request body and type and sends it to the correspondant calls