Page 1 of 1

insert multi rows

Posted: Mon Dec 03, 2007 7:48 am
by hrubos
I want to insert multirows by command "UPDATE", but it doesn't run.
I have a table and user can insert to it
c1 : <blank>
c2 : <blank>
c3 : <blank>

The first, I insert following :
c1: 1
c2: 2
c3: <blank>
c4: <blank> ---------------> It returns result OK
The second, in table there are c1 =1 and c2 = 2, I continue inserting
c1: 1
c2: 2
c3: 4
c4: <blank>
-------------------> result in table after submitting:
c1: 4
c2:2
c3: <blank>
c4 : <blank>

Where did I do bad???
php1:

Code: Select all

echo "<form action='../financeCustom/finance_customdb.php' method='POST'>"	;
	echo "<td class = 'cena'>";
	echo "<input type='text' name='usdNaklad[]' value='' size='4'>";
	echo "</td>";
	echo "<td class = 'cena'>";
	echo "<input type='text' name='euroNaklad[]' value='' size='4'>";
	echo "</td>";
	echo "<td class = 'cena'>";
	echo "<input type='text' name='korunNaklad[]' value='' size='4'>";
	echo "</td>";
	echo "<td class = 'cena'>";
	echo "<input type='text' name='skNaklad[]' value='' size='4'>";
	echo "</td>";
echo "<input type='submit' name='insertCustom' value='Nhap du lieu'>";
php2:

Code: Select all

if(isset($_POST['insertCustom'])){
		
	
	
	  $container = $_POST['contNum'];
	  $usdCena = $_POST['usdCena'];
	  $euroCena = $_POST['euroCena'];
	  $korunCena = $_POST['korunCena'];
	  $skCena = $_POST['skCena'];
	  $usdNaklad = $_POST['usdNaklad'];
	  $euroNaklad = $_POST['euroNaklad'];
	  $korunNaklad = $_POST['korunNaklad'];
	  $skNaklad = $_POST['skNaklad'];
	  
	 foreach($container as $r=>$cont)
  {
$container = mysql_real_escape_string($cont);
//$idCus = mysql_real_escape_string($_POST['idCus'][$row]);
$usdCena = mysql_real_escape_string($_POST['usdCena'][$r]);
$euroCena = mysql_real_escape_string($_POST['euroCena'][$r]);
$korunCena = mysql_real_escape_string($_POST['korunCena'][$r]);
$skCena = mysql_real_escape_string($_POST['skCena'][$r]);

if($usdCena){
//echo "check container num: ".$container."";
$query = "UPDATE customCena
		      SET cenaCustom = '$usdCena',
		  	  typCustom='usd'
		  	  WHERE container_num = '$cont' ";

	}
}
Thank you in advance

Posted: Mon Dec 03, 2007 2:25 pm
by volka
You probably have a for/while/foreach loop somewhere in php1 that is related to the code snippet you've provided?
And
hrubos wrote:I want to insert multirows by command "UPDATE", but it doesn't run.
what do you really want INSERT or UPDATE?