Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- Class mysql
- {
- public $query;
- public $data;
- public $result;
- public $rows;
- protected $config;
- protected $host;
- protected $port;
- protected $user;
- protected $pass;
- protected $dbname;
- protected $con;
- public function __construct()
- {
- try
- {
- #array com dados do banco
- include 'database.conf.php';
- global $databases;
- $this->config = $databases['local'];
- # Recupera os dados de conexao do config
- $this->dbname = $this->config['dbname'];
- $this->host = $this->config['host'];
- $this->port = $this->config['port'];
- $this->user = $this->config['user'];
- $this->pass = $this->config['password'];
- # instancia e retorna objeto
- $this->con = new mysqli( "$this->host", "$this->user", "$this->pass","$this->dbname");
- //@mysql_select_db( "$this->dbname" );
- if ( !$this->con )
- {
- throw new Exception( "Falha na conexão MySql com o banco [$this->dbname] em database.conf.php" );
- }
- else
- {
- return $this->con;
- }
- }
- catch ( Exception $e )
- {
- echo $e->getMessage();
- exit;
- }
- return $this;
- }
- public function query($query = '' )
- {
- try
- {
- if ( $query == '' )
- {
- throw new Exception( 'mysql query: A query deve ser informada como parâmetro do método.' );
- }
- else
- {
- $this->query = $query;
- $this->result = mysqli_query( $this->query );
- }
- }
- catch ( Exception $e )
- {
- echo $e->getMessage();
- exit;
- }
- return $this;
- }
- public function fetchAll()
- {
- $this->data = "";
- $this->rows = 0;
- while ( $row = @mysqli_fetch_array( $this->result, MYSQLI_ASSOC ) )
- {
- $this->data[] = $row;
- }
- if ( isset( $this->data[0] ) )
- {
- $this->rows = count( $this->data );
- }
- return $this->data;
- }
- public function rowCount()
- {
- return @mysqli_affected_rows();
- }
- public function limit( $limit, $offset )
- {
- return "LIMIT " . ( int ) $limit . "," . ( int ) $offset;
- }
- }
- /* end file */
- <?php
- global $databases;
- $databases = array(
- 'local' => array
- (
- 'host'=>'localhost',
- 'port'=>3306,
- 'dbname'=>'ok',
- 'user'=>'root',
- 'password'=>'root'
- )
- );
Add Comment
Please, Sign In to add comment