function auto_checkout_by_location($location_id) { $query = <<<SQL SELECT t.`id`, t.`registration_id`, t.`checked_in`, t.`checked_out`, t.`created`, t.`modified` FROM `tracking` t INNER JOIN `registration` r ON t.`registration_id` = r.`id` WHERE r.`location_id` = :location_id AND t.`checked_out` IS NULL SQL; $dbaccess = new db_access(); $dbaccess->open_connection(); $checkins = $dbaccess->fetch_all($query, array(get_db_param(':location_id', $location_id, PDO::PARAM_INT)), true); $query = <<<SQL UPDATE `tracking` SET `checked_out` = :now, `modified` = :now WHERE `id` = :tracking_id; SQL; foreach ($checkins as $checkin) { $dbaccess->update($query, array(get_db_param(':tracking_id', $checkin['id'], PDO::PARAM_INT), get_db_param(':now', get_db_now(), PDO::PARAM_STR)), true); } $dbaccess->close_connection(); return json_decode(json_encode($data), FALSE); }
function getAddress($query) { global $t_address; $sqlQueryString = "SELECT * FROM '" . $t_address . "' WHERE address LIKE '%" . $query . "%'"; $a = new db_access(); return $a->prepareSentence($sqlQueryString); }
function searchQuery($code, $searchQuery) { $dbConnection = new db_access(); $result = false; //en caso que tenga código if ($code) { switch ($code) { case ':na': $result = $dbConnection->getName($searchQuery); break; case ':co': $result = $dbConnection->getCode($searchQuery); break; case ':ip': $result = $dbConnection->getIp($searchQuery); break; case ':ad': $result = $dbConnection->getAddress($searchQuery); break; default: $result = false; } //en caso que NO tenga código } else { $result = array_merge($dbConnection->getName($searchQuery), $dbConnection->getIp($searchQuery), $dbConnection->getAddress($searchQuery), $dbConnection->getCode($searchQuery)); } return $result; }
function db_query($sql) { $connect = new db_access(); $connect->initialize(); $connect->connect(); $result = mysql_query($sql); if (!$result) { die("Unable to query database" . mysql_error() . "\n" . $sql); } return $result; }
if ($database == 'mysql') { if ($db_host && $db_user && $db_name) { $sc = new db_mysql(); $sc->connect($db_host, $db_user, $db_pass, $db_name, $CFG['db_expires'], $CFG['db_charset'], $CFG['pconnect']); } else { $sc =& $db; } } else { if ($database == 'mssql') { require DT_ROOT . '/include/db_mssql.class.php'; $sc = new db_mssql(); $sc->connect($db_host, $db_user, $db_pass, $db_name); } else { if ($database == 'access') { require DT_ROOT . '/include/db_access.class.php'; $sc = new db_access(); $sc->connect(DT_ROOT . '/' . $db_host, $db_user, $db_pass, $db_table); } else { msg('配置文件错误'); } } } $key = strpos($db_key, '.') !== false ? trim(substr(strrchr($db_key, '.'), 1)) : $db_key; if (!isset($fid)) { $r = $sc->get_one("SELECT min({$db_key}) AS fid FROM {$db_table} WHERE {$db_key}>{$lastid} {$db_condition}"); $fid = $r['fid'] ? $r['fid'] : 0; } if (!isset($tid)) { $r = $sc->get_one("SELECT max({$db_key}) AS tid FROM {$db_table} WHERE {$db_key}>{$lastid} {$db_condition}"); $tid = $r['tid'] ? $r['tid'] : 0; }
<?php @(include_once 'config.php'); @(include_once 'database.php'); @(include_once 'functions.php'); $connect = new db_access(); $connect->initialize(); $connect->connect();