Find Jobs
Hire Freelancers

PHP array compare and db update script

$200-400 USD

処理中
投稿日: 約8年前

$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年前

お金を稼ぎたいですか?

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
お支払い方法確認済み
メンバー登録日:6月 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)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。