A simple MySQL class for use in PHP.
Feel free to suggest improvements.

A proof of concept idea I had for implementing an aspect oriented framework in PHP (yes, I know about http://aophp.net, but it requires a module).

I thought it was neat, so I'm going to share it.

Hope someone likes it.

Using the extract() Functio

This code, working with MovableType, creates a tag cloud of tags entered into the keyword field of a blog entry. You can see the results and read my write-up which explains some other things that help with MovableType and tag clouds. I got this code from Al-Muhajabah and made a few minor tweaks. Put the PHP snippet below inside a MT template that creates a php page.

Validate Email Address

This is a quick set of overrides for Javascript so that any variable can be passed to PHP in a GET/POST activity. Just call myVar.toPHP();

I use this little set of functions extensively in a little Javascript/PHP RPC handler I wrote. I don't have the reverse function, as I pass JSON back to the browser for the return value.

Note: This lib is not safe for binaries or HTML Elements. The former will come out similar to FTP ASCII breaks, and the latter will cause infinite recursion. If you want to make a speical case for HTML Elements, do so; you could probably just test for parentNode and create a 'safe' object from that. I didn't need it, so I didn't code it.

As for binary safety, at some point between toPHP/escape/post/urldecode/unserialize, the object breaks. Rather than create a huge fix for something I didn't need to do, I put in a quick match/hack. Don't like it? Write the fix yourself.

A database API written in Perl for a MySQL.

You will need to edit the settings for your server.

Enojy

This class is a MySQL database access wrapper. It can:

- Connect to a MySQL server
- Execute SQL queries and retrieve single value results or return result rows into arrays
- Return the last inserted table row identifier, the number of result rows and the number of affected rows
- Count the number of executed queries
- Lock and unlock tables
- Escape text literal values or like patterns
- Retrieve database access errors

A simple page hits counter that uses a single cookie to tell the user how many times they have visited the page.

Pull items from a mysql db table and display in the following format-
item1, item2, item3

In the example code, the query will return all items that have the color "red" specified in the db.