Login   Register  
PHP Classes
elePHPant
Icontem

File: datamanage/php_inc/search.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Mathew  >  Data Manager  >  datamanage/php_inc/search.php  >  Download  
File: datamanage/php_inc/search.php
Role: Class source
Content type: text/plain
Description: class2
Class: Data Manager
Retrieve and store MySQL records using Web forms
Author: By
Last change:
Date: 9 months ago
Size: 2,969 bytes
 

Contents

Class file image Download
<?php
class mySearch
{
    var 
$fldList = array();
    var 
$dateFld = array();
    function 
__construct($fList,$dateFld=NULL)     
    {
         
$this -> fldList $fList;
         
$this -> dateFld $dateFld;
    }
    function 
getSearch($dbfld,$dbval,$oper,$sTo)
    {
        
$sqlAdd "";
        for(
$x=0$x count($dbfld); $x++)
        {
            
$sIn $dbfld[$x];
            
$sFor $dbval[$x];
            
$sToV $sTo[$x];
            
$operator $oper[$x];
            if(
in_array($this -> fldList[$sIn], $this -> dateFld))
            {
                
$sFor date('Y-m-d H:i:s',strtotime($sFor));
                
$sToV date('Y-m-d H:i:s',strtotime($sToV));
            }
            if(
$sIn != "" && $sFor != "" && $operator != "")
            {
                if(
is_array($this -> fldList[$sIn]))
                {
                    
$sqlAdd .= "and ( ";
                    for(
$x=0$x<count($this -> fldList[$sIn]); $x++)
                    {
                        
$con = ($x==0) ? "" "or";
                        
$sqlAdd .= $this -> getSearchC($sIn$sFor,$sToV$operator,$this -> fldList[$sIn][$x],$con);
                    }
                    
$sqlAdd .= ")";
                }
                else
                {
                    
$sqlAdd .= $this -> getSearchC($sIn$sFor,$sToV$operator,$this -> fldList[$sIn],'and');
                }
            }
        }
        return 
$sqlAdd;
    }
    
    function 
getTotWidth($widthVal,$display)
    {
        
$totWidth 0;
        for(
$i=0$i count($display); $i++)
        {
            
$totWidth += $widthVal[$display[$i]];
        }
        
//$totWidth = $totWidth + (8*count($display)) + (1*count($display));
        
return $totWidth;
    }
    
    function 
getSearchC($sIn$sFor,$sToV$operator,$cfldList,$cond)
    {
        if(
$sIn != "" && $sFor != "" && $operator != "")
        {
            switch (
$operator
            {
                case 
"e":
                    
$sqlAdd .= $cond "$cfldList."= '$sFor'";
                break;
                case 
"n":
                    
$sqlAdd .= $cond "$cfldList."<> '$sFor'";
                break;
                case 
"s":
                    
$sqlAdd .= $cond "$cfldList" like ('$sFor%')";
                break;
                case 
"c":
                    
$sqlAdd .= $cond "$cfldList" like ('%$sFor%')";
                break;
                case 
"k":
                    
$sqlAdd .= $cond "$cfldList" not like ('%$sFor%')";
                break;
                case 
"l":
                    
$sqlAdd .= $cond "$cfldList" < '$sFor' ";
                break;
                case 
"g":
                    
$sqlAdd .= $cond "$cfldList" > '$sFor' ";
                break;
                case 
"m":
                    
$sqlAdd .= $cond "$cfldList" <= '$sFor' ";
                break;
                case 
"h":
                    
$sqlAdd .= $cond "$cfldList" >= '$sFor' ";
                break;
                case 
"btw":
                    
$sqlAdd .= $cond "$cfldList" >= '$sFor$cond "$cfldList" <='$sToV'";
                break;

                case 
"u":
                    
$var explode(',',$sFor);
                    
$newVar "";
                    for(
$i=0;$i<count($var);$i++)
                    {
                        
$newVar.=($i 0) ? "," "";
                        
$newVar.= "'".trim($var[$i])."'";
                    }
                    
$sqlAdd .= $cond "$cfldList" in ($newVar) ";
                break;
                case 
"x":
                    
$var explode(',',$sFor);
                    
$newVar "";
                    for(
$i=0;$i<count($var);$i++)
                    {
                        
$newVar.=($i 0) ? "," "";
                        
$newVar.= "'".trim($var[$i])."'";
                    }
                    
$sqlAdd .= $cond "$cfldList" not in ($newVar) ";
                break;

            }
        }
            return 
$sqlAdd;
    }
}
?>