Find Jobs
Hire Freelancers

PHP array compare and db update script

$200-400 USD

В роботі
Опублікований almost 8 years ago

$200-400 USD

Оплачується при отриманні
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.
ID проекту: 10096049

Про проект

10 пропозицій(-ї)
Дистанційний проект
Активність 8 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
10 фрілансерів(-и) готові виконати цю роботу у середньому за $316 USD
Аватарка користувача
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
$631 USD за 10 дні(-в)
5,0 (884 відгуки(-ів))
8,5
8,5
Аватарка користувача
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.
$336 USD за 6 дні(-в)
4,8 (40 відгуки(-ів))
5,2
5,2
Аватарка користувача
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
$200 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hi, I have strong knowledge about this. And I have a working a lot of projects like this I believe we will a strong partnership
$333 USD за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор NORWAY
OSLO, Norway
5,0
84
Спосіб оплати верифіковано
На сайті з черв. 14, 2002

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.