Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 12 of 12
  1. #1
    Regular Coder
    Join Date
    May 2012
    Posts
    153
    Thanks
    115
    Thanked 0 Times in 0 Posts

    PHP and MYSQL on Windows Server?

    I am geting pretty comfortable with PHP & MYSQL, and have been creating websites and databases.

    Now..... I got a job at a larger corporation, and they would like to have something created for them, not too intense, but a small site on their intranet where they can upload and display photos and information about employees, photos from Christmas parties and events, etc.

    The issue is that they have Windows installed on their server.
    The manager was excited when he heard that I did web design, and asked if I knew ASP & MS SQL.

    2 questions.....

    1) Would it be a major learning curve, to pick up ASP & MS SQL (if I am not an expert, but fairly comfortable with PHP/Mysql)?

    2) Would it be worth suggesting that they install PHP & Mysql on their Windows Server? Or too difficult... or just not a good idea in general?

    I would appreciate your inputs? Thank you.

  • #2
    Senior Coder
    Join Date
    Aug 2006
    Posts
    1,398
    Thanks
    11
    Thanked 296 Times in 295 Posts
    If this is for something quick and dirty, I'd think the fastest path would be to install PHP and MySQL on the server since you know them. On the other hand, if you want to learn ASP and MySQL, it could be a good opportunity to broaden your horizons on their nickel.


    Dave

  • Users who have thanked tracknut for this post:

    Eggweezer (01-30-2013)

  • #3
    Regular Coder
    Join Date
    May 2012
    Posts
    153
    Thanks
    115
    Thanked 0 Times in 0 Posts
    Thanks Dave, but it is kind a a bigger coompany. Yeah, pretty wierd, but their IT Dept is actually is out west (US), so it is difficult for them to spend time on this.

    So then.... probably ASP & MS Sql is probably the way to go. I understand that it might not be as similar to PHP/Mysql as I had hoped. Do you know if that is true? Thanks. Craig

  • #4
    Senior Coder
    Join Date
    Feb 2011
    Location
    Your Monitor
    Posts
    4,439
    Thanks
    62
    Thanked 537 Times in 524 Posts
    If you do want to install PHP and MySQL on their server there are many preconfigured packages available known as WAMP.

    I use the UniformServer but many are fond of XAMPP. Both have Apache, MySQL and PHP preconfigured. You just copy the directory onto that machine, and run - either as seperate programs or as system services. No need for installation or manual configuration (which is a real pita I might add).
    See my new CodingForums Blog: http://www.codingforums.com/blogs/tangoforce/

    Many useful explanations and tips including: Cannot modify headers - already sent, The IE if (isset($_POST['submit'])) bug explained, unexpected T_CONSTANT_ENCAPSED_STRING, debugging tips and much more!

  • Users who have thanked tangoforce for this post:

    Eggweezer (01-30-2013)

  • #5
    Regular Coder
    Join Date
    May 2012
    Posts
    153
    Thanks
    115
    Thanked 0 Times in 0 Posts
    Thanks tangoforce. I will have to discuss this with them. Appreciate your input.

  • #6
    Regular Coder
    Join Date
    Aug 2009
    Posts
    160
    Thanks
    42
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by tangoforce View Post
    If you do want to install PHP and MySQL on their server there are many preconfigured packages available known as WAMP.

    I use the UniformServer but many are fond of XAMPP. Both have Apache, MySQL and PHP preconfigured. You just copy the directory onto that machine, and run - either as seperate programs or as system services. No need for installation or manual configuration (which is a real pita I might add).
    ^This...I did this recently, which implies it can't be that hard, lol! Only issue I had was an ini+Ipv6 thing but a quick Google had me going in no time...

  • Users who have thanked chevy_ls_6 for this post:

    Eggweezer (01-31-2013)

  • #7
    New Coder
    Join Date
    Dec 2012
    Location
    USA
    Posts
    82
    Thanks
    3
    Thanked 17 Times in 17 Posts
    If they are asking if you know ASP, then they most likely have IIS already installed.

    IIS supports PHP and MySQL, there is no need to double up on your web servers. Simply ask your IT Department to install PHP and MySQL - MySQL is most likely already installed or if MS SQL is installed, learn that.

  • Users who have thanked TFlan for this post:

    Eggweezer (01-31-2013)

  • #8
    Regular Coder
    Join Date
    Oct 2011
    Posts
    113
    Thanks
    9
    Thanked 1 Time in 1 Post
    You would need to get something like WAMP or XAMPP , once you have one of those configure IIS to run on port 81 and Apache to run on 82 , then get nginx to proxy redirect them both so you can now run both Apache and IIS without any ports in the address.

    Good luck

  • Users who have thanked Vernk for this post:

    Eggweezer (01-31-2013)

  • #9
    New Coder
    Join Date
    Dec 2012
    Location
    USA
    Posts
    82
    Thanks
    3
    Thanked 17 Times in 17 Posts
    Again, DO NOT have two servers going at once. It's more work and effort than it's worth


    IIS supports multiple web sites, if you are familiar with it, you will know what I'm talking about, if not, get familiar with it.
    Last edited by TFlan; 01-30-2013 at 06:16 PM.

  • Users who have thanked TFlan for this post:

    Eggweezer (01-31-2013)

  • #10
    Senior Coder
    Join Date
    Feb 2011
    Location
    Your Monitor
    Posts
    4,439
    Thanks
    62
    Thanked 537 Times in 524 Posts
    Quote Originally Posted by TFlan View Post
    Again, DO NOT have two servers going at once. It's more work and effort than it's worth
    Not really, I've done it in the past. I had Apache and IIS running on the same machine with Apache setup to use proxyforwarding for ASP pages.

    I didn't use it for any specific purpose / project, just to see if it could be done and how easy. If I can do it, I'm pretty sure most folks can.
    See my new CodingForums Blog: http://www.codingforums.com/blogs/tangoforce/

    Many useful explanations and tips including: Cannot modify headers - already sent, The IE if (isset($_POST['submit'])) bug explained, unexpected T_CONSTANT_ENCAPSED_STRING, debugging tips and much more!

  • Users who have thanked tangoforce for this post:

    Eggweezer (01-31-2013)

  • #11
    New Coder
    Join Date
    Dec 2012
    Location
    USA
    Posts
    82
    Thanks
    3
    Thanked 17 Times in 17 Posts
    Sure, it's possible and works fine in a personal environment.

    But he is in a corporation - corporations don't play nice. Use their existing server.

    Talk to your IT department about setting up an intranet website, they will take care of the server, you just worry about the coding.

  • Users who have thanked TFlan for this post:

    Eggweezer (01-31-2013)

  • #12
    Regular Coder
    Join Date
    May 2012
    Posts
    153
    Thanks
    115
    Thanked 0 Times in 0 Posts
    Thank you all for your inputs and suggestions! Wow, some nice info. I guess my first stop will be to sit down and talk with their IT dept, and go from there. You did answer a lot of questions. Thanks all for taking the time.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •