Import a SQL file using the command line in MySQL

A common use of mysqldump is for making a backup of an entire database:

  shell> mysqldump db_name > backup-file.sql

 You can load the dump file back into the server like this:

  UNIX
shell> mysql db_name < backup-file.sql

  Same in Windows comand prompt
mysql -p -u[user] [database] < backup-file.sql

  PowerShell
C:\> cmd.exe /c "mysql -u root -p db_name < backup-file.sql"

  MySQL command line
mysql> use db_name; mysql> source backup-file.sql;

PHP find value by index in multidimensional/associative array

Following function has easily to find and retrieve value by index from multidimensional/associative array

function array_key_exists_value($searchkey, $assocarray)
{
 $output='';
    $result = array_key_exists($searchkey, $assocarray);
    if ($result)
 {
  $output =$assocarray[$searchkey];
 }
else
{ 
    foreach ($assocarray as $val) {
        if (is_array($val)) {
            $output = array_key_exists_value($searchkey, $val);
        }
    }
} 
    return $output;
}

Convert a PHP Object to an Array

Following function has easily to convert an associative array from object data

function object_to_array($result) 
{ 
    $arraydata = array(); 
    foreach ($result as $key=>$value) 
    { 
        if (is_object($value)) 
        { 
            $arraydata [$key]=object_to_array($value); 
        } 
        elseif (is_array($value)) 
        { 
            $arraydata [$key]=object_to_array($value); 
        } 
        else 
        { 
            $arraydata [$key]=$value; 
        } 
    } 
    return $arraydata ; 
}