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

standard ALV application toolbar, into custom report....
HI,

I have a question regarding displaying standard ALV menu path and application toolbar

button help
i originally had this but realised it is much easier to have a button.

Code: <?php

Remove letter from numeric textbox
I have a textbox that will search the employee database by entering in the employee ID and it will r

add text and number image
hi guys ..

ok see i want the user to add their name and pick a number then click get it and i

Problem in back link
I have page where i have given javascript back link but when i click on it browser give a message

How to restrict the display of report variants
Hello All,

I want t know how to restrict the display of report variants.
I mean, whe

MySQL Does not UPDATE- SQLString Problem
vb Syntax (Toggle Plain Text) 1. SQL = "UPDATE sampletable SET column1 = 'C1sample1'"

File upload issues
Hi Guys,

Can anyone see any issues with this code:
Code: [Select]$setImage= 'productimages

Else statement screws up all css
Does anyone know what goes wrong in the process with this php code?
This code seems to be causing

get url?
how do i get the url of the page i'm currently on, on my website.. i think its get header.. how do i