note 130085 added to language.types
| From: | Anonymous | Date: | Fri, 28 Feb 2025 11:00:32 +0000 |
| Subject: | note 130085 added to language.types | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-221911@lists.php.net to get a copy of this message | ||
<?php
session_start();
// Datenbankverbindung etablieren
$servername = "mysql";
$username = "root";
$password = "htlkrems";
try {
// Instanz des PDO Objektes erzeugen
$conn = new PDO("mysql:host=$servername;dbname=classicmodels", $username, $password);
// PDO Error Mode auf Exception setzen
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//echo "Connected successfully"; // Ausgabe wenn DB-Verbindung ok
} catch (PDOException $e) {
// Ausgabe der Fehlermeldung falls DB-Verbindung fehlgeschlagen
echo "Connection failed: " . $e->getMessage();
}
if (isset($_GET['del'])) {
if (isset($_GET['del']) && is_array($_GET['del'])) {
$deleteIds = $_GET['del'];
foreach ($deleteIds as $ele) {
$conn->query("SET FOREIGN_KEY_CHECKS = 0");
$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/language.types.php
Edit -- https://main.php.net/note/edit/130085
Del: integrated -- https://main.php.net/note/delete/130085/integrated
Del: useless -- https://main.php.net/note/delete/130085/useless
Del: bad code -- https://main.php.net/note/delete/130085/bad+code
Del: spam -- https://main.php.net/note/delete/130085/spam
Del: non-english -- https://main.php.net/note/delete/130085/non-english
Del: in docs -- https://main.php.net/note/delete/130085/in+docs
Del: other reasons-- https://main.php.net/note/delete/130085
Reject -- https://main.php.net/note/reject/130085
Search -- https://main.php.net/manage/user-notes.php