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

quotes changing
hi all

in my content

opening quotes " changes to “

close qu

Need help in Generating Combinations
Need help generating all possible combination of names in an array

Lets say i have the follow

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d

read integers that returns a negative or prints the average
Im trying to finish this homework assignment by tommarow afternoon and I keep getting stuck.
Wr

I think i'm using the syntax incorrectly
Hi Everyone!

I'm new to this forum and a newbie with PHP - I'm glad I found this site - I hop

Restricted access to sub-folder in iis6 doesn't work?
Basically I'm trying to add restriction to sub-folder (which contains pdf) in web.config for iis6 as

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

Preventing blank or already entered values
Im trying to learn how to place a read file line by line and prevent duplicate entries and also BLAN

query based on 2 conditions
I want to select if the doc_type is either s OR f but this doesn't work:

Code: [Select]$query

modifying query string with no page refresh
Hi everybody,
I've tried to get info about my problem all over the internet but i didn't find out