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.
Did you know?Explore Trending and Topic pages for more stories like this.

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
No comments posted yet

Your Answer:

Login to answer
348 Like 52 Dislike
Previous forums Next forums
Other forums

why isn't this PHP code working ???
it's suppose to find a name on the database.

<?php

$s = $_POST["lname&

Character Set Setup
Whats the best character set to use if you want every character to work, and also how do you make yo

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim

Regular expression tips or resources
Hello! I'm having some issues implementing the appropriate regex patter to eliminate unwanted charac

How to limit the calls to an API
Hello, in my simple script I call an api which effectively involves me getting an xml file.

H

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

login page does not execute a else statement
I've created a login page using sessions.
When an incorrect user name or password is entered then

How can I Compare two xml documents?
Hi all,

I am doing a POC for my project and I am using XE database 10g version.

Progress bar for webpage
Hi,
I want to implement a progress/waiting bar on my webpage - exactly the same thing that the Mi

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash