📁 File Manager
Editing:
/home/wedigitalindia/public_html/demo.wedigitalindia.com/dcl-erp/asset-edit.php
<?php session_start(); require_once "config.php"; ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); // Function to sanitize input function sanitizeInput($input) { return htmlspecialchars(strip_tags(trim($input))); } // Check if asset_id is set if (isset($_GET['id'])) { $asset_id = sanitizeInput($_GET['id']); // Fetch asset details $sql = "SELECT id, name, type, serial_no, model_no, assigned_to, date, description, status FROM assets WHERE id = ?"; if ($stmt = mysqli_prepare($conn, $sql)) { mysqli_stmt_bind_param($stmt, "i", $asset_id); if (mysqli_stmt_execute($stmt)) { mysqli_stmt_bind_result($stmt, $id, $name, $type, $serial_no, $model_no, $assigned_to, $assigned_date, $description, $status); mysqli_stmt_fetch($stmt); } else { echo "Error: " . mysqli_error($conn); exit(); } mysqli_stmt_close($stmt); } else { echo "Error: " . mysqli_error($conn); exit(); } } else { echo "Invalid asset ID."; exit(); } include_once("include/head.php"); ?> <div class="main-panel"> <div class="content-wrapper"> <div class="card"> <div class="card-body"> <div class="row"> <div class="col-md-3"> <h4 class="card-title">EDIT ASSET</h4> </div> </div> <div class="row"> <div class="col-12"> <form class="cmxform" id="commentForm" method="post" action="process_assets.php?action=edit" enctype="multipart/form-data"> <fieldset> <input type="hidden" name="asset_id" value="<?php echo $id; ?>"> <div class="row"> <div class="form-group col-md-6"> <label for="asset_name">Asset Name</label> <input class="form-control" type="text" name="asset_name" value="<?php echo $name; ?>" required> </div> <div class="form-group col-md-6"> <label for="asset_type">Type</label> <select id="asset_type" class="form-control" name="asset_type" required> <option value="">Choose Type</option> <option value="A" <?php if ($type == 'A') echo 'selected'; ?>>A</option> <option value="B" <?php if ($type == 'B') echo 'selected'; ?>>B</option> <option value="C" <?php if ($type == 'C') echo 'selected'; ?>>C</option> </select> </div> <div class="form-group col-md-6"> <label for="serial_number">Serial Number</label> <input class="form-control" type="text" name="serial_number" value="<?php echo $serial_no; ?>"> </div> <div class="form-group col-md-6"> <label for="model_number">Model Number</label> <input class="form-control" type="text" name="model_number" value="<?php echo $model_no; ?>"> </div> <div class="form-group col-md-6"> <label for="assigned_to">Assigned To</label> <select id="assigned_to" class="form-control" name="assigned_to"> <option value="">Choose Employee</option> <?php $sql = "SELECT employee_id, first_name, last_name FROM employees"; $result = mysqli_query($conn, $sql); while ($row = mysqli_fetch_assoc($result)) { $selected = ($assigned_to == $row['employee_id']) ? 'selected' : ''; echo '<option value="' . $row['employee_id'] . '" ' . $selected . '>' . $row['first_name'] . ' ' . $row['last_name'] . '</option>'; } ?> </select> </div> <div class="form-group col-md-6"> <label for="assigned_date">Assigned Date</label> <input class="form-control" type="date" name="assigned_date" value="<?php echo $assigned_date; ?>"> </div> <div class="form-group col-md-12"> <label for="description">Description</label> <textarea class="form-control" name="description"><?php echo $description; ?></textarea> </div> <div class="form-group col-md-6"> <label for="status">Status</label> <select id="status" class="form-control" name="status" required> <option value="0" <?php if ($status == '0') echo 'selected'; ?>>Active</option> <option value="1" <?php if ($status == '1') echo 'selected'; ?>>Inactive</option> </select> </div> </div> <input class="btn btn-primary" type="submit" value="Update" name="submit"> </fieldset> </form> </div> </div> </div> </div> </div> </div> <?php include_once("include/footer.php"); ?>
Save
Cancel