File "sign_order_pending.php"

Full path: /home/julaysp1/public_html/admin/order/list/sign_order_pending.php
File size: 772 B (772 B bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor &nnbsp; Back

<?php
session_start();
$email = base64_decode($_SESSION["user_id"]);
include_once("../../includes/configuration.php");

// Fetch data from the order_list table
$sql = "SELECT id, email, order_type, user_type, nid, bio_totto, status, received, opinion, order_time 
        FROM order_list 
        WHERE user_type = 'file' 
        AND status = 'pending' 
        AND order_type = 'sign_copy'"; // Only 'sign_copy' will be selected

// Execute the query
$result = $conn->query($sql);

$orders = array();

if ($result->num_rows > 0) {
    // Fetch all rows into an array
    while ($row = $result->fetch_assoc()) {
        $orders[] = $row;
    }
}

// Return data as JSON
echo json_encode($orders);

// Close the connection
$conn->close();
?>