Unix vs IIS

[phpgroopie]

Hi All,

 

Sorry for the very noob question but I am not a PHP programmer. I have a client that asked me to publish a website on IIS that someone else developed for them. It is all PHP and accesses a MySQL database. I got the website to display but it will not access the database. Come to find out the development was on a UNIX box. I have been able to modify the mysql_connect statement a little and it authenticated to the DB server but it will not access the data.

 

Will this work or does it need to run on a UNIX box?

 

Thanks in advance.

[rarebit]

Have you put the data in?

[phpgroopie]

Sure did.

 

When the code that was written does a mysql_select_db it does not seem to get access. Even when I use the root user to authenticate.

[rarebit]

There's your problem then, do a test page and play with the details until correct... Why use 'root' user, what user have you granted privileges to?

[phpgroopie]

I recognize that the problem is at the connection point with the DB. I was just using root as a test when the other users ID I had setup, which has all priviledges, would not work.

 

My concern is that this was orginally developed on a UNIX box. My only question is, "Is the PHP code different for pages developed on UNIX than if it was developed on an IIS box?" They do not want me to take the time to change the code on all of the webpages that this other company developed for them if that is what it is going to take to make it work on IIS. They would rather go back to the other company and tell them to fix it under their original contract with them.

[rarebit]

As far as i'm aware both the php and mysql should operate exactly the same... But pls don't quote me! (e.g. i've never had any probs... sounds like a connection prob! Check user, host, password, db name... Obvious I know but REALLY make sure, recopy across etc...)

[effigy]

It sounds like your MySQL permissions are not set up properly.

 

My only question is, "Is the PHP code different for pages developed on UNIX than if it was developed on an IIS box?"

 

Only if they used non-portable code. All of the MySQL functionality should be the same as long as the versions are.

[phpgroopie]

The mysql version on the IIS box is 5 and the UNIX development box was 4. So looks like that may be part of the problem. Not 100% about the current PHP version as I do not have it in front of me but the original was 5.0.4

 

What is non-portable code? The reason I ask is that I was able to make a few changes to the code and get the mysql_connect statement to work.

 

Original

<? $dbclns = @mysql_connect....etc.

 

Change to:

<?php

$dbclns = @mysql_connect....etc.

 

So would the above indicate non-portable code or differences between mySQL versions.

 

Thanks

[rarebit]

That's something to do with some setting in php.ini, I always use full tags anyway!

[effigy]

That would be a configuration issue, not a portability issue. A portability issue, for example, would be moving COM code from Windows to Unix, or Unix commands to Windows, such as $files = `ls`.

[phpgroopie]

OK.....I know you guys are flying somewhat blind but do I have to worry about the version mismatch or is it just the configuration of the php.ini file?

 

 

[effigy]

If the website displays, the PHP tags are not the issue. Can you login into MySQL at the command line?

[phpgroopie]

The website displays fine with the exception of the db content.

 

Unfortunately the server is at the client site so I have no access right now. If you have some suggestions on things to check though that would be awsome.

[effigy]

MySQL user accounts, passwords, and permissions. Also, make sure you're error checking everything as well (the "@" you used in your previous example is a bad idea).