PHP Classes

File: _mysql.php

Recommend this page to a friend!
  Classes of Alex  >  MySQL V class  >  _mysql.php  >  Download  
File: _mysql.php
Role: Class source
Content type: text/plain
Description: MySQL class
Class: MySQL V class
Generic MySQL database access layer
Author: By
Last change: change one symbol...
Date: 10 years ago
Size: 3,591 bytes
 

Contents

Class file image Download
<?php

class MySQL{

var
$dbHost="localhost";
var
$dbName="mforum";
var
$dbTable="users";
var
$dbUser="root";
var
$dbPassword="";

var
$link;
var
$status=0;
var
$error="";

function
MySQL(){//constructor for class MySQL .Have next arguments
                       //$dbHost,$dbUser,$dbPassword,$dbName

         
$count_args=func_num_args();

          if (
$count_args>0){

              
$host=@func_get_arg(0);

               if (
$host){
                  
$this->dbHost=$host;
               }

              
$user=@func_get_arg(1);

               if (
$user){
                  
$this->dbUser=$user;
               }

              
$passwd=@func_get_arg(2);

               if (
$passwd){
                 
$this->dbPassword=$passwd;
               }

              
$db=@func_get_arg(3);

               if (
$db){
                  
$this->dbName=$db;
               }
          }

}

function
__destruct(){
          if (
$this->link)//if($this->link!=false)
             
mysql_close($this->link);
}


function
get_error(){
         return
$this->error;
}

function
set_error($error){
        
$this->error=$error;
        }


function
get_link(){
         return
$this->link;
}

function
get_status(){
         return
$this->status;
}

function
get_table(){
         return
$this->dbTable;
}

function
set_table($dbTable){
        
$this->dbTable=$dbTable;
}

function
get_database(){
         return
$this->dbName;
}

function
set_database(){

        
$count_args=func_num_args();

         if (
$count_args>0){
            
$dbName=@func_get_arg(0);

             if (
$dbName){
                
$this->dbName=$dbName;
             }
         }

        if (
$this->link){
            
$this->status=@mysql_select_db($this->dbName,$this->link);

             if (
$this->status==false){
                
$this->error="error select database ".$this->dbName." ".mysql_error();
                 }
         }

                return
$this->status;
}


function
connect(){
        
$this->link=mysql_connect($this->dbHost,$this->dbUser,$this->dbPassword)
                or
$error="error connect to ".$this->dbHost." ".mysql_error();
}

function
disconnect(){

        
$result=false;

         if (
$this->link){//if($this->link!=false)
           
mysql_close($this->link);
           
$result=true;
         }

         if (
$result==false){
            
$this->error="cant close connection :(";
           }
}

function
describe_table($dbTable){

        
$query="describe `".$dbTable."`";
        
$result=mysql_query($query) or print mysql_error();

        
$field_list=array();

         if (
$result!=false){
            while (
$row=mysql_fetch_row($result)){
                
$field_list[]=$row[0]; //get field name
           
}
          }

          return
$field_list;
}

function
query($query,$show_query=false){
        
$result=false;
        
$result=mysql_query($query) or print mysql_error();

         if (
$show_query==true){
             print
'<pre>';
            
print_r($query);
             print
'</pre>';
         }

         return
$result;
}

function
get_count_fields($dbTable,$where=""){
        
$query="select count(*) as c from `".$dbTable."` ".$where;
        
$result=mysql_query($query) or print mysql_error();

        
$fields_count=false;

         if (
$result!=false){
            
$fields_count=mysql_result($result,0,0);
          }

          return
$fields_count;
}

}

?>

For more information send a message to info at phpclasses dot org.