Today is: 8 January, 2012
Check todays hot topics

Home

PHP

Dynamic Form Generation
Thursday, October 1, 2009 - 18:29
class, dynamic, form, piece of crap

This is a crappy dynamic form class I built. It's been stripped down to protect the innocent. It's actually kinda useful if you have to generate a lot of forms. This does not include a post handler, control scripts or templates. If you scroll to the bottom you'll see a simple use case.

0

Mass SQL - Perform mysql query across multiple replicated databases
Wednesday, July 29, 2009 - 18:13
mass, mass query, monitoring, Mysql, php, query, replication

In large environments it becomes difficult to ensure your data is always in sync. I've noticed that the troubleshooting process is often flawed at certain organizations. People tend take a 10 mile wide top down approach to troubleshooting every problem that comes across their desk. In conjunction with a few other tools, this can help you isolate data anomalies.

There are certain dangers to running this script. It goes without saying that this should never be public facing unless you want bots/people hammering your databases with connect attempts.

0

MASS SQL - Revised
Wednesday, July 29, 2009 - 18:29
mass, mass query, monitoring, Mysql, php, query, replication

This is a revised version of the previous MassSQL Tool. I like this version a little better. Here we're using mysql_fetch_field() which is much better.

And most noteworthy we're displaying results vertically. I think this is much easier to read. Sorry if it looks like the smarty templates are broken or invalid HTML. This is primarily because I integrated this into a private web portal.

0

MySchema - Tree type graphical display of Mysql Databases
Wednesday, July 29, 2009 - 17:43
Canvas Lib, Javascript, Mysql, Ortho, Panels, Schema, Tree Diagram, View

This script is an unfinished/stripped down version of a php script I wrote to display Mysql schemas side by side. The idea was to display two DB schemas in a tree view side by side. This is meant to integrate with some perl (or other) scripts that would visually display database replication. This is extremely powerful in two potential places:

1) A monitoring system not unlike nagios. If the nagios check is able to drop runtime data (possibly in XML?) that can be used to present a realtime weather map of your Mysql replication health.

0