taboritis

Experience

8,970

0 Best Reply Awards

  • Member Since 1 Month Ago
  • 89 Lessons Completed
  • 3 Favorites

11th July, 2017

taboritis left a reply on Differences In Fields Names In User Table • 2 weeks ago

Thank You. It works.

taboritis left a reply on Differences In Fields Names In User Table • 2 weeks ago

(2/2) QueryException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause' (SQL: select * from users where id = 1 limit 1)

taboritis started a new conversation Differences In Fields Names In User Table • 2 weeks ago

I have to use to my project existing table 'users'. I cannot change fields names. How can I config Laravel to use table like this.

id -> userid name -> username,

CREATE TABLE users ( userid int(11) NOT NULL AUTO_INCREMENT, login varchar(50) CHARACTER SET utf8 NOT NULL, password varchar(255) CHARACTER SET utf8 DEFAULT NULL, username varchar(255) DEFAULT NULL, email varchar(255) DEFAULT NULL, isadmin bit(1) DEFAULT NULL, department varchar(255) DEFAULT NULL, warehouse varchar(250) CHARACTER SET utf8 NOT NULL, alias varchar(100) CHARACTER SET utf8 NOT NULL, role varchar(255) DEFAULT NULL, remember_token varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, created_at timestamp NULL DEFAULT NULL, updated_at timestamp NULL DEFAULT NULL, PRIMARY KEY (userid,login) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin2;

Edit Your Profile
Update

Want to change your profile photo? We pull from gravatar.com.