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

Encrypt php code?
Is it possible to encrypt php code in files,
so that it displays a load of unreadable characters

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

Anti Spam Code
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I

Effort Estimation Template for Steady State Support
Hi Everyone,

Is there any SAP provided template/format for system change and enhancements

Strange array issue, never happened before.
mysql_fetch_array returns 1 array per call. Generally that's why it is inserted into a while statem

values not being entered into table
hi. I;ve created a form, so that when a user enters data into it, it gets added to a table in a data

array_count_values question?
ok i'm trying to create a top ten list from a database of listed favorite movies.

the followi

Displaying Multidimensional Arrays...about to put my head in a vice, PLEASE HELP
I am fairly new to PHP and MySQL and I have a problem which I have been trying to resolve for days.

frames get header location..
i have two frames, one top, one bottom. how do i do a form on the bottom frame that gives me the ur

UL and LI Add Form
The idea I want here is when the user click on a character name from the drop down select bar at the