<?php  
  
  
    class Database  
    { 
	var $db;
	public $db_name='db_pustak';
	var $host;
	var $password;
	var $queries;
	var $result;
	var $user;
	public  $nwords ;	
 
 	public $pagination;
	public $id;
	private $id_name;
	private $table_name;
	private $columns = array();
	
	
		function Database($host, $user, $password, $dbname)
		{
			$this->host     = 'localhost';
			$this->user     = 'root';
			$this->password = '';
			 
		
			
		}
		function connect($redirect = false)
		{ 
				$this->queries = array();
	
				$this->db = mysql_connect('localhost', 'root', $this->password) or $this->notify(mysql_error(), false, true);
				
				mysql_select_db($this->db_name, $this->db) or $this->notify(mysql_error(), false, true);
				date_default_timezone_set("Asia/Kolkata");
				/******/
				//Preloader Values
					$row=$this->getRows("system_one_time_setting", $whr='1');
			 
				$_SESSION["doc_appointment_fee"]=$row["doc_appointment_fee"];
				$_SESSION["doc_appointment_expiry_day"]=$row["doc_appointment_expiry_day"]*(60*60*24);
				$_SESSION["doc_emergency_fee"]=$row["doc_emergency_fee"];
				$_SESSION["ServerCashDate"]=$row["cashdate"];
				
				/*****/
				
		}
		function Notify($para1=null)
		{// system Error
				echo '<a class="close" data-dismiss="alert">×&nbsp;</a> <div class="alert alert-danger"> <h3>This is a Modal Heading</h3>'.$para1.'<br><br></div>';
		}
		function Error($para1=null)
		{
			echo '<a class="close" data-dismiss="alert">×</a> <div class="alert alert-success"> '.$para1.'</div>';
		}
		function Message($para1=null)
		{
			echo ' <div class="alert alert-info"> '.$para1.'</div>';
		}
		
	
	  // Set timezone




  // Time format is UNIX timestamp or
  // PHP strtotime compatible strings
  
				function systime()
				{
				date_default_timezone_set('Asia/Calcutta');
				$time_now=mktime(date('H'),date('i'),date('s'),0,0,0);
				return date('H:i',$time_now);}
		
				function systimeInt()
				{
				date_default_timezone_set('Asia/Calcutta');
				return $time_now=mktime(date('H'),date('i'),date('s'),0,0,0);}


			  function systemdate()
			  {
			  return $this->DateToInt(date("d-m-Y"));
			  }
  
  
		  	function dateDiff($dob, $now = false)
			{
			if (!$now) $now = date('d-m-Y');
			$dob = explode('-', $dob);
			$now = explode('-', $now);
			$mnt = array(1 => 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
			if (($now[2]%400 == 0) or ($now[2]%4==0 and $now[2]%100!=0)) $mnt[2]=29;
			if($now[0] < $dob[0]){
				$now[0] += $mnt[$now[1]-1];
				$now[1]--;
			}
			if($now[1] < $dob[1]){
				$now[1] += 12;
				$now[2]--;
			}
			if($now[2] < $dob[2]) return false;
			$str=($now[2] - $dob[2]).' Y '.($now[1] - $dob[1]).' M '.($now[0] - $dob[0]).' D';
			return $str;}
			
//$x = my_old('29-4-2008', '28-5-2009');
//print_r($x);
  
/*function dateDiff($dob, $now = false){
	if (!$now) $now = date('d-m-Y');
	$dob = explode('-', $dob);
	$now = explode('-', $now);
	$old = $now[2]*12+$now[1]-$dob[2]*12-$dob[1]-($dob[0]>$now[0] ? 1 : 0);
	$str=  floor($old / 12).' Y'.'   '.($old % 12).' M';
	return $str;
}
//$x = my_old('04-07-1984', date('d-m-Y'));
//print_r($x);
  */
  /*
  function dateDiff_old($time1, $time2, $precision = 6) {

    // If not numeric then convert texts to unix timestamps
	date_default_timezone_set('Asia/Calcutta');
    if (!is_int($time1)) {
      $time1 = strtotime($time1);
    }
    if (!is_int($time2)) {
      $time2 = strtotime($time2);
    }
 
    // If time1 is bigger than time2
    // Then swap time1 and time2
    if ($time1 > $time2) {
      $ttime = $time1;
      $time1 = $time2;
      $time2 = $ttime;
    }
 
    // Set up intervals and diffs arrays
    $intervals = array('year','month','day','hour','minute','second');
    $diffs = array();
 
    // Loop thru all intervals
    foreach ($intervals as $interval) {
      // Create temp time from time1 and interval
      $ttime = strtotime('+1 ' . $interval, $time1);
      // Set initial values
      $add = 1;
      $looped = 0;
      // Loop until temp time is smaller than time2
      while ($time2 >= $ttime) {
        // Create new temp time from time1 and interval
        $add++;
        $ttime = strtotime("+" . $add . " " . $interval, $time1);
        $looped++;
      }
 
      $time1 = strtotime("+" . $looped . " " . $interval, $time1);
      $diffs[$interval] = $looped;
    }
 
    $count = 0;
    $times = array();
    // Loop thru all diffs
    foreach ($diffs as $interval => $value) {
      // Break if we have needed precission
      if ($count >= $precision) {
	break;
      }
      // Add value and interval 
      // if value is bigger than 0
      if ($value > 0) {
	// Add s if value is not 1
	if ($value != 1) {
	  $interval .= "s";
	}
	// Add value and interval to times array
	$times[] = $value.' '.$interval;
	$count++;
      }
    }
 
    // Return string with times
    $sentance= implode(", ", $times);
 
	$sentance= str_replace("years","Y",$sentance);
	$sentance= str_replace("months","M",$sentance);
	$sentance= str_replace("days","D",$sentance);
	$sentance= str_replace("month","M",$sentance);
	$sentance= str_replace("day","D",$sentance);
	return $sentance;
  }
	*/
	
	
			function insertuserwork($para)
			{ //$this->userid=$_SESSION["id"];
			 
			//$lastid1=$this->insert('system_logindetails',array($this->userid,$para, $_SERVER['REMOTE_ADDR']),"userid,remarks,ip");
			//echo 'mailto : smc@gmail.com';
			}
	
			function change_password()
			{
			
			$newpassword=md5($_POST["password"]);
			$confirm_pass=$_POST["confirm_pass"];
			$old_pass=md5($_POST["old_pass"]);
			
			if(($_POST["old_pass"]<>"")&&($newpassword<>"")&&($_POST["confirm_pass"]<>"")){
			 $changeSql="select * from system_login where password='$old_pass' and status=1 and id=".$_SESSION["id"];
			
			$changers=mysql_query($changeSql) or die($error="Please Try after Sometime");
			if(mysql_num_rows($changers)>0)
			{
			$changeSql="update system_login set password='$newpassword' where password='$old_pass' and status=1 and id=".$_SESSION["id"];
			$changers=mysql_query($changeSql) or die($error="Please Try after Sometime");
			?><a style="color:#990000; text-decoration:blink; font-weight:bold">
			<?php 
			echo "Password Changed Sucessfully</br>";
			?></a><?php 
			$this->insertuserwork('Changed Password Sucess');
			}
			else
			{?><a style="color:#990000; text-decoration:blink; font-weight:bold">
			<?php 
			echo "Incorrect Password <br>";
			?></a><?php 
			$this->insertuserwork('Changed Password But Not Sucess');
			
			}
			}
			}	

			function finddd($dt)
			{
			date_default_timezone_set('Asia/Calcutta');
			$date=explode("-", $dt); 
			return $date[0];	}
			
			function findmm($dt)
			{
			date_default_timezone_set('Asia/Calcutta');
			$date=explode("-", $dt); 
			return $date[1];}
			
			function findyy($dt)
			{
			date_default_timezone_set('Asia/Calcutta');
			$date=explode("-", $dt); 
			return $date[2];
			}
	
			function IntToDate($para=null)
			{
				return date("d-m-Y", $para);
			}
			
			function DateToInt($para=null)
			{	$date=explode("-", $para); 
				return mktime(0, 0, 0, ($date[1]), $date[0], $date[2]);
			}
			
			function TimeToInt24($para=null)
			{	 
				date_default_timezone_set('Asia/Calcutta');
				$time=explode(":",$para);
				$hh=$time[0];
				$mm=$time[1];
		 
				 return mktime($hh,$mm,0,0,0,0);
			}
			
			function IntToTime24($para=null)
			{
				date_default_timezone_set('Asia/Calcutta');
				return date('H:i',$para);
				
			}
	
			function addmonth($dt,$mm,$dd)
			{
			  
			date_default_timezone_set('UTC');
			$date=explode("-", $dt); 
			return (mktime(0, 0, 0, ($date[1]+$mm), ($date[0]+$dd), $date[2]));	}
	
			function datetimetointeger($d,$t)
			{
			date_default_timezone_set('Asia/Calcutta');
			$date=explode("-",$d);
			$time=explode(":",$t);
			//echo $time[0].",".$time[1].",0,".$date[0].",".$date[1].",".$date[2]."<br>";
			return mktime($time[0],$time[1],0,$date[1],$date[0],$date[2]);}	
					
			function datetimetoineger($d,$t)
			{
			date_default_timezone_set('Asia/Calcutta');
			$date=explode("-",$d);
			$time=explode(":",$t);
			//echo $time[0].",".$time[1].",0,".$date[0].",".$date[1].",".$date[2]."<br>";
			return mktime($time[0],$time[1],0,$date[1],$date[0],$date[2]);}			
	
			function TimeToIntAMPM($para=null)
			{	 date_default_timezone_set('Asia/Calcutta');
				$hh=substr($para,0,2);
				$mm=substr($para,3,2);
				$AMPM=substr($para,6,2);
				if($AMPM=="PM")
				{
				if($hh<12){
				$hh=12+$hh;
				}
				
				}
				if(($AMPM=="AM") && ($hh==12))
				{
				$hh="00";
				}
				//echo $hh.":".$mm."<br>";;
				 return mktime($hh,$mm,0,0,0,0);
				 //echo "<br>".$hh.":".$mm."<br>";
				 
				
				//return mktime(0, 0, 0, ($date[1]), $date[0], $date[2]);
			}
	
			function IntToTimeAMPM($para=null)
			{
				 date_default_timezone_set('Asia/Calcutta');
			$time=date('H:i',$para);
			$time=explode(":",$time);
			$hh=$time[0];
			$mm=$time[1];	
			
			if($hh==00){$AMPM="AM";$hh=12;}
			elseif(($hh>00)&&($hh<12)){$AMPM="AM";}
			elseif(($hh>=12)&&($hh<24)){$AMPM="PM";$hh=$hh-12;}
			
		//	if(($hh>12)&&($mm>0)){$hh=$time[0]-12;$AMPM="PM";}
			return "$hh:$mm $AMPM";
			}
			
			function pageCaption($x)
			{
			$filnemae=explode("_",$x);
			return ($filnemae[0]);
			}
			
			function table_GETDATA($sid)
			{
			  $where="md5(id)='$sid'";
			  return $this->getRows($this->Table_Name,$where);
			}
	 
	 		function InvalidURL()
			{
			header("Location:invalidurl.php");
			exit;
			}

			function checkurl($tablename)
			{ 
				$this->error="";
					if($_SERVER['QUERY_STRING']<>"")
					{
					$QS=explode("=",$_SERVER['QUERY_STRING']);
					if($QS[0]<>"uid") {$this->InvalidURL();}//{$this->InvalidURL($this);}
		
					if(($_GET["wid"]<>'c4ca4238a0b923820dcc509a6f75849b') && ($_GET["wid"]<>'eccbc87e4b5ce2fe28308fd9f2a7baf3')) {$this->InvalidURL();}
					}
						if(isset($_GET["uid"]))
						{
						$sid=$_GET["uid"];
						$where="md5(id)='$sid'";
						
						$this->temp=$this->getRows($tablename,$where);
						if($this->temp==0){ $this->InvalidURL();}
						
						}
				$this->disableit="";	
					if(@$_GET["wid"]=='c4ca4238a0b923820dcc509a6f75849b'){$this->Save='Edit';} elseif(@$_GET["wid"]=='eccbc87e4b5ce2fe28308fd9f2a7baf3') {$this->Save='View';$this->disableit='readonly="" style="border:none; background:#FFFFFF; outline-style:none;box-shadow:none;color:#000;resize:none" '; }  else {$this->Save='New';}
			}
	 
	 		function tableExists($table)
			{  
			$tablesInDb = @mysql_query('SHOW TABLES FROM '.$this->db_name.' LIKE "'.$table.'"')  or $this->Notify(mysql_error().$table);
			if($tablesInDb)
			{
				if(mysql_num_rows($tablesInDb)==1)
				{
					return true; 
				}
				else
				{ 
				echo "Invalid Table Name";
					return false; 
				}
			}
			}
			
			function CreateSelect($SELECTNAME,$table,$value,$option,$where='',$selected,$disbaleit )
			{
		
				if($this->tableExists($table))
				{ 
				if($where<>'')$where='where '.$where;
				$tempSQL="select $value,$option from $table $where order by $value";
				$tempresult=mysql_query($tempSQL)  or $this->Notify(mysql_error());
				if($disbaleit=="")
				{
					 echo' <select id="'.$SELECTNAME.'" name="'.$SELECTNAME.'" class="input-large"  required ""  >';
					 echo '<option  value="">Please Select </option>';
						 while($temprow=mysql_fetch_array($tempresult))
						 {
						 ?>
			<option  value="<?php echo $temprow["$value"]?>" <?php if($temprow["$value"]==$selected){?>selected="selected"<?php } ?>> <?php echo $temprow["$option"];?></option> 
						 <?php
						 }
						 echo '</select>';
			  }
			  else
			  {
			  while($temprow=mysql_fetch_array($tempresult))
			  {
			 if($temprow["$value"]==$selected){?><input type="text"  value="<?php echo $temprow["$option"];?>" <?php echo $disbaleit;?> /><?php  }
			  }
			  }
			  
			  
			}
			}
			
			function CreateDD($selected,$disbaleit)
			{if($disbaleit==""){
		
			
			 echo' <select id="DD" name="DD" class="input-mini" '.$disbaleit.'>';
			 for($i=1;$i<=31;$i++)
			 {
			 ?><option  value="<?php echo $i?>" <?php if($i==$selected){?>selected="selected"<?php } ?>> <?php if($i<10) {echo "0".$i;}else {echo $i;};?></option> 
			 <?php
			 }
			 echo '</select>';
		 }
			 else
			 {
			 echo $selected;
			 }
			}
			
			function CreateMM($selected,$disbaleit)
			{
				if($disbaleit==""){
			 echo' <select id="MM" name="MM" class="input-mini"'.$disbaleit.'>';
		
			 ?>
			<option  value="1" <?php if(1==$selected){?>selected="selected"<?php } ?>> <?php echo "Jan";?></option> 
			<option  value="2" <?php if(2==$selected){?>selected="selected"<?php } ?>> <?php echo "Feb";?></option> 
			<option  value="3" <?php if(3==$selected){?>selected="selected"<?php } ?>> <?php echo "Mar";?></option> 
			<option  value="4" <?php if(4==$selected){?>selected="selected"<?php } ?>> <?php echo "Apr";?></option> 
			<option  value="5" <?php if(5==$selected){?>selected="selected"<?php } ?>> <?php echo "May";?></option> 
			<option  value="6" <?php if(6==$selected){?>selected="selected"<?php } ?>> <?php echo "Jun";?></option> 
			<option  value="7" <?php if(7==$selected){?>selected="selected"<?php } ?>> <?php echo "Jul";?></option> 
			<option  value="8" <?php if(8==$selected){?>selected="selected"<?php } ?>> <?php echo "Aug";?></option> 
			<option  value="9" <?php if(9==$selected){?>selected="selected"<?php } ?>> <?php echo "Sep";?></option> 
			<option  value="10" <?php if(10==$selected){?>selected="selected"<?php } ?>> <?php echo "Oct";?></option> 
			<option  value="11" <?php if(11==$selected){?>selected="selected"<?php } ?>> <?php echo "Nov";?></option> 
			<option  value="12" <?php if(12==$selected){?>selected="selected"<?php } ?>> <?php echo "Dec";?></option> 
			
			 <?php
		
			 echo '</select>';
			 }
			 else
			 {
			 echo $selected;
			 }
			}
	
			function CreateYYYY($selected,$disbaleit)
			{if($disbaleit==""){
			 echo' <select id="YYYY" name="YYYY" class="input-mini"'.$disbaleit.'>';
		
			
		for($i=Date("Y");$i>=1930;$i--)
			 {
			 ?><option  value="<?php echo $i?>" <?php if($i==$selected){?>selected="selected"<?php } ?>> <?php  {echo $i;};?></option> 
			 <?php
			 }
			 echo '</select>';
			  }
			 else
			 {
			 echo $selected;
			 }
			}
			
			function CreateYY($selected,$disbaleit)
			{
			 echo' <select id="YY" name="YY" class="input-mini">';
			 for($i=1;$i<=12;$i++)
			 {
			 ?>
			 <option  value="1" <?php if(1==$selected){?>selected="selected"<?php } ?>> <?php echo "Jan";?></option> 
			 <?php
			 }
			 echo '</select>';
			}
	
			function getMaxValue($tableName,$FieldName1, $whr=Null)
			{	
			if($whr<>null){$whr="Where $whr";}
			$sqlNum = 'SELECT max( ' .$FieldName1.') as numrows FROM ' . $tableName ." ".$whr ;  
				$varResult = mysql_query($sqlNum) or $this->Notify(mysql_error());
				$resutlNum = mysql_fetch_array($varResult)  or $this->Notify(mysql_error());
				return $resutlNum[numrows];
			}
	
			function getMinValue($tableName,$FieldName, $whr=Null)
			{	
			if($whr<>null){$whr="Where $whr";}
			$sqlNum = 'SELECT min( ' .$FieldName1.') as numrows FROM ' . $tableName ." ".$whr ; 
				$varResult = mysql_query($sqlNum) or $this->Notify(mysql_error());
				$resutlNum = mysql_fetch_array($varResult)  or $this->Notify(mysql_error());
				return $resutlNum[numrows];
			}
			
			function getSumValue($tableName,$FieldName,  $whr=Null)
			{	
			
			if($whr<>null){$whr="Where $whr";}
			$sqlNum = 'SELECT sum( ' .$FieldName.') as numrows FROM ' . $tableName ." ".$whr ;
		
				 $varResult = mysql_query($sqlNum) or $this->Notify(mysql_error());
				$resutlNum = mysql_fetch_array($varResult)  or $this->Notify(mysql_error());
				return $resutlNum[numrows];
			}
	
			function getNumRows($tableName, $whr='')
			{	 $sqlNum = 'SELECT count(*) as numrows FROM ' . $tableName .' Where  '.$whr ;
				 
		//echo $sqlNum;
				$varResult = mysql_query($sqlNum) or $this->Notify(mysql_error());
				$resutlNum = mysql_fetch_assoc($varResult) ;
				
					return $resutlNum[numrows];
		
			}
	
/*function getNumRows_ren($tableName, $whr='')
	{	$sqlNum = 'SELECT * FROM ' . $tableName .' Where  '.$whr ;
		 
		
		$varResult = mysql_query($sqlNum) or $this->Notify(mysql_error());
		$counter=0;
		while($resutlNum = mysql_fetch_array($varResult)  or $this->Notify(mysql_error()))
		{
			
			$sql='SELECT count(*) as numrow FROM ' . $tableName .' Where  patient_id='.$resutlNum["patient_id"] ;
			$varResult_2 = mysql_query($sql) or $this->Notify(mysql_error());
			$resutlNum_2 = mysql_fetch_assoc($varResult_2)  or $this->Notify(mysql_error());
			if($resutlNum_2["numrow"]>1)
			{
				$counter++;
			}
			//echo $sql;
		}
		
  		return $counter;

	}*/
	
			 function getRows($tableName, $whr='')
			{	$sqlNum = 'SELECT * FROM ' . $tableName .' Where   '.$whr ;
				//echo $sqlNum;
				 $varResult = mysql_query($sqlNum) ;
				 @$retunrow = mysql_fetch_array($varResult) ;
				 return $retunrow;
			}
	
	//================================= Custome List For Pharmacy Order Form ================================
	//+++++++++++++++++++
		  function PrepairPagination($msql)
		  {
 	 $q=$msql;
 	 $total_pages = mysql_num_rows(mysql_query($q));
			 $limit =20; //how many items to show per page
			if(isset($_GET['page'])) {
			$page = $_GET['page'];
			$start = ($page - 1) * $limit; //first item to display on this page
			} else {
			$page = 0;
			$start = 0; //if no page var is given, set start to 0
			}
			$sql=' LIMIT '.$start.','. $limit;
			 $q=$q.$sql;
			 $this->finalsql=$q;
			
								if ($page == 0)
							 $page = 1;
								$prev = $page - 1;
								$next = $page + 1;
								$lastpage = ceil($total_pages / $limit);
								$lpm1 = $lastpage - 1;
							
								$this->pagination = "";
								if ($lastpage > 1) {
									$this->pagination .= '<div class="pagination pagination-right"><ul>';
									if ($page > 1)
										$this->pagination.= "<li><a href=\"$targetpage?page=$prev\">Previous</a></li>";
									else
										$this->pagination.= "<li class='disabled'><a href='#'>Previous </a></li>";
									if ($lastpage < 7 + ($adjacents * 2)) {
										for ($counter = 1; $counter <= $lastpage; $counter++) {
											if ($counter == $page)
											$this->pagination.='<li class="active"><a href="#"><span class="sr-only">'.$counter.'</span></a></li>';
											else
												$this->pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
										}
									} else if ($lastpage > 5 + ($adjacents * 2)) {
										if ($page < 1 + ($adjacents * 2)) {
											for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) {
												if ($counter == $page)
													$this->pagination.='<li class="active"><a href="#">'.$counter.'  </a></li>';
												else
													$this->pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
											}
											$this->pagination.= "<li class='disabled'><a href='#'>... </a></li>";
											$this->pagination.= "<li><a href=\"$targetpage?page=$lpm1\">$lpm1</a></li>";
											$this->pagination.= "<li><a href=\"$targetpage?page=$lastpage\">$lastpage</a></li>";
										} else if ($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) {
											$this->pagination.= "<li><a href=\"$targetpage?page=1\">1</a></li>";
											$this->pagination.= "<li><a href=\"$targetpage?page=2\">2</a></li>";
 
											for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) {
												if ($counter == $page)
													$this->pagination.='<li class="active"><a href="#">'.$counter.'  </a></li>';
												else
													$this->pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
											}
											$this->pagination.= "<li><a href=\"$targetpage?page=$lpm1\">$lpm1</a></li>";
											$this->pagination.= "<li><a href=\"$targetpage?page=$lastpage\">$lastpage</a></li>";
										} else {
											$this->pagination.= "<li><a href=\"$targetpage?page=1\">1</a></li>";
											$this->pagination.= "<li><a href=\"$targetpage?page=2\">2</a></li>";
 											for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) {
												if ($counter == $page)
													$this->pagination.='<li class="active"><a href="#">'.$counter.'  </a></li>';
												else
													$this->pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";

											}
										}
									}
									if ($page < $counter - 1)
										$this->pagination.= "<li><a href=\"$targetpage?page=$next\">Next</a></li>";
									else
										$this->pagination.= "<li class='disabled'><a href='#'>Next</a></li>";
									$this->pagination.= "</ul></div> ";
  }
  }
			
	
	 
      
  
  //++++++++++++++++++++++++++++*******************
	
	
	function getGallaeryList($table, $rows = '*', $where = null, $order = null,$deleterow)
    {
	if($_GET["cmd"]=="Clear"){unset($_SESSION["where"]);}
	if(isset($_POST["Delete"]))
	{ $d="delete from $table where md5(id)='". $_POST["deleterow"]."'";
	$d=mysql_query($d) or $this->Notify(mysql_error()."aa");
	$this->Message("One Record Deleted");
	}
	echo ' <table width="100%" border="0" align="center" cellpadding="20" cellspacing="1">';
   
		$tbl_name = $table;
			$targetpage = "photo_list.php";
									$adjacents = 3;
								$query = "SELECT COUNT(*) as num FROM $tbl_name ";
								$total_pages = mysql_fetch_array(mysql_query($query));
								$total_pages = $total_pages[num];
							
							
								$limit = 12;
								$page = $_GET['page'];
								if ($page)
									$start = ($page - 1) * $limit;
								else
									$start = 0;
							
								$sql = "SELECT * FROM $tbl_name order by id desc LIMIT $start, $limit";
								$result = mysql_query($sql);
							
								if ($page == 0)
									$page = 1;
								$prev = $page - 1;
								$next = $page + 1;
								$lastpage = ceil($total_pages / $limit);
								$lpm1 = $lastpage - 1;
							
								$pagination = "";
								if ($lastpage > 1) {
									$pagination .= "<div class=\"pagination\">";
									if ($page > 1)
										$pagination.= "<a href=\"$targetpage?page=$prev\">Previous</a>";
									else
										$pagination.= "<span class=\"disabled\">Previous</span>";
							
									if ($lastpage < 7 + ($adjacents * 2)) {
										for ($counter = 1; $counter <= $lastpage; $counter++) {
											if ($counter == $page)
												$pagination.= "<span class=\"current\">$counter</span>";
											else
												$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
										}
									} else if ($lastpage > 5 + ($adjacents * 2)) {
										if ($page < 1 + ($adjacents * 2)) {
											for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) {
												if ($counter == $page)
													$pagination.= "<span class=\"current\">$counter</span>";
												else
													$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
											}
											$pagination.= "...";
											$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
											$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
										} else if ($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) {
											$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
											$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
											$pagination.= "...";
											for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) {
												if ($counter == $page)
													$pagination.= "<span class=\"current\">$counter</span>";
												else
													$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
											}
							
											$pagination.= "...";
											$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
											$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
										} else {
											$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
											$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
											$pagination.= "...";
											for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) {
												if ($counter == $page)
													$pagination.= "<span class=\"current\">$counter</span>";
												else
													$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
											}
										}
									}
									if ($page < $counter - 1)
										$pagination.= "<a href=\"$targetpage?page=$next\">Next</a>";
									else
										$pagination.= "<span class=\"disabled\">Next</span>";
									$pagination.= "</div>\n";
								}
if (mysql_num_rows($result) > 0) {
$ctr=0;
									while ($rs = mysql_fetch_array($result)) {
 
                    ?>
       <?php if($ctr==0) {echo "<tr>";}?>
            <td  valign="baseline" align="center" bgcolor="#FFFFFF" height="150px"><br />
			<div style="background:#CCCCCC; padding-top:20px; padding-bottom:20px;border-radius:5px; height:280px">
		
				 <img src="../uploadthumbs/<?php echo $rs["image"];?>" style="border-radius:5px; " >
		 
			<br />
			<?php echo "Date:".substr($rs["i_date"],0,10);?> 
			<br />
				<div style="width:180px; text-align:justify">	Details:<?php echo substr($rs["image_details"],0,100);?></div> <br />
						
						
						
			<a  style="font-size:11px" href="#delModal<?php echo md5($rs[0]);?>"  data-toggle="modal"> <button class="btn  btn-danger">Delete</button></a>
			</div>
				<div id="delModal<?php echo md5($rs[0]);?>" class="modal hide fade in" role="dialog" ria-labelledby="myModalLabel" aria-hidden="true">
                             <div class="modal-header">
                                <a class="close" data-dismiss="modal">x</a>
                                <h3>Confirmation Delete</h3>
                            </div>
                             <div><form class="contact" method="post">
											<input type="hidden" name="deleterow"  value="<?=md5($rs[0])?>" />
											   <fieldset>
												<div class="modal-body">
												 <ul class="nav nav-list">
												  <?php
													$nooffield= mysql_num_fields($query)  or $this->Notify(mysql_error());
												 for($makehead=1;$makehead< $nooffield;$makehead++){ 
												  echo  '<p>'. mysql_field_name($query,$makehead).':'.$key[$makehead]?>
												   </p><?php }?>
													</ul> 
												 </div>
												</fieldset>
											
											 </div>
											 <div class="modal-footer">
												<button class="btn  btn-danger" name="Delete"  id="submit">Delete</button>
												  <a href="#" class="btn" data-dismiss="modal">Close</a>
											 </div>
											 </form>
                     </div>
			</td>

                 <?php if($ctr==4) {echo "</tr>";}?>
          <?php 
		
		  $ctr++;
		  if($ctr==4)
		  {$ctr=0;}
		  
		  } }?>
  <?php echo '</table>';
		echo '<div class="category" align="right">';
 echo $pagination ?>
<?php echo "</div>";

	 }
	
	function getList($table, $rows = '*', $where = null, $order = null,$deleterow)
    {
	//die('hello');
	if(@$_GET["cmd"]=="Clear"){unset($_SESSION["where"]);} 
	if(isset($_POST["Delete"]))
	{ $d="delete from $deleterow where md5(id)='". $_POST["deleterow"]."'";
	$d=mysql_query($d) or $this->Notify(mysql_error());
	$this->Message("One Record Deleted");
	}
	$adjacents = 3;
        $q = 'SELECT '.$rows.' FROM '.$table;
	
        if($where != null)
            $q .= ' WHERE '.$where;
			        if($order != null)
			  $q .= ' order by '.$order;
			 //	echo $q;
        if($this->tableExists($table))
       {
        $query = @mysql_query($q) or $this->Notify(mysql_error());
        if($query)
        {
	 	$total_pages = mysql_num_rows(mysql_query($q));
		$targetpage=$_SESSION["varFileName"];

		 $limit = FRONT_PAGE_LIMIT; //how many items to show per page
			if(isset($_GET['page'])) {
			$page = $_GET['page'];
			$start = ($page - 1) * $limit; //first item to display on this page
			} else {
			$page = 0;
			$start = 0; //if no page var is given, set start to 0
			}
			$sql=' LIMIT '.$start.','. $limit;
			 $q=$q.$sql;
								if ($page == 0)
							 $page = 1;
								$prev = $page - 1;
								$next = $page + 1;
								$lastpage = ceil($total_pages / $limit);
								$lpm1 = $lastpage - 1;
							
								$pagination = "";
								if ($lastpage > 1) {
									$pagination .= '<div class="pagination pagination-right"><ul>';
									if ($page > 1)
										$pagination.= "<li><a href=\"$targetpage?page=$prev\">Previous</a></li>";
									else
										$pagination.= "<li class='disabled'><a href='#'>Previous </a></li>";
									if ($lastpage < 7 + ($adjacents * 2)) {
										for ($counter = 1; $counter <= $lastpage; $counter++) {
											if ($counter == $page)
											$pagination.='<li class="active"><a href="#"><span class="sr-only">'.$counter.'</span></a></li>';
											else
												$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
										}
									} else if ($lastpage > 5 + ($adjacents * 2)) {
										if ($page < 1 + ($adjacents * 2)) {
											for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) {
												if ($counter == $page)
													$pagination.='<li class="active"><a href="#">'.$counter.'  </a></li>';
												else
													$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
											}
											$pagination.= "<li class='disabled'><a href='#'>... </a></li>";
											$pagination.= "<li><a href=\"$targetpage?page=$lpm1\">$lpm1</a></li>";
											$pagination.= "<li><a href=\"$targetpage?page=$lastpage\">$lastpage</a></li>";
										} else if ($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) {
											$pagination.= "<li><a href=\"$targetpage?page=1\">1</a></li>";
											$pagination.= "<li><a href=\"$targetpage?page=2\">2</a></li>";
 
											for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) {
												if ($counter == $page)
													$pagination.='<li class="active"><a href="#">'.$counter.'  </a></li>';
												else
													$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
											}
											$pagination.= "<li><a href=\"$targetpage?page=$lpm1\">$lpm1</a></li>";
											$pagination.= "<li><a href=\"$targetpage?page=$lastpage\">$lastpage</a></li>";
										} else {
											$pagination.= "<li><a href=\"$targetpage?page=1\">1</a></li>";
											$pagination.= "<li><a href=\"$targetpage?page=2\">2</a></li>";
 											for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) {
												if ($counter == $page)
													$pagination.='<li class="active"><a href="#">'.$counter.'  </a></li>';
												else
													$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";

											}
										}
									}
									if ($page < $counter - 1)
										$pagination.= "<li><a href=\"$targetpage?page=$next\">Next</a></li>";
									else
										$pagination.= "<li class='disabled'><a href='#'>Next</a></li>";
									$pagination.= "</ul></div> ";
		}
								 $query = @mysql_query($q)  or $this->Notify(mysql_error());
             $this->numResults = mysql_num_rows($query) ;
			
			 
			$callingpage=explode("_",$targetpage);

			$filnemae=explode(".",$targetpage);
			$filesql="select * from system_filelist where filename='".$filnemae[0]."'";
			$fileans=mysql_query($filesql) or die(mysql_error);
			 $showoption=mysql_fetch_array($fileans);
		 $_SESSION["otherpagename"]=$callingpage[0].'_alter';

			$color='active';
			?>
<div class="table-responsive">
   <table class="table table-striped table-hover"> <thead>
			<tr>
	 <?php 
	 $nooffield= mysql_num_fields($query)  or $this->Notify(mysql_error());
	 for($makehead=1;$makehead< $nooffield;$makehead++){ 
	 $fnamexyz= mysql_field_name($query,$makehead);
	 $tname=explode("_",$fnamexyz);
	
	 	 if(($tname[0]=="IntToDate") || ($tname[0]=="IntToTimeAMPM")|| ($tname[0]=="IntToTime24")|| ($tname[0]=="TIME24")|| ($tname[0]=="TIMEAMPM")|| ($tname[0]=="Age"))
		 { $FieldName=$tname[1];}
		  else 
		   {$FieldName=$fnamexyz;}

	 ?><form method="POST">
		  <td  align="left"   ><input type="submit" name="SUBMIT"   value="<?php echo $FieldName;?>"  style="width:80%; border:none;  box-shadow:none; background:none; color:#000000; font-weight:bold; text-align:left "/>
		<input type="hidden" name="fieldvalue" value="<?=$makehead+1?>" />

      </td>  </form>
	  
		 <?php }?>
		 <?php if($showoption["Edit"]==0){  ?> <td ><span  style="font-weight:bold;font-size:12px">Edit</span></td><?php }?>
		 <?php if($showoption["Delete"]==0){?><td><span  style="font-weight:bold;font-size:12px">Delete</span></td><?php }?>
		 <?php if($showoption["View"]==0){?><td><span  style="font-weight:bold; font-size:12px">View</span></td><?php }?>
		 </tr> 
		 </thead>
            <tbody>
		 <?php 
			while($key=@mysql_fetch_array($query))
			{if($color=='active'){$color='warning';}else {$color='active';}echo "<tr class='$color'>";
			for($x = 0; $x < mysql_num_fields($query); $x++)
			{	 	// if(($tname[0]=="DATE") || ($tname[0]=="DATETIME")|| ($tname[0]=="DATETIMEAMPM")|| ($tname[0]=="TIME24")|| ($tname[0]=="TIMEAMPM"))
			
				 $tname=explode("_", mysql_field_name($query,$x));
				 
				 if(($tname[0]=="IntToDate"))
				 {$value=$this->IntToDate($key[$x]);}
				 elseif($tname[0]=="IntToTimeAMPM")
				  {$value=$this->IntToTime12($key[$x]);}
				   elseif($tname[0]=="IntToTime24")
				  {$value=$this->IntToTime24($key[$x]);}
				  elseif(($tname[0]=="Age"))
				 {$value=$this->dateDiff($this->IntToDate($key[$x]),date('d-m-Y'));}
				
				  else
				 {$value=$key[$x];}
				 
				   
				  
				 
			if($x>0){echo "<td  ><font size=2> ". $value."</font> </td>";}}
			?>
 <?php
       if($showoption["Edit"]==0){
	if($showoption["editfile"]<>"No"){$editfile=$showoption["editfile"];} else {$editfile=$_SESSION["otherpagename"];}?>

			<td style="width:1px" align="center">
			
			<a style="font-size:11px; text-decoration:none; " href="<?php echo $editfile.'.php?uid='.md5($key[0]).'&wid='.md5(1);?>">  Edit</a>
			 </td>
			 <?php }?>			 
				</td>

			  <?php if($showoption["Delete"]==0){?>
				<td style="width:1px" align="center">
				<a  style="font-size:11px; text-decoration:none;" href="#delModal<?php echo md5($key[0]);?>"  data-toggle="modal"> Delete</a>
				<div id="delModal<?php echo md5($key[0]);?>" class="modal hide fade in" role="dialog" ria-labelledby="myModalLabel" aria-hidden="true">
                             <div class="modal-header btn-danger">

                                <h3 style="float:left; font-weight:bold">Confirmation Delete</h3>
                         <a class="close" data-dismiss="modal" style="float:right; cursor:default;"><strong>X</strong></a>
<div style="clear:both"></div>
                            </div>
                             <div><form class="contact" method="post">
											<input type="hidden" name="deleterow"  value="<?=md5($key[0])?>" />
											   <fieldset>
												<div class="modal-body">
												 <ul class="nav nav-list" style="text-align:left">
												  <?php
													$nooffield= mysql_num_fields($query)  or $this->Notify(mysql_error());
												 for($makehead=1;$makehead< $nooffield;$makehead++){ 
												  echo  '<p>'. mysql_field_name($query,$makehead).'<strong>&nbsp;:&nbsp;</strong>'.$key[$makehead]?>
												   </p><?php }?>
													</ul> 
												 </div>
												</fieldset>
											
											 </div>
											 <div class="modal-footer">
												<button class="btn  btn-danger" name="Delete"  id="submit">Delete</button>
												  <a href="#" class="btn" data-dismiss="modal" style="text-decoration:none">Close</a>
											 </div>
											 </form>
                     </div>
			 </td>
				<?php }?>
				 <?php if($showoption["View"]==0){
				if($showoption["viewfile"]<>"No"){$executeview=$showoption["viewfile"];} else {$executeview=$_SESSION["otherpagename"];}
					 ?>
				<td style="width:2px" align="center">
 			    <a style="font-size:11px" href="<?php echo $executeview.'.php?uid='.md5($key[0]).'&wid='.md5(3).'&cmd=Clear'?>" />View</a>

				

				 
				</td>
				<?php } 
			
			 
			}	 
			echo " </tbody></table></div>";
echo "<div align='right'>". $pagination."</div>";
       
            return true; 
        }
        else
        {
            return false; 
        }
        }
else
      return false; 
    }
	
	/********* GET DETAIL LIST************/
	function getDetailList($table, $rows = '*', $where = null, $order = null)
    {
 
	if(isset($_POST["Delete"]))
	{ $d="delete from $table where md5(id)='". $_POST["deleterow"]."'";
	$d=mysql_query($d)  or $this->Notify(mysql_error());
	 $this->Message("One Record Deleted ");
	}
	$adjacents = 3;
        $q = 'SELECT '.$rows.' FROM '.$table;
        if($where != null)
            $q .= ' WHERE '.$where;
			
      
        if($this->tableExists($table))
       {
	   if(isset($_POST["SUBMIT"]))
			{$_SESSION["ORDERBY"]=$_POST["fieldvalue"];
			if($_SESSION["ASCDESC"]=="asc"){$_SESSION["ASCDESC"]="desc";} else {$_SESSION["ASCDESC"]="asc";
			
			}
		 
			}
			if(!isset($_SESSION["ORDERBY"])){$_SESSION["ORDERBY"]=1;$_SESSION["ASCDESC"]="asc";}
			$q.=" order  by ".$_SESSION["ORDERBY"]." ".$_SESSION["ASCDESC"];
		
        $query = @mysql_query($q) or die(mysql_error())  ;
	
        if($query)
        {
	 	$total_pages = mysql_num_rows(mysql_query($q));
		$targetpage=$_SESSION["varFileName"];
		 $limit = FRONT_PAGE_LIMIT; //how many items to show per page
			if(isset($_GET['page'])) {
			$page = $_GET['page'];
			$start = ($page - 1) * $limit; //first item to display on this page
			} else {
			$page = 0;
			$start = 0; //if no page var is given, set start to 0
			}
			$sql=' LIMIT '.$start.','. $limit;
		 $q=$q.$sql;
	//	 echo $q;
			 
			
							if ($page == 0)
							 $page = 1;
								$prev = $page - 1;
								$next = $page + 1;
								$lastpage = ceil($total_pages / $limit);
								$lpm1 = $lastpage - 1;
							
								$pagination = "";
								if ($lastpage > 1) {
									$pagination .= '<div class="pagination pagination-right"><ul>';
									
									if ($page > 1)
									
										$pagination.= "<li><a href=\"$targetpage?page=$prev\">Previous</a></li>";
										
									else
										$pagination.= "<li class='disabled'><a href='#'>Previous </a></li>";
							
									if ($lastpage < 7 + ($adjacents * 2)) {
										for ($counter = 1; $counter <= $lastpage; $counter++) {
											if ($counter == $page)
											$pagination.='<li class="active"><a href="#">1 <span class="sr-only">($counter)</span></a></li>';
											else
												$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
										}
									} else if ($lastpage > 5 + ($adjacents * 2)) {
										if ($page < 1 + ($adjacents * 2)) {
											for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) {
												if ($counter == $page)
													$pagination.='<li class="active"><a href="#">'.$counter.'  </a></li>';
												else
													$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
											}

											$pagination.= "<li class='disabled'><a href='#'>... </a></li>";
											$pagination.= "<li><a href=\"$targetpage?page=$lpm1\">$lpm1</a></li>";
											$pagination.= "<li><a href=\"$targetpage?page=$lastpage\">$lastpage</a></li>";
										} else if ($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) {
											$pagination.= "<li><a href=\"$targetpage?page=1\">1</a></li>";
											$pagination.= "<li><a href=\"$targetpage?page=2\">2</a></li>";
 
											for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) {
												if ($counter == $page)
													$pagination.='<li class="active"><a href="#">'.$counter.'  </a></li>';
												else
													$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
											}
							
											
											$pagination.= "<li><a href=\"$targetpage?page=$lpm1\">$lpm1</a></li>";
											$pagination.= "<li><a href=\"$targetpage?page=$lastpage\">$lastpage</a></li>";
										} else {
											$pagination.= "<li><a href=\"$targetpage?page=1\">1</a></li>";
											$pagination.= "<li><a href=\"$targetpage?page=2\">2</a></li>";
 											for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) {
												if ($counter == $page)
													$pagination.='<li class="active"><a href="#">'.$counter.'  </a></li>';
												else
													$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
											}
										}
									}
									if ($page < $counter - 1)
										$pagination.= "<li><a href=\"$targetpage?page=$next\">Next</a></li>";
									else
										$pagination.= "<li class='disabled'><a href='#'>Next</a></li>";
									$pagination.= "</ul></div> ";
		}
								 $query = @mysql_query($q);
             $this->numResults = mysql_num_rows($query);
			
			$callingpage=explode("_",$targetpage);
			$_SESSION["otherpagename"]=$callingpage[0].'_alter';
			$color='active';
			?>

            <tbody>
		 <?php 
			while($key=@mysql_fetch_array($query))
			{if($color=='active'){$color='warning';}else {$color='active';}echo "<tr class='$color'>";
			for($x = 0; $x < mysql_num_fields($query); $x++)
			{
			if($x>0){echo "<td  ><font size=2> ". $key[$x]."</font> </td>";}}
			?>
			 
				<td style="width:1px" align="center">

				<a  style="font-size:11px" href="#delModal<?php echo md5($key[0]);?>"  data-toggle="modal"> Delete</a>
				<div id="delModal<?php echo md5($key[0]);?>" class="modal hide fade in" role="dialog" ria-labelledby="myModalLabel" aria-hidden="true">
                             <div class="modal-header">
                                <a class="close" data-dismiss="modal">x</a>
                                <h3>Confirmation Delete</h3>
                            </div>
                             <div><form class="contact" method="post">
											<input type="hidden" name="deleterow"  value="<?=md5($key[0])?>" />
											   <fieldset>
												<div class="modal-body">
												 <ul class="nav nav-list">
												  <?php
													$nooffield= mysql_num_fields($query);
												 for($makehead=1;$makehead< $nooffield;$makehead++){ 
												  echo  '<p>'. mysql_field_name($query,$makehead).':'.$key[$makehead]?>
												   </p><?php }?>
													</ul> 
												 </div>
												</fieldset>
											
											 </div>
											 <div class="modal-footer">
												<button class="btn  btn-danger" name="Delete"  id="submit">Delete</button>
												  <a href="#" class="btn" data-dismiss="modal">Close</a>
											 </div>
											 </form>
                     </div>
			 
				</td>
				
				 
			<?php
			
			 
			}	 
			echo " </tbody></table></div>";
echo "<div align='right'>". $pagination."</div>";
      
                    
            return true; 
        }
        else
        {
            return false; 
        }
        }
else
      return false; 
    }
 
 
 
	/********** END OF DETAIL LIST */
 
        public function insert($table,$values,$rows = null)
  			 {   
        if($this->tableExists($table))  
        {  
            $insert = 'INSERT INTO '.$table;  
            if($rows != null)  
            {  
                $insert .= ' ('.$rows.')';   
            }  
  
            for($i = 0; $i < count($values); $i++)  
            {  
                 
                    $values[$i] = '"'.$values[$i].'"';  
					
            }  
            $values = implode(',',$values);  
            $insert .= ' VALUES ('.$values.')';  
			//echo $insert;
             $ins = @mysql_query($insert) or $this->Notify(mysql_error());;              
			$insert_id=mysql_insert_id();
            if($ins)  
            {  
                return $insert_id;   
            }  
            else  
            {  
                return false;   
            }  
        }  
    }
 
        public function delete($table,$where)
			{  
        if($this->tableExists($table))  
        {  
            if($where == null)  
            {  
                $delete = 'DELETE '.$table;   
            }  
            else  
            {  
                $delete = 'DELETE FROM '.$table.' WHERE '.$where;   
            }  
            $del = @mysql_query($delete) or $this->Notify(mysql_error());
  
            if($del)  
            {  
                return true;   

            }  
            else  
            {  
               return false;   
            }  
        }  
        else  
        {  
            return false;   
        }  
   }  
  		 public function update($table,$rows,$where=null)  
   			 {  
	     if($this->tableExists($table))  
        {  
            // Parse the where values  
            // even values (including 0) contain the where rows  
            // odd values contain the clauses for the row  
			///echo count($where);
          
            $update = 'UPDATE '.$table.' SET ';  
            $keys = array_keys($rows);   
            for($i = 0; $i < count($rows); $i++)  
			   {  
					if(is_string($rows[$keys[$i]]))  
					{  
						$update .= $keys[$i].'="'.$rows[$keys[$i]].'"';  
					}  
					else  
					{  
						$update .= $keys[$i].'='.$rows[$keys[$i]];  
					}  
					  
					// Parse to add commas  
					if($i != count($rows)-1)  
					{  
						$update .= ',';   
					}  
				}  
         	 $update .= ' WHERE '.$where;  
	 
          	 $query = @mysql_query($update) or $this->Notify(mysql_error());  
            if($query)  
            {  
                return true;   
            }  
            else  
            {  
                return false;   
            }  
        }  
        else  
        {  
            return false;   
        }  
    }
	
		function integertotime($in)
		{
		date_default_timezone_set('Asia/Calcutta');
		return date('H:i A',$in);
		}
		
		function timetointeger($in)
		{
		date_default_timezone_set('Asia/Calcutta');
		$time=explode(":",$in);
		 
		return mktime($time[0],$time[1],0,0,0,0);
		}
			
			
/////////////////////////////////		
/////////////////////////////////			
		function fileupload($tablename,$fname,$id1,$StartFileName)
		{
			
				$tname=$_FILES[$fname]['tmp_name'];
				$file_slice = explode('.', $_FILES[$fname]['name']);
				
				$ext = '';
				$ext = strtoupper(end($file_slice));
				$format = ($ext == 'JPG') ? 'JPEG' : $ext;
				
			
			
			if ((($ext == "GIF")|| ($ext == "JPEG")|| ($ext == "JPG")))
			{
				if ($_FILES[$fname]["error"] > 0)
				{
					"Return Code: " . $_FILES[$fname]["error"] . "<br />";
					return 1;
				}
				else
				{	
					$filemd=$StartFileName."_".$id1;
					$myfilesave1="../staffimage/".$filemd.".".$ext;
					$this->BThumbnail($tname, $myfilesave1, 130,240,$format);
					$qry2 = "UPDATE  ".$tablename."  SET emp_photo= '".$filemd.".".$ext."'  WHERE md5(id)='$id1'"; 				
					mysql_query($qry2);
					
					return;
					
				}
			
			}
		}
/////////////////////////

////////////////////////
		function BThumbnail($img_path, $tn_path, $width,$height, $format="JPEG")
		{ 
			assert(in_array($format, array("JPEG","PNG","GIF")));
			$img = call_user_func("ImageCreateFrom$format", $img_path);
			$img_wd = ImageSX($img);
			$img_ht = ImageSY($img);
			if($img_wd>$img_ht) // if width is bigger that height(landscape)
			{
			$tn_wd  = $width;
			$tn_ht  = ($img_ht * $tn_wd) / $img_wd;
			}
			if($img_wd<$img_ht) // if height is bigger that height(portrait)
			{
			$tn_ht  = $height;
			$tn_wd  = ($img_wd * $tn_ht) / $img_ht;
			}
			if($img_wd==$img_ht)  // if width =  hight (Square)
			{
			$tn_ht  = $height;
			$tn_wd  = $width;
			}
			$tn  = ImageCreateTrueColor($tn_wd, $tn_ht);
			ImageCopyResampled($tn, $img, 0, 0, 0, 0, $tn_wd, $tn_ht, $img_wd, $img_ht);
		
			call_user_func("Image$format", $tn, $tn_path, $width);
			ImageDestroy($img);
			ImageDestroy($tn);
		}	
	
///////////////////////////////	 


		function Inwords($number) { 
    if (($number < 0) || ($number > 999999999)) 
    { 
    throw new Exception("Number is out of range");
    } 
	
	 $Gnc = floor($number / 10000000);  /* crore (giga) */ 
    $number -= $Gnc * 10000000; 

    $Gn = floor($number / 100000);  /* lakh (giga) */ 
    $number -= $Gn * 100000; 
    $kn = floor($number / 1000);     /* Thousands (kilo) */ 
    $number -= $kn * 1000; 
    $Hn = floor($number / 100);      /* Hundreds (hecto) */ 
    $number -= $Hn * 100; 
    $Dn = floor($number / 10);       /* Tens (deca) */ 
    $n = $number % 10;               /* Ones */ 

    $res = ""; 
	
	 if ($Gnc) 
    { 
        $res .= $this->Inwords($Gnc) . " Crore "; 
    } 

    if ($Gn) 
    { 
        $res .= $this->Inwords($Gn) . " Lakh"; 
    } 

    if ($kn) 
    { 
        $res .= (empty($res) ? "" : " ") . 
            $this->Inwords($kn) . " Thousand"; 
    } 

    if ($Hn) 
    { 
        $res .= (empty($res) ? "" : " ") . 
            $this->Inwords($Hn) . " Hundred"; 
    } 

    $ones = array("", "One", "Two", "Three", "Four", "Five", "Six", 
        "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", 
        "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eightteen", 
        "Nineteen"); 
    $tens = array("", "", "Twenty", "Thirty", "Fourty", "Fifty", "Sixty", 
        "Seventy", "Eigthy", "Ninety"); 

    if ($Dn || $n) 
    { 
        if (!empty($res)) 
        { 
            $res .= " and "; 
			
        } 

        if ($Dn < 2) 
        { 
            $res .= $ones[$Dn * 10 + $n]; 
        } 
        else 
        { 
            $res .= $tens[$Dn]; 

            if ($n) 
            { 
                $res .= "-" . $ones[$n]; 
            } 
        } 
    } 

    if (empty($res)) 
    { 
        $res = "Zero"; 
    } 

    return $res; 
}
}   
?> 