I can't get anymore. MySql -PHP

Escomputers

I've just installed apache 2.2.15, mysql 5.1.45 and php5.3.2

everything was ok, so I started creating web pages.

I've also configured correctly php with mysql,
through the famous procedure:
removing the comment ; of extension_dir line in php.ini
copying mysql and apache php libraries into my system32 folder.
setting system variables in the PATH.

now when I try to connect to mysql with a script it shows this damned error that I googled and googles a million times:

fatal error: call to undefined function mysql_connect.
my script is:

//connecting to MySQL
$db = mysql_connect('localhost', 'xxxx', 'xxxxx') or
    die ('Unable to connect. Check your connection parameters.');

the only one solution I guess I've founded was one by a php developer in php.net official site.

he says that in windows 7, vista and windows server 2008

there's a problem regarding the ip in the hosts file located in C:/windows/system32/etc

and he says to set it like this:

127.0.0.1 localhost

my defaul was this:

127.0.0.1 localhost

::1 localhost

so trying and re-trying I noticed that the only one change when removing the comment (#) from (# ::1 localhost), is that firefox says "Unable to connect to the server" instead of the error reported above.

I'm desperate.

bradgrafelman

Escomputers wrote:
copying mysql and apache php libraries into my system32 folder.

PHP-related files should never be copied outside of the root PHP directory. The same applies for Apache and MySQL as well. Delete whatever copies of files you've placed in system directories.

First thing to check is if your php.ini file is being parsed at all. Do a phpinfo() and locate the value of some PHP directive - display_errors, for example. If it is shown as On, change it to Off in your php.ini file (or vise versa if it's already Off) and restart Apache. Does phpinfo() reflect the new value you set in php.ini?

Escomputers wrote:
setting system variables in the PATH.

Can you explain what you mean by that? What does your PATH environment variable look like now?

Escomputers

I copied those files because I following this book

http://www.flipkart.com/beginning-php5-apache-mysql-web/0764579665-65w3f2yf0c

It's a new book written in 2009.
Authors say that when the book was written the latest stable versions were:
PHP: Version 6.0.0;
Apache:Version 2.2.9;
MySQL: Version 5.0.67;

so,
on page 11 "Chapter 1 = Configuring PHP for MySQL"

it says:

<<finally, to load php extension copy libmysql.dll file from C:\PHP folder and paste it into C:\Windows\System32 or C:\WINNT\System32>>
I read this "copy" procedure also in many web forums.

I buy it for 50$. is it possible that I wasted my money?

I attached my phpinfo

laserlight

Escomputers wrote:
It's a new book written in 2009.

No, it was written circa 2004; some of the members of this online forum community were involved.

Escomputers wrote:
Authors say that when the book was written the latest stable versions were:
PHP: Version 6.0.0;

This update must be wrong: PHP 6 has not yet been released.

Copying the files can work. The problem is that you need to know exactly which to copy, and then you may forget to replace them when you upgrade.

bradgrafelman

And another problem is that it goes against what the manual says to do:

The PHP manual used to promote the copying of files into the Windows system directory, this is because this directory (C:\Windows, C:\WINNT, etc.) is by default in the systems PATH. Copying files into the Windows system directory has long since been deprecated and may cause problems.

Besides, if you're using PHP 5.3, you shouldn't even need libmysql - PHP 5.3+ should be using the mysqlnd built-in driver instead.

Escomputers wrote:
I attached my phpinfo

I don't see any attachments, but did you try the procedure I mentioned to check whether PHP is parsing your php.ini file? If so, what were the results?

Escomputers

I changed the values (default, production and developer) of display errors in my php.ini to off but in my phpinfo nothing happens even restarting apache and deleting cookies.

I forget to say that recently I installed zend studio text editor with php debugging tool.

and as I see the programhas set its configuration values in my phpinfo.

now I disinstalled it and deleted files in system32 directory.

bradgrafelman

Escomputers wrote:
I changed the values (default, production and developer)

What is this supposed to mean? There should only be one php.ini file... did you not rename "php.ini-dist" (or whatever it's called) to "php.ini" ?

Escomputers

what did you understand?

I mean in my php.ini there's a block of code that says:

; display_errors
; Default Value: Off
; Development Value: Off
; Production Value: Off

bradgrafelman

Those are comments (as is any other line that begins with a semicolon) - they don't actually do anything. To actually set (or change) a directive, you have to find the where it says, for example:

display_errors = On

Escomputers

ok, changed, but nothing happens in my php.info!

bradgrafelman

Okay, so there's the first problem we need to fix. How is PHP integrated into Apache? Is it via an ISAPI module, meaning there's a "LoadModule" line in Apache's httpd.conf that points to a PHP .dll file?

Escomputers

yes, LoadModule php5_module "C:\PHP\php5apache2_2.dll"

bradgrafelman

Okay, do you also PHPIniDir "C:\PHP" in your httpd.conf file as well?

Escomputers

yes man

bradgrafelman

So you found the "display_errors =" line in c:\php\php.ini, changed it, and phpinfo() didn't reflect the new value? Did you restart Apache after making the change?

Escomputers

yes exactly...

The problem could be solved by installin WAMP buy I don't want to use a precompiled packages...

so mate what should we do?I think it is a mistery...without a solution:queasy:

bradgrafelman

And you're sure that the file is named "php.ini" exactly? Could you upload a copy of it (rename it to have a .txt extension first)?

Escomputers

attached phpinfo

bradgrafelman

Loaded Configuration File (none)

Looks like PHP isn't finding your php.ini file after all.

Can you upload a copy of your httpd.conf file for Apache?

Escomputers

attached