Find Jobs
Hire Freelancers

PHP array compare and db update script

$200-400 USD

In corso
Pubblicato circa 8 anni fa

$200-400 USD

Pagato al completamento
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.
Rif. progetto: 10096049

Info sul progetto

10 proposte
Progetto a distanza
Attivo 8 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
10 freelance hanno fatto un'offerta media di $316 USD
Avatar dell'utente
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 in 10 giorni
5,0 (884 valutazioni)
8,5
8,5
Avatar dell'utente
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 in 6 giorni
4,8 (40 valutazioni)
5,2
5,2
Avatar dell'utente
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 in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 10 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: NORWAY
OSLO, Norway
5,0
84
Metodo di pagamento verificato
Membro dal giu 14, 2002

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.