You should add ->nullable() or ->default(‘somethingHere’) to fields which you send empty values. $table->string(‘family’)->nullable(); //this means that if you send empty value this field will become MySQL NULL Or set default value: $table->string(‘family’)->default(‘default value here’); Than remigrate: php artisan migrate:rollback and php artisan migrate
To extend/swap a Laravel core class, you can create a Service Provider: File: app/App/Libraries/Extensions/FormBuilder/FormBuilderServiceProvider.php <?php namespace App\Libraries\Extensions\FormBuilder; use Illuminate\Support\ServiceProvider as IlluminateServiceProvider; use App\Libraries\Extensions\FormBuilder\FormBuilder; class FormBuilderServiceProvider extends IlluminateServiceProvider { /** * Indicates if loading of the provider is deferred. * * @var bool */ protected $defer = true; /** * Register the service provider. * * … Read more
The issue is that the filter() method does not rekey the underlying collection array. So, the Collection is still representing an array, it is just that your array looks like this: [ 4 => Object4, 7 => Object7, ] While this is a perfectly valid array in PHP, this is not a proper array in … Read more
Two steps : Declare & transfer $variable to View from Controller function. public function index() { return view(“index”, [ “variable” => $variable ]); } Indicate where transferred $variable from Controller appear in view.blade.php. {{ $variable }} If you do not make sure, $variable is transferred or not {{ isset($variable) ? $variable : ” }}
You’ll have to add multiple whereHas for that: $query = User::with(‘activities’); foreach($selectedActivities as $activityId){ $query->whereHas(‘activities’, function($q) use ($activityId){ $q->where(‘id’, $activityId); }); } $userByActivities = $query->get();
So after doing much more searching and reading from different sources this is what I came up with and it’s working fine: /app/models/Navigation.php <?php class Navigation extends Eloquent { /** * The database table used by the model. * * @var string */ protected $table=”navigation”; public function parent() { return $this->hasOne(‘navigation’, ‘id’, ‘parent_id’); } public … Read more
Since Laravel 4.1, inside your model (in this case Company and People) you can set the protected property $morphClass to whatever you want. <?php namespace Lion; class Company extends \Eloquent { protected $morphClass=”Company”; } Now in your table you can store the type without the namespace: | id | realatable_type | relatable_id | 2 | … Read more
Using built-in HTML helpers have many benefits: Using Form::open you add CSRF protection input hidden (by default) Using form elements (inputs/textarea etc.) and withInput method for Redirection allows you to easily fill in the form with the same data with almost no coding If you use Redirect::route(‘form’->withInput(); and have input text {{Form::text(‘username’)}} it will automatically … Read more
As it was stated, chunks won’t really help you in this case if it is a time execution problem. I think that bulk insert you are trying to use cannot handle that amount of data , so I see 2 options: 1 – Reorganise your code to properly use chunks, this will look something like … Read more
Just do this: ‘timezone’ => ‘Asia/Singapore’ in config/app.php file and run this 3 command: php artisan cache:clear php artisan view:clear and php artisan config:cache Hope this helps you!!