Method to populate empty database fields, just some random ghetto superstar code.

populate_empty_fields.php

<?php

/**
 * Populates empty database fields, ghetto fix for not having default values. 
 * 
 * @param  string $table Table name to grab fields from
 * @param  array  $data  Array of data to merge the default values into.
 * @param  object $db    Reference to the database connection, yea I'm a ghetto superstar.
 * 
 * @return array
 */
function populate_empty_fields($table = NULL, $data = array(), $db)
{
	if ( FALSE === is_string($table) ) return $data;
	
	//this is pretty much what $db->getFields does....
	//$result = mysql_query("SHOW COLUMNS FROM $tbl");
	$db->getFields($table, TRUE);
	$fields = $db->fields;
	foreach ($fields as $field) {
		if ( array_key_exists($data, $field['Field']) ) CONTINUE;
		if ( is_null($field['Default']) )
		{
			// kinda ghetto but check if the field type is a INT and either make a default zero or empty string.
			$data["{$field['Field']}"] = ( FALSE !== strpos($field['Type'],'int') ) ? 0 : NULL;			
		}

	}

	return $data;
}