Create basic PHP weekly schedule that stores times/dow as UTC in MySQL but entered in Time Zone of Choice

Imekamilika Ilichapishwa Miaka 5 iliyopita Kulipwa wakati wa kujifungua
Imekamilika Kulipwa wakati wa kujifungua

Write a tiny webapp within 48 hours (please tell me if this is unrealistic before I award you the project).

Page 1: Allow user to enter (Create & Update) a weekly schedule (open/closed) in a selected local time zone and store as UTC into a mysql database. Design your SQL database with the understanding the database will end up storing many other scheduled for other locations.

Page 2: Show status of current time/day of week vs. schedule (True/False) if the current time and day of the week is within the schedule set. (Think like "business is open")

Important: Gracefully handle Saturday/Sunday transition differences between UTC and selected time zone including daylight savings time.

More Details:

I will be paying your through freelancer, don't underbid and ask me to pay direct.

PHP 5.2 - 7.0, must be straight PHP, no frameworks because the plan will be to integrate into codeigniter 3.x when you're complete.

On selection page allow for selection of a 7-day schedule in local time zone: (to be handled by user settings when integrated later). Ensure to take account for daylight savings time based on date.

I've already created an account to a site w/ FTP and a database. You will have to provide a SQL schema (SQL statement or you can do it yourself w/ PHP) because my SQL server is locked and will only allow for certain specific IP addresses to connect to it.

MySQL PHP

Kitambulisho cha Mradi: #18368372

Kuhusu mradi

12 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

micromanagement

Hello, Having read your job description, I feel to be a good fit for this job, as I have hands on experience working on the PHP, CSS, Mysql, HTML, JQuery Frameworks, as well as Major CMS's like Joomla, WordPress an Zaidi

$111 USD kwa siku 3
(Maoni 9)
4.6

12 wafanyakazi huru wanazabuni wastani wa $179 kwa kazi hii

KashirinA

Dear client I have good skills about php and laravel and nodejs If u want me ,I will show good result for u I have good review for u I have rich experience about your job I m very interesting of your job My re Zaidi

$200 USD kwa siku 3
(Maoni 129)
7.4
microwebtechs

Hello sir please reply soon and complete all soon, I will start work right now and complete all soon thanks

$283 USD kwa siku 1
(Maoni 271)
6.8
MyAwesomeTeam

Hello mate, I have ability to do this project: PHP, MySQL I always: -Do project fast as possible. -Charge a reasonable cost. -Provide Quality Product. All my previous project was feedbacked 5 stars. becau Zaidi

$158 USD kwa siku 3
(Maoni 79)
6.3
jarki2017

Hi I've started web development from 2004. I am a monster in PHP/MySQL I can show my MySQL skill in the following. SELECT id, GROUP_CONCAT(res SEPARATOR ' ' ) AS result FROM (SELECT id, field1, lowcase, CONCAT( Zaidi

$155 USD kwa siku 3
(Maoni 38)
6.1
akgarg007

Hi I am a PHP, Laravel developer. [ API INTEGRATION ] I have worked on PHP, Angular5+, HTML5, Laravel, and Codeigniter. I have also worked on many APIs, especially email marketing like Zoho, MailChimp, Salesfo Zaidi

$200 USD kwa siku 5
(Maoni 45)
6.1
bhrugeshpatel

hey i can do that in just 2 day.....but also i can try to complete before....can you ready for the job....i offer you cheap price. thanks

$88 USD kwa siku 2
(Maoni 8)
2.1
chenglin91

Hello. I am senior web developer with 10+ years experience. My main skill is javascript, Hybrid App, Angular, Vue.js, Node, python, Django, Laravel, PHP and so on. I guarantee best result and in time return. I am w Zaidi

$250 USD kwa siku 3
(Maoni 2)
1.3
honey02thakur

Dear As a highly skilled PHP Web Developer, I read your posting for a new PHP Web Developer with interest. My experience aligns well with the qualifications you are seeking at Collaborative Systems, in particular m Zaidi

$140 USD kwa siku 3
(Maoni 0)
0.0