Convert a standard database array into JSON

json_database.php

<?php
// Copyright (C) 2007 Robert Wallis - July 11, 2007
function json_database($recordset)
{
	if (0==count($recordset))
		return '[]';
	$o = "[\n";
	foreach($recordset as $records)
	{
		$o .= '{';
		foreach ($records as $column=>$value)
		{
			if (is_null($value))
				$o .= addslashes($column).':null,';
			else if (is_numeric($value))
				$o .= addslashes($column).':'.$value.',';
			else
				$o .= addslashes($column).':"'.addslashes($value).'",';
		}
		$o = substr($o, 0, -1);
		$o .= "},\n";
	}
	$o = substr($o, 0, -2);
	$o .= "\n]";
	return $o;
}