Immortal_pony

UPDATE
	`wp_posts`
SET
	`post_title` = CONCAT(
		LEFT(post_title, LOCATE(' ', post_title)-1), 
		' №',
		SUBSTR(post_title, LOCATE(' ', post_title))
	)
WHERE
	`post_type`='post'
ORDER BY
	`post_date`

function mergeAs($key, $arr, $to) {
    if (count($arr) !== count($to)) {
        throw new \InvalidArgumentException ("Arrays must have the same size");
    }
    
    $merged = [];
    foreach ($to as $index=>$element) {
        $element[$key] = $arr[$index];
        $merged[] = $element;
    }
    
    return $merged;
}

$orderIds = ["7", "4", "3", "5", "6", "1"];
$files = [
    [
        'name' => "Screenshot from 2019-01-10 15-04-58.png", 
        'type' => "image/png",
        'tmp_name' => "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a70d8",
        'error' => 0,
        'size' => 249784
    ],
    [
        'name' => "Screenshot from 2019-01-09 16-29-26.png", 
        'type' => "image/png",
        'tmp_name' => "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a7179",
        'error' => 0,
        'size' => 440472
    ],
    [
        'name' => "Screenshot from 2019-01-07 18-10-31.png", 
        'type' => "image/png",
        'tmp_name' => "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a71cb",
        'error' => 0,
        'size' => 175614
    ],
    [
        'name' => "par-de-ruedas-dentadas-dos-tamanos_318-44594.jpg", 
        'type' => "image/jpeg",
        'tmp_name' => "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a721c",
        'error' => 0,
        'size' => 26891
    ],
    [
        'name' => "300614.png", 
        'type' => "image/png",
        'tmp_name' => "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a7264",
        'error' => 0,
        'size' => 11784
    ],
    [
        'name' => "0.jpeg", 
        'type' => "image/jpeg",
        'tmp_name' => "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a72ac",
        'error' => 0,
        'size' => 291469
    ]
];

$files = mergeAs("order", $orderIds, $files);
var_dump($files);

/* Result */
/*
array(6) {
  [0]=>
  array(6) {
    ["name"]=>
    string(39) "Screenshot from 2019-01-10 15-04-58.png"
    ["type"]=>
    string(9) "image/png"
    ["tmp_name"]=>
    string(107) "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a70d8"
    ["error"]=>
    int(0)
    ["size"]=>
    int(249784)
    ["order"]=>
    string(1) "7"
  }
  [1]=>
  array(6) {
    ["name"]=>
    string(39) "Screenshot from 2019-01-09 16-29-26.png"
    ["type"]=>
    string(9) "image/png"
    ["tmp_name"]=>
    string(107) "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a7179"
    ["error"]=>
    int(0)
    ["size"]=>
    int(440472)
    ["order"]=>
    string(1) "4"
  }
  [2]=>
  array(6) {
    ["name"]=>
    string(39) "Screenshot from 2019-01-07 18-10-31.png"
    ["type"]=>
    string(9) "image/png"
    ["tmp_name"]=>
    string(107) "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a71cb"
    ["error"]=>
    int(0)
    ["size"]=>
    int(175614)
    ["order"]=>
    string(1) "3"
  }
  [3]=>
  array(6) {
    ["name"]=>
    string(48) "par-de-ruedas-dentadas-dos-tamanos_318-44594.jpg"
    ["type"]=>
    string(10) "image/jpeg"
    ["tmp_name"]=>
    string(107) "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a721c"
    ["error"]=>
    int(0)
    ["size"]=>
    int(26891)
    ["order"]=>
    string(1) "5"
  }
  [4]=>
  array(6) {
    ["name"]=>
    string(10) "300614.png"
    ["type"]=>
    string(9) "image/png"
    ["tmp_name"]=>
    string(107) "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a7264"
    ["error"]=>
    int(0)
    ["size"]=>
    int(11784)
    ["order"]=>
    string(1) "6"
  }
  [5]=>
  array(6) {
    ["name"]=>
    string(6) "0.jpeg"
    ["type"]=>
    string(10) "image/jpeg"
    ["tmp_name"]=>
    string(107) "/var/www/product/public/website/content/tmp/apartment_images_1927b69a6e00d870384ad6877cc50ece_5c3854e9a72ac"
    ["error"]=>
    int(0)
    ["size"]=>
    int(291469)
    ["order"]=>
    string(1) "1"
  }
} 
*/

SELECT 
	`category`.`title`,
	 CONCAT(
		'{',
			'"hasMore":', IF(COUNT(`product`.`id`)>3, 'true', 'false'), ', ',
			'"products":[',
				COALESCE(GROUP_CONCAT(
					JSON_OBJECT('id', `product`.`id`, 'title', TRIM(`product`.`title`))
					ORDER BY `product`.`title` ASC
					LIMIT 3
				)),
			']',
		'}'
	) AS product
FROM 
	`category`
	LEFT JOIN `product` ON (`category`.`id`=`product`.`category_id`)
GROUP BY `category_id`

<?php foreach ($categories as $category) { ?>
    <h3><?= $category->title ?></h3>
    <?php $products = json_decode($category->products) ?>
    <?php if (!empty($category->hasMore)) { ?>
        <?php foreach ($products as $product) { ?>
             <span>Id: <?= $product->id ?>, Title: <?= $product->title ?></span>
        <?php } ?>
    <?php } ?>
    <?php if (!empty($category->hasMore)) { ?>
        <a>Смотреть больше</a>
    <?php } ?>     
<?php } ?>

$ids = implode(", ", $arItems["PRODUCT_ID"]);
$sum = array_sum($arItems["PRICE"]);

<?php
class Fields
{
    protected $parent;
    
    public function __construct(\Data &$parent) 
    {
        $this->parent = $parent;
    }
    
    public function __get($name) 
    {
        return array_key_exists($name, $this->parent->fields) ? $this->parent->fields[$name] : false;
    }

    public function __set($name, $value) {
        $this->parent->fields[$name] = $value;
    }
}

class Data
{
    public $fields = [
        'foo' => "bar"
    ];
    
    public function __get($name){
        if($name == 'f'){
            return new \Fields($this);
        }
        else {
            return false;
        }
    }
}

$data = new Data();
$data->f->testInfo = "test passed";
echo $data->fields['testInfo']; // выведет "test passed"