a96lex / tappx-test-backend

Backend for tappx test

Tappx test backend

Simple php CRUD backend repository to handle bundle information.

Local usage

mysql

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
    );

Serve php:

• clone this repo
• run php -S localhost:8000

Ready to go!

To use with the frontend, see frontend local usage

Structure

• 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