current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote -2 down vote favorite
1

i am unable to update my table after submitting array data. ex: 1. Product Name: DELL 329 Quantity :5 Rate :2500 Amount :12500 2. Product Name:Dell 21 Quantity :8 Rate :1800 Amount :14400

but only last index of array is update in table

like Product Name:Dell 21 Quantity :8 Rate :1800 Amount :14400 Product Name:Dell 21 Quantity :8 Rate :1800 Amount :14400

            $in_no=$_POST['in_no'];

    //enter rows into item_info table
            foreach($_POST['p_name'] as $row=>$nm)
            {
                    $p_name=mysql_real_escape_string($nm);
                    $quantity=mysql_real_escape_string($_POST['quantity'][$row]);
                    $rate=mysql_real_escape_string($_POST['rate'][$row]);
                    $amount=mysql_real_escape_string($_POST['amount'][$row]);




            echo "Product Name:".$p_name." Quantity :".$quantity." Rate :".$rate." Amount :".$amount."<br/>";

            $involv = "UPDATE item_info set `p_name`='$p_name', `quantity`='$quantity', `rate`='$rate', `amount`='$amount' where `in_no`='$in_no'";

            mysql_query($involv);

`

share|improve this question
2  
$in_no=$_POST['in_no']; is set outside the loop. so you are updating the same record (where in_no='$in_no') multiple times inside the loop. –  cartina Jun 10 '13 at 12:05
    
did you not close the foreach {... ? have you tried to echo the $involv in each loop to inspect your query? –  steven Jun 10 '13 at 12:06
add comment

closed as not a real question by hakre, HamZa, simON, N.B., Jocelyn Jun 10 '13 at 13:13

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

3 Answers

up vote 1 down vote

your $in_no seems to stay constant out side the foreach loop. Hence you are updating the same row again and again. may be you should use some parameter in the $_POST['p_name']

share|improve this answer
add comment
up vote 0 down vote

You have to add an in_no value for every row you want to update, like you did with quantity, rate and amount.

//enter rows into item_info table
        foreach($_POST['p_name'] as $row=>$nm)
        {
                $p_name=mysql_real_escape_string($nm);
                $quantity=mysql_real_escape_string($_POST['quantity'][$row]);
                $rate=mysql_real_escape_string($_POST['rate'][$row]);
                $amount=mysql_real_escape_string($_POST['amount'][$row]);
                $in_no=$_POST['in_no'][$row];



        echo "Product Name:".$p_name." Quantity :".$quantity." Rate :".$rate." Amount :".$amount."<br/>";

        $involv = "UPDATE item_info set `p_name`='$p_name', `quantity`='$quantity', `rate`='$rate', `amount`='$amount' where `in_no`='$in_no'";

        mysql_query($involv);
share|improve this answer
    
$sql="delete from item_info where in_no='".$in_no."'"; –  Ravinda Chauhan Jun 12 '13 at 11:56
add comment
up vote 0 down vote

as far as what i understand from your question you have to

1 - delete all records with the same in_no before foreach loop
2 - Replace update sql with insert

and this will work fine , otherwise you have to deal with item_info using record id not in_no id

hope this will be clear

share|improve this answer
    
thanks Mr Samy....now it is working –  Ravinda Chauhan Jun 12 '13 at 11:53
    
Then accept the answer :D –  SamyMassoud Jun 12 '13 at 15:11
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.