Mysql Database management In Single PHP File

Adminer is one of the best tool for Managing Mysql database.For connecting to a database just copy latest adminer php file to your PHP Web server document web-root

Enabling Case sensitive support for mysql in Wamp

For enabling case sensitive support for mysql in Wamp update mysql.ini(WAMP–>MYSQL–>mysql.ini) in wamp with lower_case_table_names=2

Reference:

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

SoftException in Application.cpp:629: Directory is writeable by group

“SoftException in Application.cpp:629: Directory  is writeable by group”. generally happens in CGI server with suPHP and Fastcgi Servers.

Fix:

By Changing executable files/folders permission from 777 to 755 will fix such issues.

Reason:

1. Both suPHP and Fastcgi Servers has the security and ownership benefits.
2. PHP files are executed as cpanel Users.
3. Files and folders with 777 permission excluded from execution

Here’s an easy forward-compatible way to use JSON (json_encode() and json_decode()) in versions of PHP earlier than 5.2.

Download the Services_JSON PEAR package (JSON.tar)

And then add the following to your custom functions:

JSON DECODE

if (!function_exists('json_decode'))
  {

     

       function json_decode($content, $assoc=false)
                   {
                       require_once 'classes/JSON.php';
                       if ($assoc)
                         {
                            $json = new Services_JSON(SERVICES_JSON_LOOSE_TYPE);
                         }
                     else
                        {
                           $json = new Services_JSON;
                        }
                     return $json->decode($content);
                 }
}

JSON ENCODE

if (!function_exists('json_encode'))
{
    function json_encode($content)
       {
         require_once 'classes/JSON.php';
        $json = new Services_JSON;
        return $json->encode($content);
       }
}

That’s it! Your code will continue to work, even when you eventually upgrade to PHP 5.2