PHP - Problem Reading Exif Data

Hello again. I'm trying to load data from a Facebook Share Data XML file and then displaying them in a WordPress plugin. Here's my code so far:


// Fetch Share Count Data

function fb_button () {
$fbshareUrl = urlencode(get_permalink($post->ID));
$fbshareTitle = urlencode($post->post_title);
$fbLinkStats = simplexml_load_file('http://api.facebook.com/restserver.php?method=links.getStats&urls='.$shareUrl);

 $fb_params =
        '?u=' . $fbshareUrl .
        '&t=' . $fbshareTitle .
        ''
        ;

// Vertical Facebook Button

       $fb_share = '
<div class="fsbsharer" id="fb">
<a href="http://www.facebook.com/sharer.php' . $fb_params . '"  class="facebookShare">

<span class="fb_share_size_Small fb_share_count_wrapper">
<span></span>

<span class="fb_share_count_nub_top "></span> 
<span class="fb_share_count  fb_share_count_top">


<div class="fb_share_count_inner">
'. $fbLinkStats->link_stat->total_count .'
</div>

</div>
<span style="cursor:pointer;" class="FBConnectButton FBConnectButton_Small"><span class="FBConnectButton_Text">Share</span></span>
</a>
</div>
';


       echo $fb_share;
    }


This code works for everything except the title and the share count. I can fix the title myself but the share count isn't working.

When I use this in plain HTML:
<?php echo $fbLinkStats->link_stat->total_count.''; ?>
it works fine, but when I combine it all into another function to echo, it no longer works properly.

Thanks.

Hello All,

Please excuse my lack of knowledge in advance, I'm a beginner but pick things up relatively quickly, and tend to do things by trial and error.

I would appreciate any help that anyone could offer with the following:

I would like to retrieve two pieces of data from a "text file" and use them to calculate a result from a function I have in javascript. An example of the javascript code is:

<script type="text/javascript">
function calculate() {
var drybulb = document.calc_form.drybulb.value;
var relhum = document.calc_form.relhum.value;
var answer = '';
if (drybulb !== '' && relhum !== '') {
answer = (0.567*drybulb*1) + (0.393 * (relhum*1/100 * 6.105 * Math.exp(17.27 * drybulb / (237.7 + drybulb*1)))) + 3.94;
}
document.calc_form.answer.value = answer;
return false;
}
</script>

Currently this is evaluated with entry from a simple html form, but I would like to have this performed "automatically".


The "text file" that I would like to access is here, not on my server:

http://www.bom.gov.au/fwo/IDV60901/IDV60901.94870.axf

I would like to extract the "air_temp" and "rel_hum" values under the [data] section for use in my function. I just need the "most recent" values (i.e. first), not all those contained in the file. This is a single record from that section (sorry for the mess this no doubt makes):

[data]
sort_order,wmo,name[80],history_product[80],local_date_time[80],local_date_time_full[80],aifstime_utc[80],air_temp,apparent_t,cloud[80],cloud_base_m,cloud_oktas,cloud_type[80],cloud_type_id,delta_t,dewpt,gust_kmh,gust_kt,lat,lon,press,press_msl,press_qnh,press_tend[80],rain_trace[80],rel_hum,sea_state[80],swell_dir_worded[80],swell_height,swell_period,vis_km[80],weather[80],wind_dir[80],wind_spd_kmh,wind_spd_kt
0,94870,"Moorabbin Airport","IDV60901","27/10:00pm","20120227220000","20120227110000",18.8,19.3,"Partly cloudy",510,3,"-",-9999,0.8,17.5,13,7,-38.0,145.1,1013.5,-9999.0,1013.5,"-","11.4",92,"-","-",-9999.0,-9999,"10","-","S",11,6



Would it be possible to obtain these values using PHP?, and if so any advice on how this could be done (noting my minimal knowledge) would be greatly appreciated.

Cheers.

trying to create a simpleprogram that will read a text file and output information and calculations using the data in the text file. I have 4 radio buttons which represent an item Number. when one is selected the output form should print to a table the ID,Part,Count, Price, and the inventory Value= ($count * $price), can anyone tell me what i am doing wrong?
This is what the .txt file looks like:

AC1000:Hammers:122:12.50
AC1001:Wrenches:5:5.00
AC1002:Handsaws:10:10.00
AC1003:Screwdrivers:222:3.00

Here's what i have so far:
Code: [Select]
<?php
$inf = 'infile.txt';
$FILEH = fopen($inf, 'r') or die ("Cannot open $inf");
$inline = fgets($FILEH,4096);
$found = 0;
//$ptno = 
//if (isset($_POST['AC1000']) || isset($_POST['AC1000']) || isset($_POST['AC1000']) || isset($_POST['AC1000'])) {
while (!feof($FILEH) && !($found)){
list($ptno,$ptname,$num,$price) = split (':', $inline);
if ($ptno == $id) {
print '<table border=1>';
print '<th> ID <th> Part <th> Count <th> Price';
print "<tr><td> $ptno </td><td>$ptname</td>";
print "<td> $num </td><td> \$price</td><tr>";
print '</table>';
$found = 1;
}
$inline = fgets($FILEH,4096);
}
if ($found !=1) {
print "Error: PartNo=$id not found";
}
fclose ($FILEH);
?>

Hello,

I have two photos. According to http://metapicz.com (a website that displays exif data for an image) image1.jpg has a GPSAltitudeRef which is "below sea level". For the second image the GPSAltitudeRef is reported as "above sea level".

When I extract the GPS data in PHP for the first image I get...

$exif1 = exif_read_data('image1.jpg', 0, true);

["GPS"]=> array(17) { ["GPSVersion"]=> string(4) "" ["GPSLatitudeRef"]=> string(1) "N" ["GPSLatitude"]=> array(3) { [0]=> string(4) "37/1" [1]=> string(4) "47/1" [2]=> string(10) "42221/1000" } ["GPSLongitudeRef"]=> string(1) "W" ["GPSLongitude"]=> array(3) { [0]=> string(5) "122/1" [1]=> string(4) "23/1" [2]=> string(10) "46896/1000" } ["GPSAltitudeRef"]=> string(1) "" ["GPSAltitude"]=> string(7) "1408/10" ["GPSTimeStamp"]=> array(3) { [0]=> string(3) "4/1" [1]=> string(4) "43/1" [2]=> string(10) "38000/1000" } ["GPSStatus"]=> string(1) "A" ["GPSMeasureMode"]=> string(1) "3" ["GPSSpeedRef"]=> string(1) "K" ["GPSSpeed"]=> string(4) "8/10" ["GPSTrackRef"]=> string(1) "T" ["GPSTrack"]=> string(9) "25135/100" ["GPSMapDatum"]=> string(6) "WGS-84" ["GPSDateStamp"]=> string(10) "2011:07:15" ["GPSDifferential"]=> int(0) }

 

When I extract the GPS data in PHP for the second image I get...

$exif2 = exif_read_data('image2.jpg', 0, true);

 ["GPS"]=> array(13) { ["GPSVersion"]=> string(4) "" ["GPSLatitudeRef"]=> string(1) "N" ["GPSLatitude"]=> array(3) { [0]=> string(4) "43/1" [1]=> string(4) "53/1" [2]=> string(8) "2950/100" } ["GPSLongitudeRef"]=> string(1) "W" ["GPSLongitude"]=> array(3) { [0]=> string(4) "79/1" [1]=> string(4) "25/1" [2]=> string(8) "3516/100" } ["GPSAltitudeRef"]=> string(1) "" ["GPSAltitude"]=> string(9) "19650/100" ["GPSTimeStamp"]=> array(3) { [0]=> string(4) "19/1" [1]=> string(3) "9/1" [2]=> string(3) "5/1" } ["GPSDOP"]=> string(10) "14134/1000" ["GPSImgDirectionRef"]=> string(1) "M" ["GPSImgDirection"]=> string(5) "354/1" ["GPSProcessingMode"]=> string(13) "ASCIIfused" ["GPSDateStamp"]=> string(10) "2020:06:24" }

 

That is all the GPS data extracted for each image. The GPSAltitudeRef for both is " ", that is it's empty. According to other sources on the net if it had a value then (0 = above sea level) and (1= below sea level), but both are empty.

How do I (or metapicz.com) determine from that exif data that image1.jpg is "below sea level" and image2.jpg is "above sea level".

Thanks

Edited August 1, 2020 by Snap

Hi,

I want to create a function that reads the exif orientation data of an image and rotates it as required - needs to run before before the resize function here, I'm using GD library if that is relevant:

function resize_gd($sourceFileName, $folder, $destinationFileName, $newWidth, $newHeight, $keepProportion)
	{
		$newWidth = (int)$newWidth;
		$newHeight = (int)$newHeight;
		if (!$this->gdInfo >= 1 || !$this->checkGdFileType($sourceFileName)) {
			return false;
		}
		$img = &$this->getImg($sourceFileName);
		if ($this->hasError()) {
			return false;
		}
		$srcWidth = ImageSX($img);
		$srcHeight = ImageSY($img);

		if ( $keepProportion && ($newWidth != 0 && $srcWidth<$newWidth) && ($newHeight!=0 && $srcHeight<$newHeight) ) {
			if ($sourceFileName != $folder . $destinationFileName) {
				@copy($sourceFileName, $folder . $destinationFileName);
			}
			return true;
		}
		
		if ($keepProportion == true) {
			if ($newWidth != 0 && $newHeight != 0) {
				$ratioWidth = $srcWidth/$newWidth;
				$ratioHeight = $srcHeight/$newHeight;
				if ($ratioWidth < $ratioHeight) {
					$destWidth = $srcWidth/$ratioHeight;
					$destHeight = $newHeight;
				} else {
					$destWidth = $newWidth;
					$destHeight = $srcHeight/$ratioWidth;
				}
			} else {
				if ($newWidth != 0) {
					$ratioWidth = $srcWidth/$newWidth;
					$destWidth = $newWidth;
					$destHeight = $srcHeight/$ratioWidth;
				} else if ($newHeight != 0) {
					$ratioHeight = $srcHeight/$newHeight;
					$destHeight = $newHeight;
					$destWidth = $srcWidth/$ratioHeight;
				} else {
					$destWidth = $srcWidth;
					$destHeight = $srcHeight;
				}
			}
		} else {
			$destWidth = $newWidth; 
			$destHeight = $newHeight; 
		}
		$destWidth = round($destWidth);
		$destHeight = round($destHeight);
		if ($destWidth < 1) $destWidth = 1;
		if ($destHeight < 1) $destHeight = 1;
		
		$destImage = &$this->getImageCreate($destWidth, $destHeight);

Edited June 7, 2019 by mcfc4heatons

I have 4 websites
http://www.mercurymagazines.com/pr1/101/101395
http://www.mercurymagazines.com/pr1/169/16000
http://www.mercurymagazines.com/pr1/101/101396
http://www.mercurymagazines.com/pr1/169/16001

I am trying to write a program that will open each webpage one at a time, look for a unique word such as 'FREE' and if it is found the write the URL to a file, if not then no output and the next webpage is opened. I know this word exists only on one of the pages above (http://www.mercurymagazines.com/pr1/101/101396).

When http://www.mercurymagazines.com/pr1/101/101396 appears last in the list located in source.txt the programs WORKS.
When http://www.mercurymagazines.com/pr1/101/101396 appears in any other position such as first, or second, the program does NOT work.

My head is sore from banging against my desk. Any assistance would be appreciated.

<?php

$file_source = fopen("source.txt", "r");
$file_target = fopen("targets.txt", "w");

while (!feof($file_source) ) {
$url = fgets($file_source);

echo '<br>'.$url;

$raw_text = file_get_contents($url);

mb_regex_encoding( "utf-8" );
$words = mb_split( ' +', $raw_text );
 
foreach ($words as $uniques) {
echo $uniques;
  if ($uniques == 'FREE') {
     fwrite($file_target, $url);
     
     }
}

}

?>

Hi

What I need to do is retrieve information from a web form, that contains a file id, and which options from check boxes have been ticked.
The code in the web form is.
Code: [Select]
    <td width=\"206\"><p>$filename1<br><img src=\"$filename1\" alt=\"$filename1\" /></p>
    <p>
      <label>
        <input type=\"checkbox\" name=\"image_id[$unique_id1][save]\" value=\"save\" id=\"CheckboxGroup1_1\" />
        Save</label>
      <br />
      <label>
        <input type=\"checkbox\" name=\"image_id[$unique_id1][delete]\" value=\"delete\" id=\"CheckboxGroup1_2\" />
        Delete</label>
        <br><label>
        <input type=\"checkbox\" name=\"image_id[$unique_id1][rotate]\" value=\"rotate\" id=\"CheckboxGroup1_3\" />
        Image needs rotating</label>
      <br />
    </p></td>

This returns the following when I do a Code: [Select]
var_dump of $_POST['image_id'][/code] when all three boxes are ticked.

Code: [Select]
array(1) { [4600]=> array(3) { ["save"]=> string(4) "save" ["delete"]=> string(6) "delete" ["rotate"]=> string(6) "rotate" } }

the format is as follows
4600 is the file ID, the 3 others are save, delete, and rotate

It appears to work ok, but I can't get at the data easily

I can get the key using key(), but I can't get the other bits of data out using a foreach loop.

Code: [Select]
if(isset($_POST['image_id']))
{
$file_info = $_POST['image_id'];
if (isset($file_info))
{
var_dump($_POST['image_id']);
while($element = current(file_info))
{     
echo "<br> Loop                     = " . key($file_info)."\n";
$index_key = key($file_info);
foreach ($dog1 as $index_key => $value)
{
        Echo "<br> foreach value = $value";
}
      next($file_info);
}
}
}
I'm wondering if the array that is being sent back is ok as I tried to creat an array that sent back the same and couldn't, so maybe my code in the form needs changing.

Hi there,
on my yardmaps website, if a user uploads an image taken with an iphone, and the exif data sets orientation to 1, the image is automatically rotated when put through the imagecopyresampled function.

If I take the same image, and strip out the exif data with photoshop (save as for web, no meta data), the image uploads correctly.

Is there any way to force imagecopyresampled to not rotate the image?

Thanks
B

<league name="italy" id="1">
     <match name="AC Milan v Palermo" time="15/02/2011 20:45">
          <bettype name="Versus (with Draw)">
          <bet outcome_name="AC Milan"      odd="1.87">
               <bet outcome_name="X"                 odd="3.40">
               <bet outcome_name="Palermo"  odd="4.00">
          </bettype>
    </match>

    <match name="Juventus v Torino"  time="15/02/2011 20:45">
         <bettype name="Versus (with Draw)">
                <bet outcome_name="Juventus"   odd="2.00">
              <bet outcome_name="X"          odd="3.00">
              <bet outcome_name="Torino"  odd="2.00">
         </bettype>
   <bettype name="Half Time">
               <bet outcome_name="1"  odd="2.40">
               <bet outcome_name="X"  odd="3.40">
               <bet outcome_name="2"  odd="1.40">
          </bettype>
     </match>
</league>

<league name="Spain" id="2">
     <match name="Barcelona v Real Madrid" time="15/03/2011 21:45">
          <bettype name="Versus (with Draw)">
          <bet outcome_name="Barcelona"    odd="1.87">
               <bet outcome_name="X"            odd="3.40">
               <bet outcome_name="Real Madrid"  odd="4.00">
         </bettype>
     </match>
</league>


im trying to parse attributes of above xml  with using xpath functions. what i want to output is this:
(  <bettype name="Half Time"> this will be ignored   )


Italy
AC Milan v Palermo
1.87 3.40 4.00
Juventus v Torino
2.00 3.00 2.00

spain
Barcelona v Real Madrid
1.87 3.40 4.00



im trying do this with below xpath codes



$xml=simplexml_load_file('http://xml.gamebookers.com/sports/football.xml_attr.xml');
$league=$xml->xpath("//league");          
$matches=$xml->xpath('//bettype[@name="Versus (with Draw)"]/..'); 
$odds=$xml->xpath('//match/bettype[@name="Versus (with Draw)"]/bet'); 



i searched and tried lots of tutorials. i need help in writing the correct code
thanks

Well, im a n00b for php, and what i need is a php script which will read data from .xml file and write it into .txt file. Can someone help me?
Example of .xml file :

<?xml version="1.0" encoding="utf-8"?>
<tv generator-info-name="NeTXMLTV/1.0.0.0" source-info-url="http://www.net-tv.hr/" source-info-name="NeT TV XMLTV" source-data-url="http://www.net-tv.hr/xmltv/net-pregled-programa-xmltv.xml">
  <programme channel="NeT TV" start="20110413063000 +0200" stop="20110413080000 +0200">
    <title lang="hr">JUTARNJI EXPRESS</title>
    <category lang="hr">glazbeno-informativni program</category>
    <desc lang="hr">Glazbeno informativna emisija sa servisnim informacijama i jutarnjim temperaturama, idealna za jutarnje buđenje uz toplu kavu ili čaj....</desc>
  </programme>
</tv>

I need the .txt file to look like this:
201104130630 - 201104130800
JUTARNJI EXPRESS
glazbeno-informativni program
Glazbeno informativna emisija sa servisnim informacijama i jutarnjim temperaturama, idealna za jutarnje buđenje uz toplu kavu ili čaj....

Can someone please help me? thanks

Transferring data from sub-domain.site.com
Reading sub-domain.site.com

What is this all about?
I'm going to put all .. images into a separate sub-domain eg: images.site.com.
This would create a folder inside my public_HTML called "images"

Now when sites have that Transferring data, and Reading... is this .. something relating to what I want. Facebook also does it, and they get their images for the site from a sub domain, how is it all done?

I'm not sure if its entirely PHP, but I hope someone can help.

Thanks

I have a simple query and need to print the result.
My code does not print a resulr but the query is valid and returns a result.
Any help appreciated.
Code: [Select]
$query = ("SELECT * FROM wp_book WHERE Author_ID = '$Author_ID'");

            $result = mysql_query($query) or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error());
            echo mysql_error();
            if (!$result) {
                echo "<br />";
                echo"No Result";
            }
            echo"Result";
           

            while($row = mysql_fetch_assoc($result)){
           
            echo $row['WorkingTitle'];

            }

Hi, i have a transaction table which includes following fields.
 
    tran_ID,account_number,account_type,transaction_type,amount,Date

I want to know how these data can be retrieved and display in another table. The table is filled with several records.

Thanks,
Heshan

Hi...

I create a payroll system and now I have an issue or problem in saving data before I save data using save button now i want to save data when  clicking the employee name at the navigalist list from the left side.


Here is my code for the searching and displaying employee name at navigation list:


Here is my code for search.php:

Code: [Select]
<?php

session_start();
include 'config.php';

$queryString = $_GET["query"];

if ($queryString == "" || $queryString == null) {

$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ',  FNAME, ' ', MI, '.') AS FULLNAME FROM PERSONAL 
        ORDER BY FULLNAME ASC";
}
else {

$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ',  FNAME, ' ', MI, '.') AS FULLNAME FROM PERSONAL WHERE CONCAT(LNAME, ', ',  FNAME, ' ', MI, '.')  LIKE '" . $queryString . "%' ORDER BY FULLNAME ASC";

}

$recPersonalQuery = $conn->Execute($sql);
if (!$recPersonalQuery->BOF) {
    $recPersonalQuery->MoveFirst();
}

echo "<hr />";
echo "<ul>";
while (!$recPersonalQuery->EOF) {
    $empID   = $recPersonalQuery->fields["EMP_ID"]; 
    $empFullName = $recPersonalQuery->fields["FULLNAME"];

  echo "<li onclick=changeEmployeePay('$empID'); >$empFullName</li>";
  //echo "<li onkeyup=changeEmployeePay('$empID'); >$empFullName</li>";
    echo "<hr />";
    $recPersonalQuery->MoveNext();
} 
echo "</ul>";

$recPersonalQuery->Close();
exit();    
?>


here is the javascript code and the template for displaying employee name list:
Code: [Select]
<html>
<head>
<title></title>
<script>
function searchemppay(queryString) {
    var ajaxRequest = remoteRequestObject();
    ajaxRequest.onreadystatechange = function() {
        if (ajaxRequest.readyState == 4 && ajaxRequest.status == 200) {
            var result = ajaxRequest.responseText;
         
            document.getElementById('searchpayroll').innerHTML = result;
        }
    }

    var url = "search.php?query=" + queryString;
    ajaxRequest.open("GET", url, true);
    ajaxRequest.setRequestHeader("If-Modified-Since", "Sat, 1 Jan 2000 00:00:00 GMT");
    ajaxRequest.send(null);

}

function changeEmployeePay(queryID) {
 
window.location = "SearchData.php?queryEmpID=" + queryID;
}
</script>

</head>
<body>
<div id="Search">
<form>
<p class="serif"><b>Search Lastname:</b></p>
<input type="text" name="search_" size="20" onkeyup="searchemppay(this.value);"> 
<div id="searchpayroll" style="overflow:auto; height:390px; width:auto; margin-left:2px" >
<hr />
<ul>
{section name=co_emp loop=$personalAll}
<li onclick="changeEmployeePay('{$personalAll[co_emp].EMP_ID}')">{$personalAll[co_emp].FULLNAME}</li>
<!--<li onkeyup="changeEmployeePay('{$personalAll[co_emp].EMP_ID}')">{$personalAll[co_emp].FULLNAME}</li>-->
<hr />
{sectionelse}
<li>No records found</li>
{/section}
</ul>
</div>
</div>

</body>
</html>

 and here is the code for displaying employee data
Code: [Select]
<?php
include 'config.php';
$currentEmpID = $_SESSION['empID']; 
 
$sql = "SELECT EMP_ID, CONCAT(LNAME, ', ' , FNAME, ' ', MI) AS FULLNAME FROM PERSONAL ORDER BY LNAME ASC";
$recPersonalNav = $conn->GetAll($sql);
$smarty->assign('personalAll', $recPersonalNav);

$EMP_NO = $_POST['EMP_NO'];

$sql = "SELECT em.EMP_NO, p.EMP_ID, CONCAT(LNAME, ', ',  FNAME, ' ', MI, '.') AS FULLNAME FROM PERSONAL p, EMPLOYMENT em  WHERE p.EMP_ID='$currentEmpID' AND em.EMP_ID = '$currentEmpID'";      
  
$recPersonalHead = $conn->Execute($sql);
$fullName = $recPersonalHead->fields["FULLNAME"];
$empno = $recPersonalHead->fields["EMP_NO"];

$smarty->assign('empid', $currentEmpID);
$smarty->assign('fullname', $fullName);
$smarty->assign('empno', $empno);

 $sql = "SELECT EMP_ID, RATE FROM wage WHERE EMP_ID = '$currentEmpID'";
 $rsWage = $conn->Execute($sql);
 
 $Rate      = $rsWage->fields['RATE'];    
 

 $sql = "SELECT EMP_ID,EMP_NO, STATUS FROM employment WHERE EMP_ID = '$currentEmpID'";
 $rsStatus = $conn->Execute($sql);
 
 $STATUS = $rsStatus->fields['STATUS'];
 $EMP_ID = $rsStatus->fields['EMP_ID'];


$sql = "SELECT em.EMP_NO, em.STATUS, w.RATE, r.Hours, o.OT_Hours 
FROM $ADODB_DB.employment AS em 
INNER JOIN $ADODB_DB.wage AS w ON em.EMP_ID = w.EMP_ID
LEFT JOIN $PAYROLL.regular_sum_hours AS r ON em.EMP_NO = r.EMP_NO
LEFT JOIN $PAYROLL.ot_data AS o ON r.EMP_NO = o.EMP_NO
WHERE  em.EMP_ID = '$currentEmpID' AND o.STATUS = 'Offset'";
 
  $RsEarnings = $conn2->Execute($sql); 
  
  $Rate      = $RsEarnings->fields['RATE'];
  $Hours      = $RsEarnings->fields['Hours'];
  $Offset = $RsEarnings->fields['OT_Hours'];

  $Hours = substr($Hours, 0, 5);
  $Hours = str_replace(':', '.', $Hours);
  
  $Hours = ($Hours + $Offset);
  
 $Amount = $_POST["Amount"];
 
 $Amount = round(($Hours/8)* $Rate, 2); 

  $smarty->assign('Rate', $Rate);
  $smarty->assign('Hours', $Hours);
  $smarty->assign('Amount', $Amount);



$sql = "SELECT em.EMP_NO, o.OT_Category, SUM(OT_Hours) AS OT_Hours, o.STATUS FROM $PAYROLL.ot_data o, $ADODB_DB.employment em WHERE em.EMP_NO = o.EMP_NO AND o.OT_Category = 'RegularOvertime' AND o.STATUS = 'Overtime' AND em.EMP_ID = '$currentEmpID' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);

$OTReg_Hours = $rsOTData->fields['OT_Hours'];
$OTReg_Hours = round($OTReg_Hours, 2);

$OTReg_Amt = round((($Rate / 8 * 1.3) * $OTReg_Hours), 2);

$smarty->assign('OTReg_Hours', $OTReg_Hours);
$smarty->assign('OTReg_Amt', $OTReg_Amt);



$sql = "SELECT em.EMP_NO, o.OT_Category, SUM(OT_Hours) AS OT_Hours FROM $PAYROLL.ot_data o, $ADODB_DB.employment em  WHERE em.EMP_NO = o.EMP_NO AND o.OT_Category = 'SundayRegular' AND em.EMP_ID = '$currentEmpID' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);

$SunReg_Hours = $rsOTData->fields['OT_Hours'];
$SunReg_Hours = round($SunReg_Hours, 2);

$SunReg_Amt = round((($Rate / 8 * 1.35) * $SunReg_Hours), 2); 

$smarty->assign('SunReg_Hours', $SunReg_Hours);
$smarty->assign('SunReg_Amt', $SunReg_Amt); 


$sql = "SELECT em.EMP_NO, o.OT_Category, SUM(OT_Hours) AS OT_Hours FROM $PAYROLL.ot_data o, $ADODB_DB.employment em WHERE em.EMP_NO = o.EMP_NO AND o.OT_Category = 'SundayOvertime' AND em.EMP_ID = '$currentEmpID' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);

$OTSun_Hours = $rsOTData->fields['OT_Hours'];
$OTSun_Hours = round($OTSun_Hours, 2);

$OTSun_Amt = round((($Rate / 8 * 1.35 * 1.35) * $OTSun_Hours), 2);

$smarty->assign('OTSun_Hours', $OTSun_Hours);
$smarty->assign('OTSun_Amt', $OTSun_Amt); 


$sql = "SELECT em.EMP_NO, o.OT_Category, SUM(OT_Hours) AS OT_Hours FROM $PAYROLL.ot_data o, $ADODB_DB.employment em WHERE em.EMP_NO = o.EMP_NO AND o.OT_Category = 'HolidayRegular' AND em.EMP_ID = '$currentEmpID' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);

$HolReg_Hours = $rsOTData->fields['OT_Hours'];
$HolReg_Hours = round($HolReg_Hours, 2);

$HolReg_Amt = round((($Rate / 8 * 1.5) * $HolReg_Hours), 2);

$smarty->assign('HolReg_Hours', $HolReg_Hours);
$smarty->assign('HolReg_Amt', $HolReg_Amt); 

$sql = "SELECT em.EMP_NO, o.OT_Category, SUM(OT_Hours) AS OT_Hours FROM $PAYROLL.ot_data o, $ADODB_DB.employment em WHERE em.EMP_NO = o.EMP_NO AND o.OT_Category = 'HolidayRegularOvertime' AND em.EMP_ID = '$currentEmpID' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);

$HolRegOT_Hours = $rsOTData->fields['OT_Hours'];
$HolRegOT_Hours = round($HolRegOT_Hours, 2);

$HolRegOT_Amt = round((($Rate / 8 * 2.05 * 1.35) * $HolRegOT_Hours), 2);

$smarty->assign('HolRegOT_Hours', $HolRegOT_Hours);
$smarty->assign('HolRegOT_Amt', $HolRegOT_Amt); 


$sql = "SELECT em.EMP_NO, SUM(l.HOURS_LEAVE) AS HOURS_LEAVE FROM $PAYROLL.leave_data l, $ADODB_DB.employment em WHERE em.EMP_NO = l.EMP_NO AND em.EMP_ID = '$currentEmpID' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);


$HolLeave_Hours = $rsOTData->fields['HOURS_LEAVE'];

$HolLeave_Hours = round($HolLeave_Hours, 2);

$HolLeave_Amt = round((($Rate) * $HolLeave_Hours), 2);

$smarty->assign('HolLeave_Hours', $HolLeave_Hours);
$smarty->assign('HolLeave_Amt', $HolLeave_Amt); 


$sql = "SELECT em.EMP_NO, o.OT_Category, SUM(OT_Hours) AS OT_Hours FROM $PAYROLL.ot_data o, $ADODB_DB.employment em WHERE em.EMP_NO = o.EMP_NO AND o.OT_Category = 'NightPremiumRegular' AND em.EMP_ID = '$currentEmpID' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);

$NPReg_Hours = $rsOTData->fields['OT_Hours'];
$NPReg_Hours = round($NPReg_Hours, 2);

$NPReg_Amt = round((($Rate / 8 * 0.15) * $NPReg_Hours), 2);


$sql = "SELECT em.EMP_NO, o.OT_Category, SUM(OT_Hours) AS OT_Hours FROM $PAYROLL.ot_data o, $ADODB_DB.employment em WHERE em.EMP_NO = o.EMP_NO AND o.OT_Category = 'NightPremiumSunday' AND em.EMP_ID = '$currentEmpID' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);

$NPSun_Hours = $rsOTData->fields['OT_Hours'];
$NPSun_Hours = round($NPSun_Hours, 2);

$NPSun_Amt = round((($Rate / 8 * 1.35 * 0.15) * $NPSun_Hours), 2);


$sql = "SELECT em.EMP_NO, o.OT_Category, SUM(OT_Hours) AS OT_Hours FROM $PAYROLL.ot_data o, $ADODB_DB.employment em WHERE em.EMP_NO = o.EMP_NO AND o.OT_Category = 'NightPremiumHoliday' AND em.EMP_ID = '$currentEmpID' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);

$NPHol_Hours = $rsOTData->fields['OT_Hours'];
$NPHol_Hours = round($NPHol_Hours, 2);

$NPHol_Amt = round((($Rate / 8 * 2.05 * 0.15) * $NPHol_Hours), 2);


$NP_Hours = round(($NPReg_Hours + $NPSun_Hours + $NPHol_Hours), 2);
$NP_Hours = round($NP_Hours, 2);

$NP_Amt =  round(($NPReg_Amt + $NPSun_Amt + $NPHol_Amt), 2); 

$smarty->assign('NP_Hours', $NP_Hours);
$smarty->assign('NP_Amt', $NP_Amt);

$sql = "SELECT COUNT(o.EMP_NO) AS EMP_NO, o.OT_Category, o.OT_Hours, o.STATUS FROM $PAYROLL.ot_data o, $ADODB_DB.employment em WHERE em.EMP_NO = o.EMP_NO AND o.OT_Category IN ('RegularOvertime', 'HolidayRegular', 'HolidayRegularOvertime') AND o.OT_Hours > 2  AND em.EMP_ID = '$currentEmpID' AND o.STATUS = 'Overtime' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);
$MealReg_Hours = $rsOTData->fields['EMP_NO'];
$MealReg_Hours = round($MealReg_Hours, 2);

$MealReg_Amt = round(($MealReg_Hours * 23), 2);

$sql = "SELECT COUNT(o.EMP_NO) AS EMP_NO, o.OT_Category, o.OT_Hours FROM $PAYROLL.ot_data o, $ADODB_DB.employment em WHERE em.EMP_NO = o.EMP_NO AND o.OT_Category IN ('SundayRegular', 'SundayOvertime') AND o.OT_Hours > 2 AND em.EMP_ID = '$currentEmpID' GROUP BY em.EMP_NO";
$rsOTData = $conn2->Execute($sql);

$MealSun_Hours = $rsOTData->fields['EMP_NO'];
$MealSun_Hours = round($MealSun_Hours, 2);


$MealSun_Amt = round(($MealSun_Hours * 30), 2);

$Meal_Hours = round(($MealReg_Hours + $MealSun_Hours), 2);

$Meal_Amt = round(($MealReg_Amt + $MealSun_Amt), 2);
$smarty->assign('Meal_Hours', $Meal_Hours);
$smarty->assign('Meal_Amt', $Meal_Amt);


$sql = "SELECT COUNT(a.EMP_NO) AS EMP_NO, w.RATE FROM $ADODB_DB.wage w, $ADODB.employment em, $PAYROLL.attendance a WHERE em.EMP_NO = a.EMP_NO AND w.RATE = 302 AND em.EMP_ID = '$currentEmpID' GROUP BY w.RATE";
$rsOTData = $conn2->Execute($sql);

$Cola_Hours = $rsOTData->fields['EMP_NO'];
$Cola_Hours = round($Cola_Hours, 2);


$Cola_Amt = round(($Cola_Hours * 28), 2);
      
$smarty->assign('Cola_Hours', $Cola_Hours);
$smarty->assign('Cola_Amt', $Cola_Amt);

$TotEarn = $_POST['TotEarn'];

$TotEarn = round(($Amount + $OTReg_Amt + $SunReg_Amt + $OTSun_Amt + $HolReg_Amt + $HolRegOT_Amt + $HolLeave_Amt + $NP_Amt + $Meal_Amt + $Cola_Amt), 2);

$smarty->assign('TotEarn', $TotEarn);


$HDMF = $_POST['HDMF'];

$sql = "SELECT Ref_No, Range FROM $PAYROLL.hdmf, $ADODB_DB.employment em WHERE em.EMP_ID = '$currentEmpID'";
$rs = $conn2->Execute($sql);

$Range = $rs->fields['Range'];
 
if ($TotEarn <= $Range) {
    $HDMF = round(($TotEarn * 0.01), 2);
} else {
    $HDMF = round(($TotEarn * 0.02), 2);
}  

$smarty->assign('HDMF', $HDMF);


$SSS = $_POST['SSS'];

$sql = "SELECT Ref_No, From_Range, To_Range, Employee_Share FROM $PAYROLL.sss, $ADODB_DB.employment em WHERE em.EMP_ID = '$currentEmpID' AND $TotEarn BETWEEN From_Range AND To_Range";
$rs = $conn2->Execute($sql);

$SSS = $rs->fields['Employee_Share'];

$smarty->assign('SSS', $SSS);     



$PCHL = $_POST['PCHL'];

$sql = "SELECT Ref_No, From_Range, To_Range, Employee_Share FROM $PAYROLL.pchl, $ADODB_DB.employment em WHERE em.EMP_ID = '$currentEmpID' AND $TotEarn BETWEEN From_Range AND To_Range";
$rs = $conn2->Execute($sql);

$PCHL = $rs->fields['Employee_Share'];

$smarty->assign('PCHL', $PCHL);

$TAX = $_POST['TAX'];

$sql = "SELECT EMP_ID, EMP_NO, W4_STATUS, DEPENDENTS FROM employment  WHERE EMP_ID = '$currentEmpID'";
$rsTax = $conn->Execute($sql);

$W4_STATUS = $rsTax->fields['W4_STATUS'];
$DEPENDENTS = $rsTax->fields['DEPENDENTS'];

if($W4_STATUS == 1 AND $DEPENDENTS == 0 AND $TotEarn >= 0 AND $TotEarn <= 2083){
  $TAX = round($TotEarn * .05);
}
elseif($W4_STATUS == 2 AND $DEPENDENTS == 0 AND $TotEarn >= 0 AND $TotEarn <= 2083){
  $TAX = round($TotEarn * .05);
  
}
elseif($W4_STATUS == 1 AND $DEPENDENTS == 0 AND $TotEarn >= 2083 AND $TotEarn <= 2500) {
  $TAX = round($TotEarn - 2083);
  $TAX = round(20.83 + ($TAX * .10));
}
elseif($W4_STATUS == 2 AND $DEPENDENTS == 0 AND $TotEarn >= 2083 AND $TotEarn <= 2500) {
  $TAX = round($TotEarn - 2083);
  $TAX = round(20.83 + ($TAX * .10));
}
elseif($W4_STATUS == 1 AND $DEPENDENTS == 0 AND $TotEarn >= 2500 AND $TotEarn <= 3333) {
  $TAX = round($TotEarn - 2500);
  $TAX = round(104.17 + ($TAX * .15));
} 
else{
    $TAX = round(0);
}

$smarty->assign('TAX', $TAX);


 $sql = "SELECT s.EMP_NO, s.SSSAmor FROM $PAYROLL.sssloan s, $ADODB_DB.employment em WHERE em.EMP_NO = s.EMP_NO AND em.EMP_ID = '$currentEmpID'";
 $RsDed = $conn2->Execute($sql);
 
 $SSSAmor = round($RsDed->fields['SSSAmor']);
 
$sql = "SELECT h.EMP_NO, h.HDMFAmor FROM $PAYROLL.hdmfloan h, $ADODB_DB.employment em WHERE em.EMP_NO = h.EMP_NO AND em.EMP_ID = '$currentEmpID'"; 
 $RsHDMF = $conn2->Execute($sql);
 
 $HDMFAmor = round($RsHDMF->fields['HDMFAmor']);
 
 
$sql = "SELECT u.EMP_NO, u.UDTAmor FROM $PAYROLL.udtloan u, $ADODB_DB.employment em WHERE em.EMP_NO = u.EMP_NO AND em.EMP_ID = '$currentEmpID'";
 $RsUDT = $conn2->Execute($sql);
 
 $UDTAmor = round($RsUDT->fields['UDTAmor']);

$TotalDed = $_POST['TotalDed'];

 $sql = "SELECT o.EMP_NO, o.BurialSeparationCont, o.TaxAjt, o.CashAdvance, o.AdvanceShirt, o.AdvanceMed, o.AdvanceOther FROM $PAYROLL.other_deductions o, $ADODB_DB.personal p, $ADODB_DB.employment em WHERE em.EMP_ID = '$currentEmpID' AND em.EMP_NO = o.EMP_NO";
 $rsOtherDed = $conn2->Execute($sql);
 
 $BurialSep = round($rsOtherDed->fields['BurialSeparationCont']);
 $TaxAjt = round($rsOtherDed->fields['TaxAjt']);
 $CashAdvance = round($rsOtherDed->fields['CashAdvance']);
 $AdvancesShirt = round($rsOtherDed->fields['AdvanceShirt']);
 $AdvancesMed = round($rsOtherDed->fields['AdvanceMed']);
 $AdvancesOthers = round($rsOtherDed->fields['AdvanceOther']);
 
 $smarty->assign('BurialSep', $BurialSep);
 $smarty->assign('TaxAjt', $TaxAjt);
 $smarty->assign('CashAdvance', $CashAdvance);
 $smarty->assign('AdvancesShirt', $AdvancesShirt);
 $smarty->assign('AdvancesMed', $AdvancesMed);
 $smarty->assign('AdvancesOthers', $AdvancesOthers);
 

$TotalDed = round(($SSS + $HDMF + $PCHL + $TAX + $SSSAmor + $HDMFAmor + $UDTAmor + $BurialSep + $TaxAjt + $CashAdvance + $AdvancesShirt + $AdvancesMed + $AdvancesOthers), 2); 

 $smarty->assign('SSSAmor', $SSSAmor);
 $smarty->assign('HDMFAmor', $HDMFAmor);
 $smarty->assign('UDTAmor', $UDTAmor);
 $smarty->assign('TotalDed', $TotalDed);
 
$THP = $_POST["TakeHomePay"];

$THP = round($TotEarn - $TotalDed, 2);

$smarty->assign('THP', $THP);

 
 $sql = "SELECT EMP_NO, OTReg_Amt, SunReg_Amt, OTSun_Amt, HolReg_Amt, HolRegOT_Amt, HolLeave_Amt, NP_Amt, Meal_Amt, Cola_Amt FROM other_earnings WHERE EMP_NO = '$empno'";
 $RsOtherEarnings = $conn2->Execute($sql);
 
 $numrowsOtherEarnings = $RsOtherEarnings->RecordCount();
 
 if($numrowsOtherEarnings > 0){ 
 
 $saverec['EMP_NO'] = $empno;
 $saverec['OTReg_Amt'] = $OTReg_Amt;
 $saverec['SunReg_Amt'] = $SunReg_Amt;
 $saverec['OTSun_Amt'] = $OTSun_Amt;
 $saverec['HolReg_Amt'] = $HolReg_Amt;
 $saverec['HolRegOT_Amt'] = $HolRegOT_Amt;
 $saverec['HolLeave_Amt'] = $HolLeaveAmt;
 $saverec['NP_Amt'] = $NP_Amt;
 $saverec['Meal_Amt'] = $Meal_Amt;
 $saverec['Cola_Amt'] = $Cola_Amt;
 
  $updateOtherEarnings = $conn2->GetUpdateSQL($RsOtherEarnings, $saverec); 
  $conn2->Execute($updateOtherEarnings); 
 }
 else{
 $sql = "SELECT o.EMP_NO, o.OTReg_Amt, o.SunReg_Amt, o.OTSun_Amt, o.HolReg_Amt, o.HolRegOT_Amt, o.HolLeave_Amt, o.NP_Amt, o.Meal_Amt, o.Cola_Amt FROM $PAYROLL.other_earnings o, $ADODB_DB.employment em WHERE em.EMP_ID = '$currentEmpID'";
 $RsOtherEarnings = $conn2->Execute($sql);
 
$saverec['EMP_NO'] = $empno;
 $saverec['OTReg_Amt'] = $OTReg_Amt;
 $saverec['SunReg_Amt'] = $SunReg_Amt;
 $saverec['OTSun_Amt'] = $OTSun_Amt;
 $saverec['HolReg_Amt'] = $HolReg_Amt;
 $saverec['HolRegOT_Amt'] = $HolRegOT_Amt;
 $saverec['HolLeave_Amt'] = $HolLeaveAmt;
 $saverec['NP_Amt'] = $NP_Amt;
 $saverec['Meal_Amt'] = $Meal_Amt;
 $saverec['Cola_Amt'] = $Cola_Amt;
 
  $insertOtherEarnings = $conn2->GetInsertSQL($RsOtherEarnings, $saverec); 
  $conn2->Execute($insertOtherEarnings); 
 }

 
 $sql = "SELECT EMP_NO, SSS, TAX, PCHL, HDMF FROM deductions WHERE EMP_NO = '$empno'";
 $RsDeduction = $conn2->Execute($sql);
 
 $numrowsDeduction = $RsDeduction->RecordCount(); 
 
 if($numrowsDeduction > 0){
 $saverec['EMP_NO'] = $empno;
 $saverec['SSS'] = $SSS;
 $saverec['TAX'] = $TAX;
 $saverec['PCHL'] = $PCHL;
 $saverec['HDMF'] = $HDMF;
 
 
 $updateDeductionSQL = $conn2->GetUpdateSQL($RsDeduction, $saverec); 
 $conn2->Execute($updateDeductionSQL); 
 }
 else{
  $sql = "SELECT d.EMP_NO, d.SSS, d.TAX, d.PCHL, d.HDMF FROM $PAYROLL.deductions d, $ADODB_DB.employment em WHERE em.EMP_ID = '$currentEmpID'";
 $RsDeduction = $conn2->Execute($sql);
 
 $saverec['EMP_NO'] = $empno;
 $saverec['SSS'] = $SSS;
 $saverec['TAX'] = $TAX;  
 $saverec['PCHL'] = $PCHL;
 $saverec['HDMF'] = $HDMF;
 
 $insertSQL = $conn2->GetInsertSQL($RsDeduction, $saverec); 
 $conn2->Execute($insertSQL); 
 }
 
 
 $sql = "SELECT EMP_NO, SSSLoan, HDMFLoan, UDTLoan FROM loan_deductions WHERE EMP_NO = '$empno'";
 $RsLoan = $conn2->Execute($sql);
 
 $numrowsRsLoan = $RsLoan->RecordCount();
 
 if($numrowsRsLoan > 0){
 $saverec['EMP_NO'] = $empno;
 $saverec['SSSLoan'] = $SSSAmor;
 $saverec['HDMFLoan'] = $HDMFAmmor;
 $saverec['UDTLoan'] = $UDTAmor;
 
 $updateLoanSQL = $conn2->GetUpdateSQL($RsLoan, $saverec); 
 $conn2->Execute($updateLoanSQL); 
 }
 else{
 
 $sql = "SELECT l.EMP_NO, l.SSSLoan, l.HDMFLoan, l.UDTLoan FROM $PAYROLL.loan_deductions l, $ADODB_DB.employment em WHERE em.EMP_ID = '$currentEmpID'";
 $RsLoan = $conn2->Execute($sql);
 
 $saverec['EMP_NO'] = $empno;
 $saverec['SSSLoan'] = $SSSAmor;
 $saverec['HDMFLoan'] = $HDMFAmor;
 $saverec['UDTLoan'] = $UDTAmor;
 
 $insertSQL = $conn2->GetInsertSQL($RsLoan, $saverec); 
 $conn2->Execute($insertSQL); 
 }

   $sql = "SELECT EMP_NO, Amount, TotalEarnings, TotalDeductions, TakeHomePay FROM totalpay WHERE EMP_NO = '$empno'";
  $rsTotal = $conn2->Execute($sql);
  
  $numrows = $rsTotal->RecordCount();
  
  if($numrows > 0){
  
  $saverec['EMP_NO'] = $empno;
  $saverec['Amount'] = $Amount;
  $saverec['TotalEarnings'] = $TotEarn;
  $saverec['TotalDeductions'] = $TotalDed;
  $saverec['TakeHomePay'] = $THP;
  
  $updateSQL = $conn2->GetUpdateSQL($rsTotal, $saverec); 
  $conn2->Execute($updateSQL);  
  }
  else{ 
  $sql = "SELECT t.EMP_NO, t.Amount, t.TotalEarnings, t.TotalDeductions, t.TakeHomePay FROM $PAYROLL.totalpay t, $ADODB_DB.employment em WHERE em.EMP_ID = '$currentEmpID'";
  $rsTotal = $conn2->Execute($sql);
  
  $saverec['EMP_NO'] = $empno;
  $saverec['Amount'] = $Amount;
  $saverec['TotalEarnings'] = $TotEarn;
  $saverec['TotalDeductions'] = $TotalDed;
  $saverec['TakeHomePay'] = $THP;
  
  $insertSQL = $conn2->GetInsertSQL($rsTotal, $saverec); 
  $conn2->Execute($insertSQL);  
  } 
$smarty->display('header.tpl');
$smarty->display('left.tpl');
$smarty->display('empPayrollData.tpl');
$smarty->display('footer.tpl'); 

?>

I have a problem in saving data from other deductions and the total deductions and takehomepay, because other deductions is insertable textfield and when I add other deductions the total deductions will change also the Take Home Pay. Idon't know where Can I add this code for saving data of other deductions and updating the changes if Total Deductions and Take Home Pay.

Code: [Select]
$sql = "SELECT EMP_NO, BurialSeparationCont, TaxAjt, CashAdvance, AdvanceShirt, AdvanceMed, AdvanceOther FROM other_deductions WHERE EMP_NO = '$empno'";
  $rsOtherDed = $conn2->Execute($sql);
 
  $numrows1 = $rsOtherDed->RecordCount();
 
  if($numrows1 > 0){ 
  $saverec['EMP_NO'] = $empno;
  $saverec['BurialSeparationCont'] = $BurialSep;
  $saverec['TaxAjt'] = $TaxAjt;
  $saverec['CashAdvance'] = $CashAdvance;
  $saverec['AdvanceShirt'] = $AdvancesShirt;
  $saverec['AdvanceMed'] = $AdvancesMed;
  $saverec['AdvanceOther'] = $AdvancesOthers;

  $updateSQL = $conn2->GetUpdateSQL($rsOtherDed, $saverec);

  $conn2->Execute($updateSQL);

 
  }
  else{
  $sql = "SELECT o.EMP_NO, o.BurialSeparationCont, o.TaxAjt, o.CashAdvance, o.AdvanceShirt, o.AdvanceMed, o.AdvanceOther FROM $PAYROLL.other_deductions o, $ADODB_DB.employment em WHERE em.EMP_ID = '$currentEmpID'";
  $rsOtherDed = $conn2->Execute($sql);
 
  $saverec['EMP_NO'] = $empno;
  $saverec['BurialSeparationCont'] = $BurialSep;
  $saverec['TaxAjt'] = $TaxAjt;
  $saverec['CashAdvance'] = $CashAdvance;
  $saverec['AdvanceShirt'] = $AdvancesShirt;
  $saverec['AdvanceMed'] = $AdvancesMed;
  $saverec['AdvanceOther'] = $AdvancesOthers;

  $insert = $conn2->GetInsertSQL($rsOtherDed, $saverec);
  $conn2->Execute($insert);
 
 }
   
   $Amount = $_POST["Amount"];
   $TotEarn = $_POST["TotEarn"];
   $TotalDed = $_POST["TotalDed"];
   $THP = $_POST["TakeHomePay"];
 
   $sql = "SELECT EMP_NO, Amount, TotalEarnings, TotalDeductions, TakeHomePay FROM totalpay WHERE EMP_NO = '$empno'";
  $rsTotal = $conn2->Execute($sql);
 
  $numrows = $rsTotal->RecordCount();
 
  if($numrows > 0){
 
  $saverec['EMP_NO'] = $empno;
  $saverec['Amount'] = $Amount;
  $saverec['TotalEarnings'] = $TotEarn;
  $saverec['TotalDeductions'] = $TotalDed;
  $saverec['TakeHomePay'] = $THP;
 
  $updateSQL = $conn2->GetUpdateSQL($rsTotal, $saverec);
  $conn2->Execute($updateSQL); 
  }
  else{
  $sql = "SELECT t.EMP_NO, t.Amount, t.TotalEarnings, t.TotalDeductions, t.TakeHomePay FROM $PAYROLL.totalpay t, $ADODB_DB.employment em WHERE em.EMP_ID = '$currentEmpID'";
  $rsTotal = $conn2->Execute($sql);
 
  $saverec['EMP_NO'] = $empno;
  $saverec['Amount'] = $Amount;
  $saverec['TotalEarnings'] = $TotEarn;
  $saverec['TotalDeductions'] = $TotalDed;
  $saverec['TakeHomePay'] = $THP;
 
  $insertSQL = $conn2->GetInsertSQL($rsTotal, $saverec);
  $conn2->Execute($insertSQL); 
  }

I don't know where I can put this code to save the data that i inserted in other deductions