$conditions = [];
$parameters = [];
// conditional statements
if (!empty($_GET['name']))
{
// here we are using LIKE with wildcard search
// use it ONLY if really need it
$conditions[] = 'name LIKE ?';
$parameters[] = '%'.$_GET['name']."%";
}
if (!empty($_GET['age']))
{
// here we are using equality
$conditions[] = 'age = ?';
$parameters[] = $_GET['age'];
}
$sql = "SELECT * FROM users";
// a smart code to add all conditions, if any
if ($conditions)
{
$sql .= " WHERE ".implode(" AND ", $conditions);
}
// the usual prepare/bind/execute/fetch routine
$stmt = $mysqli->prepare($sql);
$stmt->bind_param(str_repeat("s", count($parameters)), ...$parameters);
$stmt->execute();
$b = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
if($b) {
print_r($b);
} else {
echo "0 results";
}
__DIR__ Директория файла. Если используется внутри подключаемого файла, то возвращается директория этого файла.https://www.php.net/manual/ru/language.constants.p...
/((09|10|11|12|13|14|15|16|17|18|19|20|21):([0-5]\d))|(22:00)/
foreach ($n as $values) {
if ($values["PROPERTY_DAYTIME_VALUE"] == 1366 && $values["PROPERTY_TYPE_VALUE"] == 1375) {
$arItem[0]["SUBCATEGORY"][0]["PRODUCTS"][] = $values;
}
}
<?php
$array = ['name' => 'Albert1991'];
// json
var_dump(json_encode($array)); //{"name":"Albert1991"}
// НЕ json, а сериализованный формат php
var_dump(serialize($array)); // a:1:{s:4:"name";s:10:"Albert1991";}
$fields = [
'clientName' => 'name',
'clientPhone' => 'phone',
'clientEmail' => 'email'
];
$where = [];
$resultArr = [];
foreach($fields as $key => $field) {
if($arr[$key]) {
$where[] = "`$field` LIKE ?";
$resultArr[] = '%' . $arr['clientName'] . '%';
}
}
if(count($where) > 0) {
$sql .= ' WHERE ' . implode(' AND ', $where);
}
Possible solutions:
# Reduce memory load on the system
# Increase physical memory or swap space
# Check if swap backing store is full
# Decrease Java heap size (-Xmx/-Xms)
# Decrease number of Java threads
# Decrease Java thread stack sizes (-Xss)
# Set larger code cache with -XX:ReservedCodeCacheSize=
# JVM is running with Zero Based Compressed Oops mode in which the Java heap is
# placed in the first 32GB address space. The Java Heap base address is the
# maximum limit for the native heap growth. Please use -XX:HeapBaseMinAddress
# to set the Java Heap base and to place the Java Heap above 32GB virtual address.