Learn VBA & Macros in 1 Week!

PHP - Moved: Tutorial For Creating A Membership Form And Saving Data

Full Excel VBA Course - Beginner to Expert

Moved: Tutorial For Creating A Membership Form And Saving Data	View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=342211.0

Full Excel VBA Course - Beginner to Expert

Moved: Php Membership Registration Form

Similar Tutorials

View Content

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=342885.0

Moved: Membership Site

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=349090.0

Moved: Creating Data From Multiple Rows

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=344772.0

Moved: Any Free Membership Subscription Scripts?

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=321119.0

Creating A Url Based On Form Data

Similar Tutorials

View Content

I have a multi-step form that offers different options of membership to users with the e-mail domain 'vip.co.uk' I finally have it working but have hit a wall with pulling the variables together to form an URL that can be submitted to the payment gateway in the final step. The variables I need to pass are username, password, email, subscription id (a value attached to a radio button in step 2 - not yet built it). I have a JS fiddle at http://jsfiddle.net/zsasvoo4/15/. The final form will be in PHP and I'd prefer to use that language.

Creating Pdf With Php And Saving It On Server

Similar Tutorials

View Content

Is it possible to do this? fpdf just opens a dialog box asking the user to save the pdf instead of saving it on the server.

Also, is it possible to create a pdf from the data in a mysql table with PHP?

Thanks!

Moved: Need A Tutorial

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=308352.0

Moved: Cron Job Tutorial

Similar Tutorials

View Content

This topic has been moved to Linux.

http://www.phpfreaks.com/forums/index.php?topic=334310.0

Moved: Advanced Php Tutorial

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=343600.0

Moved: A Login Tutorial?

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=130332.0

Moved: Curl Tutorial

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=330907.0

Moved: Login Tutorial

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=351363.0

Problem In Saving Data

Similar Tutorials

View Content

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>

<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

Moved: Wall Script Tutorial Help

Similar Tutorials

View Content

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=334229.0

Moved: Web Programming Ebook / Tutorial

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=332907.0

Moved: Php Shopping Cart Tutorial

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=316360.0

Moved: Php Appointment Diary Tutorial

Similar Tutorials

View Content

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=348851.0

Moved: Posting Form Data

Similar Tutorials

View Content

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=346552.0

Saving Read Txtfile Data To Db Help

Similar Tutorials

View Content

hi, i have the class here, and am trying to save the read column of the textfile to db. but unfortunately it's not being save, i don't know what's wrong... I also attached the textfile so you'll have an idea what am i trying to read from

class Extractor
{
  public $filehandler;
  public $data = array();

  // set your db access details
  private $host = HOST;
  private $username = USERNAME;
  private $password = PASSWORD;
  private $dbname = DBNAME;

  public function __construct($file)
  {
    $this->filehandler = $file;
  }

  //prints col1 of textfile
  public function printcol1()
  {
    $fp = fopen($this->filehandler,'r');
    while(($this->data = fgetcsv($fp,1000,",")) !== FALSE)
    {
       # $this->data[0]."<br />";
        $this->savetodb($this->data[0]);
    }
    fclose($fp);
  }

  public function savetodb($data)
  {
    try{
      $pdo = new PDO("mysql:host=$this->host;dbname=$this->dbname",$this->username,$this->password);
      $pdo->exec("INSERT INTO test(col,id) VALUES ({$data},null)");
      $pdo = null;
    }catch(PDOException $e){
      echo $e->getMessage()."<br />";
    }
  }

}

$file = 'iso3166.txt';
$shit = new Extractor($file);
$shit->printcol1();

Saving / Updating Arrayed Data

Similar Tutorials

View Content

Hello all,

I have form that has several fields. Each field will be saved to a table (which is a relations table we will call markups). The form is built from another table which is an array of categories. The output will build a form with each category and allow the end-user to input data for each category. The information the user will be entering is markup values.

Cat1 | Markup Input
Cat2 | Markup Input
Cat3 | Markup Input

I'll be saving the data in their own columns and not as an serialized array to the database. I'm currently looping through the arrayed fields and saving the data to the markup relations table. I've read other forums and serializing the data will be to difficult to retrieve for relationship purposes?? Anyway, here's my question:

Let's say the user is entering the markups for the first time. They go down the list of categories and add their markups for each and click save. Cool, no problem just do an INSERT INTO. Then, they go into the category setup screen and add a category then go back to the markup screen and now have to update the category markup that was just added.

So now I have to do an UPDATE to the current listed markups table (no problem). But now I have to add another row in the same table from that array. Is there a logical way of handling this. I guess I'm looking for some ideas on how to accomplish this task. I hope you guy understand what I'm after here. Thanks for any suggestions on this.