Wednesday, 15 January 2014

Creating the Database Tables

Before developing any php code I went ahead and started building the first 3 database tables (user, subfolder and file). The permissions table will be added further on once all the other tables and queries are functional. I created my own database in phpmyadmin in order to place all the content (i.e. tables) within it.

conninfo.php






jointables.php
The jointables page is meant to connect the tables and retrieve the data from each user, the code developed below will attempt to do so although I will need to test it. 





User Table




Subfolder Table 





File Table



No comments:

Post a Comment