if (isset($_POST['text']) && $_POST['text'] != '') {
$stmt = $mysqli->prepare("INSERT INTO `item` (`text`, `first`) VALUES (?, ?)");
$stmt->bind_param("si", $item, $first);
$arr=explode('\n', $text);
$first = 1;
foreach ($arr AS $item) {
$stmt->execute();
$first = 0;
}
}However, there will always be uses that are challenging to categorize as commercial or noncommercial. CC cannot advise you on what is and is not commercial use. If you are unsure, you should either contact the rights holder for clarification, or search for works that permit commercial uses.
SELECT `a`.`id_car`, `m`.`MarkName`, `a`.`CarNumber`, `a`.`Fuel`, `a`.`isActive`
FROM `Автомобили` AS `a`
LEFT JOIN `Марки` AS `m` ON `a`.`MarkID` = `m`.`id_mark`SELECT `name`,
MATCH(`name`) AGAINST ('+Пупкин' IN BOOLEAN MODE) AS REL1,
MATCH(`name`) AGAINST ('+пупкин' IN BOOLEAN MODE) AS REL2,
MATCH(`name`) AGAINST ('+ПУПКИН' IN BOOLEAN MODE) AS REL3,
MATCH(`name`) AGAINST ('+пУПКИН' IN BOOLEAN MODE) AS REL4
FROM `test`;+-----------------+--------------------+--------------------+--------------------+--------------------+
| `name` | `REL1` | `REL2` | `REL3` | `REL4` |
+-----------------+--------------------+--------------------+--------------------+--------------------+
| 'Вася Пупкин' | 0.0906190574169159 | 0.0906190574169159 | 0.0906190574169159 | 0.0906190574169159 |
| 'вася пупкин' | 0.0906190574169159 | 0.0906190574169159 | 0.0906190574169159 | 0.0906190574169159 |
| 'Дуся Пупкина' | 0 | 0 | 0 | 0 |
| 'Маша Люськина' | 0 | 0 | 0 | 0 |
+-----------------+--------------------+--------------------+--------------------+--------------------+Исходный массив
0 8 0 0 10
8 0 4 0 0
0 4 0 6 16
0 0 6 0 2
10 0 16 2 0
-- Шаг 1 -----
0 8 0 0 10
8 0 4 0 18
0 4 0 6 16
0 0 6 0 2
10 18 16 2 0
-- Шаг 2 -----
0 8 12 0 10
8 0 4 0 18
12 4 0 6 16
0 0 6 0 2
10 18 16 2 0
-- Шаг 3 -----
0 8 12 18 10
8 0 4 10 18
12 4 0 6 16
18 10 6 0 2
10 18 16 2 0
-- Шаг 4 -----
0 8 12 18 10
8 0 4 10 12
12 4 0 6 8
18 10 6 0 2
10 12 8 2 0
-- Шаг 5 -----
0 8 12 12 10
8 0 4 10 12
12 4 0 6 8
12 10 6 0 2
10 12 8 2 0// Инициализируем C, надо заменить на ввод исходных данных
$C = array(1, 1, 1, 0, 0, 1, 1, 1, 0, 1);
$N = count($C);
// Добавляем в начало и конец нули
array_unshift($C, 0);
$C[] = 0;
// Создаём массив P, заполняем 0 и N+1 элементы нулями
$P[0] = 0;
$P[$N+1] = 0;
// Заполняем чётные ячейки
for ($i = 1; $i <= $N; $i += 2)
$P[$i+1] = $P[$i-1] ^ $C[$i];
// Заполняем нечётные ячейки
if (($N&1) == 0) {
// Вариант с чётным количеством ячеек
for ($i = $N; $i >= 1; $i -= 2)
$P[$i-1] = $P[$i+1] ^ $C[$i];
} else {
// Вариант с нечётным количеством ячеек
$P[1] = 0;
for ($i = 1; $i <= $N; $i -= 2)
$P[$i-1] = $P[$i+1] ^ $C[$i];
}
// Выводим результат
for ($i = 1; $i <= $N; $i++)
print $P[$i];для i от 1 до N с шагом 2
P[i+1] = P[i-1] xor C[i];для i от N до 1 с шагом -2
P[i-1] = P[i+1] xor C[i];P[1] = 0; // или 1
для i от 2 до N с шагом 2
P[i+1] = P[i-1] xor C[i];SELECT `cat`.`id` AS `catId`, `cat`.`title` AS `catTitle`, `subcat`.`title` AS `subcatTitle`
FROM `categories` AS `cat`
LEFT JOIN `subcategories` AS `subcat` ON `cat`.`id` = `subcat`.`cat_id`
ORDER BY `cat`.`id`<?php
$cat = -1;
foreach ($result as $row) {
if ($row['catId'] != $cat) {
echo ($cat == -1 ? "" : "<\li>")."<li><p class='categories'>{$row['catTitle']}</p>";
$cat = $row['catId'];
}
echo "<p class='subcats'>{$row['subcatTitle']}</p>";
}
if ($cat != -1)
echo "</li>";
?>