Find Jobs
Hire Freelancers

adjustable PHP script for syhronising SQL DB's online (internet) and offline (intranet).

$30-100 USD

已完成
已发布大约 21 年前

$30-100 USD

货到付款
I'm looking for a PHP-script that can synchronise 2 DB's (one as the back-end of my website and one as the back-end of intranet website). Both of these websites are based on PHP-nuke. I need to be able to specify wich tables to be synchronised (these settings should be stored in a synhro administration table) Both intranet and internet-servers are installed with LAMP servers. Intranet server is on a cable connection (no fixed IP). Synchronisation should be initiated from intranet server (time-based using cron or admin-triggered). A php-nuke admin-module (in admin section) would be ideal (not necessary). The online DB is not accessible directly (only through php-pages). The solution should use PHP-nuke abstraction layer so that different types of DB's can be synced. I should be able to (e.g.): * sync user tables * sync forum posts * sync entry lists for competition (show-jumping) (**) * sync results for jumped courses (penalties, ...) (**) ** this is what I will need the script for. The two first are examples The script should be made adjustable , so that other tables can be synced later ## Deliverables Let me explain more clearly: I'ld like the script to act according to the synchronisation rules stored in a synchronisation table. This way, I can 'manage' the script by altering the rules in the table. Don't know if I can put this into format. table: sync_rules field1: rule-id (just an identifier) field2: table-name (name of the tables to be synced) field3: direction (this says how to do synchronisation, online => offline or offline => online (up- or download)) field4: record_or_not (this defines if the whole table needs to be synced (not 1 record) or just one record) Let's put that last one better: I want to be able to call your script with a function of my own in wich I can pass a table-name and record and then your script just syncs that one record in that table. Those were just fields that I could come up with. (adding fields later on to further define the synchronisation rules is possible) In this setup I only install the script on my intranet (because that is the only place I can use it, since I don't have a fixed IP). In order to use the script, we would need a few functions in a file that we put online to enable us to write and read to and from the DB (insert, update, delete)and (reading table records to compare them with what I have offline.) I would also like a sript that insert, edit , delete rules from the sync table (simple) in the PHP-nuke admin area. I hope that clears it out a little. (I could almost do it myself) Anyway, I appreciate your fast response. Thanks in advance. To be delivered: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) installation tool not necessary (only txt-file that show where files should be put in document tree) 3) Complete ownership and distribution copyrights to all work purchased. - - I want to release the source code to the PHP-nuke community 4) Source code should be commented (a little) ## Platform LAMP- servers. Web-based administration. (cross-browser)
项目 ID: 2917100

关于此项目

4提案
远程项目
活跃21 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$85 USD 在14天之内
5.0 (3条评论)
3.4
3.4
4威客以平均价$79 USD来参与此工作竞价
用户头像
See private message.
$59.50 USD 在14天之内
5.0 (6条评论)
3.1
3.1
用户头像
See private message.
$85 USD 在14天之内
0.0 (1条评论)
0.0
0.0
用户头像
See private message.
$85 USD 在14天之内
0.0 (0条评论)
0.0
0.0

关于客户

BELGIUM的国旗
Belgium
5.0
1
会员自5月 25, 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)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。