i have a problem with inserting data to database.i have to insert array as well,which is not working.the first query work,but the second query didnt work.the second query should insert array of data.
Code: Select all
<?php
session_start();
// Connects to your Database
mysql_connect("localhost", "ODBC", "") or die(mysql_error());
mysql_select_db("wms") or die(mysql_error());
//checks cookies to make sure they are logged in
if(isset($_COOKIE['ID_my_site']))
{
$username = $_COOKIE['ID_my_site'];
$pass = $_COOKIE['Key_my_site'];
$check = mysql_query("SELECT * FROM users WHERE username = '$username'")or die(mysql_error());
while($info = mysql_fetch_array( $check ))
{
//if the cookie has the wrong password, they are taken to the login page
if ($pass != $info['password'])
{ header("Location:http://localhost/projek/home.php");
}
//otherwise they are shown the user area
else
{
$bilpekerja = isset($_POST[bilorg]) ? $_POST[bilorg] : '';
$jarak = isset($_POST[jarak]) ? $_POST[jarak] : '';
$kondisi = isset($_POST[kondisi]) ? $_POST[kondisi] : '';
$input = isset($_POST[input]) ? $_POST[input] : '';
$jenis = isset($_POST[jenis]) ? $_POST[jenis] : '';
$hayat = isset($_POST[hayat]) ? $_POST[hayat] : '';
$kelas = isset($_POST[kelas]) ? $_POST[kelas] : '';
$aktiviti = isset($_POST[aktiviti]) ? $_POST[aktiviti] : '';
$berat = isset($_POST[berat]) ? $_POST[berat] : '';
$isipadu = isset($_POST[isipadu]) ? $_POST[isipadu] : '';
$rujukan = $_SESSION['rujukan'];
$tarikh = $_SESSION['tarikh'];
$syarikat = $_SESSION['syarikat'];
$jenisp = $_SESSION['jenisp'];
$db=mysql_connect("localhost","ODBC","");
mysql_select_db("wms",$db);
include ("function.inc.php");
include ("pengiraan_pekerja.php");
if(is_array($jenis))
{
$kirahayatvar = kirahayat($_POST['hayat']);
$kiraberatvar = kiraberat($_POST['berat']);
$kiraisipaduvar = kiraisipadu($_POST['isipadu']);
$kelasvar = kelas($_POST['kelas']);
$aktivitivar = aktiviti($_POST['aktiviti']);
foreach($jenis as $key=>$value)
{
$kadarharga[$key] = $kelasvar[$key] * ($kirahayatvar[$key] + $aktivitivar[$key] + $kiraisipaduvar[$key] + $kiraberatvar[$key]);
$s[] = $kadarharga[$key];
$kosPengurusan = array_sum($s);
}
}
if($kondisi =="Y")
$kond = 327 * $input;
else
$kond = 0;
$Kdrpgktn = 1 * $jarak;
//overal calculation
$subjumlah = $kosPengurusan + $Kdrpgktn;
if ($agensi == "A"){
$awam = 0.9 * $subjumlah;
$SubJumlah = $awam;
}
else {
$swasta = 1 * $subjumlah;
$SubJumlah = $swasta;
}
$KosKhidmat = $SubJumlah + $KdrElaun + $kond;
$MarginUntung = 0.2 * $KosKhidmat;
$KosSeluruh = $KosKhidmat + $MarginUntung;
$sql="INSERT INTO borangsrs(no_rujukan, tarikh, nama_syarikat, jenis_perkhidmatan, bil_pekerja, kadar_elaun, kadar_pengangkutan, sub_jumlah, kos_khidmat, margin, kos_seluruh, kondisi) VALUES('$rujukan', '$tarikh', '$syarikat', '$jenisp', '$bilpekerja', '$KdrElaun', '$Kdrpgktn', '$SubJumlah', '$KosKhidmat', '$MarginUntung', '$KosSeluruh', '$kond')";
$result=mysql_query($sql);
//this code not working,the thing is,i have to insert this array at the same place as a above coz they're connected
foreach($jenis as $key=>$value)
{
$q[] = $kadarharga[$key];
$kosPeng = array_sum($q);
$sql="UPDATE borangsrs SET unsur ='$value', hayat ='$hayat[$key]', kelas ='$kelas[$key]', aktiviti = '$aktiviti[$key]',isipadu ='$isipadu[$key]',berat = '$berat[$key]', kadarharga = '$kadarharga[$key]',kospengurusan ='$kosPeng' WHERE no_rujukan ='$rujukan'";
$result=mysql_query($sql);
}
?>