File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/cron/update_contact_validations.php
Back
<?php include_once("../../cfg/db.php"); //2843645245947376 if(isset($argv[1])){ parse_str($argv[1], $params); if(isset($params['apiKey']) && $params['apiKey'] === '2843645245947376'){ $current_date = $db->select("SELECT DATE_FORMAT(NOW(),'%Y-%m-%d')"); $get_uploaded_today = "SELECT c.id, cc.email_1, cc.mobile_phone_1 FROM customer c INNER JOIN customer_contact cc ON cc.customer_id = c.id WHERE DATE_FORMAT(c.date_uploaded, '%Y-%m-%d') = '$current_date' AND c.upload_source = 0"; // echo $get_uploaded_today; return; $variable = $db->sql_query($get_uploaded_today); foreach($variable AS $row){ $id = $row['id']; $email = $row['email_1']; $mobile_number = $row['mobile_phone_1']; $db->sql_query("INSERT INTO `contact_validations` (`customer_id`, `email`, `mobile_number`) VALUES ('$id', '$email', '$mobile_number')"); } } } echo "What are you doing? "; //this will appear if there's an error on param or code ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings