You seem to have come up with the gist of it yourself. One thing to note is that XAMPP is a development software suite, so you wouldn't want to run your live server with it. For scripting the SQL query, you have plenty of options, but if you have php developers at work or somebody who knows some basic php you should be able to write a service quite easily. Using javscript with Node.js is also a good option, as you don't need to setup apache since node.js can be used as a webserver directly via express.js.
If you want to setup a way to respond to the new data, I'd make sure you've got the server setup with SSL. After that you can send the data via POST requests. I'd also set up some type of authentication scheme, but you'll have to decide weather you want to use basic authentication or something more complicated. In either case, make sure all data input from the user is properly escaped to avoid SQL injection attacks.
Emails are pretty simple, as PHP has a built in function to send mail, and sending mail with node.js is nearly as simple. I have no experience with text messages, but you might want to take a look at this page: https://davidwalsh.name/send-text-message
I hope this helped you out a bit