Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Jul 2011
    Posts
    95
    Member #
    28555
    Liked
    1 times
    I have a fully functional PHP login script on my hosting with MySQL databases but this is now going to be hosted on a local server running windows server 2003, IIS6 and SQL server management 2008.

    Is there anyway of making the same script work on this server or does the whole lot need changing for SQL server?

    Adey

  2.  

  3. #2
    Junior Member
    Join Date
    Apr 2012
    Posts
    12
    Member #
    31568
    You can run PHP on IIS for the most part.. however if you need to run the site in ASP, then you will need to write everything and convert the database

  4. #3
    CPD
    CPD is offline
    Member
    Join Date
    May 2012
    Location
    South London, England
    Posts
    36
    Member #
    31775
    Liked
    5 times
    The SQL Syntax is ever so slightly different and there are some differences between the DBMS' in terms of functionality. For example SQL Server does not have a "LIMIT" clause unlike MySQL. PHP Should run just fine on an IIS however, if you want to interact with an SQL Server you should look into writing an SQLSRV adaptor class. SQLSRV is the Microsoft supported driver for PHP and practically offers full functionality of the SQL Server through PHP on a Windows environment. Using an ODBC driver could eventually lead you into problems as it does not fully support SQL Server yet.

  5. #4
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    MS-SQL 08 supports the ROW_NUMBER() function, which allows equivalent functionality to LIMIT. T-SQL has various other differences, too, e.g. the implementation of IF(), etc. I suggest reading up on MySQL-to-T-SQL conversion.

    Personally, I always write my SQL using ANSI-92 standards (e.g. using CASE instead of IF), to maximize compatibility with all database... to account for exactly the O.P's situation. About 10 years ago, I built the DB-end of a commercial grade reporting app for GE Security that required compability with Oracle, SQL Server, Informix, and Postgres. Taught me a lot about how to make SQL (and DB schemas) universally compatible.

  6. #5
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,485
    Member #
    425
    Liked
    2783 times
    You can run PHP AND mySQL on IIS, so there really isn't a need to reinvent the wheel. The only thing you might need to change is the connection string. Everything else should work.

    Tell whoever the server admin is to install PHP and MySQL using Web Platform Installer. They won't have to think much, everything pretty well configures itself nicely (some tweaks may need to be done but for a basic login script I doubt it) and the whole process takes about 5-10 minutes (unless they install other things on the server).
    If I've helped you out in any way, please pay it forward. My wife and I are walking for Autism Speaks. Please donate, and thanks.

    If someone helped you out, be sure to "Like" their post and/or help them in kind. The "Like" link is on the bottom right of each post, beside the "Share" link.

    My stuff (well, some of it): My bowling alley site | Canadian Postal Code Info (beta)


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 10:29 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com