Home > Article > Backend Development > Micro company internal ordering system implemented by PHP+Mysql+jQuery+fullcalendar (1/8)_PHP tutorial
Micro-company internal ordering system implemented by PHP+Mysql+jQuery+fullcalendar
Plug-ins involved in this article: jQuery, jQuery.UI, fullcalendar
Database tutorial creation:
CREATE TABLE USER
(
ID INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(100)
);
CREATE TABLE ITEM
(
ID INT PRIMARY KEY AUTO_INCREMENT,
USER_ID INT,
FOOD TINYBOLB,
ORDER_TIME TIMESTAMP
);
ALTER TABLE ITEM ADD FOREIGN KEY(USER_ID) REFERENCES USER(ID) ON DELETE CASCADE;
An entity base class, not very well encapsulated: Entity.php tutorial
PHP code 1 2 3 4 5 6 7 8