Insert into db with foreach problem

Question

I have no idea why this foreach it`s not running. When i post the article, only inserts once. Should make it at much as needed. Do you see any problem?

$array_produse = array();
for($i=1; $i<=8; $i++)
{
    $gramaj = isset($_POST['image'.$i.'_gramaj']) ? $_POST['image'.$i.'_gramaj'] : '';
    $pret = isset($_POST['image'.$i.'_pret']) ? $_POST['image'.$i.'_pret'] : '';

    $array_produse[$i]['gramaj'] = $gramaj;
    $array_produse[$i]['pret'] = $pret;
    $array_produse[$i]['numar_produs'] = $i;
}

foreach($array_produse as $produs)
{
   $wpdb->insert(
        'produse',
        array(
            'id' => $post_id,
            'pret' => $produs['pret'],
            'gramaj' => $produs['gramaj'],
            'numar_produs' => $produs['numar_produs']
        ));
}

Answer 1

(See comments)

$wpdb->insert(
    'produse',
    array(
        'id' => $post_id,
        'pret' => $produs['pret'],
        'gramaj' => $produs['gramaj'],
        'numar_produs' => $produs['numar_produs']
    ),
    array(
        '%d',
        '%s',
        '%s',
        '%d'
    )    
);

Answer 2

// Turn on errors display
$wpdb->show_errors();

foreach($array_produse as $produs){

    // Prepare query
    $sql = $wpdb->prepare("
        INSERT INTO $wpdb->produse ('id', 'pret', 'gramaj', 'numar_produs') 
        VALUES (%d, %s, %s, %s)", 
        $post_id, $produs['pret'], $produs['gramaj'], $produs['numar_produs']
        )
    );

    // Execute query
    $wpdb->query($sql);

    // Show error if any
    $wpdb->print_error(); 

}

Answer 3

Problem solved. 'id' from db was primary, needs to be index.

Answer 4

Final code, if anyone needs it:

global $wpdb;

$array_produse = array();
for($i=1; $i<=8; $i++)
{
    $gramaj = isset($_POST['image'.$i.'_gramaj']) ? $_POST['image'.$i.'_gramaj'] : '';
    $pret = isset($_POST['image'.$i.'_pret']) ? $_POST['image'.$i.'_pret'] : '';

    if($gramaj != '' and $pret != '')
    {
        $array_produse[$i]['id'] = $post->ID;
        $array_produse[$i]['gramaj'] = $gramaj;
        $array_produse[$i]['pret'] = $pret;
        $array_produse[$i]['numar_produs'] = $i;
    }
}

foreach($array_produse as $produs)
{

    $wpdb->insert(
        'produse',
        array(
            'id' => $produs['id'],
            'pret' => $produs['pret'],
            'gramaj' => $produs['gramaj'],
            'numar_produs' => $produs['numar_produs']
        ),
        array(
            '%d',
            '%s',
            '%s',
            '%d'
        )
    );
}