Interview Question in SQL Server Configurations


 

Interview Question :: Some newbie question on setting up the programming platform


greetings,

i would like to ask something related with PHP and RDBMS

1. often heard the combination of PHP-MYSQL-APACHE. but i am more familiar with Microsoft SQL Server, can i switch and adopt the RDBMS into Microsoft SQL Server and IIS?

can introduce any useful URL for how to setting the configuration and let PHP-MSSQL-IIS get connected.

2. within one O/S (windows XP pro) installed MSSQL and MYSql, would it get conflict (example: browser opening port)?

3. what's the main diffference for java applet against java script? which one were more in-used over wepage design?

thank you

yk.ngu
Answers to "Some newbie question on setting up the programming platform"
RE: Some newbie question on setting up the programming platform?

1. You sure can have a PHP, SQL Server, and IIS working together. I currently have that configured on two separate XP machines. The idea is get IIS up and running if it not already. Then install SQL Server and start it. Then follow the instructions I show you in the link provided below. You will need to setup PHP with an account on SQL server or have it use an existing one you created.



2. I know you can have both installed at the same time (again I have this configuration) but I have never tried running both at the same time. I am not sure you would really want to do that. Choose one or the other and go with that just to save yourself troubles later.



3. Java is a full blown programming language. It is compiled into machine code and executes as a program on the computer. JavaScript however is a script or partial language, it is run within the browser on the client-side. So you could potentially have a Java servelet (runs on the server) and JavaScript on a web page that accesses it. JavaScript is a bit limited (it doesn't handle memory like a language, it has access right limitations to the clients computer files, doesn't have much of what a full language has). Don't confuse it with Java which is a fully implemented language and can create executable programs.



Javascript is the one used more widely on web pages. It is used for quick validation, using functions that require no trip to the server for information, and is one of the main technologies behind AJAX. I have provided a couple JavaScript tutorial links below.



Hope these answer your questions.
 
Vote for this answer ::  
Update Alert Setting