Simple php program

------------------- [login to view URL] --------------------- Get id from GET method. For example, id = 12345. And retrieve data from SQL and file directory. You have to write SQL I/O. I will make webdesign layout later. So, just output text. 1. Retrieve the title from table ‘TITLE’. ‘TITLE’ has id and title. 2. If there is ./include/[login to view URL], include it. Almost, it is a tiny html snippet. 3. Retrieve from table ‘WATCHER’. Use id. ‘WATCHER’ has id, srl, name,time. There are several records. Sort by time desc. Number of items are limited by 30. If limited, display ‘more’ link ([login to view URL]) 4. Get index number from id. The first char of id. So, idx=1 and table name is ‘C1’. Retrieve from table ‘C1’. Use id. ‘C1’ has id, name, and phone. There are several records about one id. Almost 2 or 3. 5. Truncate id from 12345 to 1234. Retrieve from table ‘B1’. ‘B1’ has id, name, and phone. Only one record. 6. Truncate from 1234 to 123. Retrieve from table ‘A1’. Same above. ------------------- [login to view URL] -------------------- Get id and act from GET. >>> no act Retrieve all records from table ‘WATCHER’. Paginate per 100 items. >>> act=add Get srl,name,time from GET. Write on DB. >>> act=delete Get srl from GET. Search the item by id and srl. Then delete from DB. ----------------------- [login to view URL] ------------------------- This program write DB from CSV file format. You have to write CSV part. Get table and csv from GET. Load CSV. First line is header. Parse into SQL query. Delete all records from table. And rewrite. If there is no table, make it. (end)