Fork me on GitHub

Tag: database

Tag Archives: database

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

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