website issueshttps://git.ece.iastate.edu/com-s-319/website/-/issues2018-06-02T09:09:37Zhttps://git.ece.iastate.edu/com-s-319/website/-/issues/2Replace ID based SQL table lookup with String Constant2018-06-02T09:09:37ZryanwadeReplace ID based SQL table lookup with String ConstantAdd string constant to SQL.php for "USER_TABLE":"USER", "PAGE_TABLE":"PAGES", "ADMIN_TABLE":"ADMIN"
Modify all calls to SQL->GET_TABLE($id) to use constants. This string will be used to Query the database for the table and return a S...Add string constant to SQL.php for "USER_TABLE":"USER", "PAGE_TABLE":"PAGES", "ADMIN_TABLE":"ADMIN"
Modify all calls to SQL->GET_TABLE($id) to use constants. This string will be used to Query the database for the table and return a SQL_TABLE with a reference to the result of the queryFeature 0.9ryanwaderyanwadehttps://git.ece.iastate.edu/com-s-319/website/-/issues/1SQL.php and realSQL.php integration2018-06-02T09:09:37ZryanwadeSQL.php and realSQL.php integrationIntegrate realSQL.php into SQL.php
Replace array based implementation with SQL implementation
Examples:
SQL() replace $tables with a connection to the database
https://git.ece.iastate.edu/com-s-319/website/commit/5314003386daf0c52a...Integrate realSQL.php into SQL.php
Replace array based implementation with SQL implementation
Examples:
SQL() replace $tables with a connection to the database
https://git.ece.iastate.edu/com-s-319/website/commit/5314003386daf0c52a642eda22726735cddbef5e#note_66
SQL_Table($src) $src should be a reference to the SQL table.
SQL_ROW($src) $src should be a reference to a row in an SQL table
GET_ROW($id) should query the table and return a SQL_ROW
Note: SQL.php was originally an array based implementation. fakeSQL.php was used as a way to extract the array data so it could be updated without making it look like the functionality of SQL.php had changed.
https://git.ece.iastate.edu/com-s-319/website/commit/5314003386daf0c52a642eda22726735cddbef5e#note_66Feature 0.9ryanwaderyanwade