$stmt = $pdo->prepare('INSERT INTO `Client`(`id`, `surname`, `name`, `patron`, `serie`, `number`, `propiska`,`telephone`) VALUES (?,?,?,?,?,?,?,?)');/*ошибка ,удалить `банк`*/
$stmt->execute([$id, $surname, $name, $patron, $serie, $number, $propiska,$telephone,/*$ls,$balance,$date*/]);/*error*/
$stmt = $pdo->prepare('INSERT INTO `Client2`(`id`, `surname`, `name`, `patron`, `serie`, `number`, `propiska`,`telephone`) VALUES (?,?,?,?,?,?,?,?)');/*ошибка ,удалить `банк`*/
$stmt->execute([$id, $surname, $name, $patron, $serie, $number, $propiska,$telephone,/*$ls,$balance,$date*/]);/*error*/
$cases = [];
$ids = [];
$params = [];
foreach ($request->data as $value => $id) {
$id = (int) $id;
$cases[] = "WHEN {$id} then ?";
$params[] = $value;
$ids[] = $id;
}
$ids = implode(',', $ids);
$cases = implode(' ', $cases);
\DB::update("UPDATE `table_name` SET `position` = CASE `id` {$cases} END WHERE `id` in ({$ids})", $params);
$categories = Category::whereName($name)->get();
$articles = Article:with('types')->whereIn('id', $categories->pluck('id'))->paginate(10);