File manager - Edit - /home/autoph/public_html/connectv1/lms/cfg/func.php
Back
<?php class functions{ /** * Query the database * * @param $query The query string * @return mixed The result of the mysqli::query() function */ public function sql_query($query) { // Connect to the database $connection = $this -> connect(); // Query the database // echo $query; $result = $connection -> query($query); return $result; } public function sql_query_id($query) { // Connect to the database $connection = $this -> connect(); // Query the database $result = $connection -> query($query) ; return $connection -> insert_id; } public function sql_query_affected_rows($query) { // Connect to the database $connection = $this -> connect(); // Query the database $result = $connection -> query($query) ; return $connection -> affected_rows; } public function sql_query_num_rows($query) { // Connect to the database $connection = $this -> connect(); // Query the database $result = $connection -> query($query) ; return $result -> num_rows; } /** * Fetch rows from the database (SELECT query) * * @param $query The query string * @return output */ public function select($query) { $result = $this -> sql_query($query); if($result === false) { return false; } $row = $this -> index_arr_values($result -> fetch_assoc()); if(empty($row)){ return ""; } return $row[0]; } /** * Quote and escape value for use in a database query * * @param string $value The value to be quoted and escaped * @return string The quoted and escaped string */ public function escape($value) { if (is_array($value)) { return array_map(array($this, 'escape'), $value); } $connection = $this -> connect(); return $connection -> real_escape_string(trim(preg_replace("/[[:blank:]]+/"," ", $value))); } /** * Return the values of associative array as indexed array * *@param associative array *@return indexed array */ public function index_arr_values($value){ if(empty($value)){ return array(); } return array_values($value); } /** * Return the keys of associative array as indexed array * *@param associative array *@return indexed array */ public function index_arr_keys($value){ return array_keys($value); } /** Get Client's IP */ // Function to get the client IP address function get_client_ip() { $ipaddress = ''; if (getenv('HTTP_CLIENT_IP')) $ipaddress = getenv('HTTP_CLIENT_IP'); else if(getenv('HTTP_X_FORWARDED_FOR')) $ipaddress = getenv('HTTP_X_FORWARDED_FOR'); else if(getenv('HTTP_X_FORWARDED')) $ipaddress = getenv('HTTP_X_FORWARDED'); else if(getenv('HTTP_FORWARDED_FOR')) $ipaddress = getenv('HTTP_FORWARDED_FOR'); else if(getenv('HTTP_FORWARDED')) $ipaddress = getenv('HTTP_FORWARDED'); else if(getenv('REMOTE_ADDR')) $ipaddress = getenv('REMOTE_ADDR'); else $ipaddress = 'UNKNOWN'; return $ipaddress; } function get_user_session(){ if(isset($_SESSION['crm_user'])){ return $_SESSION['crm_user']; }else{ return false; } } function system_settings(){ $system_settings_obj = $this -> sql_query("SELECT * FROM `lms_cnf_system` WHERE 1"); $system_settings_arr= array(); foreach($system_settings_obj as $row){ $system_settings_arr = array_merge($system_settings_arr,array($row['name']=>$row['value'])); } return $system_settings_arr; } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings