Find Jobs
Hire Freelancers

Create new db and keep data syncronized

$250-750 USD

Completed
Posted over 8 years ago

$250-750 USD

Paid on delivery
I have developed a small PHP/MySQL website that allows private-persons or businesses to do their simple inventory. This uses one database. I now want to have one business per database. This means that when a business register on my site, a clone of the dev-database is made and this created business is now attached to this db (mysql-connection has a dynamic field and connects to this users session-database). Tasks 1: Create new company (database) from a php-script. This is pretty easy to do, you can basically write two mysql-calls to do it. But I want to be able to do the following in addition: Task 2, 3 and 4. Task 2. Be able to mange it from a master-admin-area (some /sysadmin/[login to view URL] script or similar area, can use inbuilt password protection), so that I can keep track of all the "installs" done and for instance a) disable, b) delete or c) "upgrade" each install. This admin area can use simple bootstrap. By c) "Upgrade", I mean to syncronize the database against the dev-database that it was cloned from. For instance, I migth add a column of type varchar 255 and this is syncronized to the other databases once I run "Upgrade". I migth also delete a column or change a field length. I have earlier written a "sync" script like this, but I have now lost it and don't want to do it again. It basically dumped the "dev-database" to a text-file and then grabs the columns list from the "cloned database" and compare each of tables and columns with them. If there is changes, columns are added/modified/dropped. MySQL has built in features to list columns and tables. There are a few custom fields named custom_f1_ that should not be deleted or altered. Task 3. Two places in the script, users can upload images/documents. This is directories or links that users may guess or follow link to that I want to avoid out of security concerns. I would want to use for instance a [login to view URL] and [login to view URL] php-file (with session-check from Task 4 below) to be sure that only correct logged in user can see this image. Images/docs are uploaded outside public-document root. You need to write and implement these two [login to view URL] and [login to view URL] (or find another solution to secure this). Task 4. Add session/password protection to the script and complete it (redirect user to login page if not authorized). Basically, make sure a hashed/secret name for db is passed on and check if user is authorized for this db. It uses a common [login to view URL] file, so shouldn't be to hard. It is not so big job to make this work, but it is a bigger job to make it work well and I want that last part.
Project ID: 8965318

About the project

3 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, My name is Faizan and I am a PHP developer. I have seen your project requirements and I think I can do 1,2 and 4. I need to understand 3 in a bit detail but that would not be a problem. The idea is that master db will hold user information and their db name, it will also contain list of all created databases. . We will replace your db connection with our code based on logged in user and it will only work on that database. A little bit about me: I belong to a team of 3 developers and 2 designers. I am the team lead, CTO, Manager, Rainmaker or whatever you can say :).We have been working in the field of PHP development since last 5 years. We have worked on Wordpress, Drupal and Joomla. We are also capable of handling small to medium level codeigniter or CakePHP projects very easily. The designer can provide you everything from a simple company logo to full fledge Website or Mobile App Mockups and layouts. We can provide responsive and mobile friendly websites as well. Bootstrap or [login to view URL] are the major frameworks we normally use to achieve the result. We work during Pacific Standard Time from 8AM to 6PM and are available to chat/email during and around these timings. So you can take updates easily and directly. You can see our portfolio inside my profile just to get any idea of work. You can see our reviews as well. Okay I wont take much of your time. Let me know if you are interested or if you have any questions Best Regards Faizan Shakil Faruqi
$526 USD in 10 days
4.9 (106 reviews)
7.6
7.6
3 freelancers are bidding on average $536 USD for this job
User Avatar
Dear Sir, Hope you are doing well, I have read your job description, I am willing to work with you as per your requirements. I have already done similar job and win 5 star rating with wonderful review. - I ll complete all of your requirements - I ll do more tweaks for you as well Sir i ensure you that i am best suit for this post. Please open chat with me so we can discuss more in details Looking forward to hear from you. Best Regards, Waheed Gondal
$526 USD in 10 days
5.0 (13 reviews)
5.3
5.3
User Avatar
Greeting!!! Today your job posting is caught my attention and glad to know you, your project requirements is very comfortable for me. Because I have worked with these requirements every times. Please keep your concentration with my skills. I am showing you those skills shot and simple. I am expert Website developer and Responsive designer . My expertise in PHP,SQL, WordPress, Opencart is very well and I have done lots of website by using these. Using PHP framework (Codeignetor, Yii) have created many software. I love creativity and minimal design and my expertise is html5, css3, javascript, jquery, photoshop, illustrator, bootstrap4. I want to provide you the best solutions for your business. And always I keeps my concentration with the your satisfactions. Regards, Reza
$555 USD in 10 days
4.8 (3 reviews)
3.3
3.3

About the client

Flag of NORWAY
OSLO, Norway
5.0
82
Payment method verified
Member since Jun 14, 2002

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.