PHP Error after install

thekidscareya

I installed PHP 4.4.0 and MySQL 5.0.15 on a Windows 2000 Server running IIS.

I get the following error after transferring a site from Linux server to this server:

Fatal error: Call to undefined function mysql_connect() in d:\Inetpub\wwwroot\uc_votech_shared\student_organizations\FBLA Site Folder\FBLA Site\functions.php on line 13

The script works fine on the Linux server and there is no coding/syntax errors in the script.

What went wrong?

Thanks for your help in advance. I really appreciate it.

Attached is the php.ini file in a txt format.

subwayman

Check you PHP version on the linux box. I think I am right in saying the mysql is NOT enabled by default in PHP 5. That could be where your problem is.

thekidscareya

subwayman wrote:
Check you PHP version on the linux box. I think I am right in saying the mysql is NOT enabled by default in PHP 5. That could be where your problem is.

The PHP version on the windows box is 4.4.0..not 5.
The PHP version on the linux box is 4.3.10-16. (thats what it says when i do phpinfo();

drew010

php4 for windows has mysql support built in, but since you are using mysql5 you might need to use mysqli since the mysql functions dont support all functionality for versions greater than 4.1.0

thekidscareya

So I have to change all my functions?

Ex:
mysql_connect() = mysqli_connect()
mysql_select_db() = mysqli_select_db()
mysql_fetch_array() = mysqli_fetch_array()
mysql_query() = mysqli_query()
mysql_num_rows() = mysqli_num_rows()

This should solve it? Is that correct?

drew010

well, mysqli is a class, so it has some different member functions.
this page is probably a good one to look at.
http://php.net/manual/en/function.mysqli-query.php
to see if you can get a connection with it, and select some data.

subwayman

Yes, if you install the mysqli option. Check your installation instructions for php 5. It may be you can install the ordinary extension or install the cgi version.

thekidscareya

Wait...the mysqli functions are not defaultly installed into PHP 4.4.0?

thekidscareya

I upgraded to PHP5 and now i get this error:

This PHP CGI binary was compiled with force-cgi-redirect enabled. This
means that a page will only be served up if the REDIRECT_STATUS CGI variable is
set, e.g. via an Apache Action directive.
For more information as to why this behaviour exists, see the <a href="http://php.net/security.cgi-bin">manual page for CGI security</a>.
For more information about changing this behaviour or re-enabling this webserver,
consult the installation file that came with this distribution, or visit
<a href="http://php.net/install.windows">the manual page</a>.

drew010

make sure the php.ini value for cgi.force_redirect is turned off. if it is commented out that means its enabled, so uncomment and turn it off. that should help fix the problem

thekidscareya

It's off...attached is the php.ini from the PHP 5 installation

subwayman

No it's not:

; cgi.force_redirect = 1

the semi colon comments it out.

thekidscareya

; cgi.force_redirect is necessary to provide security running PHP as a CGI under
; most web servers. Left undefined, PHP turns this on by default. You can
; turn it off here AT YOUR OWN RISK
; You CAN safely turn this off for IIS, in fact, you MUST.
; cgi.force_redirect = 1
cgi.force_redirect = 0

underneath it, it has the value as 0

subwayman

Yes you are right. Apologies for my last post.

"Quick to learn in haste"

thekidscareya

no problem...we all make mistakes

Squintz

I am having the same issues.

[PHPThis PHP CGI binary was compiled with force-cgi-redirect enabled. This
means that a page will only be served up if the REDIRECT_STATUS CGI variable is
set, e.g. via an Apache Action directive.
For more information as to why this behaviour exists, see the <a href="http://php.net/security.cgi-bin">manual page for CGI security</a>.
For more information about changing this behaviour or re-enabling this webserver,
consult the installation file that came with this distribution, or visit
<a href="http://php.net/install.windows">the manual page</a>.
[/code]

I also have the redirect turned off and cant figure out why I am getting this message. Please help! I am running IIS from Windows 2000 Pro