= CURRENT_DATE+\" 00:00:00\" ORDER BY id DESC LIMIT 1"; $result = $conn->query($sql); if ($result->num_rows > 0) { $row = $result->fetch_assoc(); } header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); ini_set('max_execution_time', 10800); $mobile = $row['mobile_number']; $id= $row['id']; $message = urlencode("Your Udyam Registration Application is received and is on hold for NON PAYMENT. Pay now https://pmny.in/vrb0P6D2UoEk to start processing. TXCARE Rgds"); // echo $message; $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, 'http://198.24.149.4/API/pushsms.aspx?loginID=Taxcare69&password=Personal803&mobile='.$mobile.'&text='.$message.'&senderid=BUSREG&route_id=2&Unicode=0&Template_id=1207163774365174110'); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($curl); $sql = " UPDATE msme_form SET is_sms_sent = 'true' WHERE id = '".$id."' "; $result = $conn->query($sql); echo 'update done'; echo'
';