Door problems of the 2006 BMW 3 Series

Door locks on 2006 BMW 330xi suddenly stopped functioning properly midway through the day and were unable to be unlocked. I was able to open the door with the embedded physical key in the fob but when I got in the car and tried operating the doors they again locked but were unable to be unlocked neither by the unlock button on the console, the fob or the door handle. The only way I was able to exit the car was to roll down the drivers side window, and use the emergency mechanical key to unlock it by extending my hand out the window. Since the driver's side door is the only door with a physical keylock, it was the only door that was able to open. For the remainder of the day, all 3 passengers had to climb out of their windows to exit.