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

Check premium expire
Hi,

I am making a simple file hosting site and want to check if users premium subscriptions h

how can i display php source code snippets ?
I am outputting some pho code .. and I want to display the source code so people can copy and paste

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

PHP url branch??
Functionally, using PHP, I'm doing a test of login input submitted by a user via an html form in a f

re calling a function without including file
Hi,
i am new to programming in php, i was just checking the wordpress code and found out in the w

PHP and Javascript
Hello Everyone,

I have a page that needs a javascript code to be written between PHP code but

PHP referral database. I would like this form to email the referrer.
Okay, Hello I've been trolling for years. This the first time I've ever asked for php help. Normally

Select all entries from database that include a phrase
I have a database of clubs - one of the categories is meeting time and place
I would like to have

classic dynpro : hide area and auto adjust hights
Hi,

I want to develop a similar user interface as is used in standard transaction MIGO.