mysql2json

class mysql2json{
  function getJSON($result){
    $rows = array("data"=>array());
 
    if(get_resource_type($result) != "mysql result")
      return json_encode($rows);
 
    while($r = mysql_fetch_assoc($result))
      $rows['data'][] = $r;
 
    for($i = 0, $size = sizeof($rows['data']); $i < $size; $i++) 
      foreach($rows['data'][$i] as $key => $value)
        $rows['data'][$i][$key] = $this->noReturns( 
          utf8_encode( 
            $this->decodeString( $value ) 
          ) 
        );
 
    return json_encode($rows);
  }
 
  function decodeString($s) {
    if( mb_detect_encoding($s,"UTF-8, ISO-8859-1, GBK")=="UTF-8" ) 
      $s = utf8_decode($s);
 
    return $s;
  }	
 
  function noReturns($s) { return str_ireplace(array("\n","\r","\t"),"",$s); }
}