PHP中的Java同步概念

Question

Condition

I have comma separated list of airway bill numbers in a record in table core_config_data. This table uses engine Innodb.

I have a class with a function to take read this record, explode it, unshift one airway bill number, implode rest and save in database again.

Problem

When 2 or more people press assign airway bill number at same instance, all the shipment get same airway bill numbers.

Question

Is there a way in php / magento / zend to implement synchronized for this kind of situation.

Regards, Saurabh

Answer 1

You can use locks, but I suggest to create a table for airway bill numbers.

SELECT counter_field FROM child_codes FOR UPDATE;
UPDATE child_codes SET counter_field = counter_field + 1;

http://dev.mysql.com/doc/refman/5.0/en/innodb-locking-reads.html