Default page

Edit File: update.php

<?php
session_start();
if (!isset($_SESSION['user_email'])) {
    header("Location: login.php");
    exit();
}

// Check if 'id' is set in the URL
if (isset($_GET['id'])) {
    $id = $_GET['id'];

// Database connection (update with your own credentials)
    $servername = "localhost";
    $username = "t001";
    $password = "ZRTsRb6Ycp585AEC";
    $dbname = "t001";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

// Check if the form is submitted
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $aname = $_POST['aname'];
        $amountss = $_POST['amountss'];
        $bname = $_POST['bname'];
        $cname = $_POST['cname'];
        $remark = $_POST['remark'];
        $statuss = $_POST['statuss'];

// Update query
        $sql = "UPDATE caigou SET aname=?, amountss=?, bname=?, cname=?, remark=?, statuss=? WHERE id=?";
        $stmt = $conn->prepare($sql);

if ($stmt === false) {
            die("Error preparing statement: " . $conn->error);
        }

if (!$stmt->bind_param("ssssssi", $aname, $amountss, $bname, $cname, $remark, $statuss, $id)) {
            die("Error binding parameters: " . $stmt->error);
        }

if ($stmt->execute()) {
            echo "Data updated successfully";
            header("Location: index.php");
            exit(); // Ensure no further code is executed
        } else {
            echo "Error updating data: " . $stmt->error;
        }

$stmt->close();
    }

// Retrieve data to display in the form
    $sql = "SELECT * FROM caigou WHERE id=?";
    $stmt = $conn->prepare($sql);

if ($stmt === false) {
        die("Error preparing statement: " . $conn->error);
    }

if (!$stmt->bind_param("i", $id)) {
        die("Error binding parameters: " . $stmt->error);
    }

if (!$stmt->execute()) {
        die("Error executing query: " . $stmt->error);
    }

$result = $stmt->get_result();
    $row = $result->fetch_assoc();

$stmt->close();
    $conn->close();
} else {
    die("No ID parameter provided.");
}
?>

<!DOCTYPE html>
<html lang="zxx">
<head>
    <meta charset="utf-8" />
    <meta http-equiv="x-ua-compatible" content="IE=edge" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0 user-scalable=no" />
    <meta name="description" content="Fully Responsive Admin & Dashboard Template" />
    <meta name="keyword" content="" />
    <meta name="author" content="WRAPCODERS" />

<link rel="preconnect" href="https://fonts.googleapis.com" />
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin />
    <link
      href="https://fonts.googleapis.com/css2?family=Inter:wght@100..900&family=Public+Sans:ital,wght@0,100..900;1,100..900&display=swap"
      rel="stylesheet"
    />

<link
      rel="shortcut icon"
      type="image/x-icon"
      href="assets/images/favicon.ico"
    />

<title>修改数据</title>

<link rel="stylesheet" href="assets/vendors/metismenu/metisMenu.min.css">

<link rel="stylesheet" href="assets/vendors/@flaticon/flaticon-uicons/css/all/all.css">

<link rel="stylesheet" type="text/css" href="assets/css/theme.min.css">

<script src="assets/js/color-modes.min.js"></script>

</head>

<main id="edash-main">
        
        
        
       <?php include 'view/header.php'; ?>

<div
          class="edash-page-container container-xxl"
          id="edash-page-container"
        >
          
          <div class="edash-content-breadcumb row mb-4 mb-md-6 pt-md-2">
            <div class="col-12">
              <div class="d-flex align-items-center justify-content-between">
                <div>
                  <h2 class="h4 fw-semibold text-dark">修改数据</h2>
                  <nav aria-label="breadcrumb">
                    <ol class="breadcrumb mb-0">
                      <li class="breadcrumb-item">
                        <a href="index.php">首页</a>
                      </li>
                      <li class="breadcrumb-item">
                        <a href="">删除</a>
                      </li>
                      <li class="breadcrumb-item active" aria-current="page">
                        修改数据
                      </li>
                    </ol>
                  </nav>
                </div>
                <div class="d-flex align-items-center gap-2">
    <a href="delete.php?id=<?php echo $id; ?>" class="btn btn-md btn-soft-danger" onclick="return confirm('确定要删除吗？')" >删除</a>
</div>

</div>
            </div>
          </div>
          
          
          <div class="edash-content-section row g-3 g-md-4">
            
            
            <div class="col-12">
              <div class="card">
                <div class="card-header">
                  <h4 class="card-title">修改数据</h4>
                </div>
                <div class="card-body">
                  <form class="was-validated" action="" method="post">
                                    <div class="mb-3">
                                        <label class="form-label">产品名称</label>
                                        <input class="form-control" type="hidden" name="id" value="<?php echo htmlspecialchars($row['id']); ?>"/>
                                        <input type="text" class="form-control" id="aname" name="aname" value="<?php echo htmlspecialchars($row['aname']); ?>" required/>
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label">数量</label>
                                        <input type="text" class="form-control" id="amountss" name="amountss" value="<?php echo htmlspecialchars($row['amountss']); ?>" required/>
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label">品牌名称</label>
                                        <input type="text" class="form-control" id="bname" name="bname" value="<?php echo htmlspecialchars($row['bname']); ?>" />
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label">叫货公司</label>
                                      
    <select class="form-select" id="cname" name="cname">
    <option value="S.J" <?php echo ($row['cname'] === 'S.J') ? 'selected' : ''; ?>>S.J</option>
    <option value="grand" <?php echo ($row['cname'] === 'grand') ? 'selected' : ''; ?>>grand</option>
    <option value="新利华" <?php echo ($row['cname'] === '新利华') ? 'selected' : ''; ?>>新利华</option>
     <option value="Fresh Green" <?php echo ($row['cname'] === 'Fresh Green') ? 'selected' : ''; ?>>Fresh Green</option>
     <option value="面点" <?php echo ($row['cname'] === '面点') ? 'selected' : ''; ?>>面点</option>

<option value="自购" <?php echo ($row['cname'] === '自购') ? 'selected' : ''; ?>>自购</option>
</select>
                      
                      
                    </div>
                                    
                                    
                                    
                                    
                                    <div class="mb-3">
                                        <label class="form-label">备注</label>
                                        <input type="text" class="form-control" id="remark" name="remark" value="<?php echo htmlspecialchars($row['remark']); ?>" />
                                    </div>
                                    
                    <div class="mb-3">
                      <label for="validationCustom04" class="form-label">状态</label>
                      
                      <select class="form-select" id="statuss" name="statuss">
    <option value="No" <?php echo ($row['statuss'] === 'No') ? 'selected' : ''; ?>>No</option>
    <option value="Yes" <?php echo ($row['statuss'] === 'Yes') ? 'selected' : ''; ?>>Yes</option>
</select>
                      
                      
                    </div>
                    
                                    <div class="mb-3">
                                        <button class="btn btn-primary" type="submit">提交修改</button>
                                    </div>
                                </form>
                </div>
              </div>
            </div>
            
          
          </div>
          
        </div>
        
        
        
        
        
        
        <footer
          class="edash-footer-container container-xxl d-flex align-items-center justify-content-between rounded-3 p-4 mx-auto mb-3 ht-64 bg-body-tertiary"
          id="edash-footer-container"
        >
          <div class="hstack">
            <span class="text-muted">
              <script>
                document.write(new Date().getFullYear());
              </script>
              ©
            </span>
            <span class="vr mx-2 bg-body-secondary"></span>
            <a >Expodash</a>
          </div>
          <div class="d-flex align-items-center gap-3">
            <a
              
              class="d-none d-sm-block"
              >Docs</a
            >
            <a  class="d-none d-sm-block"
              >About</a
            >
            <a>Support</a>
            <a
              
              >Purchase</a
            >
          </div>
        </footer>

</main>
      
      
      
      <div class="edash-menu-backdrop" id="edash-menu-hide"></div>
    </div>
    
    
    
    
    
    
    
    <script src="./../assets/js/vendors.min.js"></script>

<script src="./../assets/js/common-init.min.js"></script>

<script>
      // Example starter JavaScript for disabling form submissions if there are invalid fields
      (() => {
        "use strict";

// Fetch all the forms we want to apply custom Bootstrap validation styles to
        const forms = document.querySelectorAll(".needs-validation");

// Loop over them and prevent submission
        Array.from(forms).forEach((form) => {
          form.addEventListener(
            "submit",
            (event) => {
              if (!form.checkValidity()) {
                event.preventDefault();
                event.stopPropagation();
              }

form.classList.add("was-validated");
            },
            false
          );
        });
      })();
    </script>
  </body>
</html>