Fork me on GitHub

Tag: sql

Tag Archives: sql

Search and replace directly within MySQL.

MySQL always amazes me with the breadth of functionality that it has. Too often we just use it to push and pull information from the database. So when I hit an occasion where I can so in a single SQL statement that would require a time consuming PHP I get excited.

April 3, 2009 | Web Design & Development | 2 comments

It is Alive!

After a probably much non-missed stint of downtime this piece of shit blog is finally back up and running. The upgrade process took a bit more than expected. Read on for the whole boring story.

February 25, 2008 | Computers | 3 comments

Is this a normal coding enviroment?

Or: Editors, Editors Everywhere. Go Nuts I know I’ve done an "Editor Roundup" before, but: Doing work in a variety of languages has had me jumping editors and IDEs looking for the single perfect editor for handling PHP, HTML, CSS, JavaScript, SQL and the occasional Bash script. I recently gave up and just settled on […]

August 14, 2006 | PHP Scripting | 4 comments

mySQL Class Updated for PHP 5 part 1

I’ve updated the SQL class to use some native PHP 5, namely constructors and destructors and include some backward compatibility so PHP 4 does not freak out when it loads the class. I’ll hopefully be making this 100% PHP 5 native soon enough as I’ll actually have a native PHP 5 environment to apply it […]

March 6, 2006 | PHP Scripting | Comments Off on mySQL Class Updated for PHP 5 part 1

mySQL Class Updated

The change is minor but has significant meaning to the script. I added two functions – escapeData() and buildQuery(). The significance of adding these is mainly in the escapeData() function. Instead of encouraging the user the use addslashes before using submitted data or, worse yet, encouraging the user to rely on magic_quotes, the escapeData function […]

September 12, 2005 | PHP Scripting | 7 comments