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'>";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' ";
}
}