public function checkUser($login, $passwd) { try { $connection = new DbConnection(); $pdo = $connection->connect(); } catch (ErrorException $e) { $еггог = 'crap3'; include '../layouts/Error.html.php'; exit; } try { $sql = 'SELECT id FROM users WHERE login = :login'; $s = $pdo->prepare($sql); $s->bindValue(':login', $login); $s->execute(); } catch (PDOException $e) { $еггог = 'crap4'; include '../layouts/Error.html.php'; exit; } if ($s->rowCount() > 0) { // $_SESSION['user'] = $username; // echo 2; return true; } else { return false; } }
function login($login, $passwd) { $connection = new DbConnection(); $pdo = $connection->connect(); try { $sql = 'SELECT id, name FROM users WHERE login = :login and passwd = :passwd'; $s = $pdo->prepare($sql); $s->bindValue(':login', $login); $s->bindValue(':passwd', $passwd); $s->execute(); } catch (PDOException $e) { $error = $e->getMessage(); include APPLICATION_PATH . '/views/Error.html.php'; exit; } $row = $s->fetch(); return $row; }
/** * Gets an instance of the the DbConnection * * @param string $db_host * @param string $db_user * @param string $db_password * @param string $db_name * @return DbConnection * @todo Change to Use config from files. */ public static function getInstance($connection = '') { if (empty($connection) || !isset(self::$_instances[$connection])) { $Config = Config::getInstance(); if (empty($connection)) { $connection = $Config->system_enviroment; } $DbConfig = Config::getDbConfig($connection); $DbConnection = new DbConnection($DbConfig->db_host, $DbConfig->db_user, $DbConfig->db_password, $DbConfig->db_name); try { $DbConnection->connect(); } catch (Exception $e) { loadErrorPage('nodb'); } $DbConnection->executeQuery("SET CHARACTER SET 'utf8'"); self::$_instances[$connection] = $DbConnection; } return self::$_instances[$connection]; }
function removePost($id) { $connection = new DbConnection(); $pdo = $connection->connect(); try { $sql = "DELETE FROM posts WHERE id = :id"; $s = $pdo->prepare($sql); $s->bindValue(':id', $id, PDO::PARAM_INT); $result = $s->execute(); } catch (PDOException $e) { $error = $e->getMessage(); include APPLICATION_PATH . '/views/Error.html.php'; exit; } return $result; }
/** * Construct upgrade utility * * @param void * @return UpgradeUtility */ function __construct() { $charset = defined('DB_CHARSET') && DB_CHARSET ? DB_CHARSET : null; $this->db =& DBConnection::instance(); $this->db->connect(DB_HOST, DB_USER, DB_PASS, DB_NAME, true, $charset); }
/** * mixed XMLData(string $db, string $table, array $options = null) * * Returns the content of a table in XML format (Propel model more or less) * * @param string $db database name * @param string $table table name * @param array $options (optional) (from, to, start_table, end_table) * @return mixed false if error occurs, string if ok * @access public * @static * @see DUMP_CRLF */ public static function XMLData($db, $table, $options = null) { $localConn = new DbConnection(); if (!$localConn->connect()) { return false; } $localQuery = 'SHOW COLUMNS FROM ' . self::backQuote($table) . ' FROM ' . self::backQuote($db); if (!$localConn->exec($localQuery)) { return false; } for ($i = 0; $row = $localConn->fetchRow(MYSQL_ASSOC); $i++) { $fields[$i] = $row['Field']; $types[$i] = $row['Type']; $nulls[$i] = strtoupper($row['Null']) == 'YES' ? 'true' : 'false'; $keys[$i] = $row['Key']; $defaults[$i] = $row['Default']; $extras[$i] = $row['Extra']; } $numFields = count($fields); // Defines the offsets to use $limitClause = isset($options['to']) && $options['to'] > 0 && (isset($options['from']) && $options['from'] >= 0) ? ' LIMIT ' . ($options['from'] > 0 ? $options['from'] . ', ' : '') . $options['to'] : ''; $localQuery = 'SELECT * FROM ' . self::backQuote($db) . '.' . self::backQuote($table) . $limitClause; if (!$localConn->exec($localQuery)) { return false; } if ($localConn->numRows() == 0) { return ''; } $buffer = ' <table name="' . $table . '">' . DUMP_CRLF; while ($record = $localConn->fetchRow(MYSQL_ASSOC)) { $buffer .= ' <row>' . DUMP_CRLF; for ($i = 0; $i < $numFields; $i++) { $element = ' name="' . $fields[$i] . '"' . ' type="' . $types[$i] . '"' . ($nulls[$i] ? ' null="' . $nulls[$i] . '"' : '') . ($keys[$i] ? ' key="' . $keys[$i] . '"' : '') . ($defaults[$i] ? ' default="' . $defaults[$i] . '"' : '') . ($extras[$i] ? ' extra="' . $extras[$i] . '"' : ''); if (!is_null($record[$fields[$i]])) { $buffer .= ' <column' . $element . '>' . htmlspecialchars($record[$fields[$i]]) . '</column>' . DUMP_CRLF; } else { $buffer .= ' <column' . $element . ' />' . DUMP_CRLF; } } $buffer .= ' </row>' . DUMP_CRLF; } $localConn->close(); $buffer .= ' </table>' . DUMP_CRLF; return $buffer; }
$mysql->query("INSERT INTO test_bug34810_table_1 VALUES (1),(2),(NULL)"); $warning = $mysql->get_warnings(); if (!$warning) { printf("[001] No warning!\n"); } if ($warning->errno == 1048 || $warning->errno == 1253) { /* 1048 - Column 'a' cannot be null, 1263 - Data truncated; NULL supplied to NOT NULL column 'a' at row */ if ("HY000" != $warning->sqlstate) { printf("[003] Wrong sql state code: %s\n", $warning->sqlstate); } if ("" == $warning->message) { printf("[004] Message string must not be empty\n"); } } else { printf("[002] Empty error message!\n"); var_dump($warning); } } } $db = new DbConnection(); $db->connect(); echo "Done\n"; error_reporting(0); require_once "connect.inc"; if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) { printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); } if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bug34810_table_1")) { printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } mysqli_close($link);
*/ /** * Controlling vars */ $tab = "admin"; $nav = "dump"; /** * Checking permissions */ require_once "../auth/login_check.php"; loginCheck(OPEN_PROFILE_ADMINISTRATOR, false); // Not in DEMO to prevent users' malice require_once "../lib/Dump.php"; @set_time_limit(OPEN_EXEC_TIME_LIMIT); $auxConn = new DbConnection(); if (!$auxConn->connect()) { $auxConn->close(); Error::connection($auxConn); } $localQuery = 'SHOW TABLE STATUS FROM ' . Dump::backQuote(OPEN_DATABASE); if (!$auxConn->exec($localQuery)) { $auxConn->close(); Error::connection($auxConn); } /** * Show page */ $title = _("Optimize Database"); require_once "../layout/header.php"; /** * Breadcrumb
header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: public'); } else { header('Content-Disposition: attachment; filename="' . $filename . '.' . $ext . '"'); header('Expires: 0'); header('Pragma: no-cache'); } } // end download /** * Builds the dump */ // Gets the number of tables if a dump of a database has been required if (!isset($_POST['table_select']) || count($_POST['table_select']) != 1) { $auxConn = new DbConnection(); $auxConn->connect(); $result = $auxConn->listTables(); $numTables = $result ? $auxConn->numRows() : 0; $single = false; } else { $numTables = 1; $single = true; } // No table -> error message if ($numTables == 0) { echo '# ' . _("No tables found in database."); } else { // No csv or xml format -> add some comments at the top if ($_POST['what'] != 'csv' && $_POST['what'] != 'excel' && $_POST['what'] != 'xml') { switch ($_POST['what']) { case "data":