Going the PHP route

18/08/11

Permalink 03:21:13 pm, by mholmes, 202 words, 204 views   English (CA)
Categories: Activity log; Mins. worked: 120

Going the PHP route

I've decided to go the PHP route for the moment. These two blocks of code would be run before and after running the PHP process, and I'm putting them here so I can get them when I need them. They only need to be run once, and I'll certainly be hacking away with my scripts for many hours in between.

    # Add the extra columns we need.
ALTER TABLE `props` ADD `temp_tracking` VARCHAR(1024);
ALTER TABLE `titles` ADD `temp_tracking` VARCHAR(1024);
ALTER TABLE `owners` ADD `temp_tracking` VARCHAR(1024);
ALTER TABLE `lenders` ADD `temp_tracking` VARCHAR(1024);
ALTER TABLE `mortgages` ADD `temp_tracking` VARCHAR(1024);
ALTER TABLE `other_docs` ADD `temp_tracking` VARCHAR(1024);
    
    # Delete the extra columns we added.
    
ALTER TABLE `props` DROP COLUMN `temp_tracking`;
ALTER TABLE `titles` DROP COLUMN `temp_tracking`;
ALTER TABLE `owners` DROP COLUMN `temp_tracking`;
ALTER TABLE `lenders` DROP COLUMN `temp_tracking`;
ALTER TABLE `mortgages` DROP COLUMN `temp_tracking`;
ALTER TABLE `other_docs` DROP COLUMN `temp_tracking`;

I've written the basic code to generate the SQL to add the core title table records, built in the PHP framework for running queries, and tested with a single record to demonstrate that it's practical. Now I can start building the more complicated queries.

Pingbacks:

No Pingbacks for this post yet...

Properties

A database project to collect historical data on properties and titles.

Reports

Categories

April 2014
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30      

XML Feeds