Re: Need help with PHP + MySQL on W2k

patrick@xxxxxxxxxxxxxxxxxxxxxx wrote:
Greetings. I am new to PHP and would appreciate any help I can get.

I am having a tough time figuring out what is going on with the PHP
installtion on a W2k server. I have configured PHP (by editing the
php.ini file) to load the php_mysql.dll, which seems to be loaded
properly because I can run "php -i" from the command prompt and see a
section with mysql info as follows:

-----------------------------------------------------------------------------------------------
mysql

MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => 5.0.51a

Directive => Local Value => Master Value
mysql.allow_persistent => On => On
mysql.connect_timeout => 60 => 60
mysql.default_host => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => no value => no value
mysql.default_user => no value => no value
mysql.max_links => Unlimited => Unlimited
mysql.max_persistent => Unlimited => Unlimited
mysql.trace_mode => Off => Off
-----------------------------------------------------------------------------------------------

PHP also seems to be working fine with IIS because I am able to
display a .php page on the server that contains the command phpinfo().
However, if I run any mysql statement in the .php file, (e.g.,
mysql_connect), the processing seems to just stop at the mysql
statement, and ignoring everything below it. No error message is
returned. When I looked at the info generated from phpinfo() on the
web page, I noticed two things:
1. There is no MySQL section (in contrast to the command line result
above)
2. There is a ISAPI section which is not present in the command line
result.

I guess teh ISAPI thing is normal, but it is the lack of the MySQL
section that baffles me.

I have also tried usinig php_mysqli.dll instead of php_mysql.dll, and
I got similar results as above. So, the problem is that the dll is not
loaded by the web server (i.e., IIS). Any idea what is going on?
Please help.

Many thanks.

Patrick


What is the configuration file you're using, as indicated by phpinfo()? Probably not the one you edited.

Also, enable and display all errors - you should ALWAYS do this in a development system. That would have shown you the error, probably a missing function. In your php.ini (the correct one) you need:

error_reporting = E_ALL (or E_ALL | E_STRICT)
display_errors = on

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================

.

Relevant Pages

  • Re: IIS 6.0 on Windows Server 2003
    ... If PHP insists on using CMD.EXE to execute the shellcommand on the ... server, then no, you have no choice -- you must give read permissions to the ... this would be a security vulnerability caused by PHP. ...
    (microsoft.public.inetserver.misc)
  • Re: Speed up web pages : MySQL or PHP solutions ?
    ... People come to us to view 1 image or text + 1 PHP content. ... Can you click on the image = MYSQL ... Make your content cacheable by sending appropriate HTTP headers. ... Cache content on the server to avoid re-creation over and over again, ...
    (comp.lang.php)
  • Executing PHP files on remote web server
    ... We have a web app which uses PHP and MySQL on our in-house Apache web ... database to the web host because a lot of the data is sensitive. ... By loading the non-sensitive data into the web host's MySQL tables, ... running on our own web server. ...
    (comp.lang.php)
  • Re: Newbie Security Questions
    ... questions about PHP and its usage with MySQL. ... And even if they do, its a strange Mysql server that is sitting on the internet accepting requests from all and sundry..normally you run them on a local network, or the same box and set mysql to only accept requests FROM the apache server.. ... You have to layer that over the top using cookies and user logins if you want it. ...
    (comp.lang.php)
  • Re: Server load too high
    ... > the new dedicated server with Dual Xeon 3.2 GHz and 2GB Ram. ... > The board is written in PHP with Mysql. ... Well, since it looks like MySQL is eating more of the CPU, it could be ... In any case, I've been using PHP5 for a while now, and I've not ...
    (comp.lang.php)
Quantcast