Create function file in php

<?php

class Data
{
      
      
/************************   Insert Query   **************************************/  
function insert_item($tablename,$data)
{
        $data_sql='';
                $msg='';
        foreach($data as $field => $value)
        {
        $data_sql .= $field."='".$value."',";
        }

                $data_sql=rtrim($data_sql,",");
                $sql="insert $tablename SET  $data_sql";


           
            $result=mysql_query($sql)or die(mysql_error());
               
                return $result;

      
}
      
      
      
/********************************************************************************/ 



      

/************************       Update Query  **************************************/            
function update_item($tablename,$data,$where)
{
        $data_sql='';
                $msg='';
        foreach($data as $field => $value)
        {
        $data_sql .= $field."='".$value."',";
        }

                $data_sql=rtrim($data_sql,",");
            $sql="update $tablename set $data_sql " ;
                 
                  if($where<>'')
                  {
                  $sql.= " where ".$where;
                  }
         
          $sql;
 
          mysql_query($sql)or die(mysql_error());
        }
      

/********************************************************************************************/ 



                

/*******************************      Delete       ************************************/             
      
function tbl_delete($tablename,$where)
       {
    $sql="delete from $tablename ";
           
         
        if($where<>'')
    {
     $sql.= "where ".$where;
    }
         
         $sql;


    $result = mysql_query($sql)or die(mysql_error());
               
       
         
       }
      
/***************************************************************************************/         

      




      
/***************************************    Select      ********************************/

function tbl_select($tablename)
       {
        $sql=mysql_query("select * from $tablename")or die(mysql_error());
        return $sql;
       }


function tbl_select_where($tablename,$where)
     {
          $sql="select * from $tablename where ";
          if($where<>'')
         {
               $sql.= $where;
         }     
 
          $sql=mysql_query($sql)or die(mysql_error());
          return $sql;
     }



function tbl_select_where_limit($tablename,$where,$limit)
     {
          $sql="select * from $tablename ";
          if($where<>'')
         {
               $sql.= 'where '.$where;
         }   
          if($limit<>'')
         {
               $sql.= $limit;
         }   
 
          $sql=mysql_query($sql)or die(mysql_error());
          return $sql;
     }

/***************************************************************************************/       

}

 /*--------------------------------------remove***spaces-----------------------------------------------*/
// replace multiple spaces to one space from string

function replace_spaces($string) {

   $string = preg_replace('/\s+/', ' ',$string);

   return $string;
}

//remove all spaces from string
function remove_spaces($string) {

   $string = preg_replace('/\s+/', '',$string);

   return $string;
}

 /*--------------------------------------remove***spaces--end---------------------------------------------*/

/*--------------------------------------remove***spacialchar-----------------------------------------------*/

function remove_special($string) {  //remove all spacial character from string

   //$string = str_replace(' ', '-', $string);

   return preg_replace('/[^A-Za-z0-9\s+]/', '', $string);
}

function url_format($string) {  //remove all spacial character from string

   $string = preg_replace('/\s+/', '-', $string);

   return strtolower(preg_replace('/[^A-Za-z0-9\-]/', '', $string));
}

 /*-------------------------------------page-redirect---------------------------------------------*/

 function Redirect($url) {  //page redirect

print("<script>window.location='".$url."'</script>");

}

/*-------------------------------------get total product by category---------------------------------------------*/

function Category_product($catgoryid)
{
$proresult = mysql_query("SELECT id FROM product where status = '1' and cat_id = '".$catgoryid."'");
$portotals = @mysql_num_rows($proresult);

$catresult = mysql_query("SELECT id FROM category where status = '1' and parent_id = '".$catgoryid."'");
$cattotals = @mysql_num_rows($catresult);
if($cattotals>0)
{
$subcat = "";
while($catrow = mysql_fetch_assoc($catresult))
{
$subcat .= $catrow['id'].",";
}
$subcat = rtrim($subcat,",");
$prodresult = mysql_query("SELECT id FROM product where status = '1' and FIND_IN_SET(cat_id,'".$subcat.",".$catgoryid."')");
$aa = @mysql_num_rows($prodresult);

$subcatresult = mysql_query("SELECT id FROM category where status = '1' and FIND_IN_SET(parent_id,'".$subcat."')");
$sbcattotals = @mysql_num_rows($subcatresult);
if($sbcattotals>0)
{
$subscat = "";
while($scatrow = mysql_fetch_assoc($subcatresult))
{
$subscat.= $scatrow['id'].",";
}
$subscat = rtrim($subscat,",");
$sprodresult = mysql_query("SELECT id FROM product where status = '1' and FIND_IN_SET(cat_id,'".$subcat.",".$subscat.",".$catgoryid."')");
$pordtotals = @mysql_num_rows($sprodresult);
return " (".$pordtotals.")";
}else {return " (".$aa.")";}

}else {return " (".$portotals.")";}
/*if($cattotals>0)
{

$subcat = "";
while($catrow = mysql_fetch_assoc($catresult))
{
$subcat .= $catrow['id'].",";
}
$subcat = rtrim($subcat,",");
$prodresult = mysql_query("SELECT id FROM product where status = '1' and FIND_IN_SET(cat_id,'".$subcat."')");
$pordtotals = @mysql_num_rows($prodresult);
return " (".$pordtotals.")";
}else
{
return " (".$portotals.")";
}*/


}

/*-------------------------------------set page title---------------------------------------------*/
function page_title($title) {  //dinamicaly set page title

$buffer=ob_get_contents();
ob_clean();
$buffer=str_replace("%TITLE%",$title,$buffer);
return $buffer;

}
function page_breadcrumb($bread) { 

$buffers=ob_get_contents();
ob_clean();
$buffers=str_replace("%BREADCRUMBS%",$bread,$buffers);
return $buffers;

}
function meta_description($des) {  //dinamicaly set page title

$bufferd=ob_get_contents();
ob_clean();
$bufferd=str_replace("%DESCRIPTION%",$des,$bufferd);
return $bufferd;

}
function meta_keywords($key) { 

$buffersk=ob_get_contents();
ob_clean();
$buffersk=str_replace("%KEYWORDS%",$key,$buffersk);
return $buffersk;

}

 ?>