Level 50
try this
'number' =>increment(optional($sale->latest('id')->first())->number)
May 24, 2018
6
Level 46
how to unique increment simultaneous requests
we have sales table and want to add unique sale number in table
here is the code but it's duplicate the numbers with simultaneous requests.
if 5 requests at same time it's not working perfectly because when we fetch last number from database it's give us sometime old number.
$sale->create([
'number' => optional($sale->latest('id')->first())->number + 1,
'amount' => 20,
]);
there are 2 queries same time first fetch old number then increment. but it's not good for simultaneous requests.
any solution here?
thanks
Level 122
You need to lock the table whilst you create the new record
Level 35
Aren't you just recreating the auto increment functionality here? You take the highest id you can find increment it with one and than try to store it in a separate field.
That is exactly what the auto increment method of mysql does, only smarter and without the possibility of duplicates. So conclusion. Isn't the 'id' field of the sale record not the number you are looking for?
Level 46
@Snapey but how to lock the table any idea?
2 likes
Level 46
@m-rk no i want to increment number column too
all working fine but not working with same time multiple requests.
2 likes
Level 35
@ahsan but is your id value different than your number column in your database?
Please or to participate in this conversation.