note 130095 added to language.errors
| From: | Anonymous | Date: | Fri, 28 Feb 2025 11:50:17 +0000 |
| Subject: | note 130095 added to language.errors | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-221921@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;
?>
<?php
//Ausgabe:
if(isset($msg)){
echo '<div class="alert alert-success"
role="alert">'.$msg.'</div>';
}
if(count($results) > 0){
echo "<table class='table table-striped'>";
echo "<tr>
<th><a
href='?customerNumber'>customerNumber</a></th>
<th><a
href='?customerName'>customerName</a></th>
<th><a
href='?contactLastName'>contactLastName</a></th>
<th><a
href='?contactFirstName'>contactFirstName</a></th>
<th>Details</th>
<th>Delete</th>
</tr>";
foreach ($results as $row) {
echo "<tr>";
echo "<td>" . $row['customerNumber'] .
"</td>";
echo "<td>" . $row['customerName'] .
"</td>";
echo "<td>" . $row['contactLastName'] .
"</td>";
echo "<td>" . $row['contactFirstName'] .
"</td>";
echo "<td><a href='employeeDetail.php?id=" .
urlencode($row['customerNumber']) . "'>Details</a></td>";
echo "<td><a class='btn btn-danger' role='button'
href='?del=" . $row['customerNumber'].
"'>Delete</a></td>";
echo "</tr>";
}
echo "</tabele>";
}
?>
</body>
</html>
----
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.errors.php
Edit -- https://main.php.net/note/edit/130095
Del: integrated -- https://main.php.net/note/delete/130095/integrated
Del: useless -- https://main.php.net/note/delete/130095/useless
Del: bad code -- https://main.php.net/note/delete/130095/bad+code
Del: spam -- https://main.php.net/note/delete/130095/spam
Del: non-english -- https://main.php.net/note/delete/130095/non-english
Del: in docs -- https://main.php.net/note/delete/130095/in+docs
Del: other reasons-- https://main.php.net/note/delete/130095
Reject -- https://main.php.net/note/reject/130095
Search -- https://main.php.net/manage/user-notes.php