prepare("SELECT id FROM users WHERE store_type != 5");
$result = $users->execute();
$group_id = uniqid(time());
if ($result) {
while ($user = $result->fetchArray(SQLITE3_ASSOC)) {
$account_id = $user['id'];
$stmt = $dbpans->prepare("INSERT INTO notification (title, message, account_id, link,group_id) VALUES (:title, :message, :account_id, :link, :group_id)");
$stmt->bindParam(':title', $title);
$stmt->bindParam(':message', $message);
$stmt->bindParam(':link', $link);
$stmt->bindParam(':account_id', $account_id);
$stmt->bindParam(':group_id', $group_id);
$stmt->execute();
}
} else {
echo "Erro ao buscar usuários.";
}
?>
\r\n\$(\"#search\").keyup(function () {\r\n var value = this.value.toLowerCase().trim();\r\n\r\n \$(\"table tr\").each(function (index) {\r\n if (!index) return;\r\n \$(this).find(\"td\").each(function () {\r\n var id = \$(this).text().toLowerCase().trim();\r\n var not_found = (id.indexOf(value) == -1);\r\n \$(this).closest('tr').toggle(!not_found);\r\n return not_found;\r\n });\r\n });\r\n});\r\n\n \n \n\n