Php, MySQL & IIS - Together
User Rating: / 7
PoorBest 
Written by Abhishek Khatri   







Majority of the developers today employ WAMP i.e. Windows Apache MySQL Php. Although Apache provides a number of advantages over IIS.

  • Apache is an open source, free to download and easily available.
  • IIS continues to be attacked by viruses and thus not safe from security point of view. On the other hand security issues in Apache are raised occasionally and that too with limited scope.
  • The cost associated with Apache is very less as compared to IIS as it’s an open source software and is available for free. And when you talk about IIS, you are talking about Microsoft Windows and buying it as a server platform involves lot of money.

  •  But many developers are still willing to use Microsoft’s Internet Information Services (IIS) in place of Apache :  

  • Apache is useful if you are a programmer but then if you are a part of a company that’s looking for a Web Server you can’t really rely upon an open source software.
  • Apache had performance problems (although they were corrected with Apache 2.0).
  • Lastly, if you are comparing a Microsoft product with an open source software you can be rest assured that there will be countless number of people going for the Microsoft’s Internet Information Services(IIS) as a server platform.
  •  

    So here’s a method to run PHP with MySQL and IIS 6.0 Manager.   


    Installing IIS 6.0 Manager:

    IIS 6.0 Manager can be easily downloaded from the following link.

    This will automatically install IIS 6.0 in your computer in Administrative tools in the control panel after you run the setup.

      

    Installing PHP 5.2.5 

    The latest version of PHP can be downloaded from the following link:

    http://www.php.net/downloads.php#v5 
    • Unzip the downloaded file in a folder named PHP in C:
    • In the control panel click on Performance and Maintenance and select Administrative Tools. Open IIS 6.0 and right click on Default Web Site as shown in the screen shot:
    • Select Home Directory and click on configuration
    • Click the Add button and browse the ‘php5isapi.dll’ in C:\php and click OK.
    • Copy the file ‘php.ini-recommended’ from C:\PHP to C:\WINDOWS and rename it to ‘php.ini’.

    Installing MySQL 

    Install MySQL 5.0 from the following link:

     http://dev.mysql.com/downloads/index.html 

    Follow the following steps:

    • Go to “MySQL Server Instance Configuration Wizard" and click "Detailed Configuration", "Developer Machine", "Non-Transactional Database Only", "Decision Support (DSS)/OLAP", "Check Enable TCPIP Networking", Port 3306, "Standard Character Set", "Install as a Windows Service”.
    • Give it a main password (remember it) and click Execute (all the 4 buttons should light up).
    • Open the MySQL Administrator program. Set server host = localhost, username=root and password= whatever you had set. Click on catalogs, if you see "mysql" then that is a main database. This means that MySQL is installed properly.  

    Configuring PHP with MySQL 

    • Copy file “libmysql.dll” from C:\PHP to C:\WINDOWS\SYSTEM32 folder.
    • Edit file “php.ini” using a text editor. Find the line extension_dir = "./". Remove the preceding semi-colons and make it extension_dir = "c:\php\ext".
    • Remove the preceding semi-colons in the following lines as well:
      1. extension=php_mysql.dll
      2. extension=php_mysqli.dll

    php_mysql_iis_img_intro.jpg 







     

    Quote this article on your site

      Comments (1)
     1 Written by This e-mail address is being protected from spam bots, you need JavaScript enabled to view it , on 15-05-2008 07:03
    Can you help me on coding for making objective question and submitted to the database and straight away get the result after finish the examination.

    Only registered users can write comments.
    Please login or register.


    Powered by AkoComment Tweaked Special Edition v.1.4.6
    AkoComment © Copyright 2004 by Arthur Konze - www.mamboportal.com. All right reserved

     
    < Prev




    Privacy Notice | Advertising Info | Feedback | Contact Us | Partners

    The information and views presented above are by the author. Mabaloo.com does not take any gurantee of accuracy.
    The views expressed above are that of the author and in no way related to mabaloo.com
    Highlite It
    © 2007 @ mabaloo.com.