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 . "]"); }