I'm just looking for an answer or idea.
I plan to connect vb.net to mysql (which is done) and also the PHP connected to the mysql.
But I'm confuse with something.
VB.NET is use for offline things (which people will come to store and buy), but PHP is buying / booking online. (You know the airport things right ? customer can directly go to the airport and buy tickets or they can buy tickets from the internet)
For ex :
Customer A come to airport and buy a ticket which is only left 1 tickets. Customer B wanted to buy from the internet. Both of them saw there is only left 1 tickets. So, both of them buying. When Customer A buy, the employee click buy at the same time with Customer B.
In here, I'm confuse, how to declare which person should get the ticket because they click buy at the same time (server time because PHP and MySQL located to the server and vb.net applciation located to other PC/Machine) ?.
So when generating ticket ID, either employee for Cust A or Cust B know that the ticket just bought buy other person.
Sorry If it is a bit confusing, hope you understand.