Esempio n. 1
0
 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];
 }
Esempio n. 2
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();
 }
Esempio n. 3
0
 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();
 }
Esempio n. 4
0
 /**
  * @return Config
  */
 public static function getInstance()
 {
     if (empty(self::$instance)) {
         self::$instance = new self();
     }
     return self::$instance;
 }
Esempio n. 5
0
 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();
 }
Esempio n. 7
0
File: model.php Progetto: neel/bong
 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;
 }
Esempio n. 9
0
 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();
 }
Esempio n. 10
0
 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;
 }
Esempio n. 11
0
 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());
         }
     }
 }
Esempio n. 12
0
 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);
 }
Esempio n. 14
0
 /**
  * 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;
 }
Esempio n. 15
0
 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);
     }
 }
Esempio n. 17
0
 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);
     }
 }
Esempio n. 18
0
_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;
Esempio n. 19
0
 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);
             }
         }
     }
 }
Esempio n. 20
0
<?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
Esempio n. 21
0
 /**
  *
  * @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;
 }
Esempio n. 22
0
<?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);
Esempio n. 23
0
 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();
 }