public static function getCategorias() { $stmt = DBConn::getInstance()->prepare("SELECT * FROM categoria"); $stmt->execute(); $lista = array(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $u = new CadastroCategoria(); foreach ($row as $k => $v) { $u->{$k} = $v; } $lista[] = $u; } return $lista; }
public static function getFotosAlbum($album) { $stmt = DBConn::getInstance()->prepare("SELECT * FROM imagens WHERE id_album = {$album}"); $stmt->execute(); $lista = array(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $u = new CadastroAlbum(); foreach ($row as $k => $v) { $u->{$k} = $v; } $lista[] = $u; } return $lista; }
/** * Връща модел за текущия потребител * * Ако има $_SESSION['user_id'] се връща модел, * с това което е успял да зареди, в противен случай * се връща false * * @return mixed: User|boolean */ static function loadCurrentUser() { if (empty($_SESSION['user_id'])) { return false; } if ($_SESSION['user_serialized']) { $_SESSION['user'] = unserialize($_SESSION['user_serialized']); $_SESSION['user']->dbconn = DBConn::getInstance()->conn; } else { $model_user = new User(DBConn::getInstance()->conn, $_SESSION['user_id']); $model_user->fetch(); $_SESSION['user'] = $model_user; $_SESSION['user_serialized'] = serialize($model_user); } return $_SESSION['user']; }
public static function delete($id) { $cont = 0; $stmt = DBConn::getInstance()->prepare("DELETE FROM imagens WHERE id_album = {$id}"); if (!$stmt->execute()) { $cont++; } $stmt = DBConn::getInstance()->prepare("DELETE FROM album WHERE id = {$id}"); if (!$stmt->execute()) { $cont++; } if ($cont == 0) { return true; } else { return false; } }
/** * Função para buscar se existe o email cadastrado * @access static * @param $id, id para pesquisa de usuario * @return instancia do usuario */ public function findEmailUsuario($email) { $st = DBConn::getInstance()->prepare("SELECT * FROM usuario WHERE email = :email"); $st->bindParam(":email", $email, PDO::PARAM_INT); $st->execute(); //Obtém o registro encontrado $row = $st->fetch(PDO::FETCH_ASSOC); return $row; }
function __construct() { $this->dbconn = DBConn::getInstance()->conn; $this->smarty = SmartyInstance::getInstance()->smarty; $this->system = system::getInstance($this->dbconn); }
// HTTP/1.0 header("Pragma: no-cache"); //error_reporting(-1); //ini_set('display_errors', 1); //path properties define('MAIN_PATH', $mainPath); define('ROOT_PATH', $rootPath); define('MAIN_DIR', $mainDir); //DB config define('DB_HOST', "10.10.10.120"); define('DB_NAME', "tree_editor"); define('DB_USER', "root"); define('DB_PASS', "`12345';';"); //DB config ENSEMBL define('DB_HOST_ENSEMBL', "gramenedb.gramene.org"); define('DB_NAME_ENSEMBL', "ensembl_compara_plants_40_74"); define('DB_USER_ENSEMBL', "anonymous"); define('DB_PASS_ENSEMBL', "gramene"); //includes require_once $libDir . 'smarty/SmartyBC.class.php'; require_once $libDir . 'smarty/SmartyInstance.class.php'; // create object $smarty = SmartyInstance::getInstance()->smarty; require_once $libDir . "adodb/adodb.inc.php"; require_once $libDir . "adodb/DBConn.class.php"; require_once $libDir . "classes/all_classes.inc.php"; require_once $rootPath . "php/all_controllers.inc.php"; //database connect $dbconn = DBConn::getInstance()->conn; $system = system::getInstance($dbconn); $smarty->assign('mainDir', $mainDir);
public function del($archive = 0) { $q = "DELETE FROM " . $this->dbdata_table . " WHERE id=? "; $st = $this->dbconn->Prepare($q); $r = $this->dbconn->Execute($st, array($this->id)); if (!$r) { $_SESSION['hidden_error'] = "Could not fetch the " . get_class($this) . " record! " . $this->dbconn->ErrorMsg(); return false; } //generate log if ($this->dbdata_table == 'profiles' || $this->dbdata_table == 'contents' and $archive == 1) { $cols_update = array(); $vars_update = array(); $cols_update[] = 'event'; $vars_update[] = 'delete'; $cols_update[] = 'event_id'; $vars_update[] = $this->id; $cols_update[] = 'event_profile_id'; $vars_update[] = $_SESSION['profile_id']; $cols_update[] = 'event_date'; $vars_update[] = date("Y-m-d H:i:s"); $dbconn_archive = DBConn::connectArchive(); $q_archive = "INSERT INTO " . $this->dbdata_table . "(" . implode(",", $cols_update) . ") VALUES (" . str_repeat("?,", count($vars_update) - 1) . "?)"; $st_archive = $dbconn_archive->Prepare($q_archive); $r_archive = $dbconn_archive->Execute($st_archive, $vars_update); } $dbconn = DBConn::getInstance()->conn; $this->dbconn = $dbconn; return true; }