function __construct(REQUEST $req = NULL, DATABASE $db, &$info, $flags = 0)
{
parent::__construct($props, $flags);
if ($flags & GRAPHAxes::PRIVATE_AXES) {
$prefix = "{$req->props['db_server']}__{$req->props['db_name']}__";
} else {
$prefix = "";
}
if (!$info['table']) {
throw new ADEIException("The axes table is not specified in the reader configuration");
}
if (!$info['id']) {
throw new ADEIException("The id column for axes table is not specified in the reader configuration");
}
$query = "";
if (is_array($info['properties'])) {
foreach ($info['properties'] as $prop => $col) {
$query .= ", {$col} AS {$prop}";
}
}
$axes = $db->Query("SELECT {$info['id']} AS axis_id{$query} FROM {$this->col_quote}{$info['table']}{$this->col_quote}");
foreach ($axes as $axis) {
$this->axis_info[$prefix . $axis['axis_id']] = $axis;
}
}
public static function doCall($table, $data, $debug = false)
{
$DBobject = parent::init();
foreach ($data as $key => $value) {
$key = self::escape($key);
$value = self::escape($value);
$keys .= $key . ", ";
if ($value == null) {
$values .= "null, ";
} else {
$values .= "'" . $value . "', ";
}
}
$keys = rtrim($keys, ', ');
$values = rtrim($values, ', ');
$sql = "INSERT INTO {$table} (" . $keys . ") VALUES (" . $values . ")";
if ($debug == true) {
$_SESSION['debug'][] = __FUNCTION__ . ': $sql is <strong>' . $sql . '</strong>';
}
$DBobject->query($sql);
if ($DBobject->errno) {
$_SESSION['errors'][] = '<p>' . __FUNCTION__ . ' failed: ' . $DBobject->error . '<br> statement was: <strong> ' . $sql . '</strong></p>';
}
//self::$insertID = self::$db->insert_id;
}
/**
* Obtiene la instancia Singleton
* @return DB
*/
public static function getInstance()
{
if (self::$instance == null) {
self::$instance = new self();
}
return self::$instance;
}
public function insert($post)
{
extract($post);
$ip = $_SERVER['REMOTE_ADDR'];
$verification = DATABASE::DB()->prepare("SELECT * FROM result WHERE ip = :id");
$verification->bindvalue(':id', $ip, PDO::PARAM_STR);
$verification->execute();
$correspondance = $verification->fetch();
if (!$correspondance) {
$query = "\n\t\t\tINSERT INTO result (\n\t\t\tip,question_1, question_2, question_3, question_4, question_5, question_6, \n\t\t\tquestion_7, question_8, question_9, question_10_1, question_10_2, question_10_3, \n\t\t\tquestion_11, question_12) \n\t\t\tVALUES (\n\t\t\t:ip,:question_1, :question_2, :question_3, :question_4, :question_5, :question_6, \n\t\t\t:question_7, :question_8, :question_9, :question_10_1, :question_10_2, :question_10_3, \n\t\t\t:question_11, :question_12)";
$insert = DATABASE::DB()->prepare($query);
$insert->bindvalue(':ip', $ip, PDO::PARAM_STR);
$insert->bindvalue(':question_1', $question_1, PDO::PARAM_STR);
$insert->bindvalue(':question_2', $question_2, PDO::PARAM_STR);
$insert->bindvalue(':question_3', $question_3, PDO::PARAM_STR);
$insert->bindvalue(':question_4', $question_4, PDO::PARAM_STR);
$insert->bindvalue(':question_5', $question_5, PDO::PARAM_STR);
$insert->bindvalue(':question_6', $question_6, PDO::PARAM_STR);
$insert->bindvalue(':question_7', $question_7, PDO::PARAM_STR);
$insert->bindvalue(':question_8', $question_8, PDO::PARAM_STR);
$insert->bindvalue(':question_9', $question_9, PDO::PARAM_STR);
$insert->bindvalue(':question_10_1', $question_10_1, PDO::PARAM_STR);
$insert->bindvalue(':question_10_2', $question_10_2, PDO::PARAM_STR);
$insert->bindvalue(':question_10_3', $question_10_3, PDO::PARAM_STR);
$insert->bindvalue(':question_11', $question_11, PDO::PARAM_STR);
$insert->bindvalue(':question_12', $question_12, PDO::PARAM_STR);
$insert->execute();
return $info = "GOOD";
} else {
return $info = "ERROR_IP";
}
}
/**
* Obtiene el nombre de la provincia por el ID dado.
* @param type $id
* @return string
*/
function ObtenerNombreProvincia($id)
{
$db = DATABASE::getInstance();
if ($datos = $db->select("provincias", "nombre", "cod={$id}")) {
return $datos[0]["nombre"];
}
return "Desconocida";
}
/**
* Compile the current element
*/
protected function compile()
{
$sb = $this->select_bill;
$db = DATABASE::getInstance();
$stmt = $db->prepare("SELECT * FROM tl_my_modul WHERE id=?");
$res = $stmt->execute($sb);
$rowA = $res->fetchAssoc();
$this->Template->all = $rowA;
}
private function FirstConnectToDB()
{
self::$CONNECTION = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if (!self::$CONNECTION) {
exit(mysqli_connect_error($this->CONNECTION));
}
mysqli_query(self::$CONNECTION, "SET CHARACTER SET UTF8");
mysqli_query(self::$CONNECTION, "SET NAMES SET UTF8");
}
protected static function init()
{
// load configfile
$config = $GLOBALS['config'];
if (self::$INSTANCE == null) {
self::$INSTANCE = new mysqli($config['DBHOST'], $config['DBUSER'], $config['DBPASSWORD'], $config['DBNAME']);
if (self::$INSTANCE->connect_errno) {
print "DATABASE: MySQL connection failed: " . self::$INSTANCE->connect_error;
}
self::$INSTANCE->query("SET NAMES utf8;");
}
return self::$INSTANCE;
}
/**
* Updating meta row data
* @param integer $idMeta
* @param string $titulo
* @param string $descripcion
* @param DateTime $fechaLim
* @param string $categoria
* @param integer $prioridad
* @return PDOStatement|number
*/
public static function update($idMeta, $titulo, $descripcion, $fechaLim, $categoria, $prioridad)
{
//Creating UPDATE statement
$query = "UPDATE meta " . "SET titulo=:titulo, descripcion=:descripcion, fechaLim=:fechaLim, categoria=:categoria, prioridad=:prioridad " . "WHERE idMeta = :idMeta";
try {
//Preparing statement
$statement = DATABASE::getInstance()->getDb()->prepare($query);
//Relationing and executing statement
$statement->execute(array(":titulo" => $titulo, ":descripcion" => $descripcion, ":fechaLim" => $fechaLim, ":categoria" => $categoria, ":prioridad" => $prioridad));
return $statement;
} catch (PDOException $e) {
return -1;
}
}
public function connect($post)
{
extract($post);
$finalpass = base64_encode(sha1($password, true));
$select = DATABASE::DB()->prepare("SELECT * FROM users WHERE name = :name AND password = :password");
$select->bindvalue(':name', $username, PDO::PARAM_STR);
$select->bindvalue(':password', $finalpass, PDO::PARAM_STR);
$select->execute();
$correspondance = $select->fetch();
if ($correspondance) {
$_SESSION['login'] = '******';
$_SESSION['id'] = $correspondance['id'];
$_SESSION['name'] = $correspondance['name'];
$_SESSION['nb_survey'] = $correspondance['nb_survey'];
}
}
private function getUserDates()
{
$user = DATABASE::select('users', '*', "`userID`='" . $_SESSION['userID'] . "' AND `isEnabled`='1'", '');
if (count($user) == 1) {
$this->GROUP = $user[0]['userGroup'];
$this->EMAIL = $user[0]['email'];
$this->USERNAME = $user[0]['userName'];
$this->USERLATNAME = $user[0]['userLastName'];
$this->USERID = $user[0]['userID'];
$this->PASSWORD = $user[0]['password'];
$this->LOGIN = $user[0]['userLogin'];
$this->ACCESS_ADMIN_PANEL = $user[0]['accessAdminPanel'];
} else {
print_r($user);
}
}
public function InfoFile($path, $file)
{
$getInfoFromDB = DATABASE::select("filemanager", "*", "`path`='" . $path . "' AND `file`='" . $file . "' AND `isEnabled`='1'", '');
if (is_file(dirname(__FILE__) . "/../../../" . $path . '/' . $file)) {
$getExtenstion = explode('.', $file);
if (in_array($getExtenstion[count($getExtenstion) - 1], $this->extensions)) {
self::$Icons[] = $this->icons[array_search($getExtenstion[count($getExtenstion) - 1], $this->extensions)];
} else {
self::$Icons[] = 'file-o';
}
} else {
self::$Icons[] = 'folder';
}
$userInfo = new USER($getInfoFromDB[0]['userID']);
self::$fileInfo[] = array($file, substr($getInfoFromDB[0]['timestamp'], 0, 10), substr($getInfoFromDB[0]['timestamp'], 10), $userInfo->USERLATNAME);
if (is_file(dirname(__FILE__) . "/../../../" . $path . '/' . $file)) {
self::$fileInfo[][4] = new ADMIN_TRANSLATION(LANG, 'download', 1, 0);
}
}
public static function doCall($sql, $return = true, $debug = false)
{
$DBobject = parent::init();
//call the database
$result = $DBobject->query($sql);
if ($DBobject->errno) {
$_SESSION['errors'][] = '<p>select failed: ' . $DBobject->error . '<br> statement was: <strong>' . $sql . '</strong></p>';
return array();
} elseif ($return == true) {
$ret = array();
while ($row = $result->fetch_assoc()) {
$ret[] = $row;
}
return $ret;
}
if ($debug == true) {
logfile::doLog(__FUNCTION__ . ' : $sql is ' . $sql);
}
}
public static function doCall($table, $primary, $wnummer, $data, $debug = false)
{
$DBobject = parent::init();
$sql = "UPDATE {$table} SET ";
foreach ($data as $key => $value) {
if ($value == null) {
$sql .= "{$key} = null, ";
} else {
$sql .= "{$key} = '{$value}', ";
}
}
$sql = rtrim($sql, ", ");
$sql .= " WHERE " . $primary . " = '" . $wnummer . "'";
if ($debug == true) {
logfile::doLog(__FUNCTION__ . ' : $sql is ' . $sql);
}
$DBobject->query($sql);
if ($DBobject->errno) {
}
}
public function OpenFolder($path)
{
if ($path !== '.') {
$dir = opendir(dirname(__FILE__) . "/../../../" . $path);
} else {
$dir = opendir(dirname(__FILE__) . "/../../../");
}
while ($name = readdir($dir)) {
$getInfoFromDB = DATABASE::select("filemanager", "`size`,`timestamp`", "`path`='" . $path . "' AND `file`='" . $name . "' AND `isEnabled`='1'", '');
if (count($getInfoFromDB) > 0) {
$infoFile = $getInfoFromDB[0];
} else {
$insertIntoDB = DATABASE::insert('filemanager', '`file`,`path`,`timeseconds`,`userID`,`isEnabled`,`size`', "'" . $name . "','" . $path . "','" . ADMIN_CONFIGURATION::$CONFIG['timeseconds'] . "','1','1','" . filesize(dirname(__FILE__) . "/../../../" . $path . '/' . $name) . "'", '0');
}
if (isset($infoFile)) {
$userInfo = new USER($infoFile['userID']);
} else {
$userInfo = new USER($_SESSION['userID']);
}
if ($name == '.') {
$name = new ADMIN_TRANSLATION(LANG, 'FileManagerRoot', 1, 0);
}
if ($name == '..') {
$name = new ADMIN_TRANSLATION(LANG, 'FileManagerUP', 1, 0);
}
self::$fileInfo[] = ADMIN_CONFIGURATION::$CONFIG['adminURL'] . LANG . '/filemanager/?modal=1path=' . urlencode($path) . '&file=' . urlencode($name);
if (is_file(dirname(__FILE__) . "/../../../" . $path . '/' . $name)) {
$getExtenstion = explode('.', $name);
if (in_array($getExtenstion[count($getExtenstion) - 1], $this->extensions)) {
self::$Icons[] = $this->icons[array_search($getExtenstion[count($getExtenstion) - 1], $this->extensions)];
} else {
self::$Icons[] = 'file-o';
}
} else {
self::$Icons[] = 'folder';
}
self::$files[] = array($name, $userInfo->USERNAME . ' ' . $userInfo->USERLATNAME, $infoFile['size'], $infoFile['timestamp']);
}
}
/**
* @param DATABASE $db Database from which to load values.
*/
public function load($db)
{
$this->_exists = true;
$this->kind = $db->f('kind');
$this->folder_id = $db->f('folder_id');
$this->ref_id = $db->f('ref_id');
$this->importance = $db->f('importance');
$this->privileges->load($db);
}
/**
* @param DATABASE $db Database from which to load values.
*/
public function load($db)
{
$this->_exists = true;
$this->user_id = $db->f('user_id');
$this->global_privileges->load($db);
$this->allow_privileges->load($db, 'allow_');
$this->deny_privileges->load($db, 'deny_');
}
private function FindPageInDB()
{
//echo $this->LANG.' '.$this->MODULE.' '.$this->ID;
$getPage = parent::select('modules', '`moduleDirectory`', "`moduleTitle`='{$this->MODULE}'", '');
if (count($getPage) == 0) {
header("HTTP/1.0 404 Not Found");
require_once dirname(__FILE__) . '/../../common/views/404.php';
exit;
}
}
/**
* accepts a finalised sql statement and prepares SQL for DATABASE
*
* @param string $sql
* @param boolean $void set whether or not the statement is
* an insert, update, delete or typical select statement,
* i.e. select * from dual
*
* @return the class object
*/
public function __compiled_str($sql, $void = false)
{
$this->__setIsVoid();
if (is_bool($void)) {
if (!$void) {
if (DATABASE::startswith(strtoupper($sql), "SELECT")) {
$this->__setIsSelect();
}
if (DATABASE::startswith(strtoupper($sql), "UPDATE")) {
$this->__setIsUpdate();
}
if (DATABASE::startswith(strtoupper($sql), "DELETE")) {
$this->__setIsDelete();
}
if (DATABASE::startswith(strtoupper($sql), "INSERT")) {
$this->__setIsInsert();
}
}
} elseif (is_int($void)) {
if ($void === DATABASE::ALL) {
$this->__setIsSelect();
}
if ($void === DATABASE::UPD) {
$this->__setIsUpdate();
}
if ($void === DATABASE::DEL) {
$this->__setIsDelete();
}
if ($void === DATABASE::INS) {
$this->__setIsInsert();
}
}
$this->__statement__ = $sql;
$this->__fix_where();
return $this;
}
<?php require "c:/xampp/security/pixelp/_connector.php"; require "include/init.php"; require "classes/db.php"; require "classes/pixelp.php"; $db = new DATABASE(); $db->connect(DB_HOST, DB_NAME, DB_USER, DB_PASS, DB_CHARSET, DB_COLLATION); $import = new PIXELP_IMPORT($db); //$import->add_queue(); $import->process_queue();
/**
* @param DATABASE $db
*/
public function load($db)
{
$this->options_id = $db->f('options_id');
$this->trunk_id = $db->f('trunk_id');
parent::load($db);
}
// show_login_page($t, $o);
}
$ad = new LDAP();
// AD objekt
$ad->debug = $w->debug;
if (!$ad->connect()) {
$t->errors[ERROR][] = 'L002 ' . $l->txt_err_ldap_connect;
}
if (!$ad->bind($p->uname, $p->secret)) {
// create a syslog entry
syslog(LOG_NOTICE, sprintf("AD bind failed. user: %s remote_addr: %s method: %s token: %s", $p->uname, $w->remote_addr, $auth_method, $o->token));
// AD bind failis. Nüüd proovime lokaalse kasutajaga.
require INC_DIR . '/local.php';
if ($w->allow_local) {
if (!isset($d)) {
$d = new DATABASE();
// lokaalsed kasutajad paiknevad DB's. Siiani pole DB'd vaja läinud.
$d->debug = $w->debug;
if (!$d->connect(DB_HOST, DB_USER, DB_PASS, DATABASE)) {
$t->errors[ERROR][] = 'C001.1 ' . $l->txt_err_open_database;
}
}
// print_r($d);
if (local_login($d, $p->uname, $p->secret, $u)) {
$auth_method = 'local';
$authok = true;
} else {
// create a syslog entry
syslog(LOG_NOTICE, sprintf("User not found. user: %s remote_addr: %s method: %s token: %s", $p->uname, $w->remote_addr, $auth_method, $o->token));
$t->errors[ERROR][] = 'L003 ' . $l->txt_err_authentication;
}
<h3>Screenings</h3>
<?php
require_once "classes/Database.php";
require_once "classes/Screening.php";
require_once "classes/ScreeningFetcher.php";
require_once "classes/Cinema.php";
require_once "classes/Movie.php";
require_once "includes/ticketForm.php";
$db = DATABASE::getInstance();
$fetcher = new ScreeningFetcher($db);
$fetcher->getAllScreeningsFromDb();
$screeningsArray = $fetcher->getArrayWithScreenings();
if (!empty($screeningsArray)) {
echo "<ul>";
foreach ($screeningsArray as $screening) {
$movieName = $screening->getMovie()->getName();
$movieId = $screening->getMovie()->getId();
$cinemaName = $screening->getCinema()->getName();
$cinemaId = $screening->getCinema()->getId();
$screeningId = $screening->getId();
$date = $screening->getDate();
$dateFormatted = substr($date, 0, 16);
echo "<li><a href='showInfo.php?type=movie&id={$movieId}'>{$movieName}</a>, <a href='showInfo.php?type=cinema&id={$cinemaId}'>{$cinemaName}</a>, Date & Time: {$dateFormatted}";
renderTicketForm($screeningId);
echo "</li>";
}
echo "</ul>";
} else {
echo "No screenings";
}
<?php
/**
* Koodi include auth protsessiloogika arusaadavuse tagamiseks.
* Vajab $u objekti. Loob lokaalseks arvepidamiseks uued olemid.
*
* @author: walker
*/
if (!isset($d)) {
$d = new DATABASE();
$d->debug = $w->debug;
if (!$d->connect(DB_HOST, DB_USER, DB_PASS, DATABASE)) {
$t->errors[ERROR][] = 'C001 ' . $l->txt_err_open_database;
show_error_page($t, $o);
// todo - erinevad tekstid
}
}
$s = new SESSION($d);
$s->debug = $w->debug;
$s->d = $d;
// Kas selline ettevõte eksisteerib juba lokaalses andmebaasis?
if (!$s->get_organization_id($u->company)) {
$c->name = $u->company;
$c->country_id = '1';
// TODO
if (!$s->create_organization($c)) {
$t->errors[ERROR][] = 'L005 ' . $l->txt_err_user_update;
show_login_page($t, $o);
}
unset($c);
}
/**
* @param DATABASE $db Database from which to load values.
*/
public function load($db)
{
$this->id = $db->f('id');
}
}
?>
<div>
Delete frame "<?=$frame['name']?>"?
</div>
<div class="formbuttons">
<button type="button" onClick="deleteframe(true)">Delete</button>
<button type="button" onClick="clearform()">Cancel</button>
</div>
<?
break;
case "editform":
$frame = DATABASE::record("sprite_frame","sprite_frame_id",$_GET['id']);
?>
<form id="frameform">
<input type="hidden" name="action" value="edititem">
<input type="hidden" name="sprite_id" value="<?=$frame['sprite_id']?>">
<input type="hidden" name="sprite_frame_id" value="<?=$_GET['id']?>">
<div style="clear:both;padding-top:10px;text-align:right;"> Name:<input type="text" name="name" style="width:175px;" value="<?=$frame['name']?>">
X:<input type="text" name="x" style="width:35px;" value="<?=$frame['x']?>">
Y:<input type="text" name="y" style="width:35px;" value="<?=$frame['y']?>">
W:<input type="text" name="w" style="width:35px;" value="<?=$frame['w']?>">
H:<input type="text" name="h" style="width:35px;" value="<?=$frame['h']?>">
MipMap:<input type="text" name="m" style="width:35px;" value="<?=$frame['mip']?>">
</div>
<div style="text-align:center;padding: 10px;">
<canvas id="plottingcanvas" style="background-color:#000; margin-top:10px;" width="300" height="300"></canvas>
<canvas id="previewcanvas" style="background-color:#000; margin:10px;" width="150" height="150"></canvas>
function DoCache(&$req)
{
global $user_req;
global $verbose;
global $ROOT_DB;
global $syslock;
try {
$reader = $req->CreateReader(REQUEST::READER_FORBID_CACHEREADER);
} catch (ADEIException $e) {
if ($e->getCode() == ADEIException::DISCONNECTED) {
return;
}
$e->logInfo(translate("READER constructor is failed"), $req);
return $req->GetLocationString() . ", Error: " . $e->getInfo();
}
try {
$opts =& $req->GetOptions();
$rootdb = $opts->Get('root_database');
$list = $req->GetGroups($reader);
} catch (ADEIException $e) {
$e->logInfo(translate("Problem processing options"), $reader);
return $req->GetLocationString() . ", Error: " . $e->getInfo();
}
if ($rootdb) {
if (strchr($rootdb, "/")) {
$db_info = false;
$inq_app = adei_app("csv2root", "--file " . $rootdb . " --inquiry-latest-data", true);
$app = adei_app("csv2root", "--file " . $rootdb, true);
} else {
try {
$db_info = $ROOT_DB;
$db_info['database'] = $rootdb;
$database = new DATABASE($db_info);
} catch (ADEIException $e) {
unset($db_info['database']);
try {
$database = new DATABASE($ROOT_DB);
$database->CreateDatabase($rootdb);
} catch (ADEIException $e) {
$e->logInfo(translate("Problem accessing ROOT database \"%s\"", $rootdb), $req);
echo translate("Problem accessing ROOT database \"%s\": %s\n", $rootdb, $e->getInfo());
$rootdb = false;
}
}
if ($rootdb) {
$conprm = $db_info['driver'] . "://" . $db_info['host'] . ($db_info['port'] ? ":" . $db_info['port'] : "") . "/" . $rootdb;
$inq_app = adei_app("csv2root", "--db " . $conprm . " --inquiry-latest-data", true);
$app = adei_app("csv2root", "--db " . $conprm, true);
}
}
if ($rootdb) {
if (!$app || !$inq_app) {
echo "csv2root is not present";
$rootdb = false;
} else {
$groups = $reader->GetGroupList(REQUEST::NEED_INFO);
}
}
}
foreach ($list as $gid => $greq) {
if (isset($user_req->props['db_group']) && $user_req->props['db_group'] != $gid) {
continue;
}
if ($verbose) {
echo "{$greq->props['db_server']} -- {$greq->props['db_name']} -- {$gid}:";
}
$syslocked = false;
$prelocked = false;
try {
$cache = $greq->CreateCacheUpdater($reader);
$syslock->Lock(LOCK::BLOCK);
$syslocked = true;
if (!$cache->PreLock()) {
if ($verbose) {
echo " busy\n";
}
continue;
}
$prelocked = true;
$syslocked = false;
$syslock->UnLock();
$cache->Update($ivl = NULL, CACHE::DIM_AUTO, verbose ? CACHE::VERBOSE : 0);
$prelocked = false;
$cache->UnLock();
if ($rootdb) {
$grname = " --group \"" . $groups[$gid]["name"] . "\"";
ROOTCache($cache, $db_info, $app . $grname, $inq_app . $grname, $conprm ? $conprm : $rootdb);
}
unset($cache);
} catch (ADEIException $e) {
if ($prelocked) {
$cache->UnLock();
}
if ($syslocked) {
$syslock->UnLock();
}
if ($e->getCode() != ADEIException::DISABLED) {
$e->logInfo(translate("Failed to update CACHE"), $cache ? $cache : $greq);
if ($verbose) {
echo " failed\n";
}
return $greq->GetLocationString() . ", Error: " . $e->getInfo();
}
}
if ($verbose) {
echo " done\n";
}
}
return 0;
}
public function add_survey($post)
{
extract($post);
isset($choice_1) ? $choice_1 = $choice_1 : ($choice_1 = '');
isset($choice_2) ? $choice_2 = $choice_2 : ($choice_2 = '');
isset($choice_3) ? $choice_3 = $choice_3 : ($choice_3 = '');
isset($choice_4) ? $choice_4 = $choice_4 : ($choice_4 = '');
isset($choice_5) ? $choice_5 = $choice_5 : ($choice_5 = '');
$insert = DATABASE::DB()->prepare("INSERT INTO surveys (id_user, name, description, choice_1, choice_2, choice_3, choice_4, choice_5) VALUES (:id_user, :name, :description, :choice_1, :choice_2, :choice_3, :choice_4, :choice_5)");
$insert->bindvalue(':id_user', $_SESSION['id'], PDO::PARAM_INT);
$insert->bindvalue(':name', $name, PDO::PARAM_STR);
$insert->bindvalue(':description', $description, PDO::PARAM_STR);
$insert->bindvalue(':choice_1', $choice_1, PDO::PARAM_STR);
$insert->bindvalue(':choice_2', $choice_2, PDO::PARAM_STR);
$insert->bindvalue(':choice_3', $choice_3, PDO::PARAM_STR);
$insert->bindvalue(':choice_4', $choice_4, PDO::PARAM_STR);
$insert->bindvalue(':choice_5', $choice_5, PDO::PARAM_STR);
$insert->execute();
}
public static function INIT($host, $driver, $user, $pass, $name)
{
if (class_exists('PDO') === false) {
$error = "This server does not support PDO.";
throw new Exception($error);
return false;
}
if (!in_array($driver, self::DRIVERS())) {
$error = "Database driver '" . $driver . "' not supported on this server.";
throw new Exception($error);
return false;
}
try {
self::$PDO = new PDO($driver . ':host=' . $host . ';dbname=' . $name, $user, $pass);
self::$PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
self::$FETCHMODE = PDO::FETCH_ASSOC;
} catch (PDOException $e) {
$error = "Unable to connect to " . $driver . ":host=" . $host . ";dbname=" . $name . "\n";
$error .= 'ERROR: ' . $e->getMessage();
throw new Exception($e);
return false;
}
return true;
}
/**
* Devuelve los datos del usuario dado, ignorando su hash de contraseña.
* Si el usuario no existe se devuelve false.
* @param type $usuario
* @return boolean
*/
function getUsuario($usuario)
{
if (!existeUsuario($usuario)) {
return false;
}
$db = DATABASE::getInstance();
$result = $db->select("usuarios", "usuario, tipo", "usuario='{$usuario}'");
return $result[0];
}
