0

I try to insert the static value I have here

public static function saveBrandsAction()
{
    $api = new Ns_Thorleif_Adminhtml_IndexController();
    $arr = array();
    $arr[] = array('brandId' => '123', 'name' => 'test', 'globalIdentifier' => '1020002020');

    $model = Mage::getModel('thorleif/brand')->addData($arr);
    var_dump($model);
    try {
        $insertId = $model->save()->getId();
        echo "Data successfully inserted. Insert ID: ".$insertId;
    } catch (Exception $e){
        echo $e->getMessage(); 
    }
}

but in the debug the query is like this

INSERT INTO `linio_brands` () VALUES ()

and my var dump looks like

object(Ns_Thorleif_Model_Brand)#314 (15) { ["_eventPrefix":protected]=> string(13) "core_abstract" ["_eventObject":protected]=> string(6) "object" ["_resourceName":protected]=> string(14) "thorleif/brand" ["_resource":protected]=> NULL ["_resourceCollectionName":protected]=> string(25) "thorleif/brand_collection" ["_cacheTag":protected]=> bool(false) ["_dataSaveAllowed":protected]=> bool(true) ["_isObjectNew":protected]=> NULL ["_data":protected]=> array(1) { [0]=> array(3) { ["brandId"]=> string(3) "123" ["name"]=> string(4) "test" ["globalIdentifier"]=> string(10) "1020002020" } } ["_hasDataChanges":protected]=> bool(true) ["_origData":protected]=> NULL ["_idFieldName":protected]=> NULL ["_isDeleted":protected]=> bool(false) ["_oldFieldsMap":protected]=> array(0) { } ["_syncFieldsMap":protected]=> array(0) { } } Data successfully inserted. Insert ID: 5

something is wrong?

  • 1
    try changing $arr[] to $arr – Piyush Jun 27 '17 at 5:05
  • Yes it works but only to insert one row. I have many rows and for that I use the foreach and the $arr table. – javaTodev Jun 27 '17 at 15:17
0

I had to put it like this the Foreach with the setData and save into the foreach

foreach ($xml->Body->Brands->Brand as $row) {
            $arr = array('brandId' => $row->BrandId, 'name' => $row->Name);
            $model = Mage::getModel('thorleif/brand')->setData($arr);
            $model->save();
        }
  • You can also accept you own answer ;) – sv3n Jul 10 '17 at 23:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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