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

bit of help needed
Im about to sort out my registration page for my website by customising a "registration" s

Passing JS to PHP
So I have the following
Code: <?php
getdetails(?><script type="text/

Comparing two dates
Hi Guys
I have two dates I want to compare. Below is my current implementation. The problem with

At max how many columns is advisable to create in a table/view
Hi All,
I have two transaction table from which i want to create a simple view or material

Create a form of 2 numbers input and find the greatest.
Hi, everybody.

I have a homework in my training of php, which ask you to make a form that ask

function not returning the correct value
I have a program that needs to return a value from a function. I have an output statement inside the

form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how

with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s

Dump with added_funcion cl_salv_table
Hi there, I'm having some troubles adding a self defined function to an ALV in fullscreen. The thing

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


<?php

/**
* @author samoi
* @copyright 200