function remove($dbs) { echo "Remove Duplicate Row\n\n"; $db = new Database(); $conn = $db->connectDatabase(); foreach ($dbs as $dbname) { $db->selectDatabase($conn, $dbname); $db->createTmpTable($conn, "products"); $db->insertIntoTmp($conn, "products"); $db->dropTable($conn, "products"); $db->renameTable($conn, "products"); echo $dbname . "\n"; } }
function insertProductItemToDatabase($productItems, $row, $page) { static $count = 0; $db = new Database(); $conn = $db->connectDatabase(); $db->createDatabase($conn, $this->databaseName()); $db->selectDatabase($conn, $this->databaseName()); $this->createProductTable($conn); foreach ($productItems as $key => $data) { if (!isset($data['brand'])) { $data['brand'] = ''; } if (!isset($data['description'])) { $data['description'] = ''; } $data['url'] = $this->scraper->merchantUrl . $data['url']; $data['category'] = $this->item['category']; $data['merchant'] = $this->merchantName; $this->insertTable($conn, $data); $count++; $this->printResult($row, $page, $count, $data); } $this->logLastInsert($row, $page); }
<?php require_once 'database.php'; require_once 'config.php'; Server::connectToServer(); Database::selectDatabase(); $hospital_name; function getDoctorType($x) { switch ($x) { case '1': return 'Хірург'; break; case '2': return 'Педіатр'; break; case '3': return 'Травматолог'; break; } } $hospital_id = $_GET["hospital_id"]; function getHospitalName($hospital_id) { switch ($hospital_id) { case 1: return "Вінницька міська клінічна лікарня №1"; break; case 2: return "Вінницька міська клінічна лікарня №2"; break;
<?php include_once "../config.php"; include_once "../lib/Database.php"; session_start(); if (!(isset($_SESSION['student']) && isset($_SESSION['test']))) { echo "Invalid session"; return; } $student = $_SESSION['student']; $test = $_SESSION['test']; $db = new Database(DB_HOST, DB_USER, DB_PASS); $db->selectDatabase(DB_NAME); $ts = $db->getValue("select TimeSpent from oes_Test where ID = {$test}"); if ($ts == null) { $ts = 0; } if (isset($_SESSION['duration'])) { $duration = $_SESSION['duration']; } else { $duration = $db->getValue("select Duration from oes_Exam where ID = (select Exam from oes_Test where ID = {$test})"); $_SESSION['duration'] = $duration; } if ($ts < $duration) { echo "<div class=title>Thời gian</div>"; $db->query("update oes_Test set TimeSpent = " . ($ts + 1) . " where ID = {$test}"); } else { echo '<script>parent.onTimeOut()</script>'; echo "<div class=timeout>Hết giờ</div>"; $_SESSION['TIME_OUT'] = true; }
<? $INC_PATH = "/home/imperial/domains/game.imperial-battle.com/private_html/includes_01/"; require($INC_PATH.'classes/class.database.php'); require($INC_PATH.'classes/class.user.php'); require($INC_PATH.'classes/class.battleenginecollection.php'); session_start(); require($INC_PATH.'config.inc.php'); require($INC_PATH.'functions.inc.php'); /* New database object */ $db = new Database; $db->setIP($dbconf['ip']); $db->setPort($dbconf['port']); $db->setUsername($dbconf['username']); $db->setPassword($dbconf['password']); $db->setDatabase($dbconf['database']); $db->connect(); $db->selectDatabase(); /* New user object */ if ((!$user) && (!$_SESSION['user'])) { $user = new User($table['players'], 'id', 'username', 'password', $db); $_SESSION['user'] = $user; } if (($_SESSION['user']) && (!$user)) { $user = $_SESSION['user']; } ?>