PHP - Restful Service Using Tonic Framework

I am trying to create a web service using restful service tonic frame work to pull data from my website www.serviidb.com and I can print_r the output to firefox poster.  I am using SQL queries to pull the data form a mysql database.   I would like to be able to select the query for the data I want at the beginning of the code and select the output format at the end.  I am looking at having sections of the code to get "plugins", "video", "audio", and "user".  I am thinking about use select case to determine the mysql query to run.  I have programming exp in VB, basic and fortran.

Here is the URL I am using for the get command.

Code: [Select]
http://serviidb.com/api/plugins
here is the code I am using right now.

Code: [Select]
<?php 
 
class TaskDataManager {
 
public static function get($taskId, $input){
echo $taskid . "\n";
//Connect To Database
$hostname='hostname';
$username='username';
$password='password';
$dbname='dbname';


mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname);
//echo 'taskid: ' . $taskId . "\n";


if($taskId=="plugins"){
//echo $input . "\n";
$plgnsql='SELECT taxonomy_term_data.name, field_revision_field_revision.field_revision_value as version, file_managed.uri as URL'
        . ' FROM taxonomy_term_data '
        . ' left join field_data_field_plugins on taxonomy_term_data.tid = field_data_field_plugins.field_plugins_tid '
        . ' left join field_revision_field_revision on field_revision_field_revision.revision_id = field_data_field_plugins.revision_id '
        . ' left join file_usage on field_data_field_plugins.entity_id = file_usage.id'
        . ' left join file_managed on file_usage.fid = file_managed.fid'
        . ' WHERE (field_data_field_plugins.bundle ="plugin")'
        . ' '; 


//$format='json'

$result = mysql_query($plgnsql);
//$mark =jsob_encode("plugins");

$plugins = array();

//echo $result . "\n";

//$response->addHeader('Content-type', 'application/json');

while($response = mysql_fetch_array($result, MYSQL_ASSOC)){



$response[URL] = substr_replace($response[URL],'http://serviidb.com/sites/default/files/',0,9);
$reponse = json_encode($response);
print_r  ($reponse) . "\n";
}
//print_r  ($response) . "\n";




return true;
}

if($taskId=="video"){
echo $input . "\n";
//echo "started feed code" . "\n";



return true;
}
}
}

?>
Here is the output I am getting.  I am trying to figure out how to get the json output to look like the second code below.

Code: [Select]
{"name":"Blip TV","version":"0","URL":"http:\/\/serviidb.com\/sites\/default\/files\/createplugin\/BlipTVUrlExtractor.groovy"}{"name":"CBS","version":"0","URL":"http:\/\/serviidb.com\/sites\/default\/files\/createplugin\/CBS.groovy"}{"name":"iPlayer (UK)","version":"1","URL":"http:\/\/serviidb.com\/sites\/default\/files\/createplugin\/IPlayer.groovy"}{"name":"4oD (UK)","version":"1","URL":"http:\/\/serviidb.com\/sites\/default\/files\/createplugin\/Channel4od.groovy"}{"name":"YouTube","version":"1","URL":"http:\/\/serviidb.com\/sites\/default\/files\/createplugin\/youtube.groovy"}{"name":"LiveFeeds","version":"3","URL":"http:\/\/serviidb.com\/sites\/default\/files\/createplugin\/livefeeds.groovy"}{"name":"GameSpot","version":"1","URL":"http:\/\/serviidb.com\/sites\/default\/files\/createplugin\/gamespot.groovy"}

Want.
Code: [Select]
{"plugins":[{"name":"Blip TV", "version":0, "url":"http:\\serviidb.com/sites/default/files/Create Plugin/BlipTVUrlExtractor.groovy"},{"name":"CBS", ....}]}
I am also trying to figure out how to get the output in the xml format also.

Thanks is advance for the help.