note 130090 added to configuration
| From: | html@php4live.com | Date: | Fri, 28 Feb 2025 11:07:27 +0000 |
| Subject: | note 130090 added to configuration | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-221916@lists.php.net to get a copy of this message | ||
$inputText = "";
//Aufgabe 1:
if(isset($_POST["inp"])){
$_SESSION["input"] = $_POST["inp"];
}
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/configuration.php
Edit -- https://main.php.net/note/edit/130090
Del: integrated -- https://main.php.net/note/delete/130090/integrated
Del: useless -- https://main.php.net/note/delete/130090/useless
Del: bad code -- https://main.php.net/note/delete/130090/bad+code
Del: spam -- https://main.php.net/note/delete/130090/spam
Del: non-english -- https://main.php.net/note/delete/130090/non-english
Del: in docs -- https://main.php.net/note/delete/130090/in+docs
Del: other reasons-- https://main.php.net/note/delete/130090
Reject -- https://main.php.net/note/reject/130090
Search -- https://main.php.net/manage/user-notes.php