pages = info["query"]["pages"]
for page_id, page_data in pages.items():
... # что-то делаешь с page_id и page_data
pages = info["query"]["pages"]
if pages: # есть что-то в словаре?
page_data = list(pages.values())[0]
... # работаешь с page_data
я считаю их нетНапрасно.
WITH RECURSIVE `cte` AS (
SELECT `id`, `parent_id`, `comment`,
CAST(RIGHT(CONCAT('0000', `id`), 4) AS CHAR(256)) AS `path`
FROM `comments`
WHERE `parent_id` = 0
UNION
SELECT `c`.`id`, `c`.`parent_id`, `c`.`comment`,
CONCAT(`cte`.`path`, '/', RIGHT(CONCAT('0000', `c`.`id`), 4)) AS `path`
FROM `cte`
JOIN `comments` AS `c` ON `c`.`parent_id` = `cte`.`id`
)
SELECT *
FROM `cte`
ORDER BY `path`
WITH RECURSIVE
cte AS (
SELECT *, LPAD(id, 10, '0') path
FROM comments
WHERE parent_id = 0
UNION ALL
SELECT comments.*, CONCAT(cte.path, LPAD(comments.id, 10, '0'))
FROM comments
JOIN cte ON cte.id = comments.parent_id
)
SELECT id, parent_id, content
FROM cte
ORDER BY path;
def UPD_in_db(condition, **kwargs):
with sqlite3.connect('baza.sql') as conn:
with conn.cursor() as cur:
items = kwargs.items() # Для совместимости со старыми версия Python, у которых несортированный словарь
statement = 'UPDATE users SET ' + ', '.join(k + ' = ?' for k, v in items) + ' WHERE gi = ?'
params = tuple(v for k,v in items) + (condition,)
cur.execute(statement, params)
conn.commit()
UPD_in_db(99938, name='John', ank='lalala')
$list = ["openInventory" => [
"name" => "Taking Inventory",
"requires" => []
];
public function __construct(Server $O8666750554638273663) {
goto O1970219884901744879;
O6505149678668561343:
$O1777212593691497481 = @fopen($this->path, "wb");
goto O4083818622447351734;
O3393899177948378635:
$this->fp = $O1777212593691497481;
goto O0537484758143303834;
O8048393773490650940:
$this->encodeData();
goto O2278372111902823051;
O2791274778590356360:
$this->generalData();
goto O8382244228756303546;
O1005405451303321896:
$this->data["time"] = $this->time;
goto O6370898434236048902;
O8942154602257954378:
Call to a member function bind_param() on booleanГде вызывается bind_param()?
$stmt->bind_param("ssisss", $plaintiffs_json, $respondents_json, $type, $reason, $petition, $video);
Где stmt получает значение?$stmt = $conn->prepare("INSERT INTO `cases`(`nickname`, `respondent`, `type`, `reason`, `petition`, `video`) VALUES (?, ?, ?, ?, ?, ?)");
В каком случае prepare может вернуть значение типа boolean?mysqli_prepare() returns a statement object or false if an error occurred.Вывод - при вызове prepare возникает ошибка.
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);