faqts : Computers : Programming : Languages : PHP : Database Backed Sites : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

25 of 28 people (89%) answered Yes
Recently 9 of 10 people (90%) answered Yes

Entry

What should I consider when making cross-platform scripts (Linux/Apache vs NT/IIS)?
Why do my quieries work for mySQL-NT but not for mySQL on Linux?
Why do my scripts work on Linux but not on NT?

Mar 2nd, 2000 11:20
Matt Gregory, Peter W. Rasmussen,


The first thing you should consider is your webserver.
Obviously you can't use Apache specific functions if you are running 
IIS or any other webserver.
See http://www.php.net/manual/html/ref.apache.html for more information 
on Apache specific functions.

Also, many of the file system functions are Linux/Unix specific and 
will not do anything under Win32.  Rather than list all these functions 
here, check each function in the PHP manual and it will tell you if it 
will not work under windows.  There are realatively few.

Most importantly, make sure the parameters you pass are case-
sensitive.  Even though you can set case sensitivity off in mySQL, most 
servers prefer to leave it on (and it is on by default).  On the NT 
version of mySQL case sensitivity is off by default.  I have written 
many a script on an NT box and found that it didn't work on Linux 
because I forgot to make my SQL case sensitive.  (By this I mean Fields 
and Database names only, the actual SQL is case-insensitive).