Find Jobs
Hire Freelancers

Create new db and keep data syncronized

$250-750 USD

Terminado
Publicado hace más de 8 años

$250-750 USD

Pagado a la entrega
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.
ID del proyecto: 8965318

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 10 días
4,9 (106 comentarios)
7,6
7,6
3 freelancers están ofertando un promedio de $536 USD por este trabajo
Avatar del usuario
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 en 10 días
5,0 (13 comentarios)
5,3
5,3
Avatar del usuario
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 en 10 días
4,8 (3 comentarios)
3,3
3,3

Sobre este cliente

Bandera de NORWAY
OSLO, Norway
5,0
82
Forma de pago verificada
Miembro desde jun 14, 2002

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.