How can select last record by two or more parameters?

Question

In this case, if I change exp_at, than id_card will be from one field, and exp_at from another.. And if I use where statement for card, than user records disaper. how to solve???

->leftJoin('bon_card', 'bon_card.id_user', '=', 'users.id_user')

->select(DB::raw('max(bon_card.id_card) as id_card, max(bon_card.exp_at) as bon_exp_date, users.*'))

->where([['vards','LIKE',"%{$vards}%"], ['uzvards','LIKE',"%{$uzvards}%"], ['pers_kods','LIKE',"%{$pers_kods}%"], ['tel','LIKE',"%{$tel}%"], ['email','LIKE',"%{$email}%"]])

[Little Bobby](http://bobby-tables.com/) says **[you may be at risk for SQL Injection Attacks](https://stackoverflow.com/q/60174/)**. Learn about [Prepared Statements](https://en.wikipedia.org/wiki/Prepared_statement) with [parameterized queries](https://stackoverflow.com/a/4712113/5827005). I recommend `PDO`, which I [wrote a class for](https://github.com/GrumpyCrouton/GrumpyPDO) to make it extremely easy, clean, and more secure than using non-parameterized queries. Also, [This article](http://php.net/manual/en/mysqlinfo.api.choosing.php) may help you choose between `MySQLi` and `PDO` — GrumpyCrouton, Oct 16 '17 at 19:15

score 0 · Answer 1 · answered Oct 16 '17 at 21:05

0

  ->leftJoin('bon_card', 'bon_card.id_user', '=', 'users.id_user')

->select(DB::raw('max(bon_card.id_card) as id_card, max(bon_card.exp_at) as bon_exp_date, users.*'))

->where([['vards','LIKE',"%{$vards}%"])->orWhere(['uzvards','LIKE',"%{$uzvards}%"])

answered Oct 16 '17 at 21:05

Aliaga Aliyev

415
1
6
22

mhm, it's not that, what I expected. actualy I want to select both joined fields as last from one row, not two different rows... – ivo Oct 16 '17 at 21:39
are you try where()->get() ? – Aliaga Aliyev Oct 16 '17 at 22:52

How can select last record by two or more parameters?

1 Answers1