0

I have Microsoft SQL Server on my computer, and separately, a website. If the action of a form on my site is set to be processed by a php script, how can I use that script to connect to and add data to a database on the SQL Server on my computer?

Thanks!

bst-for-life
  • 41
  • 5
  • you could allow external access to the db server, i cant say i know how. but i think the best solution is to use a db on the server the site is on. –  Apr 05 '15 at 01:30

1 Answers1

2

You would first need the SQL PHP Drivers then you would need to determine your connection string. Then you would need to write the php code to insert into your database (Last Answer).

You also need to create a table with the corresponding schema to hold your data. This is a very broad question hopefully this puts you on the right track.

Community
  • 1
  • 1
bumble_bee_tuna
  • 3,533
  • 7
  • 43
  • 83
  • @bst-for-life You may also want to look at some of the video tutorial on youtube that will help you along https://www.youtube.com/watch?v=72XCFF4YiOw – bumble_bee_tuna Apr 05 '15 at 01:38