csv import sample

csv import sample

 ini_set('auto_detect_line_endings', true);

        $csvFile = Input::file('csvfile');

        $uploadDir = path('public').'/uploads/data/prospects';
        $filename = $csvFile['name'];

        Input::upload('csvfile', $uploadDir, $filename);

        $handle = fopen($uploadDir.'/'.$filename, "r");
            while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
            {

                $prospect = new Prospect;

                $prospect->company_name = $data[6];
                $prospect->contact_name = $data[0].' '.$data[1];
                $prospect->dm_name = $data[0].' '.$data[1];
                $prospect->address = $data[7];
                $prospect->town_city = $data[8];
                $prospect->county = $data[9];
                $prospect->postcode = $data[10];
                $prospect->user_id = Input::get('userId');

                $prospect->save();

                $contact = new Contact;

                $contact->prospect_id = $prospect->id;
                $contact->position_id = 1;
                $contact->name = $data[0].' '.$data[1];
                $contact->contact_number = $data[2];
                $contact->contact_email = $data[3];

                $contact->save();
            }
            fclose($handle);