Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- JAK SE TO POUZIVA?
- $jmeno = new database;
- $jmeno->prikaz;
- mozne prikazy: connect(), query(mysqlprikaz) a close()
- co to vubec dela? zkontroluje jestli prikaz probehl v poradku, pokud ne vypise
- varovnou hlasku a ulozi mysql chybu do souboru
- */
- $db_host = 'localhost'; // bude stacit
- $db_user = 'uzivatel_v_db';
- $db_pass = 'heslo_do_databaze';
- $db_db = 'jmeno_databaze';
- $timestamp = date('Y-m-d H:i:s'); // Shoduje se s MySQL formatem TIMESTAMP
- // Chyby
- $general_errors = array( "SYSTEM_ERROR" => "Doslo k chybe v systemu.");
- /*
- Popis: Funkce pro odchytavani mysql chyb
- (mysql chybu posle do souboru a zobrazi varovnou hlasku)
- Parametry: Chyba, ktera se vypise uzivateli a vystup z funkce mysql_error()
- */
- function HandleMysqlError($error, $mysql_error) {
- global $timestamp;
- $handle = fopen('./mysql_errors.txt', "a");
- fwrite($handle, $timestamp." - ".$mysql_error);
- fclose($handle);
- die($error);
- }
- ########################################
- // Trida pro ulehceni zakladni prace s databazi
- class database {
- // Promenne s nastavenim database
- var $db_host = null;
- var $db_user = null;
- var $db_pass = null;
- var $db_db = null;
- // Interni promenne
- var $link;
- // Chybove hlasky
- var $errors = array();
- /*
- Konstruktor
- */
- function __construct() {
- global $db_host;
- $this->db_host = $db_host;
- global $db_user;
- $this->db_user = $db_user;
- global $db_pass;
- $this->db_pass = $db_pass;
- global $db_db;
- $this->db_db = $db_db;
- global $general_errors;
- $this->errors = $general_errors;
- }
- /*
- Popis: Funkce pro pripojeni k databazi
- */
- function connect() {
- $this->link = @mysql_connect($this->db_host, $this->db_user, $this->db_pass);
- if (!$this->link) { HandleMysqlError($this->errors['SYSTEM_ERROR'],mysql_error()); }
- $select_db = @mysql_select_db($this->db_db);
- if (!$select_db) { HandleMysqlError($this->errors['SYSTEM_ERROR'], mysql_error()); }
- $db_encoding = @mysql_query("SET CHARACTER SET utf8");
- if (!$db_encoding) { HandleMysqlError($this->errors['SYSTEM_ERROR'], mysql_error()); }
- }
- /*
- Popis: Funkce pro vykonani prikazu
- Parametry: string $sql - samotny mysql prikaz
- Vraci: Data z databaze pripravene pro zpracovani
- */
- function query($sql, $log = false) {
- $sql = @mysql_query($sql);
- if (!$sql) { HandleMysqlError($this->errors['SYSTEM_ERROR'], mysql_error()); }
- return $sql;
- }
- /*
- Popis: Funkce pro ukonceni databazoveho spojeni
- */
- function close() {
- $close = @mysql_close($this->link);
- if (!$close) { HandleMysqlError($this->errors['SYSTEM_ERROR'], mysql_error()); }
- }
- // END OF: Trida pro ulehceni zakladni prace s databazi
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement