Find Jobs
Hire Freelancers

Automatic Timed Script PHP

$30-40 USD

Closed
Posted about 14 years ago

$30-40 USD

Paid on delivery
I'm looking for code/script in PHP to help solve this issue. Server is running time at UTC. A web user will have a box for everyday of the week MON-SUN and in that box they can enter a time for everyday to send an email. The web user have there own timezone used so lets say PST -8.? Example: User has entered MON 8:00AM to send the email, all settings are saved in mysql. When it becomes 8AM on monday PST it will send the email. Currently I had a PHP script that will run every minute to check SQL to see if any user has it set for that time. Problem that i'm having is finding a solution since the server is UTC. I would rather not have the script check EVERY user and change to there timezone to check if the times match to sent the email since it feels like a waste. Other methods I have tried have not worked since they never truly go by the Users timezone. The way SQL is setup is every user has an entry and there are 3 columns for everyday of the week like, MON_active, MON_time, MON_content.
Project ID: 3063335

About the project

5 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $29 USD for this job
User Avatar
See private message.
$34 USD in 14 days
4.9 (134 reviews)
7.4
7.4
User Avatar
See private message.
$34 USD in 14 days
4.8 (37 reviews)
5.3
5.3
User Avatar
See private message.
$32.30 USD in 14 days
5.0 (12 reviews)
4.9
4.9
User Avatar
See private message.
$8.50 USD in 14 days
4.9 (52 reviews)
4.5
4.5
User Avatar
See private message.
$34 USD in 14 days
5.0 (9 reviews)
2.7
2.7

About the client

Flag of UNITED STATES
Murrieta, United States
5.0
6
Payment method verified
Member since Oct 30, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.