[PHP-NOTES] note 130194 added to configuration

[email protected] ("Anonymous") Fri, 28 Mar 2025 07:48:20 +0000 (UTC)
Newsgroups	php.notes
Message-ID	<[email protected]>
<?php
session_start();
$servername = "mysql";
$username = "root";
$password = "htlkrems";
 
try {
  $conn = new PDO("mysql:host=$servername;dbname=classicmodels", $username, $password);
  // set the PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  //echo "Connected successfully";
} catch(PDOException $e) {
  echo "Connection failed: " . $e->getMessage();
}
 
 
$conn->query("SET FOREIGN_KEY_CHECKS = 0");
$suchen="";
if(isset($_GET['suchen'])){
    $suchen=$_GET['suchen'];
    $_SESSION['suchen']=$suchen;
}else{if(isset($_SESSION['suchen'])){
    $suchen =$_SESSION['suchen'];
}}
 
$order="employeeNumber";
if(isset($_GET['order'])){
    $order=$_GET['order'];
    $_SESSION['order']=$order;
}else{if(isset($_SESSION['order'])){
    $order =$_SESSION['order'];
}}
 
 
if(isset($_GET['lo'])){
    $lo=$_GET['lo'];
    $stmt=$conn->query("DELETE from employees where employeeNumber like '$lo'");
}
 
if(isset($_GET['delSub'])){
    if(isset($_GET['del'])&&is_array($_GET['del'])){
        $delid=$_GET['del'];
        foreach($delid as $del){
        $stmt=$conn->query("DELETE from employees where employeeNumber like '$del'");
        }
    }
}
 
$stmt=$conn->query("SELECT * from employees where lastName like '$suchen%' order by $order");
$result=$stmt->fetchAll(PDO::FETCH_ASSOC);
 
?>
 
<!DOCTYPE html>
<html>
<head>
<title>Employees</title>
</head>
<body>
 
<h1>Employees</h1>
<table>
    <thead>
        <tr>
        <th><a href='?order=employeeNumber'>EmployeeNumber</a></th>
        <th><a href='?order=lastName'>Lastname</a></th>
        <th><a href='?order=firstName'>Firstname</a></th>
        <th></th>
        </tr>
    </thead>
    <body>
        <form action="employees.php">
        <?php
 
        foreach ($result as $row){
            echo "<tr>";
        echo "<td>".$row['employeeNumber']."</td>";
        echo "<td>".$row['lastName']."</td>";
        echo "<td>".$row['firstName']."</td>";
        echo "<td><input type='checkbox' name='del[]' value='".$row['employeeNumber']."'></td>";
        echo "<td><a href='?lo=".$row['employeeNumber']."'>delete</a></td>";
        echo "</tr>";
        }
        ?>
    </body>
</table>
<input type="text" name="suchen">
<button type="submit">Suchen</button>
<button type="submit" name="delSub">Delete</button>
</form>
</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/configuration.php
Edit        -- https://main.php.net/note/edit/130194
Del: integrated  -- https://main.php.net/note/delete/130194/integrated
Del: useless     -- https://main.php.net/note/delete/130194/useless
Del: bad code    -- https://main.php.net/note/delete/130194/bad+code
Del: spam        -- https://main.php.net/note/delete/130194/spam
Del: non-english -- https://main.php.net/note/delete/130194/non-english
Del: in docs     -- https://main.php.net/note/delete/130194/in+docs
Del: other reasons-- https://main.php.net/note/delete/130194
Reject      -- https://main.php.net/note/reject/130194
Search      -- https://main.php.net/manage/user-notes.php