Login   Register  
PHP Classes
elePHPant
Icontem

File: ClsDBOperation.cls.php

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  >  ClsDBOperation.cls.php  >  Download  
File: ClsDBOperation.cls.php
Role: Class source
Content type: text/plain
Description: Insert_Retrieve_Table_Data
Class: Insert Retrieve data from Table
Query a database to insert and retrieve table rows
Author: By
Last change: Major Changes have done. Messaging is highly organized. Several Very Useful Parameters.
Date: 2006-02-09 20:26
Size: 7,781 bytes
 

Contents

Class file image Download
<?php
    
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    //                                    bGlobalSourcing    [Programmer: Md. Aminul Islam]                                                //
    //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    //        Class: ClsDatabaseOperation: Used for Add,Retrieve Data from a Table of Database                                            //
    //                [ Limitation: ]                                                                                                    //
    //                [ Required Folder: None]                                                                                                    //
    //==============================================================================================================================//
    //function SaveDataIntoTable($DatabaseTableName,$TableFields,$CheckDuplicateCondition,$ConditionalErrorMsg,$SuccessMessage,$ErrorMessage):- //
    //------------------------------------------------------------------------------------------------------------------------------//
    //    This Function Takes 6 Parameters:-                                                                                            //
    //    $DatabaseTableName = The Table Name Into which want to insert data                                                             //
    //    $TableFields =          One Dimensional Array which contain all the fields of current table                                    //
    //    $CheckDuplicateCondition = Query for checking this value exists or not.                                                        //
    //    $ConditionalErrorMsg = If Duplicate Value found This Message will Return.                                                    //
    //    $SuccessMessage =     If Data Insert Successfully into Table                                                                  //
    //    $ErrorMessage =         If Error Occured while insertion data into Table                                                        //
    //    This Function Return:-                                                                                                         //                
    //                "The Table Does Not Exists."      If the table doesn't exists.                                                    //
    //                " $SuccessMessage "             If the data inserted into table successfully                                    //
    //                " $ErrorMessage "                 If the data can't inserted into table successfully                                //
    /*    
        Example:-
        $ObjForumData=new ClsDatabaseOperation();
        $DatabaseTableName="forum_info";                                                                                                    
        $TableFieldValues=array("''","'$txtForumName'","'$CurrentDate'","$CurrentUserId","'$txtForumType'","'$txtForumPassword'");    
                                                                                [ First '' is for Auto Increment.]                    
        $CheckDuplicateCondition = "ForumName='$txtForumName' and ParentForumId=0";                                                    
        $ConditionalErrorMsg = "The Forum is Already Exists.";                                                                        
        $SuccessMessage = "Forum Added Successfully.";                                                                                
        $ErrorMessage = "Error while adding forum.";                                                                                
        $Message = $ObjForumData->SaveDataIntoTable($DatabaseTableName,$TableFieldValues);                                                    
    */
    //==============================================================================================================================//
    //    function RetrieveDataFromTable($DatabaseTableName,$MessageForEmptyTable="The Table is Empty.",$Condition="",$OrderByCol=""):-//
    //------------------------------------------------------------------------------------------------------------------------------//
    //    This Function Takes 4 Parameter:-                                                                                            //
    //    $DatabaseTableName = The Table Name from which you want to retrieve data                                                     //
    //    $MessageForEmptyTable = The Message returned If the Table is Empty                                                            //
    //    $Condition = Condition For Select Data from Database.                                                                        //
    //    $OrderByCol = Orderby clause (if necessary).                                                                        //
    //    This Function Return:-                                                                                                         //
    //                "The Table Does Not Exists."      If the table doesn't exists.                                                    //
    //                "The Table Is Empty."             If the table exists but have no data.                                            //
    //                "$TableData"                    Return Tables All Data In Two Dimensional Array.                                //
    //------------------------------------------------------------------------------------------------------------------------------//
    /*    
        Example:-
            $DatabaseTableName="student";
            $MessageForEmptyTable="Currently No Students Information is Available."
            $FullTableData=$ObjStudentData->RetrieveDataFromTable($DatabaseTableName,$MessageForEmptyTable);
            echo "<br><H3>Finally Operation Result(For RetrieveDataFromTable() Function <br>:</H3>";
            if(is_array($FullTableData))
            {
                echo "<table border='1'>";
                foreach($FullTableData as $SingleRowData)
                {
                    echo "<tr>";
                    foreach($SingleRowData as $SingleCellData)
                        echo "<td align='center'>$SingleCellData</td>";
                    echo "</tr>";
                }
                echo "</table>";
            }
            else
                echo "<H4>$FullTableData</h4>";
    */            
    //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    
require_once ("ClsConnection.cls.php");
    class 
ClsDatabaseOperation extends ClsConnection
    
{
        function 
ClsDatabaseOperation()
        {
            
$this->ClsConnection();    //Connection Class Constructor for Database Connection.
            //echo "TableUpdate Class Constructor";
        
}
        
        function 
SaveDataIntoTable($DatabaseTableName,$TableFields,$SuccessMessage="Data saved into database successfully.",
                            
$ErrorMessage="Error while adding data into database.",$CheckDuplicateCondition="",$ConditionalErrorMsg="")
        {
            
//Check For Table Existance
            
if($this->DataBaseTableExists($DatabaseTableName)=="False")
                return 
"The Table Does Not Exists.";
            
//Check Condition For Insert ($CheckDuplicateCondition)
            
if($CheckDuplicateCondition!="")
            {
                
$QueryForCheckDuplicate="select * from $DatabaseTableName where $CheckDuplicateCondition";
                if(
mysql_num_rows(mysql_query($QueryForCheckDuplicate))==0)
                    
$InsertPermission="True";    //No Duplicate Value Found.
                
else
                    
$InsertPermission="False";
            }
            else
                
$InsertPermission="True";
            if(
$InsertPermission=="True")
            {
                
$GenerateQuery="insert into $DatabaseTableName values(";
                foreach(
$TableFields as $SingleField)
                    
$GenerateQuery.=$SingleField.",";
                
$GenerateQuery=substr($GenerateQuery,0,strlen($GenerateQuery)-1).")";
                
//echo $GenerateQuery;
                
if(mysql_query($GenerateQuery))
                    return 
$SuccessMessage;
                else
                    return 
$ErrorMessage;
            }
            else
                return 
$ConditionalErrorMsg;    //Error Because Same Value already exists in $DatabaseTableName table
        
}
        
        
        function 
RetrieveDataFromTable($DatabaseTableName,$MessageForEmptyTable="The Table is Empty.",$Condition="",$OrderByCol="")
        {
            
//If the Table($DatabaseTableName) does not exists.
            
if(mysql_num_rows(mysql_query("SHOW TABLES LIKE '".$DatabaseTableName."'"))<1)
                return 
"The Table Does Not Exists.";

            
//Retrieve all data from Table.
            
$BuildSelQuery=$this->QueryBuilderWithCondition($DatabaseTableName,$Condition,$OrderByCol);

            
$QueryTableData=mysql_query($BuildSelQuery)or die("Can't Execute Database Query Right Now.");
            if(
mysql_num_rows($QueryTableData)>0)
            {
                
//$FindNumberOfColumn= Total column of current table($DatabaseTableName) which will be used as index.
                
$QueryForCountCol=mysql_fetch_row(mysql_query($BuildSelQuery));
                for(
$i=0;$i<=100;$i++)
                    if(isset(
$QueryForCountCol[$i]))
                        continue;
                    else
                        break;
                
$FindNumberOfColumn=$i;
                
//echo "Total col=$FindNumberOfColumn"; 
                //Start Process: $TableData=All data of $DatabaseTableName
                
$QueryTableData=mysql_query($BuildSelQuery);
                
$Row=0;
                while(
$RsTableData=mysql_fetch_row($QueryTableData))
                {
                    for(
$Col=0;$Col<$FindNumberOfColumn;$Col++)    //Col= Indicating Column No & Counter
                        
$TableData[$Row][$Col]=$RsTableData[$Col];
                    
$Row++;
                }
                
//End Process: $TableData=All data of $DatabaseTableName
                
return $TableData;        //Return Tables All Data In Two Dimensional Array Format.
            
}
            else
                return 
$MessageForEmptyTable;
        }
    }
?>