It’s Friday! It was a great week and here’s to a fun weekend! Enjoy!

mysql-php

It happens that I’m working on 3 websites simultaneously, so I need to work efficiently.  When it comes to writing php for data inserts and updates on mysql tables (big and small), time is consumed typing out all those variables, and single quotes.  My solution around this?  A class, xSql.  It makes use of the sql catalog feature.

I created 2 primary functions – an insert and update. All is required is to put field names, and values an array. Then the functions do the work, by deciding what the field type is, inserting the single quotes where necessary, and building the insert or update sql. Once the sql statement is constructed, mysql_query is executed.

There are 2 select functions as well. One that grabs all records based on a table name and where field, and a function that grabs specific fields from a table based on a list of fields, and a single or multiple where fields.
And that’s it!

It has afforded me great speed in assembling database operations in my php scripts.  Now on to automatic form generation and validation!

My son is graduating college this coming May. I watch all the negative market news, I read about the shenanigans happening on wall street, with banks, the likes of AIG, while it keeps getting worse every day. My youngest son is unable to find even a part-time job in the San Francisco Bay Area.  With so few jobs

Recession

available, competition is fierce. So what will happen? I’m worried.

I’m encouraged when smart people like President Obama take action. When a person like John Stewart call out wall street mavens like Jim Kramer, and lay our reality at his doorstep. But where will it all end? Will we have a depression?  Is our beloved country truly on the downside?

I’m worried.

I’ve redesigned my site iphonefotog.com. The site is a growing collection of photos I’ve taken on my travels around the country and around the San Francisco Bay Area.

No more. Lots of new freedom-fighting app stores are springing up. Installing these apps aren’t so easy. You’ll have to jail-break your iphone before you can install and run the apps.  One I liked and used on my first iphone 1.0 is the dreamcatcher video recorder for iphone. It’s an awesome app. Simply point and record. And you can email the videos you record!

I had hoped that dreamcatcher would have made it on the app store. Alas, for some reason, it’s not.  Like the other rogue applications, the video recorder hopefully will appear in the alternate stores. But the question is, is it worth jail-breaking your app? I’m not sure.

More on this later.

John Stewart exposes all those bozos on CNBC for what they are, along with that asshole Rick Santelli.