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 -1 down vote favorite

So guys i have this array that i need to insert into my db. I'm using foreach but i can't get it to run with two values.

The simple array looks like this: 

    Array
(

    [1] => Array
        (
            [id_produs] => 'value'
            [id_pret] => 'value'
        )

    [2] => Array
        (
            [id_produs] => 'value'
            [id_pret] => 'value'
        )
.
.
.
    [i] => Array
        (
            [id_produs] => 'value'
            [id_pret] => 'value'
        )


)

This is what I got right now:

foreach ($vl['id_produs'] as $prds=>$val) 
        {
       if($val<>'') mysql_query("INSERT into db set  id_pachet='".$id_pachet."', id_produs='".$val."'"); 
        foreach ($vl['id_pret'] as $prdsv=>$valv) {
            if($valv<>'') mysql_query("INSERT into db  set id_pachet='".$id_pachet."',  id_pret='".$valv."'");
        }
        }

where:

$vl = array();
    $vl = $_POST;

What do I do wrong?

The hole array looks like this:

Array
(
    [nume_pachet] => Test pachet nou
    [id_produs] => Array
        (
            [0] => 0
            [1] => 41
            [2] => 135
        )

    [id_pret] => Array
        (
            [0] => 0
            [1] => 0
            [2] => 157
        )

    [pret_pachet] => 99.00
    [id_moneda] => 1
    [descriere_pachet] => Lorem ipsum dolores
    [activ] => 1
)

The db in which I want to insert the values has this structure:

id id_pachet id_produs id_pret

so In one package (id_pachet) I can have more products (id_produs) which can have more than one price (id_pret)

for example:

id  id_pachet   id_produs   id_pret
1   3       13              1
2   3       13              2
3   3       14              0

The thing is that if do this:

foreach ($vl['id_produs'] as $prds=>$val) 
     {
   if($val<>'') mysql_query("INSERT into erad_produse_pachete_str set id_pachet='".$id_pachet."',  id_produs='".$val."'"); 

    }

it's working for id_produs, but i need to insert at the same time also id_pret

UPDATE!

I got some help from my brother. And this is working for me. If you can apply it for your case I hope it helps

$produse = $_POST['id_produs'];
$preturi = $_POST['id_pret'];


if(count($produse))
foreach ($produse as $key=>$id_produs) {

    if($id_produs>0){
        $id_pret = isset($preturi[$key]) ? $preturi[$key] : 0;
        mysql_query("INSERT INTO erad_produse_pachete_str (id_pachet,id_produs,id_pret) VALUES ('{$id_pachet}', '{$id_produs}', '{$id_pret}')"); 
    }
}
share|improve this question
    
You have wrong insert query ? see here: tutorialspoint.com/mysql/mysql-insert-query.htm –  GBD Oct 6 '12 at 9:19
add comment

2 Answers 2

up vote 0 down vote

Check your insert query, it's wrong.

For example, it should be, INSERT INTO table (field1, field2,.....) VALUE (value1, value2,.....)

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

There are several things wrong:

  • the values of id_produs are numerics, you must not quote them
  • the syntax of the insert query is wrong
  • the loop over the foreach was not correct.

This should get you going:

foreach ($vl['id_produs'] as $val) {
  if($val<>'') 
    mysql_query("INSERT into `db` ( id_produs ) VALUES( $val )"); 
}

foreach ($vl['id_pret'] as $valv) {
  if($valv<>'') 
    mysql_query("INSERT into `db` ( id_pret ) VALUES( $valv )");
}
share|improve this answer
    
does his insert query syntactically correct ? –  GBD Oct 6 '12 at 9:23
    
@GBD: it took a while for figuring it al out, thanks –  JvdBerg Oct 6 '12 at 9:32
    
The db in which I want to insert the values has this structure: id id_pachet id_produs id_pret so In one package (id_pachet) I can have more products (id_produs) which can have more than one price (id_pret) for example:code id id_pachet id_produs id_pret 1 3 13 1 2 3 13 2 3 3 14 0 –  nickRO87 Oct 6 '12 at 9:37
    
I can't get this right in this comment. So I'll edit my question –  nickRO87 Oct 6 '12 at 9:39
    
@JvdBerg can I do a foreach for two values? something like this: foreach ($vl['id_produs'] as $val and $vl['id_pret'] as $valv ) –  nickRO87 Oct 6 '12 at 9:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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