Jump to content

Help Me..Urgent!

tadapapaya

By tadapapaya
in PHP Coding Help

 Share

Recommended Posts

tadapapaya Newbie

tadapapaya

Posted
Posted

i need help for this...

<?php include("validation.php"); ?>
<?php $no_staf = $_COOKIE["no_staf"]?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Script-Type" content="text/javascript">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Permohonan Elaun Perjalanan Kenderaan</title>
<link href="innerstyle.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
#apDiv1 {
position:absolute;
left:542px;
top:350px;
width:555px;
height:31px;
z-index:1;
}
#apDiv2 {
position:absolute;
left:459px;
top:567px;
width:529px;
height:47px;
z-index:2;
}
.style2 {color: #000000}
#apDiv3 {
position:absolute;
left:40px;
top:311px;
width:226px;
height:201px;
z-index:3;
}
#apDiv4 {
position:absolute;
left:324px;
top:272px;
width:77px;
height:24px;
z-index:4;
}
#apDiv5 {
position:absolute;
left:8px;
top:272px;
width:73px;
height:24px;
z-index:5;
}
#apDiv6 {
position:absolute;
left:93px;
top:272px;
width:60px;
height:24px;
z-index:6;
}
#apDiv7 {
position:absolute;
left:166px;
top:272px;
width:149px;
height:24px;
z-index:7;
}
#apDiv8 {
position:absolute;
left:7px;
top:273px;
width:556px;
height:24px;
z-index:8;
}
#apDiv9 {
position:absolute;
left:298px;
top:213px;
width:63px;
height:23px;
z-index:4;
}
#apDiv10 {
position:absolute;
left:655px;
top:564px;
width:188px;
height:18px;
z-index:4;
}
.style3 {color: #000000; font-weight: bold; }
-->
</style>
<script type="text/javascript">

function addRowToTable()
{
  var tbl = document.getElementById('kenderaan');
  var lastRow = tbl.rows.length;
  var iteration = lastRow;
  var row = tbl.insertRow(lastRow);

  var cellRight1 = row.insertCell(0);
  var sel = document.createElement('select');
  sel.name = 'nama_kelas_perjalanan_kenderaan' + iteration;
  sel.options[0] = new Option('Sila Pilih', 'Sila Pilih');
  sel.options[1] = new Option('500 KM Pertama', '500 KM Pertama');
  sel.options[2] = new Option('501 - 1000 KM', '501 - 1000 KM');
  sel.options[3] = new Option('1001 - 1700 KM', '1001 - 1700 KM');
  sel.options[4] = new Option('1701 KM & Seterusnya', '1701 KM & Seterusnya');
  cellRight1.appendChild(sel);

  var cellRight2 = row.insertCell(1);
  var el = document.createElement('input');
  el.type = 'text';
  el.name = 'jarak_perjalanan_kenderaan' + iteration;
  el.id = 'jarak_perjalanan_kenderaan' + iteration;
  el.size = 6;
  cellRight2.appendChild(el);

  var cellRight3 = row.insertCell(2);
  var el1 = document.createElement('input');
  el1.type = 'text';
  el1.name = 'kadar_cas_perjalanan_kenderaan' + iteration;
  el1.id = 'kadar_cas_perjalanan_kenderaan' + iteration;
  el1.size = 6;
  cellRight3.appendChild(el1);

  var cellRight4 = row.insertCell(3);
  var el2 = document.createElement('input');
  el2.type = 'text';
  el2.name = 'jumlah_perjalanan_kenderaan' + iteration;
  el2.id = 'jumlah_perjalanan_kenderaan' + iteration;
  el2.size = 10;
  cellRight4.appendChild(el2);

}
function removeRowFromTable()
{
  var tbl = document.getElementById('kenderaan');
  var lastRow = tbl.rows.length;
  if (lastRow > 2) tbl.deleteRow(lastRow - 1);
}
</script>
<script type="text/javascript">
<!--
function myPopup2() {
window.open( "kadar_perjalanan_kenderaan.php", "myWindow", 
"status = 1, height = 350, width = 550, resizable = 0" )
}
//-->
</script>
<script type='text/javascript'>

function formValidator(){

var nama_kelas_perjalanan_kenderaan = document.getElementById('nama_kelas_perjalanan_kenderaan');
var jarak_perjalanan_kenderaan = document.getElementById('jarak_perjalanan_kenderaan');
var kadar_cas_perjalanan_kenderaan = document.getElementById('kadar_cas_perjalanan_kenderaan');
var jumlah_perjalanan_kenderaan = document.getElementById('jumlah_perjalanan_kenderaan');
var jumlah_kesemua_perjalanan_kenderaan = document.getElementById('jumlah_kesemua_perjalanan_kenderaan');

    if(madeSelection(nama_kelas_perjalanan_kenderaan, "Sila Pilih Jarak Perjalanan")){
if(isNumeric(jarak_perjalanan_kenderaan, "Sila Masukkan Jarak Perjalanan")){
if(isFloat(kadar_cas_perjalanan_kenderaan, "Sila Masukkan Kadar Cas")){
if(isFloat(jumlah_perjalanan_kenderaan, "Sila Masukkan Jumlah")){
if(isFloat(jumlah_kesemua_perjalanan_kenderaan, "Sila Masukkan Jumlah Keseluruhan")){
return true;
}
}
}
}
}
return false;
}

function madeSelection(elem, helperMsg){
if(elem.value == "Sila Pilih"){
	alert(helperMsg);
	elem.focus();
	return false;
}else{
	return true;
}
}

function isNumeric(elem, helperMsg){
var numericExpression = /^[0-9]+$/;
if(elem.value.match(numericExpression)){
	return true;
}else{
	alert(helperMsg);
	elem.focus();
	return false;
}
}

function isFloat(elem, helperMsg){
var float = /^[0-9]+\.[0-9]+$/;
if(elem.value.match(float)){
	return true;
}else{
	alert(helperMsg);
	elem.focus();
	return false;
}
}

</script>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>
<body>
<div id="apDiv1">
<?php
    mysql_connect("localhost");
    mysql_select_db (tuntutan);

    $sambung=mysql_connect("localhost");

    if(!$sambung)
        die("gagal disambungkan".mysql_error());

    $db="tuntutan";

    mysql_select_db($db)
        or die("Gagal sambung ke dbase: $db".mysql_error());

    $query="SELECT * from tuntutan
            WHERE no_staf='$no_staf'";

    $result=mysql_query($query);

    if($myrow=mysql_fetch_array($result)){

            $no_tuntutan                                =$myrow["no_tuntutan"];
    }
?>
<form id="mohon_kenderaan" name="kenderaan" method="post" action="perjalanan_kenderaan_proses.php">

<input type="hidden" name="no_staf" value="<?echo $_COOKIE['no_staf']?>">
<input type="hidden" name="no_tuntutan" value="<?echo $no_tuntutan?>">
  <table border="1" id="kenderaan">
  <tr>
      <td><div align="center"><strong><span class="style2">Pilihan Jarak</span></strong></div></td>
      <td><div align="center"><strong><span class="style2">Jarak</span></strong></div></td>
      <td><div align="center"><strong><span class="style2">Kadar</span></strong></div></td>
      <td><div align="center"><strong><span class="style2">Jumlah</span></strong></div></td>
    </tr>
    <tr>
    <td><select name="nama_kelas_perjalanan_kenderaan" id="nama_kelas_perjalanan_kenderaan">
      <option>Sila Pilih</option>
      <option>500 KM Pertama</option>
      <option>501 - 1000 KM</option>
      <option>1001 - 1700 KM</option>
      <option>1701 KM & Seterusnya</option>
    </select></td>
    <td><input name="jarak_perjalanan_kenderaan" type="text" id="jarak_perjalanan_kenderaan" size="6" maxlength="5"/></td>
    <td><input name="kadar_cas_perjalanan_kenderaan" type="text" id="kadar_cas_perjalanan_kenderaan" size="6" maxlength="5"/></td>
    <td><input name="jumlah_perjalanan_kenderaan" type="text" id="jumlah_perjalanan_kenderaan" size="10" maxlength="6"/></td>
  </tr>
</table>
<div id="apDiv8">
  <input type="submit" name="butang" id="butang" value="Simpan" onclick='return formValidator()' />
  <input type="submit" name="butang" id="butang" value="Simpan & Seterusnya" onclick='return formValidator()' />
  <input type="reset" name="butang" id="butang" value="Kosongkan" />
  <input type="button" name="butang" id="butang" value="Tambah" onclick='addRowToTable();' />
  <input type="button" value="Buang" onclick="removeRowFromTable();" />
  <input type="button" name="butang" id="butang" value="Kadar" onClick="myPopup2()" /> 
</div>
  <div id="apDiv9">
  <label>
  <input type="text" name="jumlah_kesemua_perjalanan_kenderaan" id="jumlah_kesemua_perjalanan_kenderaan" size="10" maxlength="8"/>
  </label>
  </div>
  </form>
</div>
<div id="apDiv3">
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button1','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button1' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button1.swf" />
        <param name="quality" value="high" />
        <embed src="button1.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button2','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button2' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button2.swf" />
        <param name="quality" value="high" />
        <embed src="button2.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button14','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button14' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button14.swf" />
        <param name="quality" value="high" />
        <embed src="button14.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button3','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button3' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button3.swf" />
        <param name="quality" value="high" />
        <embed src="button3.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button12','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','button12' ); //end AC code
    </script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="movie" value="button12.swf" />
        <param name="quality" value="high" />
        <embed src="button12.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button4','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button4' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button4.swf" />
        <param name="quality" value="high" />
        <embed src="button4.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button5','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button5' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button5.swf" />
        <param name="quality" value="high" />
        <embed src="button5.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button6','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button6' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button6.swf" />
        <param name="quality" value="high" />
        <embed src="button6.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button7','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button7' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button7.swf" />
        <param name="quality" value="high" />
        <embed src="button7.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button8','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button8' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button8.swf" />
        <param name="quality" value="high" />
        <embed src="button8.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button9','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button9' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button9.swf" />
        <param name="quality" value="high" />
        <embed src="button9.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button13','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','button13' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="movie" value="button13.swf" />
        <param name="quality" value="high" />
        <embed src="button13.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button11','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button11' ); //end AC code
    </script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button11.swf" />
        <param name="quality" value="high" />
        <embed src="button11.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
  <p>
    <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','265','height','45','src','button10','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','bgcolor','','movie','button10' ); //end AC code
</script>
    <noscript>
      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="265" height="45">
        <param name="BGCOLOR" value="" />
        <param name="movie" value="button10.swf" />
        <param name="quality" value="high" />
        <embed src="button10.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="265" height="45" ></embed>
      </object>
    </noscript>
  </p>
</div>
<div class="style3" id="apDiv10">JUMLAH KESEMUA RM</div>
<div id="header">
<ul class="nav">
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
<a href="halaman_utama.html"><img src="images/logo.gif" alt="efficient" width="390" height="102" border="0" class="logo" /></a>
<ul class="sub">
<li></li>
<li></li>
<li></li>
</ul>
</div>
<!--header end -->
<!--body start -->
<div id="body">
<!--left start -->
<!--left end -->
<!--mid start -->
<!--mid end -->
<!--tight start -->
<div id="right">
  
  <p><br class="spacer" />
    </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p><br class="spacer" />
  </p>
</div>
<div id="left">
  <!--event start -->
  <div id="">
    <p align="center"><br />
        <span class="body1text style2">PERMOHONAN ELAUN PERJALANAN KENDERAAN</span></p>
    <p> </p>
    <p><br class="spacer" />
</p>
  </div>
  
  </div>
<!--tight end -->
<br class="spacer" />
</div>
<!--body end -->
<!--footer start -->
<div id="footerMain">
  <div id="footer">
    <p class="copyright">Copyright © Sistem Tuntutan 2009</p>
    <p class="design"> </p>
    </div>
</div>
<!--footer end -->
</body>
</html>

 

<?php include("validation.php"); ?>
<?php $no_staf = $_COOKIE["no_staf"]?>
<html>
<head>
<title>Perjalanan Kenderaan</title>
</head>
<body>
<script language= "PHP">

if(isset($butang))
{
    if($butang=="Simpan")
        {
            simpandata($no_tuntutan,$no_staf,$nama_kelas_perjalanan_kenderaan,$jarak_perjalanan_kenderaan,$kadar_cas_perjalanan_kenderaan,$jumlah_perjalanan_kenderaan,$jumlah_kesemua_perjalanan_kenderaan);
        }
    else if($butang=="Simpan & Seterusnya")
        {
            simpandata2($no_tuntutan,$no_staf,$nama_kelas_perjalanan_kenderaan,$jarak_perjalanan_kenderaan,$kadar_cas_perjalanan_kenderaan,$jumlah_perjalanan_kenderaan,$jumlah_kesemua_perjalanan_kenderaan);
        }
}


function simpandata2($no_tuntutan,$no_staf,$nama_kelas_perjalanan_kenderaan,$jarak_perjalanan_kenderaan,$kadar_cas_perjalanan_kenderaan,$jumlah_perjalanan_kenderaan,$jumlah_kesemua_perjalanan_kenderaan)
{
        $db="tuntutan";
        $link=mysql_pconnect("localhost");
        if(!$link)
        {
            $dberror="Couldn't connect to mysql";
        }
        if(!mysql_select_db($db,$link))
        {
            $dberror=mysql_error();
        }		
        $query="INSERT INTO perjalanan_kenderaan
(no_tuntutan,no_staf,nama_kelas_perjalanan_kenderaan,jarak_perjalanan_kenderaan,kadar_cas_perjalanan_kenderaan,jumlah_perjalanan_kenderaan,jumlah_kesemua_perjalanan_kenderaan)
VALUES
('$no_tuntutan','$no_staf','$nama_kelas_perjalanan_kenderaan','$jarak_perjalanan_kenderaan','$kadar_cas_perjalanan_kenderaan','$jumlah_perjalanan_kenderaan','$jumlah_kesemua_perjalanan_kenderaan')";
        if (!mysql_query($query,$link))
        {
            $dberror=mysql_error();
            echo "error".$dberror;
        }
        echo "<script>"
                ."alert('Tahniah! Data Anda Telah Berjaya Disimpan!');"
                ."</script>";
	echo"<script>";
        echo "location.href='pengangkutan_awam.php'";
        echo "</script>";
        mysql_close($link);
}
	echo "<script>"
                ."alert('Harap Maaf! Data Anda Tidak Berjaya Disimpan!');"
                ."</script>";
	echo"<script>";
        echo "location.href='lepas_login.php'";

function simpandata($no_tuntutan,$no_staf,$nama_kelas_perjalanan_kenderaan,$jarak_perjalanan_kenderaan,$kadar_cas_perjalanan_kenderaan,$jumlah_perjalanan_kenderaan,$jumlah_kesemua_perjalanan_kenderaan)
{
        $db="tuntutan";
        $link=mysql_pconnect("localhost");
        if(!$link)
        {
            $dberror="Couldn't connect to mysql";
        }
        if(!mysql_select_db($db,$link))
        {
            $dberror=mysql_error();
        }
	for($i=0; $i<count($_POST['jarak_perjalanan_kenderaan']); $i++ ){
        $query="INSERT INTO perjalanan_kenderaan
(no_tuntutan,no_staf,nama_kelas_perjalanan_kenderaan,jarak_perjalanan_kenderaan,kadar_cas_perjalanan_kenderaan,jumlah_perjalanan_kenderaan,jumlah_kesemua_perjalanan_kenderaan)
VALUES
('$no_tuntutan','$no_staf','$nama_kelas_perjalanan_kenderaan','$jarak_perjalanan_kenderaan','$kadar_cas_perjalanan_kenderaan','$jumlah_perjalanan_kenderaan','$jumlah_kesemua_perjalanan_kenderaan')";

        if (!mysql_query($query,$link))
        {
            $dberror=mysql_error();
            echo "error".$dberror;
        }
        echo "<script>"
                ."alert('Tahniah! Data Anda Telah Berjaya Disimpan!');"
                ."</script>";
	echo"<script>";
        echo "location.href='lepas_login.php'";
        echo "</script>";
        mysql_close($link);
}
	echo "<script>"
                ."alert('Harap Maaf! Data Anda Tidak Berjaya Disimpan!');"
                ."</script>";
	echo"<script>";
        echo "location.href='lepas_login.php'";     
}  
</script>
</body>
</html>

 

 

when user click "Tambah", a new row will appear..but,when clicked "Simpan" & "Simpan & Seterusnya", only the first row inserted into database...

Link to comment
https://forums.phpfreaks.com/topic/153670-help-meurgent/
Share on other sites
tadapapaya Newbie

tadapapaya

Posted
  • Author
Posted

okey....this the form,php....

 

<script type="text/javascript">

function addRowToTable()
{
  var tbl = document.getElementById('kenderaan');
  var lastRow = tbl.rows.length;
  var iteration = lastRow;
  var row = tbl.insertRow(lastRow);

  var cellRight1 = row.insertCell(0);
  var sel = document.createElement('select');
  sel.name = 'nama_kelas_perjalanan_kenderaan' + iteration;
  sel.options[0] = new Option('Sila Pilih', 'Sila Pilih');
  sel.options[1] = new Option('500 KM Pertama', '500 KM Pertama');
  sel.options[2] = new Option('501 - 1000 KM', '501 - 1000 KM');
  sel.options[3] = new Option('1001 - 1700 KM', '1001 - 1700 KM');
  sel.options[4] = new Option('1701 KM & Seterusnya', '1701 KM & Seterusnya');
  cellRight1.appendChild(sel);

  var cellRight2 = row.insertCell(1);
  var el = document.createElement('input');
  el.type = 'text';
  el.name = 'jarak_perjalanan_kenderaan' + iteration;
  el.id = 'jarak_perjalanan_kenderaan' + iteration;
  el.size = 6;
  cellRight2.appendChild(el);

  var cellRight3 = row.insertCell(2);
  var el1 = document.createElement('input');
  el1.type = 'text';
  el1.name = 'kadar_cas_perjalanan_kenderaan' + iteration;
  el1.id = 'kadar_cas_perjalanan_kenderaan' + iteration;
  el1.size = 6;
  cellRight3.appendChild(el1);

  var cellRight4 = row.insertCell(3);
  var el2 = document.createElement('input');
  el2.type = 'text';
  el2.name = 'jumlah_perjalanan_kenderaan' + iteration;
  el2.id = 'jumlah_perjalanan_kenderaan' + iteration;
  el2.size = 10;
  cellRight4.appendChild(el2);

}
function removeRowFromTable()
{
  var tbl = document.getElementById('kenderaan');
  var lastRow = tbl.rows.length;
  if (lastRow > 2) tbl.deleteRow(lastRow - 1);
}
</script>
<table border="1" id="kenderaan">
  <tr>
      <td><div align="center"><strong><span class="style2">Pilihan Jarak</span></strong></div></td>
      <td><div align="center"><strong><span class="style2">Jarak</span></strong></div></td>
      <td><div align="center"><strong><span class="style2">Kadar</span></strong></div></td>
      <td><div align="center"><strong><span class="style2">Jumlah</span></strong></div></td>
    </tr>
    <tr>
    <td><select name="nama_kelas_perjalanan_kenderaan" id="nama_kelas_perjalanan_kenderaan">
      <option>Sila Pilih</option>
      <option>500 KM Pertama</option>
      <option>501 - 1000 KM</option>
      <option>1001 - 1700 KM</option>
      <option>1701 KM & Seterusnya</option>
    </select></td>
    <td><input name="jarak_perjalanan_kenderaan" type="text" id="jarak_perjalanan_kenderaan" size="6" maxlength="5"/></td>
    <td><input name="kadar_cas_perjalanan_kenderaan" type="text" id="kadar_cas_perjalanan_kenderaan" size="6" maxlength="5"/></td>
    <td><input name="jumlah_perjalanan_kenderaan" type="text" id="jumlah_perjalanan_kenderaan" size="10" maxlength="6"/></td>
  </tr>
</table>
<input type="button" name="butang" id="butang" value="Tambah" onclick='addRowToTable();' />
  <input type="button" value="Buang" onclick="removeRowFromTable();" />
<input type="submit" name="butang" id="butang" value="Simpan" />

 

this is the mysql...

if(isset($butang))
{
    if($butang=="Simpan")
        {
            simpandata($no_tuntutan,$no_staf,$nama_kelas_perjalanan_kenderaan,$jarak_perjalanan_kenderaan,$kadar_cas_perjalanan_kenderaan,$jumlah_perjalanan_kenderaan,$jumlah_kesemua_perjalanan_kenderaan);
        }
}
function simpandata($no_tuntutan,$no_staf,$nama_kelas_perjalanan_kenderaan,$jarak_perjalanan_kenderaan,$kadar_cas_perjalanan_kenderaan,$jumlah_perjalanan_kenderaan,$jumlah_kesemua_perjalanan_kenderaan)
{
        $db="tuntutan";
        $link=mysql_pconnect("localhost");
        if(!$link)
        {
            $dberror="Couldn't connect to mysql";
        }
        if(!mysql_select_db($db,$link))
        {
            $dberror=mysql_error();
        }
	for($i=0; $i<count($_POST['jarak_perjalanan_kenderaan']); $i++ ){
        $query="INSERT INTO perjalanan_kenderaan
(no_tuntutan,no_staf,nama_kelas_perjalanan_kenderaan,jarak_perjalanan_kenderaan,kadar_cas_perjalanan_kenderaan,jumlah_perjalanan_kenderaan,jumlah_kesemua_perjalanan_kenderaan)
VALUES
('$no_tuntutan','$no_staf','$nama_kelas_perjalanan_kenderaan','$jarak_perjalanan_kenderaan','$kadar_cas_perjalanan_kenderaan','$jumlah_perjalanan_kenderaan','$jumlah_kesemua_perjalanan_kenderaan')";

        if (!mysql_query($query,$link))
        {
            $dberror=mysql_error();
            echo "error".$dberror;
        }
        echo "<script>"
                ."alert('Tahniah! Data Anda Telah Berjaya Disimpan!');"
                ."</script>";
	echo"<script>";
        echo "location.href='lepas_login.php'";
        echo "</script>";
        mysql_close($link);
}
	echo "<script>"
                ."alert('Harap Maaf! Data Anda Tidak Berjaya Disimpan!');"
                ."</script>";
	echo"<script>";
        echo "location.href='lepas_login.php'";     
} 

 

when user click "Tambah" it add a new row..

user enter all the value...

when user click "Simpan", in database,it only save the first row of data...

and what i need is, if the user have 3 rows of data, it all will inserted into database..

not only the first row...

sorry for my broken english..

 

Link to comment
https://forums.phpfreaks.com/topic/153670-help-meurgent/#findComment-807590
Share on other sites
jackpf Member

jackpf

Posted
Posted

You could try putting [] on the end of the input name. That way PHP puts it into an array when posting it.

 

Eg

<?php
//form
echo '<input type="text" name="name[]" />';

//PHP processing

$post = $_POST['name'];
foreach($post as $key => $value)
{
mysql_query(...put your query here
}
?>

 

Hope that works.

Link to comment
https://forums.phpfreaks.com/topic/153670-help-meurgent/#findComment-807600
Share on other sites
tadapapaya Newbie

tadapapaya

Posted
  • Author
Posted

it does not work...

this is the result...

Array

(

    [no_staf] => udm/01/001

    [no_tuntutan] => 4

    [nama_kelas_perjalanan_kenderaan] => Array

        (

            [0] => 500 KM Pertama

        )

 

    [jarak_perjalanan_kenderaan] => Array

        (

            [0] => 121

        )

 

    [kadar_cas_perjalanan_kenderaan] => Array

        (

            [0] => 12.00

        )

 

    [jumlah_perjalanan_kenderaan] => Array

        (

            [0] => 12.00

        )

 

    [nama_kelas_perjalanan_kenderaan2] => 501 - 1000 KM

    [jarak_perjalanan_kenderaan2] => 121

    [kadar_cas_perjalanan_kenderaan2] => 12.00

    [jumlah_perjalanan_kenderaan2] => 12.00

    [nama_kelas_perjalanan_kenderaan3] => 1001 - 1700 KM

    [jarak_perjalanan_kenderaan3] => 12

    [kadar_cas_perjalanan_kenderaan3] => 12.00

    [jumlah_perjalanan_kenderaan3] => 12.00

    [butang] => Simpan

    [jumlah_kesemua_perjalanan_kenderaan] => 12.00

)

1

 

 

Link to comment
https://forums.phpfreaks.com/topic/153670-help-meurgent/#findComment-807613
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.