amberlex78

SELECT * FROM `tasks2users` 
JOIN `users` ON (`tasks2users`.`user_id` = `users`.`id`) 
JOIN `tasks` ON (`tasks2users`.`task_id` = `tasks`.`id`) 

amberlex78

<?php
/*
-----------------------------------
Reformat flat array to nested array
-----------------------------------

Array(
	[2] => Array(
		[id] => 2
		[parent_id] => 0

amberlex78

<?php

// Поиск цены в строке
// Число типа: 27.30 или 33,56

preg_match('/[0-9]*[\.,]?[0-9]/', $text, $matches);

if (isset($matches[0])) {
	$price = str_replace(',', '.', $matches[0]);
} else {

amberlex78

<?php
$headers   = array();
$headers[] = "MIME-Version: 1.0";
$headers[] = "Content-type: text/html; charset=utf-8";
$headers[] = "From: Sender Name <[email protected]>";
$headers[] = "Bcc: JJ Chong <[email protected]>";
$headers[] = "Reply-To: Recipient Name <[email protected]>";
$headers[] = "Subject: {$subject}";
$headers[] = "X-Mailer: PHP/".phpversion();

amberlex78

Highlighting multi-level menu items

In a multi-level menu, you usually have to highlight the selected menu item and its parent element. This can be done based on the parent route.

<ul>
  <li>
    <a href="{{ route('admin.posts.index') }}"
       class="{{ Str::is('admin.posts.*', Route::currentRouteName()) ? 'is-active' : '' }}">
 Manage Posts

amberlex78

Display or log query

Display query

Add code in a file:

\DB::enableQueryLog();

$user = App\User::get();

amberlex78

<?php

$v = \DB::select("select version()")[0]->{"version()"};
$v = explode('-', $v)[0];

amberlex78

<?php

namespace App\Controller\Admin;

use Doctrine\ORM\EntityManagerInterface;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\Routing\Annotation\Route;

amberlex78

<?php

namespace App\ReadModel\Blog;

use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Exception;

class PostFetcher
{
    public function __construct(

amberlex78

<?php

class BladeServiceProvider extends ServiceProvider
{
    public function boot(): void
    {
        Form::component('bsText', 'collective.form.text', [
            'label', 'name', 'value' => null, 'attributes' => []
        ]);