Default page

Edit File: index1.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'];

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

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

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

if ($stmt->execute()) {
            echo "Data updated successfully";
            header("Location: index.php");
        } 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" />
    <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>Validation | Expodash - Admin & Dashboard Template</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>
  <body>
    
    
    
    <div class="main-wrapper">
      
      
      
      <?php include 'view/aside.php'; ?>
        
  
  
  
  
  
  <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">Validation</h2>
              <nav aria-label="breadcrumb">
                <ol class="breadcrumb mb-0">
                  <li class="breadcrumb-item">
                    <a href="">首页</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=""
                class="btn btn-md btn-soft-danger"
                target="_blank"
                >删除</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']); ?>" required/>
                                </div>
                                <div class="mb-3">
                                    <label class="form-label">公司名称</label>
                                    <input type="text" class="form-control" id="cname" name="cname" value="<?php echo htmlspecialchars($row['cname']); ?>" required/>
                                </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']); ?>" required/>
                                </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 href="mailto:wrapcoders@gmail.com">Expodash</a>
      </div>
      <div class="d-flex align-items-center gap-3">
        <a
          href="./../../docs/documentation.html"
          target="_blank"
          class="d-none d-sm-block"
          >Docs</a
        >
        <a href="wrapcoders@gmail.com" target="_blank" class="d-none d-sm-block"
          >About</a
        >
        <a href="wrapcoders@gmail.com" target="_blank">Support</a>
        <a
          href="https://codecanyon.net/item/expodash-bootstrap-5-admin-dashboard-template/52160996"
          target="_blank"
          >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>