Five years ago, I created JSON Table Editor. Recently I have the time to revisit the project and do some minor bug fixes and enhancements.

1. Array editing.
   In previous version, loading an array of string will give you a table of characters. This is embarrassingly wrong.
   

   The updated version has no more of this problem.

   

2. Improvements on multi-level object editing.
   I changed the button title from ‘Save to Upper Level’ to ‘Finish Editing’, which is more appropriate. I also make the window closed when you click ‘Finish Editing’ button. I also show the updated JSON so we can notice the changes.
   
   The changes also propagated all the way to the top. In previous version, on each child-window we need to click the ‘Save to Upper Level’ button.
   
3. Limiting the proxy
   The proxy in the previous version is just a dumb proxy. It fetches any url requested and dump whatever content. I see a potential misuse here. So I limit the proxy to only fetch JSON, CSV and raw/text content.

   <?php
   $qUrl = $_REQUEST["q"];
   // create a new cURL resource
   $ch = curl_init();
   // set the URL
   curl_setopt($ch, CURLOPT_URL, $qUrl);
   // get only the Head
   curl_setopt($ch, CURLOPT_NOBODY, true);
   // curl_exec return value instead of directly to out
   curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
   // do the request
   $res = curl_exec($ch);
   // check the content type
   $contentType = curl_getinfo ($ch, CURLINFO_CONTENT_TYPE);
   //only accept json, csv
   curl_close($ch);
    
   //error_log($contentType);
    
   if (strpos($contentType,'/json')!== false || strpos($contentType, '/csv')!== false || strpos($contentType, 'text/plain')!== false)
   {
      // ... SNIP ...
      // Normal CURL processing
   }
   else {
      //error_log('Not JSON');
      echo "Invalid resource. We only retrieve JSON/CSV/text resource. The requested URL returned ".$contentType;
   }
   ?>
   

That’s all, folks! Looking forward to hear your thoughts. Cheers!

Incoming Search

javascript, json, php