Encerrado

Automatic Timed Script PHP

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.

Habilidades: Amazon Web Services, Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: match management, finding match, waste management project, timed, php solve, minute script, php mysql sql example, php script setup, mysql pst, php user management script, pst mysql, php mysql user management setup, 2010 sql web project, run sql script setup project, will automatic, script minute, php code send email mysql, code send email mysql php, mysql php script send email, php automatic email, php mysql user management script, send email script php mysql, pst sql, script run php, code script php mysql

Acerca do Empregador:
( 6 comentários ) Murrieta, United States

ID do Projeto: #3063335

5 freelancers estão ofertando em média $29 para este trabalho

newgroup4u

See private message.

$34 USD in 14 dias
(134 Comentários)
7.4
toinnisfreesl

See private message.

$34 USD in 14 dias
(37 Comentários)
5.3
sunmicrosof

See private message.

$32.3 USD in 14 dias
(12 Comentários)
4.9
deadwire

See private message.

$8.5 USD in 14 dias
(52 Comentários)
4.5
homi12345

See private message.

$34 USD in 14 dias
(9 Comentários)
2.7