AWS Mysqli php cronjob Bug fixing - open to bidding
$30-250 USD
착불
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)) {
프로젝트 ID: #13211210
프로젝트 소개
수상자:
hello sir, i can do this and i can start work now pay me after work and after your satisfaction. Thanks
이 일자리에 대한 프리랜서 6 명의 평균 입찰가: $119
Hello Sir, i am having 8 years of exp i have read the project and ready to do work right now...........................
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 기타
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