Level 47
This is default behavior. The table is, after all, a table of multiple users, not just one user.
1 like
Jul 18, 2015
9
Level 1
Usign Eloquent - 's' is added to database table names
I am following this tutorial: https://www.youtube.com/watch?v=_s6K-3KT5wQ
And working on my first Laravel App.
But I have noticed that when I create a new class file (in this case "App\UserInfo"
and then try to pull information to the controller it adds an 's' to the end of the table name. Just wondering if anybody has any idea as to why it is doing this?
Here is the error: (I am trying to work with the table "UserInfo" and instead it seems to be looking for "UserInfos"
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'app.UserInfos' doesn't exist (SQL: select * from UserInfos)
use Illuminate\Database\Eloquent\Model as Eloquent;
class UserInfo extends Eloquent {
}
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Requests; use App\Http\Controllers\Controller;
use App\UserInfo
class UserInfoController extends Controller { public function index() {
$users = UserInfo::get();
return view('dashboard.users.list', compact('users'));
}
}
Level 2
Ignore me sorry
protected $table = "userinfo";
Try that in your model
Level 1
@nathanrobjohn Tanks this work for my case
Level 122
@DuartePinguim but it is not best practice. Conventionally your tables should be plural. Laravel is trying to encourage you to stick to conventions.
Level 56
Just wondering if anybody has any idea as to why it is doing this?
Because it is the normal convention, singular model names, plural table names.
You can override this by specifying your own table name in the table attribute of your eloquent model. public $table = 'your_table_name'.
2 likes
Level 1
It still does this. If I create a project with 50 tables I have to edit 50 migration files... very annoying. It should give you the choice... maybe it does mind and I have just not found it ;)
Level 1
As someone said in this thread https://laracasts.com/discuss/channels/general-discussion/makemodel-also-creates-a-migration
you can use --skip-migration when you are making your model with php artisan
Level 122
It still does this. If I create a project with 50 tables I have to edit 50 migration files... very annoying.
But you have to edit the migrations anyway?
Level 1
I think Nathan's suggestion is the very best way to get away from this whatsoever "restriction"
Just use
protected $table = "tablename";
inside ur model class
Please or to participate in this conversation.