Login   Register  
PHP Classes
elePHPant
Icontem

File: ConnectionClass

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Md. Aminul Islam  >  Insert Retrieve data from Table  >  ConnectionClass  >  Download  
File: ConnectionClass
Role: Class source
Content type: text/plain
Description: Used as DB Connector and Sql Query Generator
Class: Insert Retrieve data from Table
Query a database to insert and retrieve table rows
Author: By
Last change: Upgrade of Connection Class. Excellent Features are included Specially SQL Query Generator and Two way of Database Connection for any Project(Fully User Defined).
Date: 8 years ago
Size: 3,740 bytes
 

Contents

Class file image Download
<?php
    
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    //                                    bGlobalSourcing                                                                                //
    //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    //        This Page Establish connection with MySql(Database). + QueryBuilder function is for build query.                        //
    //==============================================================================================================================//
    //    function ClsConnection():-                                                                                                     //
    //------------------------------------------------------------------------------------------------------------------------------//
    //    Just Change These Variables As you need    :-                                                                                    //
    //    $Host="HostName"        eg. $Host="www.bglobalsourcing.com"                                                                    //
    //    $UserNam="UserName"        eg. $UserNam="bglobal"                                                                                //
    //    $Paswrd="Password"        eg. $Paswrd="*******"                                                                                //
    //    $DbName="DatabaseName"    eg. $DBName="bGlobal"                                                                                //
    //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    //==============================================================================================================================//
    //    function QueryBuilderWithCondition($TableName,$Condition,$OrderByCol):-                                                                 //
    //------------------------------------------------------------------------------------------------------------------------------//
    //    " $TableName "        The Name of Database Table.(Select * from $TableName)                                                    //
    //    " $Condition "        The Condition Appended End of Query (where Filed1="something" [and Field2>40])                            //
    //    " $OrderByCol "        The Order By Clause (ORDER BY Filed1[DESC])                                                                //
    //==============================================================================================================================//
    
class ClsConnection
    
{
        var 
$Host="localhost";
        var 
$UsrNam="root";
        var 
$Paswrd="";
        var 
$DBName="class_test";
        
        
//Establish Database Connection While Creating or Inherit this class.
        
function ClsConnection()
        {
            
mysql_connect($this->Host,$this->UsrNam,$this->Paswrd)or die("Error in localhost connection.");
            
mysql_select_db($this->DBName)or die("Error in Database Connections");
            
//echo "Connection Established (Connection Class)";
        
}

        function 
UserDefineConnection($HostName,$UserName,$Password,$DatabaseName)
        {
            if(
$HostName!="")
                
$this->Host=$HostName;
            if(
$UserName!="")
                
$this->UsrNam=$UserName;
            if(
$Password!="")
                
$this->Paswrd=$Password;
            if(
$DatabaseName!="")
                
$this->DBName=$DatabaseName;

            
mysql_connect($this->Host,$this->UsrNam,$this->Paswrd)or die("Error in localhost connection.");
            
mysql_select_db($this->DBName)or die("Error in Database Connections");
            
//echo "Connection Established by user defined Data.(Connection Class)";
        
}
        
        
//Check Table $DatabaseTableName Existance. If Exists return True otherwise False.
        
function DataBaseTableExists($DatabaseTableName)
        {
            if(
mysql_num_rows(mysql_query("SHOW TABLES LIKE '".$DatabaseTableName."'"))==1)
                return 
"True";    //Exists
            
else
                return 
"False";    //Not Exists
        
}
        
        
//This Function Build SQL Query with A Specified Condition.
        
function QueryBuilderWithCondition($TableName,$Condition="",$OrderByCol="")
        {
            if(
$Condition=="")
                
$Query="select * from $TableName";
            else
                
$Query="select * from $TableName where $Condition";
            if(
$OrderByCol!="")
                
$Query.=" ORDER BY $OrderByCol";
            return 
$Query;
        }
    }
?>