Locking mysql tables with php

Posted on 16th Feb 2014 07:03 pm by admin

Hi

BACKGROUND:
I have multiple instances of the same php script running in a WAMP environment. The script contains mysql queries to lock certain tables in the database. I'm getting some very odd behaviour which would seem to suggest that the locks are not working, and that one instance of the script is reading from a table that another instance of the script should have a write lock on.

ACTUAL QUESTION:
Do two instances of the same php script running through WAMP get totally independent locks on tables in a database?

I didn't post this question in the mysql forum because although it is about locking tables, it is about locking tables from the point of view of a php script. Please move it if I have posted in the wrong forum.

Cheers

Paul

Your Answer:

Login to answer

Other forums

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

Simultaneous select/update/insert
Hi

How would I need to go about when 2 users update a single row simultaneous? And how would

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

help with this code please?
Hello,

I am trying to build a remote upload script for my image hosting site.

I am usi

Help with looping
I have a comma separated list of colors taken from a database ($ICo) and a directory of images named

COOIS - Saving Object Overview WIP Status layouts
COOIS - Would like to be able to save the layout of an Object Overview - WIP Status report. There i

preg_replace question
Hello!!

I hope someone can help me with preg_replace.

I load two tables from an extern

PHP time (deadline within one week)
I have a column ['projdue'], which stores the deadline for a project.
I have PHP code and <

TimeZoneOffset
Hello,

Please i need your help. I have a system that users can use to punch in and out. This

Creating Images from images in PHP
Okay well I am trying to make a 'dynamic' calender image with PHP.

I have images like this: