I hope some of the more experienced developers in this forum might be able to give me some advice. I just found out that the client I'm working with is using an MS SQL db for her website. I had been planning on developing her website using MySQL but it appears that is now not an option. I've found some db connection script on the web that connect to MS SQL db and it looks pretty much the same as how I'd connect to a MySQL db with the exception of the mssql_connect() function replacing the mysql_connect() function. So I'm wondering if working with PHP and MS SQL is going to be pretty much the same as with MySQL?
The site I'm developing is not overly complex, the client just wants to be able to update a few specific pages and the footer links. So my db is just going to store article headers, articles, link names, URL's as well as username and password for a login page. So maybe 6 tables at the most. I'll be adding, editing and deleting entries through a form I'll create for my client.
Normally I'd create the tables using phpMyAdmin, but I know MS SQL doesn't support that so I'm planning on just writing the tables by hand since the db is not going to be overly complex. I was hoping to be able to still test the queries in phpMyAdmin by creating a duplicate MySQL db on my local server and just copy and pasting those queries to the scripts I create when I start working with my clients MS SQL db.
So I guess to try summarize what I'm asking I'll break it down to a few questions.
1) I'd like to know if the queries work the same way in MS SQL as they do in MySQL, or do I need to structure my queries differently?
2) After I've established my connection to the MS SQL db can I use the same PHP I normally use to make my pages editable when working with MySQL?
3)Are there any recommended resources for working with PHP and MS SQL?
Thanks in advance for your time :]