Find Jobs
Hire Freelancers

ASAP - Need a Quick PHP Script to Bulk Insert and Update Dates To a Simple MySQL table

$250-750 USD

Completed
Posted over 2 years ago

$250-750 USD

Paid on delivery
Hi there. I need someone to make me a quick script (just code) for a Core PHP project. I created a Time Slot based feature where Customers can choose an Order Date and Order Time, but the Owner/Store can limit how many orders can be reserved at every 15 minute interval. So, this script you make will help me manage the timeslots faster. The big functionality here is "bulk insert" and "bulk update" with PHP + Jquery or Javascript or Ajax or some combination. My timeslots table looks like this (and I'll give you the .sql file). 1, Mon, 2022-01-10, 4:00 PM, 3, Downtown 2, Mon, 2022-01-10, 4:15 PM, 5, Downtown 3, Mon, 2022-01-10, 4:30 PM, 10, Downtown 4, Mon, 2022-01-10, 4:45 PM, 5, Downtown STEP #1 - BULK INSERT: CREATE THE AVAILABLE DATES (NO MORE THAN 31 DATES FROM TODAY) NOTE: So the Store Owner can basically "schedule" anywhere from 1 day to 31 days ahead. 1. User can choose a start date, like Today or 02/01/2022 (a specific date). Note: I use [login to view URL] for a lot, so please use that. 2. User can choose/input a number of dates, which creates a vertical list of input text boxes (4 input boxes per date, ie. per row). Note: I think I have a feature that uses javascript to create text boxes instantly now, which I love, so maybe you can use javascript. 7 dates would create 7 input text box rows and allow them to take orders for the next 7-day week or 30 would create 30 new input box rows, which would allow them to take orders for the next month. Inputs: Date | Start Time | End Time | Location (ie. 2022-01-10 | 1:00 PM | 3:45 PM | Downtown) - this example row would create 12 new time slots when submitted (1:00 PM, 1:15 PM, 1:30 PM, etc), but if there are more dates, then obviously there will be more timeslots inserted. This example basically means the Owners is accepting Order Reservations from 1pm to 3:45pm at their Downtown location on January 10th, 2022. In Phase #2 below, we'll add "availability" to limit how many reservations can be made in between those times. 3. The input boxes created above would automatically have each date in each input. Then the Admin would be able to manually input/enter the Start Time, End Time and Location for each Date/row. Note: So, if the User chooses today, then the Date inputs would be 01/10/22, 01/11/22, 01/12/22, etc. and if the User chooses 02/01/2022, then the Date inputs would be 02/01/22, 02/02/22, 02/03/22, etc. 4. Also put a plus "+" button at the bottom of the input boxes to add 1 more Date row (on the fly), ie. 3 input boxes on the row. 5. On "submit" or "save" we insert the input box values into a table, which I'll give you. It's pretty simple. NOTE: THIS BASICALLY CREATES TONS OF *** TIMESLOTS/ROWS *** IN A TABLE BASED ON THE START AND END TIME THE ADMIN CHOSE. Table Cols: id, day, date, time, available, location (it would be awesome if you could enter the day when you insert the date also, like Mon): 1, Mon, 2022-01-10, 4:00 PM, 0, Downtown **** I think it's important to save the dates (ie. and timeslots) first, before the Admin/Store-Owners adds their Availability otherwise they might lose all their info as they are inputting it. **** STEP #2 - BULK UPDATE: INPUT THE AVAILABLE TIME SLOTS So, this would display a lot of input boxes that represent all the new Timeslot rows, which allows the Admin to input all the different availabilities for each Time Slot (ie. 3, 5, 10, 5 per the example below). We also need a delete row checkbox for each row. So, the Timeslot rows might look like this: 1, Mon, 2022-01-10, 4:00 PM, 3, Downtown 2, Mon, 2022-01-10, 4:15 PM, 5, Downtown 3, Mon, 2022-01-10, 4:30 PM, 10, Downtown 4, Mon, 2022-01-10, 4:45 PM, 5, Downtown STEP #3 - BULK DELETE AND BULK UPDATE: CREATE A NEW ARCHIVE FEATURE Then I would love an archive feature/function that I can stick in a CRON job, which removes older dates from the main timeslots table and inserts them into an identical archives table.
Project ID: 32590671

About the project

21 proposals
Remote project
Active 2 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
Awarded to:
User Avatar
Hi, My name Ertugrul. I am a full stack software engineer. I made an e-learning platform in the past which is also uses 15 minute time slots. I used a different approach. But I can handle this sql method too. Requirements for all 3 features are fair and could be done in 1 day. Since pure javascript is so much faster than jquery in every aspect, mostly I use xmlhttprequest instead of ajax. Message me to discuss further details. Best regards, Ertugrul
$350 USD in 2 days
5.0 (21 reviews)
4.3
4.3
21 freelancers are bidding on average $532 USD for this job
User Avatar
Hi, How are you? I just saw your job posting and I felt that I can help you with this job considering the experience I have with MySQL, HTML, AJAX, PHP and JavaScript. Please check my portfolio: https://www.freelancer.com/u/AwaisChaudhry?w=f Regards, Awais
$750 USD in 28 days
4.9 (124 reviews)
8.6
8.6
User Avatar
i am ready to start now you will provide html files too or only sql file will be provided? Have read your description of project very carefully. I'm a professional developer with 2 year experience as you can see my profile.
$500 USD in 4 days
5.0 (214 reviews)
7.1
7.1
User Avatar
Hi,there I am Arsen and thank you for posting a job that fits my skill set. I CAN DO THIS. My Skills -Javascript, Php, Python,Zend,Laravel,DHX,TypeScript, React, Angualr, Nestjs, Node.js. -Blockchain development(Specially NFT) Why I am bidding. I am bidding for this project because I can complete this job as much according to your requirement and I know what can be the solution for this job. I would really appreciate it if you could contact me and discuss the assignment. I wish you best of luck in your bussiness. Regards
$750 USD in 7 days
5.0 (9 reviews)
6.1
6.1
User Avatar
Hello, This is Ramazan. i can start work on it immediately. i'm very much confident to reach your expectation and give you 100% satisfaction and quality work. hope you will give me this opportunity to serve you best Thanks & regards please check my profile: https://www.freelancer.com/u/DeveloperRamazan
$500 USD in 7 days
5.0 (25 reviews)
6.0
6.0
User Avatar
Greetings! I can help you with your project. I can do all the tasks you’ve mentioned in your job post. I'm available immediately to start working on the project. I've gone through your job description and I can start working on it right away! There's no point in attracting clients to a website that they'll want to close right away. But don't worry, that won't happen to you, as I will create the perfect design for your startup website. I have designed and developed more than 40 websites from scratch in my experience of 4+ years. With my skills and background, I am confident that I will quickly surpass your expectations for this role. I am available to start immediately. I have extensive experience working with HTML, CSS Javascript, jQuery, Bootstrap, Wordpress, WooCommerce and PHP. Apart from my technical skills, I'm a very communicative person, outgoing, and love being a team player. I enjoy learning, so if there's anything that I don't know, I'm more than happy to be a student and learn from someone who knows more than me. I'm open-minded to constructive criticism and will take any advice to grow as a developer. The proposed budget is not a hard estimate, since I don't know how the new pages will look like, and I would wish to speak more about the project to give a more accurate estimate and demonstrate how I can of value to you. Please feel free to send me a message,
$350 USD in 7 days
4.7 (17 reviews)
5.5
5.5
User Avatar
The easiest solution in your case is to use ON DUPLICATE KEY UPDATE construction. It works really fast, and does the job in easy way. Lets discuss more details.
$500 USD in 7 days
4.9 (19 reviews)
5.2
5.2
User Avatar
Hello, im an expert php, laravel, js, css, ... developer, i can do the tasks for you, please contact me if you want professional work, i have 100% completion rate
$500 USD in 7 days
5.0 (7 reviews)
4.8
4.8
User Avatar
Dear, client. I just read your job posting and it sounds like you need PHP expert desperately who can build script. It is great happy to possibly have the opportunity to work with you on your project. I would like to offer you my best. I am Sergey ,a senior Full-stack developer from Russia. My professional career began 8 years ago when I graduated from university. I got my master's degree in computer science from Kharkiv National University of Radio Electronics and have been working as a web developer ever since. I have worked for many big and small IT companies so far and gained a wealth of professional experience in web development during that time, so now I can do whatever the clients want. If you are looking for a very talented and professional developer for your project, I am the one you are looking for. I would like to see more discussion through chat. Sincerely. Sergey.
$500 USD in 3 days
4.9 (13 reviews)
4.6
4.6
User Avatar
Greetings.. I have read your requirements carefully. I am a senior frontend web developer. PHP is a complete framework for building backend projects and web applications useful. also I have rich Ajax. I can start right now and I will do my best for you to provide High Quality and High Speed. I have enough development skills to change your ideas into reality with a perfect and clean code and delicate and extravagant creativity. Look forward for your reply. Thanks.
$500 USD in 4 days
5.0 (1 review)
1.2
1.2
User Avatar
Hello: I believe you are doing well. I read through the requirement mentioned in the description section. We would be happy to take up this project as it falls completely under our core capability area. We have a team of skilled developers and designers working with us under one roof, which provides us an edge to serve our clients better and that too in a competitive costing. We have been in this business since 2006 with 100+ Happy clients and successfully completed 3000+ projects of various sizes. Please provide me your convenient time for further discussion and understanding. We can start with this project on immediate basis. Looking forward to a positive response from your side. Best Regards, Paras Vyas Starlet Exports Team
$530 USD in 12 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Glenview, United States
5.0
33
Payment method verified
Member since Dec 9, 2020

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.