TUTORIAL: How to install PHP and MySQL on IIS

[ATNO/TW]

February 14th, 2008, 7:02 am

Rich_Bailey77 wrote:

I was thinking through some stuff and maybe this has something to do with what is going on here (or I could just be throwing in a some unnecessary information ). I use host headers because I host several websites and as a result the http://localhost addresses will not work for the PHPBB stuff. Do I need to change something during the MySQL setup to point to the actual address for the forums rather than localhost?

I'd be very certain that would be your trouble spot. Unfortunately I've never set up a system like you appear to have it, so don't know what to suggest. But I would certainly focus the troubleshooting on that.

February 19th, 2008, 8:40 am

I'm not making much progress with MySQL. Would you have any advice for using MSSQL Server 2000+ via ODBC since that says available?

[ATNO/TW]

February 19th, 2008, 9:08 am

You can use php with MSSQL Server, but I've never done it, so really have no advice. You might want to start a new separate thread if you'd like to try that approach.

February 23rd, 2008, 3:31 pm

Hello.

I followed the tute. But I am unable to pull up the info.php.

I have done everything in the posts. Tried reinstalling php and mysql and still it is not pulling a page, not from localhost, nor from xxx.xxx.xxx.xxx/info.php


Any ideas why this could be?


Also. I have uninstalled php and mysql 20 times. Have uninstalled the IIS service 3 times. Still I can not view the php page. I can't even view the localhost default page. I have went into properties and assigned it, its Static IP address, still I can not view it LAN or Public. I was able to get prompt for the un/pw, nothing worked for that either. Now it gives me a error 400 Bad Request.
I am sure I have muckeled something up, but I am unsure as to what. Lol

The php version I am installing is 5.25
The mySQl version I am installing is 5.0.51
I am installing it on Server 2003.


Thanks
Lesh

April 3rd, 2008, 7:48 am

hi

have a new challenge today! mysql db is connecting fine but i have this error.

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line

i had to enter the cmd env to test my query cos my php pages were just working like links. i know my php is ok cos i call pages with functions. i can select from my db tables but cant update or insert.

what can i do?

[ATNO/TW]

April 3rd, 2008, 7:55 am

Yomi, please repost this in your other post and just use that one so we can keep everything in the same place.

programming-forum/mysql-connect-error-t86937.html

Just use that one to add updates to your problem.

[ATNO/TW]

April 3rd, 2008, 7:58 am

I'm locking this thread as read only, primarily because the tutorial is a bit outdated. I'll be revising it soon and adding the updated version to the Tutorial section.

If you've followed the tutorial and still have problems that you need to ask about, please create a new Post in this Programming section and we'll help you there.