PHP5 connect to MySQL Problem, No ErrorReport & ...

[leavehere]

Hello,

Hi,

Windows XP Pro SP2
Apache 2.0.53
PHP 5.0.3
MySQL 4.1.10a

I just installed all above and the PHP runs on Apache successfully. However after I installed the MySql, and tired to use the following PHP code to test it, I failed:

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
echo "Connected to MySQL<br />";

?>

root is both my username and pwd.

When I run the PHP page, nothing displayed on the page but a blank page. Actually I ve used certain diff. PHP code to test the MySQL connection, the result is same: An BLANK PAGE.

===============================
1.after that I checked the PHP Manual, it says the PHP5 doesnt support mysql as what PHP4 does. But I dont know how to exactly configure the PHP5 to support mysql?

2.somebody told me that the reason of the blank page is that the error_reporting is turned off in my php.ini(php.ini-recommended) which is copied into C:/windows/. But in the file:

error_reporting = E_ALL

does it mean the error_reporting is on?

3. I also tried to use php.ini-dist instead of the recommeded, it sets:

error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT

however, when I try to run the code below:

<?php
asdfasdd
?>

still a blank page displayed.

=======
I think there are problems with my PHP/MySql settings, but I cnanot figure them out. any helps?

Thanks a lot!!!

[jabba_29]

Is PHP running at all?

<?php

# info.php

phpinfo();

# open [url]http://127.0.0.1/info.php[/url]
?>

In your httpd.conf file

# if installed as a module
# change path accordingly
LoadModule php5_module c:/php/php-5.0.3-Win32/php5apache2.dll
# you can also state explicitly which php.ini file to use
# change path accordingly
PHPIniDir "c:/php/php-5.0.3-Win32"

Make sure in the specified php ini that you have the extension directory is also named:

; Directory in which the loadable extensions (modules) reside.
; change accordingly
extension_dir = "C:\php\php-5.0.3-Win32\ext"
; find your mysql extension and uncomment
extension=php_mysql.dll

Restart.

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

; error_reporting is a bit-field. Or each number up to get desired error
; reporting level
; E_ALL - All errors and warnings (doesn't include E_STRICT)
; E_ERROR - fatal run-time errors
; E_WARNING - run-time warnings (non-fatal errors)
; E_PARSE - compile-time parse errors
; E_NOTICE - run-time notices (these are warnings which often result
; from a bug in your code, but it's possible that it was
; intentional (e.g., using an uninitialized variable and
; relying on the fact it's automatically initialized to an
; empty string)
; E_STRICT - run-time notices, enable to have PHP suggest changes
; to your code which will ensure the best interoperability
; and forward compatibility of your code
; E_CORE_ERROR - fatal errors that occur during PHP's initial startup
; E_CORE_WARNING - warnings (non-fatal errors) that occur during PHP's
; initial startup
; E_COMPILE_ERROR - fatal compile-time errors
; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)
; E_USER_ERROR - user-generated error message
; E_USER_WARNING - user-generated warning message
; E_USER_NOTICE - user-generated notice message
;
; Examples:
;
; - Show all errors, except for notices and coding standards warnings
;
;error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT
;
; - Show all errors, except for notices
;
;error_reporting = E_ALL & ~E_NOTICE
;
; - Show only errors
;
;error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR
;
; - Show all errors except for notices and coding standards warnings
;
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT

[leavehere]

i ve turned it on in the php.ini (recommended), which is copied to the c:/windows.

but no errors displayed at all. a bland page displayed when the code like:

<?
jdajflkdsjlkf
?>

how?

thanks a lot?

[leavehere]

thanks.

solved the problem by re-configuring everything.