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)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。