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

help, header() is not working!
Hello, I have this code:


<?php

/**
* @author samoi
* @copyright 200

Validation
Hello

I know this is a really vag question.

I need to have a input field on a form th

problem with php mysql query
Hi guy's...

I'm totally lost here..because don't have any idea how to make a query for grab r

need help about
i store the value of my select statement result to an array and stored it to a variable named $fname

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

What exactly is net neatrality?
What exactly is it? I think it's anti-censorship and... stuff... but I don't really understand it

jquery validation in codeIgniter
hai i need to add client side validation to my fiels which are selected in a forloop.the fields are

=> and <=
So I was digging through some code when I came across the <= operator. This is the first tim

php mysql query from input textbox
Hi,

I have a text box, in that i have given the mysql query. I can able to get the query in v

constructor ?
i have written this program and made 3 constructors in the class and i want to call them in the main