public function count($tabla) { $db = new DatabaseConfig(); $mysqli = $db->connect(); $resultado = $mysqli->query("SELECT COUNT(*) FROM {$tabla} WHERE activo = '1' "); $row = $resultado->fetch_row(); return $row[0]; }
public function noticia($id) { $db = new DatabaseConfig(); $mysqli = $db->connect(); $resultado = $mysqli->query("SELECT * FROM noticia WHERE id = {$id} AND activo = '1' "); if (!$resultado || mysqli_num_rows($resultado) == 0) { echo 'Noticia no encontrada'; } return $resultado; $resultado->close(); }
public function listado() { $db = new DatabaseConfig(); $mysqli = $db->connect(); $resultado = $mysqli->query("SELECT * FROM categoria"); if (!$resultado) { die('Hubo un error en la consulta [' . $db->error . ']'); } return $resultado; $resultado->close(); }
/** * @return Config */ public static function getInstance() { if (empty(self::$instance)) { self::$instance = new self(); } return self::$instance; }
public function startBackup() { $this->writeLine('-- Dump generated by vtigerCRM'); $this->writeLine('-- Date: ' . date("D, M j, G:i:s T Y")); $this->writeLine('-- HOST: ' . $this->dbConfig->getHostName() . ' Database: ' . $this->dbConfig->getDatabaseName()); $this->writeLine("-- ----------------------------------"); $this->writeLine(""); $this->writeLine("/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;"); $this->writeLine("/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;"); $this->writeLine("/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;"); $this->writeLine("/*!40101 SET NAMES utf8 */;"); $this->writeLine("/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;"); $this->writeLine("/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;"); $this->writeLine("/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;"); $this->writeLine("/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;"); }
private function save() { $this->config->set_database_tables_optimization_enabled($this->form->get_value('database_tables_optimization_enabled')); if (!$this->form->field_is_disabled('database_tables_optimization_day')) { $this->config->set_database_tables_optimization_day($this->form->get_value('database_tables_optimization_day')->get_raw_value()); } DatabaseConfig::save(); }
public function query() { $conn = $this->connection(); if (!$conn) { \DatabaseConfig::instance(); //print_r(\DB\Config::instance()); } return $conn->query(); }
/** * PDO database connection starts * return database connection instance */ public function connect() { // One connection through whole application if (null == self::$cont) { try { self::$cont = new PDO("mysql:host=" . self::$dbHost . ";" . "dbname=" . self::$dbName, self::$dbUsername, self::$dbUserPassword); } catch (PDOException $e) { die($e->getMessage()); } } return self::$cont; }
public function login($usuario, $password) { //clase DatabaseConfig utiliza el método connect() para conectarse a la base de datos $db = new DatabaseConfig(); $mysqli = $db->connect(); $resultado = $mysqli->query("SELECT * FROM usuarios WHERE email = '{$usuario}' AND tipo = 'admin'"); //valida usuario if ($row = $resultado->fetch_assoc()) { //valida password if ($row["password"] == $password) { $_SESSION['usuario'] = $usuario; $_SESSION['admin'] = $usuario; $_SESSION['nombre'] = $row["nombre"]; echo '<script language="javascript">window.location="/admin-dashboard"</script>;'; exit; } else { $mensajes = array("error1" => "Contraseña Incorrecta."); } } else { $mensajes = array("error2" => "El nombre de usuario es incorrecto!."); } return $mensajes; $resultado->close(); }
public static function connection() { // Haetaan tietokantakonfiguraatio $connection_config = DatabaseConfig::connection_config(); $config = $connection_config['config']; try { // Alustetaan PDO if (isset($config['username'])) { $connection = new PDO($config['resource'], $config['username'], $config['password']); } else { $connection = new PDO($config['resource']); } // Asetetaan tietokannan kenttien koodaukseksi utf8 $connection->exec('SET NAMES UTF8'); // Näytetään virheilmoitukset $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $connection->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); } catch (PDOException $e) { die('Virhe tietokantayhteydessä tai tietokantakyselyssä: ' . $e->getMessage()); } return $connection; }
public function backup() { if ($this->isLocalBackupEnabled() || $this->isFTPBackupEnabled()) { $sourceConfig = DatabaseConfig::getInstanceFromConfigFile(); $source = new MysqlSource($sourceConfig); $fileDest = new File($sourceConfig); $dbBackup = new DatabaseBackup($source, $fileDest); $dbBackup->backup(); $this->location->limitBackup(); $this->zip->addFile($fileDest->getFilePath(), false); foreach ($this->folderList as $folder) { $path = $this->getFolderPath($folder); $folder = $this->addTrailingSlash($folder); $this->zip->addDirectory($path, $folder); } $this->zip->close(); $this->location->save($this->getBackupFileName()); if (file_exists($fileDest->getFilePath())) { //unlink($fileDest->getFilePath()); } } }
public function recuperarPass($email) { $db = new DatabaseConfig(); $mysqli = $db->connect(); //borra todas las relaciones $resultado = $mysqli->query("SELECT * FROM usuarios WHERE email = '{$email}' "); if (mysqli_num_rows($resultado) == 0) { echo 'El email es incorrecto'; } else { return $mensajeOk = 'Datos actualizados correctamente'; } //enviar email mail($email, '$título', '$mensaje', '$cabeceras'); $resultado->close(); }
public function __construct() { $this->pdo = DatabaseConfig::connect(); $this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); }
/** * Returns the Phreezer persistance layer * @return Phreezer */ function GetPhreezer() { if ($this->phreezer == null) { if (!self::$CONVERT_NULL_TO_EMPTYSTRING) { require_once "verysimple/DB/DatabaseConfig.php"; DatabaseConfig::$CONVERT_NULL_TO_EMPTYSTRING = false; } if (self::$DEBUG_MODE) { require_once "verysimple/Phreeze/ObserveToSmarty.php"; $observer = new ObserveToSmarty($this->GetRenderEngine()); $this->phreezer = new Phreezer(self::$CONNECTION_SETTING, $observer); } else { $this->phreezer = new Phreezer(self::$CONNECTION_SETTING); } if (self::$LEVEL_2_CACHE) { $this->phreezer->SetLevel2CacheProvider(self::$LEVEL_2_CACHE, self::$LEVEL_2_CACHE_TEMP_PATH); $this->phreezer->ValueCacheTimeout = self::$LEVEL_2_CACHE_TIMEOUT; } } return $this->phreezer; }
public function updateCategoria($id, $nombre) { $db = new DatabaseConfig(); $mysqli = $db->connect(); $resultado = $mysqli->query("UPDATE categoria\n SET nombre ='{$nombre}' WHERE id='{$id}'"); if (!$resultado) { die('Invalid query: ' . mysql_error()); } else { return $mensajeOk = 'Datos actualizados correctamente'; } $resultado->close(); }
public static function get_advises(HTMLForm $html_form) { $lang = LangLoader::get('admin-server-common'); $server_configuration = new ServerConfiguration(); $maintenance_config = MaintenanceConfig::load(); $general_config = GeneralConfig::load(); $server_environment_config = ServerEnvironmentConfig::load(); $security_config = SecurityConfig::load(); $url_rewriting_available = false; try { $url_rewriting_available = $server_configuration->has_url_rewriting(); } catch (UnsupportedOperationException $ex) { } $fieldset = new FormFieldsetHTML('advises', $lang['advises']); $fieldset->add_field(new FormFieldFree('modules_management', '', MessageHelper::display($lang['advises.modules_management'], MessageHelper::SUCCESS)->render())); if ($maintenance_config->is_under_maintenance()) { $fieldset->add_field(new FormFieldFree('check_modules_authorizations', '', MessageHelper::display($lang['advises.check_modules_authorizations'], MessageHelper::SUCCESS)->render())); } if (!strstr($general_config->get_site_url(), 'localhost') && !strstr($general_config->get_site_url(), '127.0.0.1') && !$maintenance_config->is_under_maintenance() && Debug::is_debug_mode_enabled()) { $fieldset->add_field(new FormFieldFree('disable_debug_mode', '', MessageHelper::display($lang['advises.disable_debug_mode'], MessageHelper::WARNING)->render())); } if ($url_rewriting_available && !$server_environment_config->is_url_rewriting_enabled()) { $fieldset->add_field(new FormFieldFree('enable_url_rewriting', '', MessageHelper::display($lang['advises.enable_url_rewriting'], MessageHelper::NOTICE)->render())); } if (function_exists('ob_gzhandler') && @extension_loaded('zlib') && !$server_environment_config->is_output_gziping_enabled()) { $fieldset->add_field(new FormFieldFree('enable_output_gz', '', MessageHelper::display($lang['advises.enable_output_gz'], MessageHelper::NOTICE)->render())); } if (DataStoreFactory::is_apc_available() && !DataStoreFactory::is_apc_enabled()) { $fieldset->add_field(new FormFieldFree('enable_apcu_cache', '', MessageHelper::display($lang['advises.enable_apcu_cache'], MessageHelper::NOTICE)->render())); } $fieldset->add_field(new FormFieldFree('save_database', '', MessageHelper::display($lang['advises.save_database'], MessageHelper::SUCCESS)->render())); if (!DatabaseConfig::load()->is_database_tables_optimization_enabled()) { $fieldset->add_field(new FormFieldFree('optimize_database_tables', '', MessageHelper::display($lang['advises.optimize_database_tables'], MessageHelper::SUCCESS)->render())); } if ($security_config->get_internal_password_min_length() == 6 && $security_config->get_internal_password_strength() == SecurityConfig::PASSWORD_STRENGTH_WEAK && !$security_config->are_login_and_email_forbidden_in_password()) { $fieldset->add_field(new FormFieldFree('password_security', '', MessageHelper::display($lang['advises.password_security'], MessageHelper::NOTICE)->render())); } if (ServerConfiguration::get_phpversion() < '5.6') { $fieldset->add_field(new FormFieldFree('upgrade_php_version', '', MessageHelper::display($lang['advises.upgrade_php_version'], MessageHelper::NOTICE)->render())); } if (count($fieldset->get_fields())) { $html_form->add_fieldset($fieldset); } }
function setup() { if ($this->isType('mysql')) { if ($this->getCreateTarget() == true) { $this->connection =& NewADOConnection($this->dbConfig->getDBType()); $ok = $this->connection->NConnect($this->dbConfig->getHostName(), $this->dbConfig->getRootUserName(), $this->dbConfig->getRootPassword()); if (!$ok) { throw new DatabaseBackupException(DatabaseBackupErrorCode::$DB_CONNECT_ERROR, DatabaseBackup::$langString['DestConnectFailed']); } // Drop database if already exists $sql = "drop database IF EXISTS " . $this->dbConfig->getDatabaseName(); $result = $this->connection->Execute($sql); $this->checkError($result, $sql); $sql = 'create database ' . $this->dbConfig->getDatabaseName(); if ($this->supportUTF8 == true) { $sql .= " default character set utf8 default collate utf8_general_ci"; } $result = $this->connection->Execute($sql); $this->checkError($result, $sql); $this->connection->Close(); } $this->connection =& NewADOConnection($this->dbConfig->getDBType()); $ok = $this->connection->NConnect($this->dbConfig->getHostName(), $this->dbConfig->getUserName(), $this->dbConfig->getPassword(), $this->dbConfig->getDatabaseName()); if (!$ok) { throw new DatabaseBackupException(DatabaseBackupErrorCode::$DB_CONNECT_ERROR, DatabaseBackup::$langString['DestConnectFailed']); } $result = $this->connection->_Execute("SET interactive_timeout=28800", false); $result = $this->connection->_Execute("SET wait_timeout=28800", false); $result = $this->connection->_Execute("SET net_write_timeout=900", false); } }
_start_cache(); try { // load base files ctx_log_start("Initialisation"); ctx_log_start("Opening files"); $files = array_merge(glob("core/*.php"), glob("ext/*/main.php")); foreach ($files as $filename) { require_once $filename; } ctx_log_endok(); ctx_log_start("Connecting to DB"); // connect to the database $database = new Database(); //$database->db->fnExecute = '_count_execs'; // FIXME: PDO equivalent $database->db->beginTransaction(); $config = new DatabaseConfig($database); ctx_log_endok(); ctx_log_start("Loading themelets"); // load the theme parts $_theme = $config->get_string("theme", "default"); if (!file_exists("themes/{$_theme}")) { $_theme = "default"; } if (file_exists("themes/{$_theme}/custompage.class.php")) { require_once "themes/{$_theme}/custompage.class.php"; } require_once "themes/{$_theme}/layout.class.php"; require_once "themes/{$_theme}/themelet.class.php"; $themelets = glob("ext/*/theme.php"); foreach ($themelets as $filename) { require_once $filename;
private static function optimize_database_tables(Date $current_date) { if (ModulesManager::is_module_installed('database')) { $database_config = DatabaseConfig::load(); if ($database_config->is_database_tables_optimization_enabled()) { if ($database_config->get_database_tables_optimization_day() == 7 && $current_date->get_day() == 1 || $database_config->get_database_tables_optimization_day() == $current_date->get_day_of_week()) { $tables_to_optimize = array(); foreach (PersistenceContext::get_dbms_utils()->list_and_desc_tables(true) as $key => $table_info) { if (NumberHelper::round($table_info['data_free'] / 1024, 1) != 0) { $tables_to_optimize[] = $key; } } PersistenceContext::get_dbms_utils()->optimize($tables_to_optimize); } } } }
<?php /* * Tämä ohjelmakoodi on muokattu versio alkuperäisesti David Consuegran veriosta, joka löytyy täältä: * http://advancedkittenry.github.io/koodaaminen/testisovellus.html */ /***************************************************************/ /* Koodia. Tästä tiedostosta ei kannata ottaa mallia mihinkään */ /***************************************************************/ $connection_config = DatabaseConfig::connection_config(); function getDatabase() { return DB::connection(); } function getObjects() { $args = func_get_args(); $sql = array_shift($args); $query = getDatabase()->prepare($sql); $query->execute($args); return $query->fetchAll(PDO::FETCH_OBJ); } function getValue() { $args = func_get_args(); $sql = array_shift($args); $query = getDatabase()->prepare($sql); $query->execute($args); return $query->fetchColumn(); } class TableLister
/** * * @param DatabaseConfig $config * @return DatabaseConfig */ public static function getInstanceFromOtherConfig($config) { $newConfig = new DatabaseConfig($config->getHostName(), $config->getUsername(), $config->getPassword(), $config->getDatabaseName(), $config->getDBType(), $config->getRootUsername(), $config->getRootUsername()); return $newConfig; }
<?php require_once __DIR__ . "/../vendor/autoload.php"; use Symfony\Component\Yaml\Parser; use Doctrine\ORM\Tools\Setup; use Doctrine\ORM\EntityManager; use Entity\Users; class DatabaseConfig { private $em; public function __construct() { $yamlParser = new Parser(); $dbParams = $yamlParser->parse(file_get_contents(__DIR__ . '/parameters.yml')); $config = Setup::createAnnotationMetadataConfiguration(array(__DIR__ . '/../Entity'), true); $this->em = EntityManager::create($dbParams['database'], $config); } public function getManager() { return $this->em; } } $dbcon = new DatabaseConfig(); $em = $dbcon->getManager(); return \Doctrine\ORM\Tools\Console\ConsoleRunner::createHelperSet($em);
public function eliminarNoticia($id) { $db = new DatabaseConfig(); $mysqli = $db->connect(); $noticia = $mysqli->query("SELECT * FROM noticia WHERE id ='{$id}' "); while ($row = $noticia->fetch_assoc()) { $nombreNoticia = $row['titulo']; } $resultado = $mysqli->query("UPDATE noticia\n SET activo ='0' WHERE id='{$id}'"); if (!$resultado) { $mensajes = array("error" => "Ocurrió un error, intente nuevamente mas tarde."); } else { $mensajes = array("ok" => "La noticia <strong>{$nombreNoticia}</strong> se ha eliminado correctamente."); } return $mensajes; $resultado->close(); }