General error: 1366 Incorrect integer value ( QUERY EXEPTION )

manpreet Best Answer 3 years ago

im trying to add some data in the database from a form but i got an exeption : SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '[{"ID_ARTICLE":58}]' for column 'ID_ARTICLE' at row 1 (SQL: insert into annonce (TITRE_ANNONCE, TYPE_ANNONCE, PRIX, ID_ARTICLE) values (titre, 1, 100, [{"ID_ARTICLE":58}]))

which mean i cant insert the ID_ARTICLE which is an integer here is my query :

public function store(Request $request) { $annonce = new annonce;

    $IDARTICLE = DB::table('article')
        ->select('ID_ARTICLE')
        ->where('NOM_ARTICLE', $request->NOM_ARTICLE)
        ->get();


    $annonce->TITRE_ANNONCE = $request->TITRE_ANNONCE;
    $annonce->TYPE_ANNONCE = $request->TYPE_ANNONCE;
    $annonce->PRIX = $request->PRIX;
    $annonce->ID_ARTICLE = $IDARTICLE;
    $annonce->save();

    return ($annonce);
}

i tried to replace $annonce->ID_ARTICLE = $IDARTICLE; with $annonce->ID_ARTICLE = $IDARTICLE->ID_ARTICLE; to retrieve the integer value from the list but shows another error : Property [ID_ARTICLE] does not exist on this collection instance.