note 130079 added to refs.database
| From: | mmax21671@gmail.com | Date: | Fri, 28 Feb 2025 10:45:17 +0000 |
| Subject: | note 130079 added to refs.database | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-221905@lists.php.net to get a copy of this message | ||
<div class="container mt-4">
<form method="GET" class="mb-4">
<div class="input-group">
<input type="text" name="search"
class="form-control" placeholder="customerName suchen..." value="<?php
echo isset($_GET['search']) ? htmlspecialchars($_GET['search']) : '';
?>">
<button class="btn btn-primary"
type="submit">Suchen</button>
<input type="text" name="search1"
class="form-control" placeholder="customerNumber suchen..." value="<?php
echo isset($_GET['search1']) ? htmlspecialchars($_GET['search1']) :
''; ?>">
<button class="btn btn-primary"
type="submit">Suchen</button>
<button class='btn btn-danger' type="button"
onclick="window.location.href='test.php'">Reset</button>
</div>
</form>
</div>
<?php
//Search
$search = isset($_GET['search']) ? $_GET['search'] : '';
$search1 = isset($_GET['search1']) ? $_GET['search1'] : '';
$sql = "SELECT * FROM customers WHERE 1=1";
if (!empty($search)) {
$sql .= " AND customerName LIKE :search";
}
if (!empty($search1) && is_numeric($search1)) {
$sql .= " AND customerNumber = :search1";
}
$stmt = $conn->prepare($sql);
if (!empty($search)) {
$stmt->bindValue(':search', "%$search%", PDO::PARAM_STR);
}
if (!empty($search1) && is_numeric($search1)) {
$stmt->bindValue(':search1', $search1, PDO::PARAM_INT);
}
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
// sortieren
if(isset($_GET['customerNumber'])){
$stmt = $conn->query("SELECT * FROM customers ORDER BY customerNumber
ASC");
}
if(isset($_GET['customerName'])){
$stmt = $conn->query("SELECT * FROM customers ORDER BY customerName");
}
if(isset($_GET['contactLastName'])){
$stmt = $conn->query("SELECT * FROM customers ORDER BY contactLastName");
}
if(isset($_GET['contactFirstName'])){
$stmt = $conn->query("SELECT * FROM customers ORDER BY contactFirstName");
}
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
$conn = null;
?>
----
Server IP: 45.112.84.4
Probable Submitter: 80.90.5.137 (proxied: 193.170.70.42)
----
Manual Page -- https://php.net/manual/en/refs.database.php
Edit -- https://main.php.net/note/edit/130079
Del: integrated -- https://main.php.net/note/delete/130079/integrated
Del: useless -- https://main.php.net/note/delete/130079/useless
Del: bad code -- https://main.php.net/note/delete/130079/bad+code
Del: spam -- https://main.php.net/note/delete/130079/spam
Del: non-english -- https://main.php.net/note/delete/130079/non-english
Del: in docs -- https://main.php.net/note/delete/130079/in+docs
Del: other reasons-- https://main.php.net/note/delete/130079
Reject -- https://main.php.net/note/reject/130079
Search -- https://main.php.net/manage/user-notes.php