Securely sending data from shared hosted PHP script to local MSSQL

Posted by user329488 on Programmers See other posts from Programmers or by user329488
Published on 2014-06-10T00:42:11Z Indexed on 2014/06/10 3:41 UTC
Read the original article Hit count: 440

I'm trying to add data from a webhook (from a web cart) to a local Microsoft SQL Server. It seems like the best route for me is to use a PHP script to listen for new data (POST as json), parse it, then query to add to MSSQL.

I'm not familiar with security concerning the connection between the PHP script (which would sit on a shared-host website) and the local MSSQL database. I would just keep the PHP script running on the same localhost (have Apache running on Windows), but the URI for the webhook needs to be publicly accessible.

Alternately, I assume that I could just schedule a script from the localhost to check periodically for updates through the web carts API, though the webhooks seem to be more fool-proof for an amateur programmer like myself.

What steps can I take to ensure security when using a PHP on a remote, shared-host to connect to MSSQL on my local machine?

© Programmers or respective owner

Related posts about php

Related posts about security