note 130198 added to language.operators

<?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(); } $inputText = ""; //Aufgabe 1: if(isset($_POST["inp"])){ $_SESSION["input"] = $_POST["inp"]; } $conn->query("SET FOREIGN_KEY_CHECKS = 0"); if(isset($_GET['id'])){ $delCode = $_GET['id']; $stmt = $conn->query("DELETE FROM products WHERE productCode like '$delCode'"); } if(isset($_GET['subDel'])) { if (isset($_GET['del']) && is_array($_GET['del'])){ $delID = $_GET['del']; foreach($delID as $del){ $stmt = $conn->query("DELETE FROM products WHERE productCode like '$del'"); } } } if(isset($_SESSION["input"])){ $inputText = $_SESSION["input"]; $stmt = $conn->query("SELECT * FROM products WHERE productName like '$inputText%'"); }else{ $stmt = $conn->query("SELECT * FROM products"); // SQL Query ausführen } if(isset($_GET['productName'])){ $stmt = $conn->query("SELECT * FROM products ORDER BY productName"); // SQL Query ausführen } if(isset($_GET['scale'])){ $stmt = $conn->query("SELECT * FROM products ORDER BY productScale"); // SQL Query ausführen } if(isset($_GET['stock'])){ $stmt = $conn->query("SELECT * FROM products ORDER BY quantityInStock"); // SQL Query ausführen } if(isset($_GET['price'])){ $stmt = $conn->query("SELECT * FROM products ORDER BY buyPrice"); // 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.operators.php Edit -- https://main.php.net/note/edit/130198 Del: integrated -- https://main.php.net/note/delete/130198/integrated Del: useless -- https://main.php.net/note/delete/130198/useless Del: bad code -- https://main.php.net/note/delete/130198/bad+code Del: spam -- https://main.php.net/note/delete/130198/spam Del: non-english -- https://main.php.net/note/delete/130198/non-english Del: in docs -- https://main.php.net/note/delete/130198/in+docs Del: other reasons-- https://main.php.net/note/delete/130198 Reject -- https://main.php.net/note/reject/130198 Search -- https://main.php.net/manage/user-notes.php