Functions ¶

Table of Contents ¶

Found A Problem?

Learn How To Improve This Page • Submit a Pull Request • Report a Bug

User Contributed Notes 3 notes

down

2 hours ago

<form action="Ueben4falk.php" method="get">
        <?php
        echo "<input type='text' name='inp' value='$displayText'>";
        ?>
        <button type="submit">Submit</button>
    </form>
 
    <!-- Bearbeitungsformular -->
    <?php
    if (isset($_GET['edit'])) {
        $editCode = $_GET['edit'];
        $editStmt = $conn->query("SELECT * FROM products WHERE productCode = '$editCode'");
        $editRow = $editStmt->fetch(PDO::FETCH_ASSOC);

        if ($editRow) {
            echo "<h3>Produkt bearbeiten</h3>";
            echo "<form method='get'>";
            echo "<input type='hidden' name='update' value='1'>";
            echo "<input type='hidden' name='productCode' value='" . $editRow['productCode'] . "'>";
            echo "Name: <input type='text' name='productName' value='" . $editRow['productName'] . "'><br>";
            echo "Preis: <input type='text' name='buyPrice' value='" . $editRow['buyPrice'] . "'><br>";
            echo "<input type='submit' value='Ändern'>";
            echo "</form>";
        }
    }
    ?>

</body>
</html>

down

leonfalk at icloud dot com ¶

2 hours ago

<?php
                    foreach($result as $row){
                        echo "<tr>";
                        echo "<td>" . $row["productName"] . "</td>";
                        echo "<td>" . $row["productScale"] . "</td>";
                        echo "<td>" . $row["buyPrice"] . "</td>";

                        echo "<td><a href='?id=" . $row["productCode"] . "'>Delete</a></td>";
                        echo "<td><input type='checkbox' name='del[]' value='" . $row["productCode"] . "'></td>";
                        echo "<td><a href='?edit=" . $row['productCode'] . "'>Bearbeiten</a></td>";
                        echo "</tr>";                   
?>

down

leonfalk08 at icloud dot com ¶

2 hours ago

<?php
session_start();
$servername = "mysql";
$username = "root";
$password = "htlkrems";

try {
  $conn = new PDO("mysql:host=$servername;dbname=classicmodels", $username, $password);
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  echo "Connected successfully";
} catch(PDOException $e) {
  echo "Connection failed: " . $e->getMessage();
}

$displayText = "";
if(isset($_GET["inp"])){
    $_SESSION["inp"] = $_GET["inp"];
}

$conn->query("SET FOREIGN_KEY_CHECKS = 0");

if(isset($_GET["id"])){
    $delId = $_GET["id"];
    $stmt = $conn->query("DELETE FROM products WHERE productCode LIKE '$delId'");
}

if(isset($_GET["del"]) && is_array($_GET["del"])){
    $delIdarr = $_GET["del"];
    foreach($delIdarr as $arr){
        $stmt = $conn->query("DELETE FROM products WHERE productCode LIKE '$arr'");
    }
}

if(isset($_SESSION["inp"])){
    $displayText["inp"] = $_SESSION["inp"];
    $stmt = $conn -> query("SELECT * FROM products WHERE productName LIKE '$displayText%'");
}
else{
    $stmt = $conn -> query("SELECT * FROM products");
}

if (isset($_GET['update']) && isset($_GET['productCode']) && isset($_GET['productName']) && isset($_GET['buyPrice'])) {
    $code = $_GET['productCode'];
    $name = $_GET['productName'];
    $price = $_GET['buyPrice'];

    $conn->query("UPDATE products SET productName='$name', buyPrice='$price' WHERE productCode='$code'");
    header("Location: Ueben.php"); // Reload, damit das Formular verschwindet
    exit;
}

if(isset($_GET["product"])){
    $stmt = $conn->query("SELECT * FROM products ORDER BY productName");
}
if(isset($_GET["scale"])){
    $stmt = $conn->query("SELECT * FROM products ORDER BY productScale");
}
if(isset($_GET["price"])){
    $stmt = $conn->query("SELECT * FROM products ORDER BY buyPrice");
}

$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

＋add a note