Файловый менеджер - Редактировать - /home/d46091/udyogaadhaar.net/blog-post/images/698279/api.tar
Назад
WebsiteFormFetch.php 0000644 00000007702 15026517472 0010474 0 ustar 00 <?php include_once('../config.php'); date_default_timezone_set('Asia/Kolkata'); $currentTime = date('d-m-Y H:i:s'); $TodayDate = date('d-m-Y'); // $beforeTime = date('d-m-Y H:i:s'); // $sql ="SELECT * FROM msme_form WHERE payment_status = 'Unpaid' AND created_time < (NOW() - INTERVAL 5 MINUTE)ORDER BY id DESC LIMIT 10"; $sql ="SELECT * FROM msme_form WHERE payment_status = 'Unpaid' AND form_created_date ='".$TodayDate."' ORDER BY id DESC LIMIT 10"; $result = $conn->query($sql); while($row = $result->fetch_assoc()){ $data = [ "id" => $row['id'], "fname" => $row["form_name"], "aname" => $row['applicant_name'], "amob" => $row['mobile_number'], "aemail" => $row['email_id'], "office_address" => $row['office_address'], "state" => str_replace('_', ' ',$row['office_state']), "district" => $row['office_district'], "pincode" => $row['pincode'], "social_category" => $row['social_category'], "uam_number" => $row['uam_number'], "pan_card_number" => $row['pan_card_number'], "bank_account_number" => $row['bank_account_numbe'], "ifsc_code" => $row['ifsc_code'], "business_name" => $row['business_name'], "date_of_commencement_of_business" => $row['date_of_commencement_of_business'], "type_of_organisation" => $row['type_of_organisation'], "main_business_activity_of_enterprise" => $row['main_business_activity_of_enterprise'], "additional_details_about_business" => $row['additional_details_about_business'], "persons_employed_male" => $row['persons_employed_male'], "persons_employed_female" => $row['persons_employed_female'], "persons_employed_other" => $row['persons_employed_other'], "persons_employed_total" => $row['persons_employed_total'], "upload_aadhaar_card_front" => $row['upload_aadhaar_card_front'], "upload_aadhaar_card_back" => $row['upload_aadhaar_card_back'], "upload_pan_card_front" => $row['upload_pan_card_front'], "total_amt" => $row['total_amount'], "payment_status" => 'Pending', "order_id" => $row['order_id'], "payment_id" => $row['payment_id'], "gateway" => $row['c_gateway'], "merchant" => $row['c_gateway_merchant'], "created_at" => $row['form_created_on'], "payment_stage" => $row['payment_stage'], "fpage" => 'udyogaadhaar.net' ]; $postArray[] = $data; } // echo $json = json_encode($postArray); ?>