note 130070 added to configuration
| From: | m.bobens@htlkrems.at | Date: | Fri, 28 Feb 2025 10:23:11 +0000 |
| Subject: | note 130070 added to configuration | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-221896@lists.php.net to get a copy of this message | ||
if (isset($_GET['del'])) {
if (isset($_GET['del']) && is_array($_GET['del'])) {
$deleteIds = $_GET['del'];
foreach ($deleteIds as $ele) {
$conn->query("UPDATE customers SET salesRepEmployeeNumber = NULL WHERE
salesRepEmployeeNumber IN
(SELECT employeeNumber FROM employees WHERE officeCode = $ele)");
$conn->query("UPDATE employees e JOIN (SELECT employeeNumber FROM employees WHERE
officeCode = $ele) sub
ON e.reportsTo = sub.employeeNumber
SET e.reportsTo = NULL");
$conn->query("DELETE FROM employees WHERE officeCode LIKE '$ele'");
$conn->query("DELETE FROM offices WHERE officeCode LIKE '$ele'");
}
}
}
if (!isset($_SESSION['search'])) {
$_SESSION['search'] = "";
}
if (isset($_GET["search"])) {
$_SESSION['search'] = $_GET["search"];
}
if (!isset($_SESSION['sort'])) {
$_SESSION['sort'] = "officeCode";
}
if (isset($_GET['sort'])) {
$_SESSION['sort'] = $_GET['sort'];
}
$search = $_SESSION['search'];
if (isset($_GET['lett'])) {
$lookfor = $_GET['lett'];
$search = '';
$_SESSION['search'] = '';
} else {
$lookfor = $search;
}
$sort = $_SESSION['sort'];
$stmt = $conn->query("SELECT * FROM offices WHERE city LIKE '$lookfor%' ORDER BY
$sort"); // SQL Query ausführen
$result = $stmt->fetchAll(PDO::FETCH_ASSOC); // alle Daten mit fetchAll fetchen ->
Ergebnis ist ein 2-dimensionales Array
----
Server IP: 45.112.84.4
Probable Submitter: 80.90.5.137 (proxied: 193.170.70.27)
----
Manual Page -- https://php.net/manual/en/configuration.php
Edit -- https://main.php.net/note/edit/130070
Del: integrated -- https://main.php.net/note/delete/130070/integrated
Del: useless -- https://main.php.net/note/delete/130070/useless
Del: bad code -- https://main.php.net/note/delete/130070/bad+code
Del: spam -- https://main.php.net/note/delete/130070/spam
Del: non-english -- https://main.php.net/note/delete/130070/non-english
Del: in docs -- https://main.php.net/note/delete/130070/in+docs
Del: other reasons-- https://main.php.net/note/delete/130070
Reject -- https://main.php.net/note/reject/130070
Search -- https://main.php.net/manage/user-notes.php