Slava Rozhnev

<?php
$search = "Диагональ 17,6";

echo preg_replace(
		'/(\d),(\d)/', '$1.$2', 
		$search
); //Диагональ 17.6

<?php
$query = 'SELECT
		`methods`.* 
	FROM `methods` 
	LEFT JOIN `groups` ON `groups`.`id` = `methods`.`group_id` 
	WHERE 
		`methods`.`active` = ? AND 
		`groups`.`active` = ? 
	ORDER BY `methods`.`group_id`, `methods`.`position`;';

// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute([1, 1]);

if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
	$group_id = $row['group_id'];
	
	printf(
		'<ul data-group_id="%d">' . PHP_EOL . '    <li data-id="%d">%s</li>' . PHP_EOL, 
		$group_id, $row['id'], $roe['name']
	);
	
	while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
		if ($group_id != $row['group_id']) {
			$group_id = $row['group_id'];
			printf(
				'</ul><ul data-group_id="%d">' . PHP_EOL, 
				$group_id
			);
		}
		printf('    <li data-id="%d">%s</li>' . PHP_EOL, $row['id'], $roe['name']);
	}
	
	printf('</ul>');
}

<?php 
	if (is_array($this->product->extra_field)){
		foreach($this->product->extra_field as $extra_field){
			if ($extra_field["id"] == 1){
				print $extra_field['value'];
			}
		}
	// } - here is error 
	}else{ 
		print $this->product->description; 
	} 
?>

<?php

$week_days = [
    "Воскресенье",
    "Понедельник",
    "Вторник",
    "Среда",
    "Четверг",
    "Пятница",
    "Суббота",
];

date_default_timezone_set("Europe/Moscow");
$startdate = strtotime("first day of +2 month");
$month = date("m", $startdate);
if ($month == 03) {
    echo "Март" . "\n";
}
$enddate = strtotime("last day of +2 month");
$array = [];
for ($i = $startdate; $i <= $enddate; $i += 86400) {
    $array[] = date("d ", $i) . $week_days[date("w", $i)];
}

foreach ($array as $row) {
    echo $row . "\n";
}

?>

$res = array_filter(
	$arr,
	fn($el)=>$el['$']==='nginx'
);

print_r($res);

$sql = "CREATE TABLE таблица1(
    id INTEGER PRIMARY KEY,
    col1 INT,
    col2 TEXT
);";
 
$db->exec($sql);

$sql = "INSERT INTO таблица1(col1, col2) VALUES 
	('aaaa', 'bbbbb'),
	('xxx', 'yyy');";

$db->exec($sql);

$sql = "SELECT * FROM таблица1;";  

$result = $db->query($sql);

while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
	$array[] = $row;
}
print json_encode($array);

class Stopwatch 
{
	private $mysqli;
	private $stopwatch_id;
	private $db;
	
	function __construct($mysqli, $stopwatch_id) 
    {
        $this->db = $_ENV['BD_NAME'];
       	$this->mysqli = $mysqli;
        $this->stopwatch_id = $stopwatch_id;
    }
	
	public function start()
    {
        $timestamp = time();
        $query = "
            INSERT INTO `$this->db`.`stopwatch` (`chat_id`, `timestamp`)
            VALUES (?, ?)
            ON DUPLICATE KEY UPDATE timestamp = ?
        ";
        $stmt = $this->mysqli->prepare($query);

        /* bind parameters for markers */
        $stmt->bind_param("iii", $this->stopwatch_id, $timestamp, $timestamp);

        /* execute query */
        return $stmt->execute();
    }
}

$citys = mysqli_query($connect, "SELECT * FROM `city`");
$citys = mysqli_fetch_all($citys);
echo '<select name="magaz">' . PHP_EOL;
foreach ($citys as $city) {
    echo '<option value=' . $city[0] . '>' . $city[1] . '</option>' . PHP_EOL;
}
echo '</select>' . PHP_EOL;

$query = "SELECT  * FROM `mytable` ";
$result = $mysqli->query($query);
$rows = $result->fetch_all(MYSQLI_ASSOC);

$MyListArray = [];

while ($row = $queryResult->fetch_assoc()) {
	$MyListArray[] = $row;
};

function cmp_function_desc($a, $b){
  return ($b['status'] <=> $a['status']);
}

uasort($banks['bank'], 'cmp_function_desc');
print_r($banks);

echo ($osName == 'Mac' || $osName == 'Linux') ? $auto_link[$osName] : $auto_link['Default'];

echo in_array($osName,['Mac', 'Linux']) ? $auto_link[$osName] : $auto_link['Default'];

echo json_encode(array('status'=>$status'result_code'=>$result_code));

echo json_encode(array('status'=>$status, 'result_code'=>$result_code));

<?php
class A
{
	protected $sql = null;
	
	public function setSQL()
    {
        $this->sql = "SELECT * FROM users WHERE id = 123";
        return $this;
    }
	
	public function getSQL()
    {
        return $this->sql;
    }
}

class B extends A
{
    public function addSQL()
    {
        $this->sql .= " AND name = 'Alex'";
		
		return $this;
    }
}
$a = new A();
$b = new B();

echo $b->setSQL()->addSQL()->getSQL();