[PHP-NOTES] note 130206 added to language.attributes

<?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();
}
$displaytext="";

if(isset($_POST['inp'])){
  $_SESSION['inp'] = $_POST['inp'];
}
if(isset($_SESSION['inp'])){
    $inputText = $_SESSION['inp'];
    $stmt = $conn->query("SELECT * FROM offices WHERE city LIKE '$inputText%'");   // SQL Query ausführen
    $displaytext = $inputText;
}
elseif(isset($_GET['letter'])){
  $letter = $_GET['letter']; 
  $_SESSION['letter'] = $letter;
  $let = $_SESSION['letter'];
  $stmt = $conn->query("SELECT * FROM offices WHERE city LIKE '$let%'");
}
else{
    $stmt = $conn->query("SELECT * FROM offices");   // SQL Query ausführen
}

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['letter'])){
          $let = $_SESSION['letter'];
          $stmt = $conn->query("SELECT * FROM offices WHERE city LIKE '$let%'");
        }
      }
  }
}

if(isset($_GET['city'])){
  $stmt = $conn->query("SELECT * FROM offices ORDER BY city");   
}
if(isset($_GET['phone'])){
  $stmt = $conn->query("SELECT * FROM offices ORDER BY phone");   
}
if(isset($_GET['adressLine1'])){
  $stmt = $conn->query("SELECT * FROM offices ORDER BY addressLine1");   
}
if(isset($_GET['country'])){
  $stmt = $conn->query("SELECT * FROM offices ORDER BY country");   
}
if(isset($_GET['postalCode'])){
  $stmt = $conn->query("SELECT * FROM offices ORDER BY postalCode");   
}
if(isset($_GET['territory'])){
  $stmt = $conn->query("SELECT * FROM offices ORDER BY territory");   
}

$result = $stmt->fetchAll(PDO::FETCH_ASSOC);      // alle Daten mit fetchAll fetchen -> Ergebnis ist ein 2-dimensionales Array

$_SESSION['res'] = $result;

?>

<div>
        <a href="?letter=A" name="let">A</a>
----
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.attributes.php
Edit        -- https://main.php.net/note/edit/130206
Del: integrated  -- https://main.php.net/note/delete/130206/integrated
Del: useless     -- https://main.php.net/note/delete/130206/useless
Del: bad code    -- https://main.php.net/note/delete/130206/bad+code
Del: spam        -- https://main.php.net/note/delete/130206/spam
Del: non-english -- https://main.php.net/note/delete/130206/non-english
Del: in docs     -- https://main.php.net/note/delete/130206/in+docs
Del: other reasons-- https://main.php.net/note/delete/130206
Reject      -- https://main.php.net/note/reject/130206
Search      -- https://main.php.net/manage/user-notes.php