I only want experienced PHP-programmers for this task, because you will not meet the deadline that is 4 days away. This means I want you to start work on this today, not to wait until day 3.
Goal: Improve and extend [login to view URL] file that is a script that compares and upgrades a local database according to a .txt file it has already grabbed.
Task number #1: 5 minutes + time to learn the script
Upgrade my script to support compare/sql upgrade of more than the 1 table. Basically copy/paste some functions-calls and make sure it works (and fix any issues that I haven't been thinking of). However, it migth needs adjustments, since I want to improve how data is displayed to the developer (more user friendly). So you migth do Main task #2 first. Up to you.
Task number #2: Main task
Current script compares each field and each value in the tables "field" (short for fields") and it displays the SQL-needed to fix the database (like insert a row into table and update table) it figures out automatically) at the bottom of the page. It is displayed both as text (human friendly) and as direct SQL-senctences that can be run directly from there if you activate AutoFix (a fixed variable). By just running that SQL directly, all tables are in sync (hopefully, also the two tables you added in task above!).
CompareEveryColumn($aRemoteArray,$aLocalArray,$aAutoFix=0,$aPreview=1,$aStepByStepConfirm=1)
My program consists of fields, pages and menus. This means that each page often has a menu and each page often have fields. But there is a very loose connection that I want to keep, so you need to look at field-values in some cases to figure that part out. As mentioned already, the script supports the sync of "fields" alone and is able to detect and fix any missing field or field-value on its own. But here you add support for "pages" and menues" as well!
In this "aStepByStepConfirm" run, if there is a difference in the fields or a page and/or menu missing, I want to see a headline in a table saying "Page Users" and a button that I can click to see what fields are different in this table. Current script does ONLY compare fields inside the table, but with other words, I want you to improve this so that it is more user-friendly for me as a developer and includes taking Pages and Menus into the script. Each page can have many fields and many small differences, so I need it to be very precise and let me manually "approve" each change (if I want to).
I want to be able to both click a bootstrap-button named like "Run SQL page users" or click on a button for each of the fields that is different. If a page is missing, a click on this "Run SQL for page users" at the headline will add the clicked page and add (if missing) the fields missing for that page IN A NEW WINDOW (so that I don't loose overview). If I click "Fix" on a field that is missing (or has wrong values) in another page, it will only add/fix that field only (this last part is already possible just be adding a javascript button that opens up and execute the SQL as param, but the page/menu-thing is more work!). You can also use Ajax for this.
The function SyncTablestoDatabase runs code on "field"table that is imported and creates/fixes columns that has wrong integer/string or doesn't exists.
Task number #3: Biggest task
Test, test and test until it works. When you have tested it 150% and fixed any bugs (even if it is already there from before or you created it), you can deliver it back to get the money.
This task includes some thinking about best solutution. I don't want quick fix, I want stable, easy to read code that works. Each time.
Hello!
With 98% to 99% completion rate, 900+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :)
I am available to get started on your project right away. I look forward to your reply.
Thanks.
Kind Regards,
Rajesh Soni
I have read your description that you mentioned that very big task of testing that says how you faced problems. I will complete and test it 100 times and give you 200% assurance before i deliver. I will give you our best work. Please ping me we discuss and start work.
Hello Sir,
i am experienced in php programing and proficient in creating scripts. i can complete described project in 3 hrs only.
i am new to freelancer. so i have no portfolio to show you my skills.
I can start work on this project now.
Thanks for considering me,
Parveen