Find Jobs
Hire Freelancers

Create new db and keep data syncronized

$250-750 USD

Ολοκληρώθηκε
Αναρτήθηκε πάνω από 8 χρόνια πριν

$250-750 USD

Πληρωμή κατά την παράδοση
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.
Ταυτότητα εργασίας: 8965318

Σχετικά με την εργασία

3 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 8 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
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 σε 10 ημέρες
4,9 (106 αξιολογήσεις)
7,6
7,6
3 freelancers δίνουν μια μέση προσφορά $536 USD για αυτή τη δουλειά
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 σε 10 ημέρες
5,0 (13 αξιολογήσεις)
5,3
5,3
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 σε 10 ημέρες
4,8 (3 αξιολογήσεις)
3,3
3,3

Σχετικά με τον πελάτη

Σημαία της NORWAY
OSLO, Norway
5,0
82
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Ιουν 14, 2002

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.