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

PHP mail() with images
I'm trying to get images to send along with my HTML e-mail sent through PHP mail(). I only tried vie

Calculating a rating by adding number of points and dividing by number of items
I have a site that users can post links to files to download. They can rate these files on a 1-5 sca

PHP friend keyword equivalent
is there a PHP equivalent for the C++ friend keyword?

Mass activity scheduling
Hi experts,

Im facing some problems to deal with mass activity jobs.
When I run some

GET vs SUBMIT Button to show sections on one index.php page?
Just curious if one of these ways is better (i.e. more efficient) than the other.

I have a

Email/MMS to Site
Hey guys. I'm looking for a way for a user to upload images and/or text via their cell phones. It

Limiting uploaded file type
I am working on a simple upload script, and I need it to limit the allowed file type that is uploade

AJAX form submit
I recently built a form that submits data to my database with an ajax function that is called throug

a function to check directory depth
I'm working on a php script to upload files in to a set directory.
the user can select to upload

insert Multiple rows into the table from that table data
Hi All,

I have a requirement like to insert mulitple rows into the table from that