A simple PHP Mysql Class

Saturday, 05 November 2011 16:22
http//tournasdimitrios1wordpresscom/2011/11/05/a-simple-php-mysql-class/#more-6911-use-simple
Simple to use :
http://tournasdimitrios1.wordpress.com/2011/11/05/a-simple-php-mysql-class/#more-6911




  

  //Simply include this file on your page 

  require_once("DbConnect.class.php"); 

   

  //Set up all yor paramaters for connection 

  $db = new DbConnect("localhost","user","password","database",$error_reporting=false,$persistent=false); 

   

   //Open the connection to your database 

       $db->open() or die($db->error()); 



      //Query the database now the connection has been made 

       $db->query("SELECT * FROM....") or die($db->error()); 

        

       //You have several options on ways of fetching the data 

       //as an example I shall use 

       while($row=$db->fetcharray()) { 

        

         //do some stuff 

          

       } 

        

       //close your connection 

       $db->close(); 



       

       */ 

Class DbConnect { 

             

                  var $host = ''; 

                  var $user = ''; 

                  var $password = ''; 

                  var $database = ''; 

                  var $persistent = false; 

                   

                  var $conn = NULL; 

                   

                  var $result= false; 

                  var $error_reporting = false; 

                   

      /*constructor function this will run when we call the class */ 

       

                  function DbConnect ($host, $user, $password, $database, $error_reporting=true, $persistent=false) { 

                       

                       $this->host = $host; 

                       $this->user = $user; 

                       $this->password = $password; 

                       $this->database = $database; 

                        $this->persistent = $persistent; 

                        $this->error_reporting = $error_reporting; 

                  } 

    

              function open() { 

                   

                  if ($this->persistent) { 

                             

                        $func = 'mysql_pconnect'; 

                   

                  } else { 

                       

                     $func = 'mysql_connect'; 

                      

                  }             

                   

                  /* Connect to the MySQl Server */ 

                   

                  $this->conn = $func($this->host, $this->user, $this->password); 

                   

                   if (!$this->conn) { 



                       return false; 

                   

                   } 

                   

                   /* Select the requested DB */ 

                   

                   if (@!mysql_select_db($this->database, $this->conn)) { 

                        

                       return false; 

                   } 

                     return true; 

              } 

    

              /*close the connection */ 

               

               function close() { 

                       

                   return (@mysql_close($this->conn)); 

               } 

    

                /* report error if error_reporting set to true */ 

                 

      function error() { 

             

          if ($this->error_reporting) { 

                 

              return (mysql_error()) ; 

          } 

           

      } 

      

       function query($sql) { 

                

             $this->result = @mysql_query($sql, $this->conn); 

         

        return($this->result != false); 

        

       } 

    function affectedrows() { 



        return(@mysql_affected_rows($this->conn)); 

    } 

     

    function numrows() { 

         

        return(@mysql_num_rows($this->result)); 

         

    } 

    function fetchobject() { 

         

         return(@mysql_fetch_object($this->result, MYSQL_ASSOC)); 

         

    } 

     function fetcharray() { 

          

          return(mysql_fetch_array($this->result)); 

          

     } 

      

     function fetchassoc() { 

          

         return(@mysql_fetch_assoc($this->result)); 

     } 

      

     function freeresult() { 

          

          return(@mysql_free_result($this->result)); 

          

     } 

         

   } 

?>