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";
     }
 }
Example #2
0
 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);
 }
Example #3
0
<?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;
Example #4
0
<?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;
}
Example #5
0
<?
$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'];
}
?>