# Name Type Collation Attributes Null Default Comments Extra Action
1 order_id Primary int(11) No None AUTO_INCREMENT Change Change Drop Drop
2 user_id int(11) No None Change Change Drop Drop
3 amount_due int(255) No None Change Change Drop Drop
4 invoice_number int(255) No None Change Change Drop Drop
5 total_products int(255) No None Change Change Drop Drop
6 order_date timestamp No current_timestamp() ON UPDATE CURRENT_TIMESTAMP() Change Change Drop Drop
7 order_status varchar(255) utf8mb4_general_ci No None Change Change Drop Drop
so here is the table where i will be storing all the users orders im very bad at coding and databases all i want to do is in the admin panel i want to add tracking(which i already added as orders_table this is the table) but i need code so that i can use the $_get and $_post method and how can i use that in my project my teacher said i should add the Dispatched from,Intermidiate location and Time till the product reached the destination.
please help me
[code]# Name Type Collation Attributes Null Default Comments Extra Action 1 order_id Primary int(11) No None AUTO_INCREMENT Change Change Drop Drop 2 user_id int(11) No None Change Change Drop Drop 3 amount_due int(255) No None Change Change Drop Drop 4 invoice_number int(255) No None Change Change Drop Drop 5 total_products int(255) No None Change Change Drop Drop 6 order_date timestamp No current_timestamp() ON UPDATE CURRENT_TIMESTAMP() Change Change Drop Drop 7 order_status varchar(255) utf8mb4_general_ci No None Change Change Drop Drop [/code] so here is the table where i will be storing all the users orders im very bad at coding and databases all i want to do is in the admin panel i want to add tracking(which i already added as orders_table this is the table) but i need code so that i can use the $_get and $_post method and how can i use that in my project my teacher said i should add the Dispatched from,Intermidiate location and Time till the product reached the destination. please help me