prepare($showquery);
$stmt->bind_param("s", $ids); // Changed to "s" for string userid
$stmt->execute();
$result = $stmt->get_result();
if($result && $result->num_rows > 0) {
$arrdata = $result->fetch_assoc();
} else {
echo '';
exit();
}
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$gstin = mysqli_real_escape_string($conn, $_POST['gstin']);
$office = mysqli_real_escape_string($conn, $_POST['office']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$moneyserial = mysqli_real_escape_string($conn, $_POST['moneyserial']);
$consignmentserial = mysqli_real_escape_string($conn, $_POST['consignmentserial']);
$updateQuery = "UPDATE users SET gstin = ?, office = ?, address = ?, consignmentserial = ?, moneyserial = ? WHERE userid = ?";
$stmt = $conn->prepare($updateQuery);
$stmt->bind_param("ssssss", $gstin, $office, $address, $consignmentserial, $moneyserial, $ids);
if ($stmt->execute()) {
echo '';
} else {
error_log("Database Error: " . $conn->error);
echo '';
}
}
}
?>