PHP Script Enhancements

Closed Posted 4 years ago Paid on delivery
Closed Paid on delivery

**** NO AUTO-BIDS PLEASE. PLEASE READ ALL REQUIREMENTS COMPLETELY AND RESPOND THAT YOU UNDERSTAND THE FOLLOWING DETAILS.

NOTE: THIS PROJECT WILL LIKELY GROW OVER TIME SO YOUR ASSITANCE WILL BE NEEDED FOR MORE CHANGES AS TIME GOES BY. PLEASE BID ACCORDINGLY AS REPEAT BUSINESS IS LIKELY

PART 1

Ensure that single quotes are escaped from all inserted values.

PART 2

FOR THIS PART YOUR FEEDBACK IS VALUED. IF YOU HAVE IDEAS THAT YOU BELIEVE ARE BETTER SUITED TO THE SOLUTION THAN WHAT IS PROVIDED BELOW, PLEASE LET US KNOW.

We have a script (attached) that synchronizes records in a parent database to a MySQL database. Currently this script processes all records in the parent database. This takes time and as the parent table grows, the time needed to synchronize will grow as well. We need a way to reduce the number of records processed by the script so this processing remains manageable.

We need a developer to modify the existing script to manage this effectively. I would like suggestions on how you would do this when taking into account the following:

For MySQL UPDATE: Most tables contain a DateUpdated field that can be used to determine the records to process. We would suggest modifying the existing sync script to:

1. Provide a parameter for "Last Update Date". This parameter can be hard coded into the script so it can be changed as needed.

2. Only synchronize/update records that have a date less than or equal to the "Last Update Date" parameter defined

NOTE: The SO_SalesOrderDetails and SO_SalesOrderHistoryDetails tables do not have a DateUpdated column. So we would need a way for the script to only update records in these detail tables that have a primary key match in the records that updated for their parents (SO_SalesOrder_Headers, SO_SalesOrder_Details) on the current sync process.

For MySQL INSERT (new records):

1. Provide a parameter for "Date Since". This parameter can be hard coded into the script so it can be changed as needed.

2. Only insert new records that have a date less than (newer) or equal to the "Date Since" parameter defined

PART 3

Create a web interface using PHP that will allow users to run synchronization scripts manually by entering a key value (such as an order number or item number) into a web form for each synchronization task. The web interface should display a line for each interface with an input value for the key and a submit button for each sync process to execute the synchronization script using the value entered. The interface should know what synchronization is being requested and only run a synchronization for that table. It should ignore the date rules define in Part 1 and simply process the record specified (i.e. Order Number, Item Number, etc)

A separate PHP script can be created for this if it is easier or cleaner than making these changes in the existing script.

PLEASE SEE THE ATTACHED FILE FOR PART 1 AND PART 2 VALUES TO USE.

Please comment all lines that are added/edited by you.

PHP MySQL

Project ID: #20628297

About the project

14 proposals Remote project Active 4 years ago

14 freelancers are bidding on average $221 for this job

shihan033010

Hi I am interested in your project requirements. I am expert in web application development using php and mysql using the bootstrap. I can fix the issue that you mentioned. Please allow me to start the project.

$200 USD in 8 days
(319 Reviews)
6.8
alexwmsoft

100% Completion Rate and 5 Stars Hi, there. My name is Lee, and I am an experienced web developer. I read your job description, and I am interested in your project. I have 6+ years of experiences in developing websit More

$140 USD in 7 days
(36 Reviews)
6.3
NadirBouchama

Hello there! how are you doing? Can you please provide more details about the project? after i have check your file i can tell you that i can do your project and if the project is fairly paid I can build you a small pa More

$155 USD in 5 days
(65 Reviews)
6.3
xiaomingming

Hello dear. I have read description and very interested. I m a senior web developer working for 6+ years and my skills and experiences are perfectly fitted on this project. It is my pleasure to work with you, and I More

$140 USD in 7 days
(5 Reviews)
5.5
kishan1383

Dear Sir/Ma'am, I have check your php file and also doc file, as I am doing same thing in my current project below are some suggestions from my side : Make one PHP form(visual thing for admin) where admin can set sche More

$200 USD in 7 days
(12 Reviews)
3.8
gabs777

Hi, I have read your project details and have look through the document and php file attached. I understand your requirement and also there are things that I will like to ask. Why you should hire me and About me in b More

$200 USD in 2 days
(17 Reviews)
3.3
NextYoo

Hello , I have 100% project complete Rate . Just because i Have good communications skills and Good skills to do projects for my clients . I applied here to serve You best , please consider me ONCE .

$140 USD in 7 days
(1 Review)
1.6
babyphilo

Hi there, I have checked the details. I will satisfy all your requirements. Don’t waste your precious time and cash – I'm professional and that I skill to form real. I assure you that I can deliver your work in the be More

$30 USD in 2 days
(2 Reviews)
1.3
Rinkup0

Hello, I am a highly-skilled web developer to create a unique website and have Strong sense of responsibility and ability to complete tasks with minimal supervision. Very happy to discuss the details with the chat. More

$500 USD in 15 days
(1 Review)
1.2
techlinesols6

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th More

$140 USD in 7 days
(1 Review)
0.0
ingund

Hi, I've read your complete requirements and I will produce a notable result for you because I have done those project before. I want to discuss complete details with you to understand your requirements, I am available More

$450 USD in 7 days
(0 Reviews)
0.0