Im thinking about having a php script on my website where samba can make a url to open which will add my transaction data to the website.
I know im sometimes a little unclear so I want to show you what im trying to acheive.
Order rigned up with a customer eintity.
The order and the customer entity is sent to the web server along with all the entites custom fields. One of the custom entiy data stored is how many points they have.
----- On website
Customer types in there barcode number into a form, an AJAX loader brings back their last transaciton as well as how many more drinks they need for a free one. Heres an example from a nearby store about what thhey look like when you go onto your account Uploading…
In my opinion you should go for a wamp webserver that uses php to connect directly to your ms sql database. Once your connected to that database, you can read or write any information you want so the possibilities are endless.
So:
Search up wamp local webserver and get it running. You know everything is working fine when you go on your browser and type localhost as the address link and it loads your server page.
Learn how to properly install and activate all of the php and MS SQL drivers for the webserver.
Learn how to connect to a ms sql database with php.
Now the possibilities are unlimited. You can do whatever you want as you enhance your coding skills.
Coming back to this, do you meant locally host the web server, If I dont want to open loads of ports, and use a company to host it, how will I go about this to still connect to my datbase?
