EZ Query for MySql database connections
Version 1.0 written by Skorch
Known issues: An error results on some queries when the string value you're searching for does not have escaped quotes encapsulating it. 'Field=\'value\'' OR "field='value'" will resolve the error until I can update the zip files. An incorrect query looks like 'field=value'.
This is a small PHP class for interfacing with a MySql Database. It saves you typing the redundant parts of all MySql queries. This greatly improves the readability of your code and allows you to save time too! It's a small class using only 3 variables and just over 1 kilobyte of disc space. The versatility of the function inputs allow a programmer to quickly specify any MySql select statement. You can access the database information by column name, table name, field values and any combination of them. The insert and update functions are very basic. I assumed the information inserted into a database, from a site visitor, would be very limited while the need to show information would be greater.
I wrote this class to display all of my webpage content from a database. The text files are basically fetch and echo pages
with a minimal amount of markup language. The text file then becomes a template. I use another small patch to create a
psuedo directory. The path named in the pseudo directory becomes the MySql row identifier. This method is very search
engine friendly and is familiar to your visitors. The URL will be completely valid and limited by the size of your database.
Download EZ Query
Back to HotScripts