Learn VBA & Macros in 1 Week!

PHP - Saving / Updating Arrayed Data

Full Excel VBA Course - Beginner to Expert

Saving / Updating Arrayed Data	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.

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Much Needed Help With Arrayed Data

Problem In Saving Data

Last Step, Updating Data In Table...passing Data

Saving Read Txtfile Data To Db Help

Saving Data From All Text Boxes In One Click

Problem In Saving Data From While Loop And Select Option

Moved: Tutorial For Creating A Membership Form And Saving Data

Updating The Looped Data

Delay Before Updating Data

Updating Data In Two Tables At Once

Updating Data From Dynamic Rows...

Editing/updating Data (php & Mysql)

Problem In Updating Data In To The Database +php

Need Help Updating Data In Mysql Database From Php Page

Updating Data Not Populating From Database On To Form

Pulling And Updating Data From A Seperate Db Table

Error Occurs While Updating Data In Mysql Using Csv File

Post Data Updating Mysql Tables With One-to-many Relationship

Saving As A .xml

Learn VBA & Macros for Excel in 1 Week!

Arrayed Data

Similar Tutorials

Hello all,

Okay, I have one for ya. I have the following arrayed data:

Code: [Select]
<?php

$fetch = mysql_query("SELECT * FROM plist WHERE item_num REGEXP '^$param' LIMIT 5");

/* Retrieve and store in array the results of the query.*/

while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {

$row_array['euc']         = $row['euc'];
$row_array['value'] = $row['item_num'];
$row_array['item_disc'] = ucfirst(strtolower($row['item_disc_1']));
$row_array['item_cost'] = $row['price'];

        array_push($return_arr,$row_array);
    }

?>

I can get the data I'm after just fine in the above array. However, I want to go a step further and get some more data from another table in the same database. The data in the second table is serialized and relates to the data in the first table which is NOT serialized. The data in the first array has a id that relates to both tables (euc).

I can't seem to figure out how to fetch the data from the second table that has the serialized data in it. So I can output the related data from both tables for each row fetched.

I understand that UNION or JOIN might work but since the data in the second table is serialized I'm not sure those methods will work. Any ideas how I can make this work? Thanks for any help on this one guys!!

Much Needed Help With Arrayed Data

Similar Tutorials

Problem In Saving Data

Similar Tutorials

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

Last Step, Updating Data In Table...passing Data

Similar Tutorials

I can add and delete data from my table. Now I need to be able to change one or more fields in an entry. So I want to retrieve a row from the db, display that data on a form where the user can change any field and then pass the changed data to an update.php program.

I know how to go from form to php. But how do I pass the data from retrieve.php to a form so it will display? Do I use a URL and Get? Can I put the retrieve and form in the same program?

Saving Read Txtfile Data To Db Help

Similar Tutorials

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 Data From All Text Boxes In One Click

Similar Tutorials

Hi All, this is my first post after joining the forum. First of all, I am not a programmer. My field is of Building design and Architecture. I work for an Architectural company. I have a great interest in programming and I started learning php, mysql, html css and jscript, to develop a timesheet application for the company. The web application was created and successully implemented in April this year...! However, all these are purely 'self learning', and it has its own downsides as well. This was just a small intro..., let me come to what i request help on. This is for further development of the application. I have a page to edit the 'utilization' rate of each employee, based on their designations. So the page has all the designations listed as <labels>, next to which a textbox, for the user to fill in the utilization rate. Scenario is that the user will not save each designation's utilization rate immediately after filling it. User will keep going till he fills the last item and then hit the submit button to save. Now, in php I can get all the values from the Request Array. But, how will I know which designations these values belong to? So, what i have as a solution is to name the textboxes with the designation_ids as suffix. May be like; utilTextbox_1, utilTextbox_2, utilTextbox_3 etc... Then when the form is submitted; Check each Request Array element to see if its name starts with 'utilTextbox' If Yes, split it using '_' to get the designation_id Update the db table with the value of the text box Check the next Array Element.....and so on... is this the correct method or is there a better way of doing this?

Problem In Saving Data From While Loop And Select Option

Similar Tutorials

Hi..

I need to save data from a while loop and data from select option, Now I encountered that using my query I only save is the last part of my while loop and also the data that I choose in select option did not save.

here is my code:

Code: [Select]
<?php
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date =date('Y-m-d H:i:s');

$sr_date = $_POST['sr_date'];
$sr_number = $_POST['sr_number'];
$Items = $_POST['Items'];
$SubItems = $_POST['SubItems'];
$ItemCode = $_POST['ItemCode'];
$DemandedQty = $_POST['DemandedQty'];
$UoM = $_POST['UoM'];
$Class = $_POST['Class'];
$Description = $_POST['Description'];
$BINLocation = $_POST['BINLocation'];
$RequestedBy = $_POST['RequestedBy'];
$ApprovedBy = $_POST['ApprovedBy'];
$ReceivedBy = $_POST['ReceivedBy'];
$IssuedBy = $_POST['IssuedBy'];

$sql = "INSERT INTO stock_requisition
(sr_date, sr_number, Items, SubItems, ItemCode, DemandedQty, UoM, Class, Description, BINLocation, RequestedBy,
ApprovedBy, ReceivedBy, IssuedBy)
VALUES
('$sr_date', '$sr_number', '$Items', '$SubItems', '$ItemCode', '$DemandedQty', '$UoM', '$Class', '$Description',
'$BINLocation', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy')
ON DUPLICATE KEY UPDATE
sr_date = '$sr_date', sr_number = '$sr_number', Items = '$Items', SubItems = '$SubItems', ItemCode = '$ItemCode', DemandedQty = '$DemandedQty',
UoM = '$UoM', Class = '$Class', Description = '$Description', BINLocation = '$BINLocation', RequestedBy = '$RequestedBy',
ApprovedBy = '$ApprovedBy', ReceivedBy = '$ReceivedBy', IssuedBy = '$IssuedBy'";

$result = mysql_query($sql, $con);

        $sql = "SELECT sr_number FROM stock_requisition ORDER BY sr_date DESC LIMIT 1";
        $result = mysql_query($sql, $con);

        if (!$result) {
            echo 'failed';
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
        }
        else {
//------------------------------------------------------------------------------------------------------------------
            // Stock Number iteration....
            $row = mysql_fetch_assoc($result);

            $currentSRNum = (int)(substr($row['sr_number'],0,3));

            $currentSRYear  = (int)(substr($row['sr_number'],2,2));
            $currentSRMonth = (int)(substr($row['sr_number'],0,2));
            $currentSRNum = (int)(substr($row['sr_number'],6,4));

            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD)
            {
                $currentSRNum = 1;
            }
            else
            {
                $currentSRNum += 1;
            }
        }
//------------------------------------------------------------------------------------------------------------------
        $yearMonth = date('ymd');
        $currentSR = $currentYMD . sprintf("%04d", $currentSRNum);
?>
<html>
<title>Stock Requisition</title>
<head>
<style type="text/css">
#ddcolortabs{
margin-left: 2px;
padding: 0;
width: 100%;
background: transparent;
voice-family: "\"}\"";
voice-family: inherit;
padding-left: 2px;
}

#ddcolortabs ul{
font: bold 12px Arial, Verdana, sans-serif;
margin:0;
padding:0;
list-style:none;
}

#ddcolortabs li{
display:inline;
margin:0 2px 0 0;
padding:0;
text-transform:uppercase;
}

#ddcolortabs a{
float:left;
color: white;
background: #8cb85c url(layout_image/color_tabs_left.gif) no-repeat left top;
margin:2px 2px 0 0;
padding:0px 0 1px 3px;
text-decoration:none;
letter-spacing: 1px;
}

#ddcolortabs a span{
float:right;
display:block;
/*background: transparent url(layout_image/color_tabs_right.gif) no-repeat right top;*/
padding:6px 9px 2px 6px;
}

#ddcolortabs a span{
float:none;
}

#ddcolortabs a:hover{
background-color: #678b3f;
}

#ddcolortabs a:hover span{
background-color: #678b3f ;
}

#ddcolortabs #current a, #ddcolortabs #current span{ /*currently selected tab*/
background-color: #678b3f;
}
</style>
<style type="text/css">
#ddcolortabs1{
position: relative;
top: 10px;
margin-left: 2px;
padding: 0;
width: 100%;
background: transparent;
voice-family: "\"}\"";
voice-family: inherit;
padding-left: 2px;
}

#ddcolortabs1 ul{
font: bold 12px Arial, Verdana, sans-serif;
margin:0;
padding:0;
list-style:none;
}

#ddcolortabs1 li{
display:inline;
margin:0 2px 0 0;
padding:0;
text-transform:uppercase;
}

#ddcolortabs1 a{
float:left;
color: white;
background: #8cb85c url(layout_image/color_tabs_left.gif) no-repeat left top;
margin:2px 2px 0 0;
padding:0px 0 1px 3px;
text-decoration:none;
letter-spacing: 1px;
}

#ddcolortabs1 a span{
float:right;
display:block;
/*background: transparent url(layout_image/color_tabs_right.gif) no-repeat right top;*/
padding:6px 9px 2px 6px;
}

#ddcolortabs1 a span{
float:none;
}

#ddcolortabs1 a:hover{
background-color: #678b3f;
}

#ddcolortabs1 a:hover span{
background-color: #678b3f ;
}

#ddcolortabs1 #current a, #ddcolortabs1 #current span{ /*currently selected tab*/
background-color: #678b3f;
}
</style>

<style>
#SR_date{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .9em;
margin-left: 10px;
width: auto;
height: auto;
float: left;
top : 10px;

}
#SR_number{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .9em;
margin-left: 270px;
width: auto;
height: auto;
float: left;
top : 10px;

}
table {
margin: 10px;
font-family: Arial, Helvetica, sans-serif;
font-size: .9em;
border: 1px solid #DDD;
width: auto;
}

th {
font-family: Arial, Helvetica, sans-serif;
font-size: .7em;
background: #694;
color: #FFF;
padding: 2px 6px;
border-collapse: separate;
border: 1px solid #000;
}

td {
font-family: Arial, Helvetica, sans-serif;
font-size: .7em;
border: 1px solid #DDD;
text-align: left;
}

#RequestedBy{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .8em;
margin-left: 10px;
width: auto;
height: auto;
float: left;
top : 10px;
}

#ApprovedBy{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .8em;
margin-left: 15px;
width: auto;
height: auto;
float: left;
top : 10px;
}

#ReceivedBy{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .8em;
margin-left: 15px;
width: auto;
height: auto;
float: left;
top : 10px;
}
#IssuedBy{
position: relative;
font-family: Arial, Helvetica, sans-serif;
font-size: .8em;
margin-left: 15px;
width: auto;
height: auto;
float: left;
top : 10px;
margin-right: 120px;
}
#save_btn{
position: relative;;
font-family: Arial, Helvetica, sans-serif;
font-size: .8em;
margin-left: 10px;
top: 10px;
}
</style>

<script type="text/javascript">
function save_sr(){
var sr_date = document.getElementById("sr_date").value;
var sr_number = document.getElementById("sr_number").value;
var Items = document.getElementById("Items").value;
var SubItems = document.getElementById("SubItems").value;
var ItemCode = document.getElementById("ItemCode").value;
var DemandedQty = document.getElementById("DemandedQty").value;
var UoM = document.getElementById("UoM").value;
var Class = document.getElementById("Class").value;
var Description = document.getElementById("Description").value;
var BINLocation = document.getElementById("BINLocation").value;
var RequestedBy = document.getElementById("RequestedBy").value;
var ApprovedBy = document.getElementById("ApprovedBy").value;
var ReceivedBy = document.getElementById("ReceivedBy").value;
var IssuedBy = document.getElementById("IssuedBy").value;

document.stock_requisition.action="StockRequisitionSave.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items="+Items+
"&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
"&IssuedBy="+IssuedBy;
document.stock_requisition.submit();

alert("Stock Requisition data save.");
window.location = "StockRequisition.php";

}
</script>
</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<div id="ddcolortabs">
<ul>
<li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>
<li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li>
<li id="current"><a href="StockRequisition.php" title="WMS RM"><span>WMS RM</span></a></li>
</ul>
</div>

<div id="ddcolortabs1">
<ul>
<li><a href="ReceivingMaterials.php" title="Receiving Materials"><span>Receiving Materials</span></a></li>
<li><a href="Shelving.php" title="Shelving"><span>Shelving</span></a></li>
<li id="current"><a href="StockRequisition.php" title="Stock Requisition"><span>Stock Requisition</span></a></li>
</ul>
</div>

<div id="SR_date">
<label>Date :</label>
<input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly" style="border: none;">
</div>
<div id="SR_number">
<label>SR# :</label>
<input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="10" readonly="readonly" style="font-weight: bold; border: none;">
<br/>
</div>
<div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php

$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_bom)){

    $Items = $row['Items'];
echo "<tr>
        <td style='border: none;font-weight: bold;'> <input type='name' value='$row[Items]' name='Items' id='Items' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='5'></td>
        </tr>";

$sql = "SELECT SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$row[Items]' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);
while($row_sub = mysql_fetch_assoc($res_sub)){

    echo "<tr>
        <td style='border: none;'> </td>
        <td style='border: none;'> <input type='text' name='SubItems' value='$row_sub[SubItems]' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'> <input type='text' name='ItemCode' value='$row_sub[ItemCode]' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'><center><input type='text' name='DemandedQty' id='DemandedQty' value='' size='7'></center></td>
        <td style='border: none;' size='3'> <input type='text' name='UoM' value='$row_sub[UoM]' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'> <input type='text' name='Class' value='$row_sub[Class]' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'> <input type='text' name='Description' value='$row_sub[Description]' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'> <input type='text' name='BINLocation' value='$row_sub[BINLocation]' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        </tr>";
}
}

?>
</table>
</div>

<div id='RequestedBy'>
<label>Requested By:</label>
<select name="Requested_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBBB'>BBBBBBBBB</option>
<option name='CCCCCCCCCC'>CCCCCCCCCC</option>
</select>
</div>

<div id='ApprovedBy'>
<label>Approved By:</label>
<select name="Approved_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBBB'>BBBBBBBBB</option>
<option name='CCCCCCCCCC'>CCCCCCCCCC</option>
</select>
</div>

<div id='ReceivedBy'>
<label>Received By:</label>
<select name="Received_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBB'>BBBBBBBB</option>
<option name='CCCCCCCC'>CCCCCCCC</option>
</select>
</div>

<div id='IssuedBy'>
<label>Issued By:</label>
<select name="Issued BY">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBB'>BBBBBBBB</option>
<option name='CCCCCCCC'>CCCCCCCC</option>
</select>
</div>

<div id="save_btn">
<input type="button" name="button" value="save" onclick="save_sr()">
</div>
</body>
</html>

I also I attach the display data.

Thank you

Moved: Tutorial For Creating A Membership Form And Saving Data

Similar Tutorials

This topic has been moved to Miscellaneous.

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

Updating The Looped Data

Similar Tutorials

Hi,

I want to loop out data from DB in <input> and change and update several posts at the same time.
Can you give me a short example, how <input> and maybe foreach could look like?

Thanks

Delay Before Updating Data

Similar Tutorials

I am working on a php project in which players can equipt items from there inventory and it shows them there current stats. When players have decided to equipt an item they hit the submit button and the new stats should show. The issue I have is that the data is delaying in update such as:

we have 10 strength
we equipt a sword with +2 to strength and click submit
it displays we have 10 strength
we equipt a axe with +3 to strength and click submit
it displays 12 strength
we equipt a sword with +2 to strength and click submit
it displays 13 strength
we equipt a sword with +2 to strength and click submit
it displays 12 strength
....

my code is represented below

<?php
updateEquiptment();
require("playerInfo.php");
?>
<p title="This stat increases how hard you hit with weapons!">Strength:<?php echo $baseStrength + getModStrength() ?> </p>

the functions updateEquiptment and getModStrength are in the playerInfo.php file and are shown like this:

$user = $_SESSION['username'];
$result = mysql_fetch_row(mysql_query("SELECT equiptment FROM warUsers WHERE name = '$user'"));
$equiptment = explode(",",$result[0]);
function updateEquiptment()
{
global $user;
$result = mysql_fetch_row(mysql_query("SELECT equiptment FROM warUsers WHERE name = '$user'")) or die(mysql_error());
global $equiptment;
$equiptment = explode(",",$result[0]);
}

//get there modified stats
function getModStrength()
{
$total = 0;
global $equiptment;
foreach ($equiptment as $value) //loop through every item in the equiptment
{
if($value == 0 || $value == null) //if nothing is equipt go to the next loop
continue;

$result = mysql_query("SELECT * FROM items WHERE id = '$value'");
$item = mysql_fetch_row($result);
$total += $item[4]; //get the items strength and add it to the total
}
return $total;
}

any help on the matter would be greatly appreciated

Updating Data In Two Tables At Once

Similar Tutorials

Ok, so I'm not quite sure how to explain this, but here it goes:

I have table A that contains stats for all players in the NHL, and then I have table B with just a few players. These few players in table B are also in table A, but table B has more information on them. I want to take the stats for these players out of table A and put into table B, and I want table B to update along with table A every time those numbers change. How would I do this?

Updating Data From Dynamic Rows...

Similar Tutorials

Hey guys,

I got another one that i could use some help on. I have a input form that utilizes a javascript that adds additional rows to my table. here is a look at what i got.

Code: [Select]
<script type="text/javascript">
function insertRow()
{
var x = document.getElementById('results_table').insertRow(-1);
var a = x.insertCell(0);
var b = x.insertCell(1);
var c = x.insertCell(2);
var d = x.insertCell(3);
var e = x.insertCell(4);

a.innerHTML="<input type=\"text\" name=\"id\">";
b.innerHTML="<input type=\"text\" name=\"place\">";
c.innerHTML="<input type=\"text\" name=\"username\">";
d.innerHTML="<input type=\"text\" name=\"earnings\">";
e.innerHTML="<input type=\"button\" value=\"delete\" onClick=\"deleteRow(this)\">";
}

function deleteRow(r)
{
var i=r.parentNode.parentNode.rowIndex;
document.getElementById('results_table').deleteRow(i);
}

</script>
this is my code stored in the header of my page. basically just a button to add a new row and a button in each row to delete rows if needed.

here is a look at my html table, pretty basic...

Code: [Select]
<table id="results_table">

<th>Event ID</th><th>Place</th><th>Username</th><th>Earnings</th>

<tr>
<td><input type="text" name="id"></td><td><input type="text" name="place"></td><td><input type="text" name="username"></td><td><input type="text" name="earnings"></td><td><input type="button" value="delete" onClick="deleteRow(this)"</td>
</tr>

</table>
Now what I am hoping to acheive is once i submit all of these rows to the database i will insert each of these rows into their own row in the database. is this doable?

the structure of my database is:

ResultID (Primary Key)
Place
Earnings
UserID (Foreign Key)
EventID (Foreign Key)

now i think the biggest problem i'm having with submitting data to the database is that in the original HTML form I am typing in the actual username and not the userID.

so when it comes to processing I need to do a switch of these two things before I run my query. Should something like this work?

Code: [Select]

$username = $_POST['username'];

$userID = "SELECT userID FROM users WHERE username="$username";

$query = mysql_query($userID);

also i've never tried to submit multiple entries at a time. maybe i have to create an array somehow in order to capture each rows data. any thoughts?

as always thanks for the help.

Editing/updating Data (php & Mysql)

Similar Tutorials

Hello folks,
I can not seem to find out why this code is not being executed properly. Basically, I'd like to edit Records, so I am using forms to retrieve data, make modifications then save them.

Code: [Select]
<?php
//connection to db

$results = mysql_query("SELECT * FROM crud WHERE id=".$_GET[id]."") or die (mysql_error());
$row = mysql_fetch_assoc($results);
echo "<form action=\"\" method=\"POST\">";
echo "Year: <input type=\"text\" value=".$row['car_year']." name=\"car_year\" /> <br />";
echo "Make: <input type=\"text\" value=".$row['car_make']." name=\"car_make\" /> <br />";
echo "Model: <input type=\"text\" value=".$row['car_model']." name=\"car_model\" /><br /><br />";
echo "Description:<br /><textarea rows=\"15\" cols=\"60\" name=\"description\" />". $row['description']. "</textarea>";
echo "<br /><input type=\"submit\" value=\"save\">";
echo "</form>";

if ($_POST['save']) {
    $car_year = $_POST['car_year'];
    $car_make = $_POST['car_make'];
    $car_model = $_POST['car_model'];
    $description = $_POST['description'];

// Update data
    $update = mysql_query("UPDATE crud SET car_year='$car_year', car_make='$car_make' car_model='$car_model', description='$description' WHERE id=".$_GET['id']."") or die (mysql_error());
echo 'Update successfull';
}

?>

Please HELP!!!!

Problem In Updating Data In To The Database +php

Similar Tutorials

hi,

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Sahansevena_ver1\admin\profile\updAdmiInfo.php on line 49

i got this error.

here is the coding
Code: [Select]
<?php
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
$dbuser="root";
    $dbpswd="****";
    $dbserver="localhost";

$nwuser=$_POST['username'];
$c_pw=$_POST['cur_password'];
$n_pw=$_POST['conf_password'];
//$user=$userName;
//$pass=$password;
//

$dbname="sahansevena";

if($_SERVER['REQUEST_METHOD']=='POST'){

    //get username and password from admin login.php

$con=mysql_connect($dbserver,$dbuser,$dbpswd);

    if(!$con){
        die('coudnt connect db connection prob'.mysql_error());
    }else{
        if($c_pw==$n_pw){

            $uname=mysql_real_escape_string($username);
            $pword=mysql_real_escape_string($n_pw);
           // setDatabase($dbname, $con) ;
           mysql_select_db($dbname, $con);
            //  $result="update admin set username='$uname',password='$pword'" where limit 0;
            $result="update admin set username='$uname' , password='$pword', last_logged_date =CURDATE(), last_log_time=CURTIME() where username='$uname' limit 0";

            //Checked to see if any rows were returned from the database
            // If rows were returned, set a session variable to 1
            $result=mysql_query($result);

            if ($result) {
                $numRow=mysql_numrows($result);
                if($numRow>0){
                    //session_start();

                   //SESSION['admin']="menuka";

echo "data was suaccesfully updated";
                   /// header ("Location:config/menu.php");

                    //mysql_close($con);
                }else{
                    //session_start();
echo " problem in updating ";
                    //$_SESSION['login'] = "";
                    //header ("Location:login.php");

                }

            }
            else {
                trigger_error(mysql_error(), E_USER_ERROR);
            }

        }

    }

}else{
    echo 'error message not post methode';
    include(login.php);
}

?>

please check my code and help me to figur out the error
thanks in advance,
menukadevinda

Need Help Updating Data In Mysql Database From Php Page

Similar Tutorials

I used to be good at this but I changed servers and everything is different... Heres my code so far:

Code: [Select]
<?php
$rated=$_REQUEST['rated'];
echo $rated;
$rating=$_REQUEST['rating'];
echo $rating;

// Make a MySQL Connection
mysql_connect("localhost", "********", "********") or die(mysql_error());
mysql_select_db("*********") or die(mysql_error());

$result = mysql_query("SELECT * FROM main WHERE username = '$rated'")
or die(mysql_error());

$row = mysql_fetch_array( $result );

$votes = $db_field['$rating'];
$newvotes = $votes + 1;

echo $newvotes;

mysql_query("UPDATE main SET $rating = '$newvotes'
WHERE username = '$rated'");

?>
Whats going on here is the colomb that I want to update comes as a variable $rated (That works) and then the database selects the row to update with $username (That works) and gets the variable $newvotes by taking the original value of the data its about to update and add 1 to it (That works) Then it updates the field to $newvotes....

I don't know why the update won't go through... there are no errors....

Updating Data Not Populating From Database On To Form

Similar Tutorials

Hi I making some forms that write to mysql database, Im now in the process of making the update form so the user can update there details on the form, I want it to populate the form with existing data but its not doing it at all. Thanks in advance Attached Files delete.php 210bytes 2 downloads modify.php 4.03KB 4 downloads index.php 473bytes 3 downloads

Pulling And Updating Data From A Seperate Db Table

Similar Tutorials

Hello:

I have a DB table with this structu
Code: [Select]
CREATE TABLE `gallery_category` (
`category_id` bigint(20) unsigned NOT NULL auto_increment,
`category_name` varchar(50) NOT NULL default '0',
PRIMARY KEY (`category_id`),
KEY `category_id` (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

What I am trying to do id pull this data into my "Edit Product" page and populate a SELECT menu with it.

I want the user to be able to re-assign a product to a new category if they chose to do so.

I want to add the data (and update the DB) to this area:
Code: [Select]
<div style="float: left; width: 550px;">
<select name='category_name'>
<option></option>
</select>

</div>

This is the full page code that allows users to update product info:
Code: [Select]
<?php

include('../include/myConn.php');
include('../include/myCodeLib.php');
include('include/myCheckLogin.php');
include('include/myAdminNav.php');
include('ckfinder/ckfinder.php');
include('ckeditor/ckeditor.php');

$photo_id = $_REQUEST['photo_id'];

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
$photo_title = mysql_real_escape_string($_POST['photo_title']);
$photo_price = mysql_real_escape_string($_POST['photo_price']);
$photo_caption = mysql_real_escape_string($_POST['photo_caption']);

$sql = "

UPDATE gallery_photos
   SET
      photo_title = '$photo_title',
      photo_price = '$photo_price',
      photo_caption = '$photo_caption'
  WHERE photo_id = $photo_id
  ";

mysql_query($sql) && mysql_affected_rows()

?>
<?php
}

$query=mysql_query("SELECT photo_title,photo_price,photo_caption FROM gallery_photos") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))
{
  $photo_title=$result['photo_title'];
  $photo_price=$result['photo_price'];
  $photo_caption=$result['photo_caption'];
}
?>

<!DOCTYPE HTML>

<html>
<head>

</head>

<body>

<div id="siteContainer">

<p>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST')
echo "<span class=\"textError\">". $photo_title ." successfully updated!</span>"
?>
</p>

<p>

<form method="post" action="<?php echo $PHP_SELF;?>">
<input type="hidden" name="POSTBACK" value="EDIT">
<input type='hidden' name='photo_id' value='<?php echo $photo_id; ?>' />

<div style="float: left; width: 120px; margin-right: 30px;">
Category:
</div>

<div style="float: left; width: 550px;">
<select name='category_name'>
<option></option>
</select>

</div>

<div style="float: left; width: 120px; margin-right: 30px;">
Title:
</div>

<div style="float: left; width: 550px;">
<input type="text" name="photo_title" size="45" maxlength="200" value="<?php echo $photo_title; ?>" />
</div>

<div style="clear: both;"><br /></div>

<div style="float: left; width: 120px; margin-right: 30px;">
Price:
</div>

<div style="float: left; width: 550px;">
<input type="text" name="photo_price" size="45" maxlength="200" value="<?php echo $photo_price; ?>" />
</div>

<div style="clear: both;"><br /></div>

Description:<br />
<textarea cols="107" rows="1" name="photo_caption"><?php echo $photo_caption; ?></textarea>

<div style="clear: both;"><br /></div>

<br />

<input type="submit" value="Submit" />

</form>

</p>

</div>

</body>

</html>

How can I do this? I'm stumped ...

Thanks!

Error Occurs While Updating Data In Mysql Using Csv File

Similar Tutorials

I need help here. I am creating a system where the user will be able to update the product stock by uploading the stock of the products according to the id that has been assigned to the product.
this is how my products table in looks like in mysql database

I tried the code below but all i could not update my data into my database. And there's not error shown on my code. I do not know what is wrong with my codes. Please help me.
below the code that i use for uploading the CSV file to the data of my product_stock.

<?php 
include 'conn.php';
if(isset($_POST["add_stock"]))
{
 if($_FILES['product_file']['tmp_name'])
 {
  $filename = explode(".", $_FILES['product_file']['tmp_name']);
  if(end($filename) == "csv")
  {
   $handle = fopen($_FILES['product_file']['tmp_name'], "r");
   while($data = fgetcsv($handle))
   {
    $product_id = mysqli_real_escape_string($conn, $data[0]);
    $product_stock = mysqli_real_escape_string($conn, $data[1]);  
    $product_status = 1 ;
    $query = "UPDATE products SET `product_stock` = '$product_stock', `product_status` = '$product_status' WHERE id = '$product_id'";
    mysqli_query($conn, $query);
   }
   fclose($handle);
   header("location: upload-product.php?updation=1");
  }
  else
  {
   echo '<script>alert("An error occur while uploading product. Please try again.")
   window.location.href = "upload-product.php"</script>';
  }
 }
 else
 {
  echo '<script>alert("No file selected! ")
  window.location.href = "upload-product.php"</script>';
 }
}
if(isset($_GET["updation"]))
{
  echo '<script>alert("Product Stock Updated successfully!")</script>';
}
?>

 <div class="col-12">
            <div class="card card-user">
              <div class="card-header">
                <h5 class="card-title">Update Product Stock</h5>
                <div class="card-body">
                <div class="form-group">
				<label for="file">Update Products stock File (.csv file)</label>
                <a href="assets/templates/product-template.xlsx" title="Download Sample File (Fill In Information and Export As CSV File)" class="mx-2">
				<span class="iconify" data-icon="fa-solid:download" data-inline="false">
				</a>
                </div>
                <form class = "form" action="" method="post" name="uploadCsv" enctype="multipart/form-data">
                <div>
                <input type="file" name="product_file" accept=".csv">
                <div class="row">
                <div class="update ml-auto mr-auto">
                <button type="submit" class="btn btn-primary btn-round" name="add_stock"> Import .cvs file</button>
                </div>
                </div>
                </div>
                </div>
                </form>
                </div>
              </div>

This is the template that i require user to key in and saved it in CSV format before uploading it.

Post Data Updating Mysql Tables With One-to-many Relationship

Similar Tutorials

Hi all

I have 3 tables
Table_1, Table_2 and Table_3

Table_1 is a list of countries, with name and country_id
Table_2 is a table that has 3 fields, id, name and description
Table 3 is a table that has name, Table_2_id

So what I need to do:
Display the name and description field of Table_2 in a form
Loop through the countries table and display each as an input box and display on the same form
When I fill out the form details, the name/description must be inserted into Table_2, creating an id
The input boxes data then also needs inserting into Table_3, with the foreign key of Table_2_id

So a small example would be:
Name: testing
Description: this is a test
Country of Australia: Hello
Country of Zimbabwe: Welcome

This means that in Table_2, I will have the following:
=============================
| id | name | description
| 1 | testing | this is a test
=============================

Table_3
=============================
| Table_2_id | name | country_id
| 1 | Hello | 20
| 1 | Welcome | 17
=============================

20 is the country_id of Australia
17 is the country_id of Zimbabwe

Code:

Generating the input fields dynamically:

                           $site_id = $this->settings['site_id'];

                           $options = '';
                           $country_code = '';
   $query = $DB->query("SELECT country_code, country_id, IF(country_code = '".$country_code."', '', '') AS sel FROM Table_1 WHERE site_id='".$this->settings['site_id']."' ORDER BY country_name ASC");

                               foreach ($query->result as $row)
                               {
                                        $options .= '<label>' . 'Test for ' . $this->settings['countries'][$row['country_code']] . '</label>' . '<br />';
                                        //$row['country_id'] is the country_id from Table_1
                                        $options .= '<input style="width: 100%; height: 5%;" id="country_data" type="text"  name="' . $row['country_id'] . '"  value="GET_VALUE_FROM_DB" />' . '<br /><br />';
                               }
                              echo $options;

This outputs:
Code: [Select]
Textareas go here......
<label>Test for Australia</label>
<input type="text" value="" name="20" id="country_data" style="width: 100%; height: 5%;">
<label>Test for Zimbabwe</label>
<input type="text" value="" name="17" id="country_data" style="width: 100%; height: 5%;">

Now, I need to insert the value of the input field and it's country_id (20 or 17) into Table_3 and also Table_2_id.
This then means I could get the value from Table_3 to populate 'GET_VALUE_FROM_DB'

But I'm at a loss on how I'd do this.

Could someone help me with this?

Thanks

Saving As A .xml

Similar Tutorials

I have a .php code that gets data from a database and saves it in a variables as xml. However how can I then save all of the data in this variable as a .xml file somewhere?

Thanks for any help.