[PHP-NOTES] 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