Some MySQL/ php fun with dates/ date modification no external code needed beyond description below

I have this table:

[login to view URL]

Go through each item line per line and select matching deals using airport code fromCode and toCode (there are three, use all three 'ANY' please).

Example fromCode SFO


The deals come from a table like this:

[login to view URL]

Look for any deal that has a fromCode SFO and a toCode LAX OR SAN OR JFK in that table.

Each line in table above has one of these three modes.

Mode 1 - Weekends (is_weekend =1):

[login to view URL]

Find all Thursdays - Sunday date combinations that are after 'start' and before 'end'. If 'start' is '0000-00-00' use any start date. If end is '0000-00-00' use one year from now.

Insert each matching airportCode combinations and multiply with each Date combination into table mightyDeals.

i.e. insert SFO-LAX 2019-09-09 - 2019-09-12 (doe the same for each combination of route and dates)

Mode 2 - Holidays (is_holiday=1)

Find all holiday dates for the country and current plus year +1. i.e. 2019 and 2020

Use this table:

[login to view URL]

Insert each matching airportCode combinations and multiply with each Date combination into table mightyDeals.

Save into related_dates and add travel_assistant_id.

Mode 3 - Fixed Dates (is_specific_date=1)

Only look for specific dates in start and end in table [login to view URL]

Insert each matching airportCode combinations and using the only one Date combination into table mightyDeals.


Evner: MySQL, PHP, SQL

Se mere: insert today date form field mysql php, php example copy date mysql html, save excel date format mysql php, saving system date mysql php, date wise search mysql php ajax, php mysql scripts reports base date range, javascript date picker mysql php, mysql php form insert date, date example database mysql php midlet, mysql php display results date, compare date mysql php, mysql php register date, mysql php date range select, mysql query find saturday date php, save current date time mysql php, mysql php search dates, highcharts date mysql php

Om arbejdsgiveren:
( 186 bedømmelser ) Palo Alto, United States

Projekt ID: #20022761

13 freelancere byder i gennemsnit $57 på dette job


i there I read the job description with interest. Now I am using godaddy and aws hosting . I have skills in HTML5 / CSS3, PHP, javaScpript/ JQuery, PhotoShop and other programming languages and software. I'll be h Flere

$40 USD in 7 dage
(184 bedømmelser)

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

$150 USD in 2 dage
(64 bedømmelser)

Thanks for the job invite. It's a pleasure to meet you and I have read your description carefully and understood. As an web expert. i have strong skills and experiences in web development for 5 years. So i can do yo Flere

$50 USD på 1 dag
(78 bedømmelser)

Hello! I read your description carefully. I've always done my project as the fastest and highest quality. I think your project is best for me. The reason is that I am a Mysql query expert. If you want to check my skill Flere

$25 USD på 1 dag
(17 bedømmelser)

Hello, how are you? Thank you for your opportunity to bid on the project. I have developed web sites for five years, including web scraps, shopping sites, business web apps, and web API integration. So, I can help y Flere

$25 USD på 1 dag
(3 bedømmelser)

Hi, Nice to meet you. :) I have already your description carefully and understood your whole requirements fully. With 6+ years of experience in Web development, I developed a lot of big and small websites using almost Flere

$150 USD in 7 dage
(4 bedømmelser)

Hi, I'm PHP/MySQL developer. I developed many applications. Looking forward to work with you. Regards

$30 USD på 1 dag
(8 bedømmelser)

Dear Hiring Manager! I have seen your job post and gone through your detail project plan. I am ready to work as a Web Developer and I am very much comfortable with theme. Please share complete requirements and best Flere

$25 USD på 1 dag
(2 bedømmelser)

Hello, I hope work with you because my skill set is very suitable to your Job and i can start now. I have been very sure that I can provide you the perfect result of it. As a professional web developer, I can compl Flere

$25 USD på 1 dag
(1 bedømmelse)

Hello, there! I have thoroughly read your job post and I would like to apply for it. I have been working with PHP more than 5 years already and have extensive experience in developing several Framework I'm also exp Flere

$30 USD på 1 dag
(2 bedømmelser)

Hi, The requirement seems to involving MySQL manipulations primarily which is something I am good at and is clear. My experience lies in MySQL database related works and I am confident to fulfil this requirement to Flere

$20 USD på 1 dag
(2 bedømmelser)

*** I have checked your description. I can do your project asap and as well. I want to discuss with you this project. Thanks.

$150 USD på 1 dag
(0 bedømmelser)

Hello, I am a Senior Web developer having excellent experiences in web development. I have been developing many websites for 7+ years and have full experience in developing websites based on your required fields. My s Flere

$20 USD på 1 dag
(0 bedømmelser)