Find Jobs
Hire Freelancers

Transactions on multiple connections, data integrity fails while one transaction executes

₹600 INR

Cerrado
Publicado hace más de 5 años

₹600 INR

Pagado a la entrega
I am trying to work on a transaction based PHP-MYSqli with OOPS code for a small application in the following scenario: PHP 5.6.x for server and PHP Desktop version phpdesktop-chrome-57.0-rc-php-7.1.3, thus application will run both on 5.6.x and 7.x versions of PHP. Multiple people can access the same php application simultaneously. This means that every user will have an independent connection available to access the application because I have included a connection on the top of every page through files inclusion. What I want is that when one user presses the submit button, all the tables inside a particular transaction should get locked in read and write mode and none of them should be accessible by any of the users on the same or any other connection. Thus, I want 100% data integrity. In the attached codes: First I start executing [login to view URL] and immediately, I also start clicking the go button of [login to view URL] another other browser tab. Following are the results of [login to view URL] when: Image: [login to view URL] is still executing Image: when [login to view URL] has finished executing It is good to see that at the end, I get the accurate results but it is bad to see that even when one transaction is execute, another user is getting the wrong output. The second user should not be able to see anything when the [login to view URL] is executing. Note: $mysqli->begin_transaction(MYSQLI_TRANS_START_READ_WRITE); doesnt work in my current version of php
ID del proyecto: 17471169

Información sobre el proyecto

4 propuestas
Proyecto remoto
Activo hace 6 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
4 freelancers están ofertando un promedio de ₹1.050 INR por este trabajo
Avatar del usuario
Hi, This is amit my designer can do this transaction as per your requirements, She read and checked attached images. Thanks
₹950 INR en 2 días
5,0 (7 comentarios)
3,8
3,8

Sobre este cliente

Bandera de INDIA
Kurukshetra, India
5,0
31
Forma de pago verificada
Miembro desde sept 8, 2015

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.