0ldn0mad

SELECT goods.goods_name, goods.price, categories.cat_name 
FROM goods
LEFT JOIN categories ON goods.cat_id = categories.cat_id

$counter = $request->session()->get('counter', 1);
$request->session()->put('counter', ++$counter);

$users = [
     [
      "name" => "Вася",
      "age" => 33,
      "salary" => 450
     ]
 ];
return view('users', ['users' => $users]);
// или
return view('users', compact('users'));

@foreach ($users as $user)
        {{$user['name']}}
@endforeach

Route::get('user/{name}', function ($name) {
  die("User: {$name}");
})->where('name', 'name|surname|age');

<td class="status_<?= $user['status'] ?>"><?= $user['status'] ?></td>

.status_admin{ ... }
.status_user{ ... }
.status_guest{ ... }

$numb1 = (float)$_POST['num1'];
$numb2 = (float)$_POST['num2'];

$numb1 = +$_POST['num1'];
$numb2 = +$_POST['num2'];

<?php
error_reporting(E_ALL);
# error_reporting(E_ALL & ~E_NOTICE);
ini_set('display_errors', 'on');
setlocale(LC_ALL, 'ru_RU.UTF-8');
#-------------------------------------------------
$operations = ['+', '-', '*', '/'];

$numb1 = 0;
$numb2 = 0;

If (!empty($_POST['num1']) && !empty($_POST['num2'])) {
  if (in_array($_POST['oper'], $operations)) {

    $numb1 = +$_POST['num1'];
    $numb2 = +$_POST['num2'];

      switch ($_POST['oper']) {
        case '+':
          $res = $numb1 + $numb2;
        break;
        case '-':
          $res = $numb1 - $numb2;
        break;
        case '*':
          $res = $numb1 * $numb2;
        break;
        case '/':
          $res = $numb1 / $numb2;
        break;
        default:
          echo "НЕДОПУСТИМОЕ ДЕЙСТВИЕ";
      }
  }else{
    $res = "Ошибка операции";
  }
}
?>

<form action='calc.php' method="post">
      <label>Число 1:</label>
      <br />
      <input name='num1' type='number' value="<?=$numb1 ?>" />
      <br />
      <label>Оператор: </label>
      <br />
      <select name="oper">
          <?php foreach ($operations as $oper): ?>
        <option value="<?= $oper;?>"><?=$oper;?></option>
          <?php endforeach;?>
      </select>
    <br />
      <label>Число 2: </label>
      <br />
      <input name='num2' type='number' value="<?=$numb2 ?>" />
      <br />
      <?php if (isset($res)): ?>
      <p> Результат: <?=$res?></p>
      <?php endif;?>
      <br />
      <input type='submit' value='Считать'>
    </form>

SELECT MONTH(purchase_date) AS mont, SUM(price) AS goods_sum
FROM goods
GROUP BY MONTH(purchase_date)

SELECT YEAR(purchase_date) AS goods_year,
  MONTH(purchase_date) AS goods_month, 
  SUM(price) AS goods_sum
FROM goods
GROUP BY YEAR(purchase_date), MONTH(purchase_date)
ORDER BY 1, 2

select
t1.name_goods,
t2.name_subcat,
t3.name_cat
from goods t1
left join subcategory t2 on t2.id_subcat = t1.id_subcat
left join category t3 on t3.id_cat = t1.id_cat

function mb_count_chars($input) {
    $l = mb_strlen($input, 'UTF-8');
    $unique = array();
    for($i = 0; $i < $l; $i++) {
        $char = mb_substr($input, $i, 1, 'UTF-8');
        if(!array_key_exists($char, $unique))
            $unique[$char] = 0;
        $unique[$char]++;
    }
    return $unique;
}

$input = "Когда Вам покажется, что цель недостижима, не изменяйте цель - изменяйте свой план действий. Конфуций";
print_r(mb_count_chars(preg_replace('/[^[:alnum:]]/u', '', mb_strtolower($input))) );

$input =<<<EOT
25 Mn Марганец (а.м. 54,938):
26 Fe Железо (а.м. 55,847):
27 Со Кобальт (а.м. 58,9332):
28 Ni Никель (а.м. 58,7):
29 Cu Медь (а.м. 63,546):
EOT;

$elements = [];
if (preg_match_all('/^\d+\s(\S+)\s(\S+)/mu', $input, $matches, PREG_SET_ORDER)) {
    foreach ($matches as $match) {
        $elements[$match[1]] = $match[2];
    }
}

var_export($elements);
/*
array (
  'Mn' => 'Марганец',
  'Fe' => 'Железо',
  'Со' => 'Кобальт',
  'Ni' => 'Никель',
  'Cu' => 'Медь',
)
*/

$arr = [4,12,73,8,1,1,36,7,6,22,22,3];

for ($i = 0; $i < count($arr); $i++) {
    if ($i && $arr[$i] == $arr[($i-1)]) {
        echo 'есть идущие подряд: '.$arr[$i].' - '.$arr[$i].'<br>';
    }
}