public static function escapeStr($value)
 {
     $link = DatabaseConnection::get();
     $value = mysql_escape_string($value);
     DatabaseConnection::closeConnection($link);
     return $value;
 }
                //echo "<pre>";
                //print_r($ansData);
                echo json_encode($ansData);
            } else {
                $DataAvailable = 'Not Available';
                echo "NoResult";
            }
        } catch (Exception $e) {
            //			echo 'Exception :'.$e->getMessage();
        }
    }
    //	echo "</tbody></table>";
    /* echo <<<endl
                   <div class="tab-pane" id="tab-add"> </div>
                   <div class="tab-pane" id="tab-edit"></div>					  
                   <div class="tab-pane" id="tab-pendingtask"> </div>
                  
    endl; */
    $_SESSION['DataAvailable'] = $DataAvailable;
    $_SESSION['totalRows'] = $NumberofRows;
    $_SESSION['resultQuery'] = $resultQuery;
    //print_r($displayColumns);
    $_SESSION['columns'] = $displayColumns;
    $db->closeConnection();
    unset($_SESSION['type']);
} else {
    echo 'problem';
    //die("Select the type first");
}
//echo "<p style='color:grey'> Please Select your Category</p>";
//echo "Final Query : ".$resultQuery;
 private function handleDatabaseError($link)
 {
     $error = mysql_error($link);
     DatabaseConnection::closeConnection($link);
     throw new Exception("Erreur DB : [" . $error . "]");
 }