CODEWITHSUNDEEP
phplaravellaravel-5laravel-5.4
Papouche Guinslyzinho
Papouche Guinslyzinho

Reputation: 5458

Laravel: How to seed database into multiple field of a db.table

I want to seed my database but everything is getting insert into one field (JOBURL) enter image description here

EmploisTableSeeder.php

use Illuminate\Database\Seeder;
use App\Emploi;
class EmploisTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     *
     *php artisan db:seed --class=EmploisTableSeeder
     */
    public function run()
    {
        //
        $json = file_get_contents('http://www.ottawacityjobs.ca/en/data/');
        $emplois = json_decode($json);
        $emplois = $emplois->jobs;

        //$emp = Emploi::create($array['order']);
        //$emp = Emploi::create($emplois);



        for ($i = 0; $i < count($emplois); $i++) {
            //print_r($emplois[$i]->JOBREF);
            //print_r("\n");

            Emploi::insert(
                array(
array('JOBURL' => isset($emplois[$i]->JOBURL) ? $emplois[$i]->JOBURL   : ' '),
array('SALARYMAX' => isset($emplois[$i]->SALARYMAX)?  $emplois[$i]->SALARYMAX  : ' ' ),
array('SALARYMIN' => isset($emplois[$i]->SALARYMIN)?   $emplois[$i]->SALARYMIN : ' ' ),
array('SALARYTYPE' => isset($emplois[$i]->SALARYTYPE)? $emplois[$i]->SALARYTYPE : ' ' ),
array('NAME' => isset($emplois[$i]->NAME)? $emplois[$i]->NAME : ' ' ),
array('POSITION' => isset($emplois[$i]->POSITION)? $emplois[$i]->POSITION : ' ' ),
array('JOBREF' => isset($emplois[$i]->JOBREF) ? $emplois[$i]->JOBREF : ' '),
array('JOB_SUMMARY' => isset($emplois[$i]->JOB_SUMMARY) ? $emplois[$i]->JOB_SUMMARY : ' '),
array('POSTDATE' => isset($emplois[$i]->POSTDATE) ? $emplois[$i]->POSTDATE : ' '),
array('EXPIRYDATE' => isset($emplois[$i]->EXPIRYDATE)? $emplois[$i]->EXPIRYDATE : ' ' ),
array('KNOWLEDGE' => isset($emplois[$i]->KNOWLEDGE) ? $emplois[$i]->KNOWLEDGE : ' '),
array('LANGUAGE_CERTIFICATES' => isset($emplois[$i]->LANGUAGE_CERTIFICATES) ?  $emplois[$i]->LANGUAGE_CERTIFICATES : ' ' ),
array('EDUCATIONANDEXP' => isset($emplois[$i]->EDUCATIONANDEXP) ? $emplois[$i]->EDUCATIONANDEXP : ' ' ),
array('COMPANY_DESC' => isset( $emplois[$i]->COMPANY_DESC) ? $emplois[$i]->COMPANY_DESC   : ' '),

                )//end array
                );//end Emploi::insert




        }
            //print_r(dd($emplois));

    }//end run function
}// end class EmploiTableSeeder

So overall I have about 90 json objects that I loop through but everything is getting inserted into one field.

Upvotes: 0

Views: 529

Answers (1)

Ganesh
Ganesh

Reputation: 3436

Include every field in single array. Do it like this.

array(
'JOBURL' => isset($emplois[$i]->JOBURL) ? $emplois[$i]->JOBURL   : ' ',
'SALARYMAX' => isset($emplois[$i]->SALARYMAX)?  $emplois[$i]->SALARYMAX  : ' ',
),

Upvotes: 1

Related Questions