function adlib($id, $type) { // create adlib xml basic structure $XML = new simpleXmlElement("<?xml version='1.0' encoding='utf-8'?><adlibXML xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:noNamespaceSchemaLocation='http://www.adlibsoft.com/adlibXML.xsd' />"); echoall("Start Adlib XML export"); echoall("Connect database"); $daba = new database(); $daba->connect("localhost", "iggmp", "1s87J37r0"); if ($daba->select("thesaurus")) { echoall("Database connected"); } else { die("***ERROR - Database connection failed"); } $termType = thesaurus::get_name($id); echoall("Starte bei <b>'" . thesaurus::get_name($id) . "'</b>"); //------------------------------------------------------------------------------ // create recordList xml_insert($XML, new simpleXmlElement("<recordList />")); // insert records in recordList $subXml = _subtree($id, $termType); if ($subXml) { xml_insert($XML->recordList, $subXml); } echoall("XML export completed<hr>"); echoall($XML); return $XML->asXML(); }
public static function get($variable, $default) { $s = database::select("variables", array("variable_value"), "variable_name='%var'", array("%var" => $variable)); if (($b = database::fetch($s, PDO::FETCH_COLUMN)) != null) { return json_decode($b, true); } else { return $default; } }
public static function challenge_login($user, $pass) { $result = false; $query = database::select('id, password')->tables('user')->where('username', '=', ':username')->where('status', '=', 1, 'and')->param(':username', $user)->limit(1)->execute(); $query_result = $query->fetch(); if ($query_result && bcrypt::verify(user::config()->get('salt') . $query_result->uid . $pass, $query_result->pass)) { $result = (int) $query_result->id; } return $result; }
public static function get_message_count($game_id) { if (safe_input::is_number($game_id)) { $db = new database(); $db->select("message", "*", "gameID= {$game_id} "); return $db->number_of_rows(); } else { return -1; //invalid game_id } }
public function __construct($argv) { self::$network_time = time(); // network time, sets to self::$network_time until we recieve some info from a main server. $parser = new parser(CONFPATH . 'services.conf'); // get the config values. self::$debug = $argv[1] == 'debug' ? true : false; // is debug mode running? y/n if (isset(self::$config->nickserv)) { self::$service_bots[] = 'nickserv'; } if (isset(self::$config->chanserv)) { self::$service_bots[] = 'chanserv'; } if (isset(self::$config->operserv)) { self::$service_bots[] = 'operserv'; } // setup our $config->service_bots dir $this->timer = new timer(); $this->mode = new mode(); $this->services = new services(); $this->commands = new commands(); $this->modules = new modules(); // setup all the subclasses. database::factory(self::$config->database->driver); // setup the db. self::$socket = self::connect(); // connect to the socket self::protocol_init(); // load the protocol class $select = database::select('core', array('max_users'), array('id', '=', '1')); $max_users = database::row($select); // get the max users self::$max_users = $max_users[0]; // set a global variable timer::add(array('core', 'reset_flood_cache', array()), 120, 0); // add a timer to reset the flood cache every // 120 seconds, indefinatly if (self::$config->settings->loglevel != 'off' || !isset(self::$config->settings->loglevel)) { timer::add(array('core', 'save_logs', array()), 300, 0); } // add another timer to save logs every 5 mins timer::add(array('core', 'check_unused_chans', array()), 5, 0); // and another one to check for unused channels every 5 seconds XD if (is_resource(self::$socket)) { $this->main_loop(); } else { exit; } // execute the main program loop }
public static function getGameById($game_id) { if (safe_input::is_number($game_id)) { $db = new database(); $db->select("game", "*", "id= {$game_id} "); if ($db->number_of_rows() > 0) { return $db->fetch_row(); } else { return FALSE; } } else { return false; } }
public static function _find_match($term, $mode, $limit) { $new_term = str_replace('*', '%', $term); // search for a nickname // allow the ability to search with "*"'s $limit = database::quote($limit); $s_limit = explode('-', $limit); $offset = $s_limit[0]; $max = $s_limit[1]; // split up the limit and stuff ^_^ if ($mode == 'suspended') { $results = database::select('users', array('id', 'display', 'last_hostmask', 'suspended', 'suspend_reason'), array('suspended', '=', '1', 'AND', 'display', 'LIKE', $new_term), '', array($offset => $max)); } else { $results = database::select('users', array('id', 'display', 'last_hostmask', 'suspended', 'suspend_reason'), array('suspended', '=', '0', 'AND', 'display', 'LIKE', $new_term), '', array($offset => $max)); } return $results; }
<?php session_start(); $pid = ''; if (isset($_GET['pid'])) { $pid = $_GET['pid']; } require_once "../../lib/server-config.php"; require_once "../../lib/connect.class.php"; $db = new database(); $db->connect2(trim($u), trim($p), trim($dbn)); $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("registerrecord"), mysql_real_escape_string($pid)); $resultRegister = $db->select($strSQL, false, true); if (!$resultRegister) { } ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="description" content="Introducing Lollipop, a sweet new take on Android."> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>SIMANH South Africa</title> <!-- Page styles --> <link href="https://fonts.googleapis.com/css?family=Roboto:regular,bold,italic,thin,light,bolditalic,black,medium&lang=en" rel="stylesheet"> <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet"> <link rel="stylesheet" href="./css/material.min.css"> <link rel="stylesheet" href="styles.css"> <link rel="stylesheet" type="text/css" href="css/style.css" />
<?php $userdata = $this->_userData; $has_ads_pin = $userdata['ads_pin']; if ($has_ads_pin != NULL) { $ads_pin = $has_ads_pin; $selectPin = "disabled"; } else { $ads_pin = ""; $selectPin = NULL; } $db = new database(DBTYPE, DBHOST, DBNAME, DBUSER, DBPASS); $checkPin = $db->select("user_accounts", "acc_type", "agent_id = '{$has_ads_pin}'", "fetch"); if ($checkPin['acc_type'] == 'admin') { $selectPin = NULL; } $accType = $this->accType; $bankList = $this->bankList; $paymentMethodList = $this->paymentMethodList; $accCode = $userdata['acc_type']; $colSize = $accCode != "pb" ? "col-md-6" : "col-md-12"; $notPB = $accCode != "pb" ? TRUE : FALSE; ?> <div class="col-xs-12"> <h2 class="page-header">Account Setup</h2> <?php include 'menu.php'; ?> <div> <div class="account-setup tab-content">
<?php session_start(); include "./server-config.php"; $strUsername = trim($_POST["data1"]); $strPassword = trim($_POST["data2"]); $strPassword = md5($strPassword); require "connect.class.php"; $db = new database(); $db->connect2(trim($u), trim($p), trim($dbn)); $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "useraccount WHERE username = '******' and password = '******' and status = '1'", mysql_real_escape_string($strUsername), mysql_real_escape_string($strPassword)); $resultaccount = $db->select($strSQL, false, true); if ($resultaccount) { print "Y"; $_SESSION['userSIMANHsession'] = session_id(); $_SESSION['userSIMANHusername'] = $resultaccount[0]['username']; session_write_close(); } else { //print $strSQL; print "N"; } $db->disconnect();
public static function get_all_roles() { return database::fetchAll(database::select("groups")); }
<?php session_start(); include "./../lib/server-config.php"; require "./../lib/connect.class.php"; $db = new database(); $db->connect2(trim($u), trim($p), trim($dbn)); //Check user priviledge $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE username = '******' and status = 1 and user_type_id = '%s'", mysql_real_escape_string("useraccount"), mysql_real_escape_string($_SESSION['userSIMANHusername']), mysql_real_escape_string(3)); $resultUser = $db->select($strSQL, false, true); //If privilegde available if ($resultUser) { $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s \n\t\t\t\tWHERE record_id = '%s'", mysql_real_escape_string("outcome"), mysql_real_escape_string($_SESSION['userSIMANHmother_record'])); $resultSelectOutcome = $db->select($strSQL, false, true); $no = 1; if ($resultSelectOutcome) { $no = sizeof($resultSelectOutcome); } $strSQL = sprintf("INSERT INTO " . substr(strtolower($tbf), 0, -2) . "%s \n\t\t\t\tVALUE ('','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s'\n\t\t\t\t,'%s','%s','%s')", mysql_real_escape_string("outcome"), mysql_real_escape_string($_POST['gender']), mysql_real_escape_string($_POST['alive']), mysql_real_escape_string($_POST['stillbirth']), mysql_real_escape_string($_POST['ag5']), mysql_real_escape_string($_POST['ag10']), mysql_real_escape_string($_POST['rbm']), mysql_real_escape_string($_POST['birth_wieght']), mysql_real_escape_string($_POST['hc']), mysql_real_escape_string($_POST['fetal_length']), mysql_real_escape_string($_POST['bdf']), mysql_real_escape_string($_POST['bdf_identify']), mysql_real_escape_string($_POST['bdn']), mysql_real_escape_string($_POST['ebf']), mysql_real_escape_string($_POST['bf']), mysql_real_escape_string($_POST['ff']), mysql_real_escape_string($_POST['skin2skin']), mysql_real_escape_string($_POST['pmctv_lb']), mysql_real_escape_string($_POST['nb_adm']), mysql_real_escape_string($_POST['nb_date_adm']), mysql_real_escape_string($_POST['nb_time_adm']), mysql_real_escape_string($_POST['nb_neonatal']), mysql_real_escape_string($_POST['nb_refer']), mysql_real_escape_string($_POST['nb_refer_facility']), mysql_real_escape_string("nb." . $_SESSION['userSIMANHmother_record'] . "-" . $no), mysql_real_escape_string($_SESSION['userSIMANHmother_record'])); $resultInsert = $db->insert($strSQL, false, true); if ($resultInsert) { $strSQL = sprintf("SELECT record_id FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s' ", mysql_real_escape_string("outcome"), mysql_real_escape_string($_SESSION['userSIMANHmother_record'])); $resultCheck = $db->select($strSQL, false, true); if ($resultCheck) { $db->disconnect(); ?> <script> alert('Delivery information complete!'); window.location = '../enter/main.php?id=4'; </script> <?php
public static function getMessages($cond = NULL, $fetch = "fetchAll") { if ($cond != NULL) { $where = $cond; } else { $where = NULL; } $db = new database(DBTYPE, DBHOST, DBNAME, DBUSER, DBPASS); $data = $db->select("user_messages", "*", $where, $fetch); return $data; }
function complete() { $userdata = $this->user; $agent_id = $userdata['agent_id']; $paymentComplete = TRUE; $db = new database(DBTYPE, DBHOST, DBNAME, DBUSER, DBPASS); $hasPayment = user::checkExist("user_payment", "agent_id = '{$agent_id}'"); $paymentDetails = $db->select("user_payment", "payment_date, payment_time, from_acc, to_acc, payment_type", "agent_id = '{$agent_id}'", "fetch"); if ($paymentDetails != FALSE) { foreach ($paymentDetails as $key => $value) { if (empty($value)) { $paymentComplete = FALSE; } } } else { $paymentComplete = FALSE; } if (!$hasPayment or !$paymentComplete) { redirect::to("setup/payment"); } $this->breadcrumb->add("Complete", "setup/complete"); $this->view->breadcrumbs = $this->breadcrumb->get(); $this->view->js = array('setup/js/setup.js'); $this->view->render('setup/complete', 'backoffice'); }
<?php session_start(); include "./../lib/server-config.php"; require "./../lib/connect.class.php"; $db = new database(); $db->connect2(trim($u), trim($p), trim($dbn)); $key = $_POST["key"]; //Check user priviledge $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE username = '******' and status = 1 and user_type_id = '%s'", mysql_real_escape_string("useraccount"), mysql_real_escape_string($_SESSION['userSIMANHusername']), mysql_real_escape_string(3)); $resultUser = $db->select($strSQL, false, true); if ($resultUser) { $strSQL = "SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "registerrecord\n\t\t\t\tWHERE (pid like '" . $key . "%' or p_fname like '%" . $key . "%' or p_lname like '%" . $key . "%' or point_no = '%" . $key . "%'\n\t\t\t\t or folder_no = '%" . $key . "%') and confirm_status = '0' and username in (SELECT username FROM " . substr(strtolower($tbf), 0, -2) . "userdescription WHERE institute_id in (SELECT institute_id FROM " . substr(strtolower($tbf), 0, -2) . "userdescription WHERE username = '******'userSIMANHusername'] . "'))"; $resultSearch = $db->select($strSQL, false, true); if ($resultSearch) { ?> <table width="100%" border="0" cellspacing="0" cellpadding="0" > <tr> <td height="25" width="40" align="left" style="padding-left:5px; color:#FFF; font-size:0.8em;" bgcolor="#669999"><strong>No </th> </strong> <td align="left" style="padding-left:5px; color:#FFF; font-size:0.8em;" bgcolor="#669999"><strong>Full name </th> </strong> <td align="left" width="120" style="padding-left:5px; color:#FFF; font-size:0.8em;" bgcolor="#669999"><strong>Admission date </th> </strong> <td align="left" width="80" style="padding-left:5px; color:#FFF; font-size:0.8em;" bgcolor="#669999"><strong>Status </strong> <td align="left" width="150" style="padding-left:5px; color:#FFF; font-size:0.8em;" bgcolor="#669999"><strong>Labour</strong> </tr> <?php
<?php /* * php code///////////********************************************************** */ $title = 'ระบบจัดการร้านค้า'; $db = new database(); $option_user = array("table" => "users"); $query_user = $db->select($option_user); /* * php code///////////********************************************************** */ /* * header*********************************************************************** */ require 'template/back/header.php'; /* * header*********************************************************************** */ ?> <div id="page-warpper"> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">ยินดีต้อนรับ!</h1> </div> </div> <div class="row"> <div class="col-lg-12"> <div class="alert alert-info" role="alert">ยินดีต้อนรับสู่ระบบ ecProduct by itOffside.com</div> </div>
<?php session_start(); $pid = ''; if (isset($_GET['pid'])) { $pid = $_GET['pid']; } require_once "../../lib/server-config.php"; require_once "../../lib/connect.class.php"; $db = new database(); $db->connect2(trim($u), trim($p), trim($dbn)); $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("outcome"), mysql_real_escape_string($pid)); $resultOutcome = $db->select($strSQL, false, true); if (!$resultOutcome) { } ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="description" content="Introducing Lollipop, a sweet new take on Android."> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>SIMANH South Africa</title> <!-- Page styles --> <link href="https://fonts.googleapis.com/css?family=Roboto:regular,bold,italic,thin,light,bolditalic,black,medium&lang=en" rel="stylesheet"> <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet"> <link rel="stylesheet" href="./css/material.min.css"> <link rel="stylesheet" href="styles.css"> <link rel="stylesheet" type="text/css" href="css/style.css" />
<?php session_start(); include "./../lib/server-config.php"; require "./../lib/connect.class.php"; $db = new database(); $db->connect2(trim($u), trim($p), trim($dbn)); //Check user priviledge $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE username = '******' and status = 1 and user_type_id = '%s'", mysql_real_escape_string("useraccount"), mysql_real_escape_string($_SESSION['userSIMANHusername']), mysql_real_escape_string(3)); $resultUser = $db->select($strSQL, false, true); if ($resultUser) { $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("registerrecord"), mysql_real_escape_string($_GET['id'])); $resultRecord = $db->select($strSQL, false, true); if ($resultRecord) { $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("delivery"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("obstetric"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("other_postnatal"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("outcome"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("postnatal"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("DELETE FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("registerrecord"), mysql_real_escape_string($resultRecord[0]['record_id'])); $resultDelete = $db->delete($strSQL); $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("registerrecord"), mysql_real_escape_string($_GET['id'])); $resultRecord = $db->select($strSQL, false, true); if ($resultRecord) { // Delete fail $db->disconnect();
<?php session_start(); $pid = ''; if (isset($_GET['pid'])) { $pid = $_GET['pid']; } require_once "../../lib/server-config.php"; require_once "../../lib/connect.class.php"; $db = new database(); $db->connect2(trim($u), trim($p), trim($dbn)); $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("complication_delivery"), mysql_real_escape_string($pid)); $resultCom = $db->select($strSQL, false, true); if (!$resultCom) { } ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="description" content="Introducing Lollipop, a sweet new take on Android."> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>SIMANH South Africa</title> <!-- Page styles --> <link href="https://fonts.googleapis.com/css?family=Roboto:regular,bold,italic,thin,light,bolditalic,black,medium&lang=en" rel="stylesheet"> <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet"> <link rel="stylesheet" href="./css/material.min.css"> <link rel="stylesheet" href="styles.css"> <link rel="stylesheet" type="text/css" href="css/style.css" />
public static function confirm_command($nick, $ircdata = array()) { $code = $ircdata[0]; if (trim($code) == '') { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_INVALID_SYNTAX_RE, array('help' => 'CONFIRM')); return false; } // wrong syntax if (!($user = services::user_exists($nick, false, array('display', 'id')))) { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_UNREGISTERED); return false; } // unregistered $code_array = database::select('validation_codes', array('nick', 'code'), array('nick', '=', $nick, 'AND', 'code', '=', $code)); if (database::num_rows($code_array) == 0) { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_INVALID_PASSCODE); } else { services::communicate(core::$config->nickserv->nick, $nick, &nickserv::$help->NS_VALIDATED); // let them know. database::update('users', array('validated' => 1), array('id', '=', $user->id)); // user is now validated. database::delete('validation_codes', array('nick', '=', $nick, 'AND', 'code', '=', $code)); // delete the code now that we've validated them core::alog(core::$config->nickserv->nick . ': ' . $nick . ' activated'); // logchan } // no passcode found }
$errors_string = ERROR_GLOBAL_ADMIN_WRITE_MAIN_CONFIG; redirect($_SERVER['SCRIPT_NAME'] . '?action=database&error_string=' . $error_string); } if (!write_contents(DIR_FS_CATALOG . 'admin/' . DIR_WS_INCLUDES . 'configure_site.php', $buffer3)) { $errors_string = ERROR_GLOBAL_ADMIN_WRITE_SITE_CONFIG; redirect($_SERVER['SCRIPT_NAME'] . '?action=database&error_string=' . $error_string); } require DIR_FS_CLASSES . 'database.php'; chdir($current_dir); $g_db = new database(); $result = $g_db->connect(); if (!$result) { $error_string = ERROR_GLOBAL_DBASE_CONNECT; redirect($_SERVER['SCRIPT_NAME'] . '?action=database&error_string=' . $error_string); } $result = $g_db->select(DB_DATABASE); if (!$result) { $g_db->query("create database " . $g_db->input(DB_DATABASE) . " DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci"); $result = $g_db->select(DB_DATABASE); if (!$result) { $error_string = ERROR_GLOBAL_DBASE_CREATE; redirect($_SERVER['SCRIPT_NAME'] . '?action=database&error_string=' . $error_string); } } $errors_array[] = ERROR_GLOBAL_UPLOADING_DATABASE; break; case 'finish': read_contents(FILE_TMP_FRONT_SERVER, $contents); eval($contents); read_contents(FILE_TMP_DBASE, $contents); eval($contents);
$db = new database(); $db->connect2(trim($u), $p, trim($dbn)); if (!isset($_GET['group_id'])) { ?> <script> alert('Parameter error!'); window.location = './main.php?id=1&group_id=<?php print $_GET['group_id']; ?> &tab_id=4'; </script> <?php exit; } $strSQL = "SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "parameter_subgroup WHERE sg_name = '" . $_POST['var_subgroup'] . "'"; $resultParametor = $db->select($strSQL, false, true); $order = 1; //No any duplicate if (!$resultParametor) { $strSQL = "INSERT INTO `db_simanh`.`" . substr(strtolower($tbf), 0, -2) . "parameter_subgroup` VALUES ('NULL','" . $_POST['var_subgroup'] . "','1','" . $_GET['group_id'] . "')"; $resultInsert = $db->insert($strSQL, false, true); $strSQL = "SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "parameter_subgroup WHERE sg_name = '" . $_POST['var_subgroup'] . "'"; $resultselect = $db->select($strSQL, false, true); if ($resultselect) { ?> <script> alert('Add parameter success!'); window.location = './main.php?id=1&group_id=<?php print $_GET['group_id']; ?> &tab_id=4';
<?php class database { protected static $c; protected $s; public function __construct() { static::$c = new PDO('mysql:host=localhost;dbname=leaderboard', 'root', ''); static::$c->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } public function p($query) { $this->s = static::$c->prepare($query); $this->s->setFetchMode(PDO::FETCH_ASSOC); } public function e($data = array()) { $this->s->execute($data); } public function select($query) { $this->p($query); $this->e(); return $this->s->fetchAll(); } } $db = new database(); echo json_encode($db->select("SELECT * FROM `tmp` ORDER BY score DESC"));
$config = array(); $mods = array(); $garde = array(); //$garde=array("a" => "", "b" => "", "c" => "","d" => "", "e" => "","f" => "", "g" => "", "h" => "", "i" => "", "j" => "", "k" => "", "l" => "", "m" => "", "n" => "", "o" => "","p" => "", "q" => "", "r" => "", "s" => "", "t" => "", "u" => "", "v" => "", "w" => "", "x" => "", "y" => "", "z" => "",); //$is_grade=grade_s($s_joueur); include 'config.php'; if (!defined("PHPTOURNOIS_INSTALLED")) { header("Location: install.php"); die; } /*** ouverture de la base de donnees ***/ $db = new database(); $db->debug($dbdebug); $db->connect($dbhost, $dbuser, $dbpass, $dbname); /*** chargement de la configuration dynamique***/ $db->select("*"); $db->from("{$dbprefix}config"); $db->exec(); $config = array_merge($config, $db->fetch_array()); if (isset($m4url)) { $config['m4url'] = $m4url; } else { $config['m4url'] = ''; } if (isset($aburl)) { $config['aburl'] = $aburl; } else { $config['aburl'] = ''; } /*** chargement de la configuration des mods***/ $db->select("*");
/********* Setting up hospital list ***********/ $hos = array(); $hoslist = "("; //Splite hospital if (isset($_GET['hospital'])) { $hos = explode('|', $_GET['hospital']); foreach ($hos as $h) { if ($h != '') { $hoslist .= "'" . $h . "',"; } else { $hoslist .= "'0000')"; } } } else { $strSQL = "SELECT institute_id FROM fmn1_institute WHERE 1"; $resultInst = $db->select($strSQL, false, true); if ($resultInst) { foreach ($resultInst as $h) { if ($h != '') { $hoslist .= "'" . $h[0] . "',"; $hos[] = $h[0]; } else { $hoslist .= "'0000')"; } } $hoslist .= "'0000')"; } } foreach ($hos as $v) { //print $v."<br>"; }
<?php session_start(); $pid = ''; if (isset($_GET['pid'])) { $pid = $_GET['pid']; } require_once "../../lib/server-config.php"; require_once "../../lib/connect.class.php"; $db = new database(); $db->connect2(trim($u), trim($p), trim($dbn)); $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("obstetric"), mysql_real_escape_string($pid)); $resultObstetric = $db->select($strSQL, false, true); ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="description" content="Introducing Lollipop, a sweet new take on Android."> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>SIMANH South Africa</title> <!-- Page styles --> <link href="https://fonts.googleapis.com/css?family=Roboto:regular,bold,italic,thin,light,bolditalic,black,medium&lang=en" rel="stylesheet"> <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet"> <link rel="stylesheet" href="./css/material.min.css"> <link rel="stylesheet" href="styles.css"> <link rel="stylesheet" type="text/css" href="css/style.css" /> <style> #view-source {
<html> <head><TITLE></TITLE></head> <body> <h1>Transfer Parents to new table</h1> <?php include "liboutput.php"; include "libdatabase.php"; // connect database $daba = new database(); $daba->connect("localhost", "iggmp", "1s87J37r0"); $daba->select("thesaurus"); $res = mysql_query("SELECT * FROM entry where descriptor='0'"); $tempArray = fetch_to_array($res, ""); echo "Anzahl: " . count($tempArray) . "<hr>"; foreach ($tempArray as $entry) { echoall($entry); database::query("UPDATE entry SET status='1' WHERE ID='" . $entry[ID] . "'"); echo "<hr>"; } ?> </body></html>
<?php include 'classDatabase.php'; if (isset($_GET['lat']) && isset($_GET['rad'])) { $myDb = new database(); $var = str_replace(["(", ")"], "", $_GET['lat']); $lat = explode(", ", $var)[0]; $long = explode(", ", $var)[1]; $radius = $_GET['rad'] / 1000; $sql = "SELECT DISTINCT `ADDRESS`,lat, `long`, ( 6371 * ACOS( COS( RADIANS({$lat}) ) * COS( RADIANS( lat ) ) * COS( RADIANS( `LONG` ) - RADIANS({$long}) ) + SIN( RADIANS({$lat}) ) * SIN( RADIANS( lat ) ) ) ) AS distance FROM `address_lat_long` HAVING distance < {$radius} ORDER BY distance;"; //$sql="SELECT DISTINCT `ADDRESS`,lat, `long`, ( 3959 * ACOS( COS( RADIANS(-6.323258) ) * COS( RADIANS( lat ) ) * COS( RADIANS( `LONG` ) - RADIANS(106.669443) ) + SIN( RADIANS(-6.323258) ) * SIN( RADIANS( lat ) ) ) ) AS distance FROM `address_lat_long` HAVING distance < 1 ORDER BY distance LIMIT 0 , 20;"; $results = []; $res = $myDb->select($sql); while ($row = mysqli_fetch_array($res)) { $results[] = array('description' => $row[0], 'lat' => $row[1], 'lng' => $row[2]); } header('Content-Type: application/json'); $json = json_encode($results); echo $json; }
<?php session_start(); $pid = ''; if (isset($_GET['pid'])) { $pid = $_GET['pid']; } require_once "../../lib/server-config.php"; require_once "../../lib/connect.class.php"; $db = new database(); $db->connect2(trim($u), trim($p), trim($dbn)); $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE record_id = '%s'", mysql_real_escape_string("delivery"), mysql_real_escape_string($pid)); $resultDelivery = $db->select($strSQL, false, true); if (!$resultDelivery) { } ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="description" content="Introducing Lollipop, a sweet new take on Android."> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>SIMANH South Africa</title> <!-- Page styles --> <link href="https://fonts.googleapis.com/css?family=Roboto:regular,bold,italic,thin,light,bolditalic,black,medium&lang=en" rel="stylesheet"> <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet"> <link rel="stylesheet" href="./css/material.min.css"> <link rel="stylesheet" href="styles.css"> <link rel="stylesheet" type="text/css" href="css/style.css" />
<?php session_start(); include "../lib/server-config.php"; require "../lib/connect.class.php"; $db = new database(); $db->connect2(trim($u), trim($p), trim($dbn)); //Query institute's name for check duplicate $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE institute_name = '%s'", mysql_real_escape_string("institute"), mysql_real_escape_string($_POST['inst_name'])); $resultInstitute = $db->select($strSQL, false, true); $order = 1; if (!$resultInstitute) { if (sizeof($resultInstitute) > 0) { //Duplication institute's name $db->disconnect(); ?> <script> alert('Duplication institute\'s name!'); window.location = './main.php?id=3&group_id=<?php print $_POST['inst_type']; ?> &tab_id=1'; </script> <?php exit; } //Insert new institute $strSQL = sprintf("INSERT INTO " . substr(strtolower($tbf), 0, -2) . "%s \n\t\t\t\t\t VALUES ('NULL','%s','%s','%s','%s','%s','%s','%s')", mysql_real_escape_string("institute"), mysql_real_escape_string($_POST['inst_name']), mysql_real_escape_string($_POST['inst_desc']), mysql_real_escape_string($_POST['inst_phone']), mysql_real_escape_string($_POST['lat_value']), mysql_real_escape_string($_POST['lon_value']), mysql_real_escape_string($_POST['inst_type']), mysql_real_escape_string(0)); $resultInsert = $db->insert($strSQL, false, true); $strSQL = sprintf("SELECT * FROM " . substr(strtolower($tbf), 0, -2) . "%s WHERE institute_name = '%s'", mysql_real_escape_string("institute"), mysql_real_escape_string($_POST['inst_name'])); $resultInstitute2 = $db->select($strSQL, false, true);