PHP Script Enhancements
$30-250 USD
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.
Project ID: #20628297
About the project
14 freelancers are bidding on average $221 for this job
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.
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
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
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
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
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 .
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