18mths ago a staff member wrote our website in PHP/MySQL, and hosted it with a 3rd party hoster, who uses H-sphere for configuration. The staff member left just after this.
The website runs, well 98% of it runs. We need to fix the 2% that doesn't - which amounts to about 33% of its business value, as well as update it.
Trouble is, I have no experience with PHP, MySQL (apart from installing it and doing the tutorial), and very little with H-sphere (only for setting up email and DNS, not for PHP and MySQL)
I can learn what needs to be learned, but am looking for the quick routes here as I have many other things to do. I used to be a programmer, so hopefully once I get the principles, I should be ok.
H-sphere is down quite often (like now) and our hosters want to migrate us to cpanel, which is another posting in itself.
I thought best to get our own local webserver up and running so we can load the site up on it, and then tweak/add functionality in an environment where we can test things quickly, and are not at the effect of the 2x issues in last paragraph.
Is this going to be a wise approach, or will I end up scratching my head for days trying to set up said local environment, and maybe I'd be better just migrating to cpanel and doing everything that way.
Locally, we run SBS 2003, and I've just discovered IIS on there.
I've added a new website under IIS, but would need to buy an IIS book to actually get anything displayed, then get the MySQL database linked in.
Maybe I'd be better installing Apache - is it free?
But, can it coexist on the same machine as IIS (this is the only machine I'll be able to install a webserver on, I think), and IIS needs to be on the SBS server as it provides a lot of useful functions for SBS, so I've read, not least Remote Web Workspace which I rely on !!
If push came to shove I could install Apache on my personal work PC I suppose...
Eventually I see us redesigning the whole thing anyway, is it likely that a webdesigner will want to use Visual Studio / IIS etc (in which case we'll end up going the microsoft way, so maybe may as well start with IIS, as that will be what we're using anyhow) ?
sorry lots of questions - all help appreciated !