How would you live update an SQL DB inventory from an xml using php

Question

using a live connection vía xml address update your database information in real time, taking the value of <amount>123</amount> from <itemid>xxx</itemid> in the mentioned xml, so it updates in real-time everytime an user makes a call for the amount of such item

Answer 1

Look it's here ↓↓↓ :)
https://docs.microsoft.com/en-us/sql/t-sql/xml/query-method-xml-data-type