lab.jordivillar.com

0x001-class.database.php

        <?php
        /**
        * Database class
        */
        class database
        {
          private $dbhost;
          private $dbuser;
          private $dbpass;
          private $dbname;
          private $conn;

          function __construct($dbuser = 'root', $dbpass = '', $dbname = 'goltv', $dbhost = 'localhost')
          {
            $this->dbhost = $dbhost;
            $this->dbuser = $dbuser;
            $this->dbpass = $dbpass;
            $this->dbname = $dbname;
          }

          public function openDB()
          {
            $this->conn = mysql_connect($this->dbhost, $this->dbuser, $this->dbpass) or die('Error connecting to mysql');
            mysql_select_db($this->dbname);
            mysql_query("SET NAMES 'UTF8'", $this->conn);
          }

          public function findBy($field, $value, $table, $return = "id")
          {
            $query = 'SELECT * FROM '.$table.' WHERE '.$field.' = "'.$value.'" LIMIT 1';
            $result = mysql_query($query, $this->conn);
            return mysql_num_rows($result) ? mysql_result($result, 0, $table.".".$return) : 0;
          }

          public function getAll($table, $where = 'WHERE 1 = 1', $as = '')
          {
            $query = 'SELECT *'.$as.' FROM '.$table.' '.$where.'';
            $result = mysql_query($query);
            
            $error = $this->mysql_errors($result);
            if(!$error)
              return false;
            while($row = mysql_fetch_assoc($result))
              $finish[] = $row;
            return $finish;
          }


          public function saveArray($array, $table)
          {
            $query = 'INSERT INTO `'.$table.'` (';
            $keys = array_keys($array);
            foreach ($keys as $key) {
              $query .= '`'.$table.'`.`'.$key.'`,';
            }
            $query .= ") VALUES (";
            foreach ($array as $value) {
              $query .= '"'.$value.'",';
            }
            $query .= ")";
            $query = str_replace(",)", ")", $query);
            echo $query;
            mysql_query($query, $this->conn);
            return mysql_insert_id();
          }

          public function updateArray($array, $table, $where = 'WHERE 1 = 1')
          {
            $query = 'UPDATE '.$table.' SET ';
            foreach ($array as $key => $value) {
              $query .= $key.' = "'.$value.'", ';
            }
            $query .= ''.$where;
            $query = str_replace(', WHERE', " WHERE", $query);
            
            mysql_query($query, $this->conn);
          }

          public function escape($value)
          {
            return mysql_real_escape_string($value, $this->conn);
          }

          public function close()
          {
            mysql_close($this->conn);
          }

          private function mysql_errors($result)
          {
            if (!$result) {
                echo "Could not successfully run query from DB: " . mysql_error();
                return false;
            }
            if (mysql_num_rows($result) == 0) {
                echo "No found results";
                return false;
            }
            else
              return true;
          }
          /**
          * ESPECIAL FUNCTIONS
          */
          public function count($table)
          {
            $query = 'SELECT count(*) FROM '.$table;
            $result = mysql_result(mysql_query($query), 0);
            return $result;
          }
        }
        ?>
Jordi Villar

0x001-class.database.php
