public function upload() { if (Input::hasFile('playerfile')) { $file = Input::file('playerfile'); $up = Excel::load($file, function ($reader) { $results = $reader->get()->toArray(); foreach ($results as $row) { $player_group_id = Group::where('name', 'Player')->firstOrFail(); $days = new DateTime(date('Y-m-d H:i:s', strtotime("+30 days"))); $player_account = array('email' => '', 'password' => Hash::make(''), 'confirmed' => 1, 'status' => 1, 'password_expiration_date' => $days, 'account_expiration_date' => $days, 'created_at' => new DateTime(), 'updated_at' => new DateTime()); foreach ($row as $key => $value) { $player_account[$key] = $value; } try { $add_account = User::create($player_account); $user_member = array('user_id' => $add_account->id, 'group_id' => $player_group_id->id, 'date_created' => new DateTime()); $add_member = UserMember::create($user_member); $player_points = array('account_id' => $add_account->id); $add_points = Points::create($player_points); } catch (Exception $e) { // return false; } } }); if ($up) { $messages = 'Upload Successful.'; $status = 'success'; } else { $messages = 'Upload failed.'; $status = 'error'; } return Redirect::route('player.index')->with($status, $messages); } else { return Redirect::action('player.index')->with('error', 'Please select a Excel or CSV File.'); } }