File "bio_totto.php"

Full path: /home/julaysp1/public_html/admin/order/insert/bio_totto.php
File size: 1.39 B
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor &nnbsp; Back

<?php
header('Content-Type: application/json');

include_once("../../includes/configuration.php");

// Get the JSON input from the AJAX request
$data = json_decode(file_get_contents('php://input'), true);

if (isset($data['id']) && isset($data['bio_totto'])) {
    $orderId = $data['id'];
    $bioTotto = $data['bio_totto'];
    $status = "success"; // Assign status to a variable

    // Prepare the SQL query to update the bio_totto field
    $sql = "UPDATE order_list SET bio_totto = ?, status = ? WHERE id = ?";

    if ($stmt = $conn->prepare($sql)) {
        $stmt->bind_param('ssi', $bioTotto, $status, $orderId); // Bind the parameters (string, string, integer)
        
        if ($stmt->execute()) {
            // Return a success response
            echo json_encode(['status' => 'success', 'message' => 'Bio Totto updated successfully.']);
        } else {
            // Return an error response if the query fails
            echo json_encode(['status' => 'error', 'message' => 'Failed to update Bio Totto.']);
        }

        $stmt->close();
    } else {
        // Return an error response if the SQL statement couldn't be prepared
        echo json_encode(['status' => 'error', 'message' => 'Database error.']);
    }
    
    $conn->close();
} else {
    // Return an error response if required data is missing
    echo json_encode(['status' => 'error', 'message' => 'Invalid input data.']);
}
?>