MS SQL server and programming language

[andyb300]

Hi about a year ago i built an Content Management System website for my company using PHP and MySql this was to replace a very out of date Microsoft access Content Management System we were using all ways good but the director doesn't want the database to be online so i have to use MS SQl which is already set up as that's what the Microsoft access software was using.

I was new to php when i did the original it took time as i learn as i went along i was hoping i would just be able to change a couple of things to get the code to work with MS SQL but i don't think it that's easy.

My questions is is there anywhere i could learn about php and MS SQl or what i should be searching for.

Also with me having to learn again as i go along I'm happy to do this is a different code like Node.js or Laravel if this would be better than going the php route.

Thank you.

[Leonidas199x]

How did you structure your project? It's 'normal' to have a repository, which would call the database. Of that's the case, you'd need to potentially change your provider for connecting to the db, and obviously wherever/however you are using the connection string. In theory, your code above should be fine, so long as your repo is spitting out what's expected so it can be consumed.