AWS Mysqli php cronjob Bug fixing - open to bidding

완료 등록 시간: 7년 전 착불
완료 착불

that is a onedayb4 app to send with a cronjob email and sms one day b4 the event

and the send now is functional

but the cronjob is the problem

okay {[{[url removed, login to view]()}]}

but it is an AWS Server and the cronjob is every hour

repeating

1 * * * * php /var/www/html/[url removed, login to view]

you know what i mean?

that is the [url removed, login to view]

<?php

require('[url removed, login to view]');

require_once('[url removed, login to view]');

require_once('[url removed, login to view]');

$connection = getConnection();

$event_exists_result = mysqli_query($connection, "SELECT * FROM events, invitees, notifications WHERE [url removed, login to view] = [url removed, login to view] AND [url removed, login to view] = [url removed, login to view] AND [url removed, login to view] > now()");

//$event_exists_result = mysqli_query($connection, "SELECT * FROM events, invitees, notifications WHERE [url removed, login to view] = [url removed, login to view] AND [url removed, login to view] = [url removed, login to view] AND [url removed, login to view] > now() AND [url removed, login to view] < timestampadd(hour, 23, now())");

if (mysqli_num_rows($event_exists_result) > 0) {

//mailNotification('[url removed, login to view]@[url removed, login to view]', 'Harry3', 'datetime', 'cron job run successfully.');//loeschen

while($row = mysqli_fetch_assoc($event_exists_result)) {

$user_query_result = mysqli_query($connection, "Select * from users where id=".$row['userId']);

$user = mysqli_fetch_assoc($user_query_result);

$number_of_emails_sent = $user['week_emails_sent'];

$datetime = DateTime::createFromFormat('Y-m-d H:i', $row['eventDate']);

$datetime->modify("+".$row['eventDuration']." minutes");

$event_end_time = $datetime->format('Y-m-d H:i');

$time_str = "From ".DateTime::createFromFormat('Y-m-d H:i', $row['eventDate'])->format('Y-m-d H:i')." to ".$event_end_time;

if($row['sendEmail'] = 1 && $row['inviteeEmail'] != ""){

mailNotification($row['inviteeEmail'], $row['inviteeFirstName'],$row['inviteeLastName'], $time_str, $row['msgForInvitee']);

}

//

$sms_product_query = mysqli_query($connection, "Select * from sms_product where user_id=".$row['userId']);

$buy_id = null;

if (mysqli_num_rows($sms_product_query) >0){

$sms_row = mysqli_fetch_assoc($sms_product_query);

$sms_limit_left = $sms_row['sms_total'] - $sms_row['sms_sent'];

$buy_id = $sms_row['id'];

$sms_sent = $sms_row['sms_sent'];

}

else{

$sms_limit_left = WEEKLY_SMS_LIMIT - $user['week_sms_sent'];

$sms_sent = $user['week_sms_sent'];

}

if( ($row['inviteeContactNumber'] != "" || $row['inviteeContactNumber'] != "0") && $sms_limit_left>0){

$text = "Hi ".$row['inviteeFirstName'].' '.$row['inviteeLastName'].", \n\n\n Event Time: " .$time_str." \n\n\n " .$row['msgForInvitee'] ." \n\n\n Thanks \n Team OneDayB4";

send_sms($row['inviteeContactNumber'], $text);

$sms_sent = $sms_sent + 1;

if($buy_id){

mysqli_query($connection, "Update sms_product set sms_sent=".$sms_sent." where id=".$buy_id);

}else{

mysqli_query($connection, "Update users set week_sms_sent=".$sms_sent." where id=".$row['userId']);

}

}

}

}

//mailNotification('[url removed, login to view]@[url removed, login to view]', 'Asher', 'datetime', 'cron job run successfully.');

//mailNotification('[url removed, login to view]@[url removed, login to view]', 'Harry', 'datetime', 'cron job run successfully.');

mysqli_close($connection);

?>

but that is not true :

while($row = mysqli_fetch_assoc($event_exists_result)) {

CSS HTML HTML5 PHP 워드프레스

프로젝트 ID: #13211210

프로젝트 소개

6 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 7년 전

수상자:

SPPresita

hello sir, i can do this and i can start work now pay me after work and after your satisfaction. Thanks

$30 USD (3일 이내)
(0건의 리뷰)
0.0

이 일자리에 대한 프리랜서 6 명의 평균 입찰가: $119

aryan151

Hello Sir, i am having 8 years of exp i have read the project and ready to do work right now...........................

$30 USD (3일 이내)
(0 리뷰)
0.0
arifjaunpur

Hello, I am Sr. web developer have strong debugging and coding skills. I am full stack developer with good knowledge of Java, PHP, JavaScript, MySQL, MongoDB, AngularJS, JQuery, HTML, Bootstrap, etc. I have creat 기타

$100 USD (1일 이내)
(0 리뷰)
0.0
neoconcepts

Hi, I am an expert in website designing and I can Develop sites in Wordpress, Magento and Core PHP. I am ready to start your project. i will give you quality work within given time frame

$200 USD (3일 이내)
(0 리뷰)
0.0