insert many data with same name in one form

Question

erza26 0 Newbie Poster

13 Years Ago

can somebody check my code...i really don't know what's the problem is...

<!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-Type" content="text/html; charset=utf-8" />
<title></title>
<style type="text/css">
<!--
body {
    margin-top: 50mm;
}
-->
</style>
<script src="gen_validatorv4.js" type="text/javascript"></script> 
<script type="text/javascript">
function upperCase()
{
var x=document.getElementById("specification").value;
document.getElementById("specification").value=x.toUpperCase();

var x=document.getElementById("permohonanNo").value;
document.getElementById("permohonanNo").value=x.toUpperCase();
}
</script>
<script type="text/javascript">
function calculateTotalPrice(){
    var price = parseFloat(document.borg_prolehan.price_unit.value);
    var kuantiti = parseInt(document.borg_prolehan.quantity.value);

    //alert(book_price);
    var total = price * kuantiti;

    document.borg_prolehan.total_price.value = total.toFixed(2);
}
</script>
</head>

<body bgcolor="#99ccff">
<div align="center">
<form id="borg_prolehan" name="borg_prolehan" method="post" action="fill_form.php?submit=yes">

<p>
<span id="spanOutput" style="border: 1px solid #000; padding: 3px;"> </span>
</p>
<table border="1" id="tblSample">
  <tr>
    <td colspan="6" align="center">PERMOHONAN PEROLEHAN : <input type="text" name="permohonanNo" id="permohonanNo" onblur="upperCase()" /></td>
    </tr>
    <tr>
      <td width="316" colspan="6" align="center">NAMA JBT/BHG : 
        <select name="bahagian" id="bahagian">
          <option value="0"></option>
<option value="Bahagian Teknologi Maklumat">Bahagian Teknologi Maklumat</option>
<option value="Bahagian Audit Dalaman">Bahagian Audit Dalaman</option>
<option value="Bahagian Kawalan Bangunan">Bahagian Kawalan Bangunan</option>
<option value="Bahagian Kejuruteraan">Bahagian Kujuruteraan</option>
<option value="Bahagian Kewangan">Bahagian Kewangan</option>
<option value="Bahagian Khidmat Masyarakat">Bahagian Khidmat Masyarakat</option>
<option value="Bahagian Landskap">Bahagian Landskap</option>
<option value="Bahagian Perundangan dan Penguatkuasaan">Bahagian Perundangan dan Penguatkuasaan</option>
<option value="Bahagian Penilaian">Bahagian Penilaian</option>
<option value="Bahagian Perancang Bandar">Bahagian Perancang Bandar</option>
<option value="Bahagian Perhubungan Awam">Bahagian Perhubungan Awam</option>
<option value="Bahagian Perlesenan">Bahagian Perlesenan</option>
<option value="Bahagian Perolehan dan Stor">Bahagian Perolehan dan Stor</option>
<option value="Bahagian Projek">Bahagaian Projek</option>
<option value="Unit Pusat Setempat">Unit Pusat Setempat</option>
          </select>
        </td>
      </tr>
  <tr>
    <th>Bil.</th>
    <th>Spesifikasi</th>
    <th>Harga Seunit</th>
    <th>Kuantiti</th>
    <th>Jumlah (RM)</th>
  </tr>
  <tr>
    <td align="center">1</td>
    <td>
    <input type="text" name="specification" id="specification" size="40" onblur="upperCase()" />
    </td>
    <td>
    <input type="text" name="price_unit" id="price_unit" size="20" />
    </td>
    <td>
    <input type="text" name="quantity" id="quantity" size="10" onblur="calculateTotalPrice();"/>
    <input name="status" type="hidden" value="PENDING" />
    </td>
    <td>
    <input type="text" name="total_price" id="total_price" size="20" readonly />
    </td>
  </tr>
  <tr>
    <td align="center">2</td>
    <td>
    <input type="text" name="specification" id="specification" size="40" onblur="upperCase()" />
    </td>
    <td>
    <input type="text" name="price_unit" id="price_unit" size="20" />
    </td>
    <td>
    <input type="text" name="quantity" id="quantity" size="10" onblur="calculateTotalPrice();"/>
    <input name="status" type="hidden" value="PENDING" />
    </td>
    <td>
    <input type="text" name="total_price" id="total_price" size="20" readonly />
    </td>
  </tr>
  <tr>
    <td align="center">3</td>
    <td>
    <input type="text" name="specification" id="specification" size="40" onblur="upperCase()" />
    </td>
    <td>
    <input type="text" name="price_unit" id="price_unit" size="20" />
    </td>
    <td>
    <input type="text" name="quantity" id="quantity" size="10" onblur="calculateTotalPrice();"/>
    <input name="status" type="hidden" value="PENDING" />
    </td>
    <td>
    <input type="text" name="total_price" id="total_price" size="20" readonly />
    </td>
  </tr>
</table>
<p>
<input type="submit" name="submit" id="submit" value="Mohon" />
<input type="reset" name="padam" id="padam" value="Padam" />
</p>
</form></div></body></html>

i try to add 3 data using same name, but it just add one data which is the first textbox row...anybody please help me....

php

Edited 11 Years Ago by Reverend Jim because: Fixed formatting

4 Contributors
7 Replies
130 Views
2 Days Discussion Span
Latest Post 12 Years Ago Latest Post by erza26

All 7 Replies

jkon 602 Posting Whiz in Training

13 Years Ago

What exactly do you want you code to do and not doing it ? … use code marks for code …

jkon 602 Posting Whiz in Training

13 Years Ago

do you have any knowledge of PHP? what is the simpanDataPermohonan function ? .... berjaya ???? I understand that you don't have any clue what you are writing ... why not trying that first ?

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

erza26 0 Newbie Poster · Answer 1 · 2011-04-19T07:24:12+00:00

i develop a form that user can order something...i've prepare 3 textbox for user if the user want to order more than one...the problem is, when i click submit button, it just insert data from the first row of textbox...the other 2 did not insert into database... this is the code for insert process...

<?php
include('config.php');

	if($_POST)
	{ $permohonanNo = $_POST["permohonanNo"];
	  $bahagian = $_POST["bahagian"];
	  $specification = $_POST["specification"];
	  $quantity = $_POST["quantity"];
	  $price_unit = $_POST["price_unit"];
	  $total_price = $_POST["total_price"];

	function simpanDataPermohonan($permohonanNo, $bahagian, $specification, $quantity, $price_unit, $total_price){	
	$sql = "INSERT INTO permohonan (permohonanNo, bahagian, specification, quantity, price_unit, total_price)
			       VALUES ('$permohonanNo', '$bahagian', '$specification', '$quantity', '$price_unit', '$total_price')";
	//echo $sql;
	$query = mysql_query($sql) or die("Error: " . mysql_error());
	}
	}
	
	function gagal()
	{
		echo"<script language='Javascript'>
			alert('Maaf..data gagal disimpan');
			location.href='fill_form.php';
			</script>";
    }
	
	function berjaya()
	{
		echo"<script language='Javascript'>
			alert('Data telah disimpan..');
			location.href='viewmohon.php';
			</script>";
    }

if(isset($_POST['submit'])){
$permohonanNo = isset ($_POST['permohonanNo']) ? $_POST['permohonanNo'] : '';
$bahagian = isset ($_POST['bahagian']) ? $_POST['bahagian'] : '';		
$specification = isset($_POST['specification']) ? $_POST['specification'] : '';
$quantity = isset($_POST['quantity']) ? $_POST['quantity'] : '';
$price_unit = isset($_POST['price_unit']) ? $_POST['price_unit'] : '';
$total_price = isset($_POST['total_price']) ? $_POST['total_price'] : '';

if(is_array($errors)){
   gagal();
	while (list($key, $value) = each($errors)){			
		echo "<span class=\"error\">".$value."</span><br />";
	}
}
else
{
	simpanDataPermohonan($permohonanNo, $bahagian, $specification, $quantity, $price_unit,  $total_price);
	simpanDataPermohonanNO($permohonanNo);
	berjaya();
}}?>

erza26 0 Newbie Poster · Answer 2 · 2011-04-19T07:59:40+00:00

erza26 0 Newbie Poster

13 Years Ago

simpanDataPermohonan is just a function name...

stanley87 0 Light Poster · Answer 3 · 2011-04-19T15:46:59+00:00

Just using the print_r for your query to make sure your data insert is available

diafol · Answer 4 · 2011-04-19T16:29:26+00:00

diafol

13 Years Ago

show the form code

erza26 0 Newbie Poster · Answer 5 · 2011-04-21T10:05:24+00:00

Re : show the form code

its alright...i've got the solution...thanks for helping....

insert many data with same name in one form

Recommended Answers Collapse Answers

All 7 Replies

Recommended Answers