Strategy Session

I have re-thought the overall strategy for a particular kind of application. Here are the steps that I think will be successful:

1. Use javascript bookmarklets to run customized code within the browser that interacts with the infomation within the browser window from the server. (Trigger the bookmarklets by setting up icons in the "links bar" for IE or the "bookmarks bar" for Safari.)

2. Use javascript cookies (within the document object) to store and retrieve data from the server, and to monitor the client for subscription expiration dates. Encrypt and delete the relevent information after use.

3. Use javascript to trigger 'autohotkey scripts' for windows or 'language&text shortcuts' for mac. This allows screentouch activation of specific shortcuts without needing a platform-specific keyboard, or a keyboard at all.

4. Use VNC to allow cross-platform access to the browser (such as from a mobile phone or tablet device). Use VPN to allow remote desktop connections to potential customers for set-up and troubleshooting.

5. Market the product/service via Twitter ( instead of by mail / email / phone / meeting / advertising / facebook ). Start with the major blog-style twitterers with large followings (within the appropriate subject matter), and then enter their "following lists" for ever expanding names of leaders for targeted populations.

Migrating PHP/SQL from MAMP to WAMP

1. Exported my database to a .sql file, using phpmyadmin. Created a new database with the same name in WAMP and left it empty. Then imported it within the phpmyadmin environment using the import function from within the empty database. Initially got error message because the database exceeded the 2MB size limit (it was 7.5MB) but followed the directions as prompted to change the php.ini file so that the max_filesize parameter was 8MB.

2. PHP scripts that ran in MAMP initially wouldn't run in WAMP. Got error messages saying I had to initiallize array variables before using them, and "undefined constant blah, assumed 'blah' " meaning put array component names in quotes, as in $array["blah"] not $array[blah].

3. Various allowable permutations of embedding SQL commands within PHP using different orders of double or single quotes behave erratically in WAMP, much testing and debugging necessary.

4. Default user/password to access mysql in MAMP ("root"/"root") changed to "root"/"" in WAMP.