MySQL not returning any values to the browser

dazaaa

Hi,

Firstly I have installed PHP and Apache.
Pages from my server return the following:
Apache/2.0.55 (Win32) PHP/5.1.2 Server at localhost Port 80
so now you know what platform is running and the PHP is correctly installed and is working I will get on with the problem

I have installed MySQL, and there are My SQL Tables there:
mysql> select * from people;
+----+------------+---------+
| id | first_name | surname |
+----+------------+---------+
| 1 | Ann | Brache |
+----+------------+---------+
1 rows in set (0.11 sec)

mysql>

I have been through (throughly every step on the php website) to install MySQL extension correctly

http://www.php.net/mysql/

I have edited my php.ini file to the correct extension directory, made sure there were no extra slashes etc.
I have uncommented extension=php_mysql.dll
I have my path set correctly:

and i have my libmysql.dll in the php dir (which the path points to) and the php_mysql.dll file in the extension dir.

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\ATI Technologies\ATI.ACE\; C:\PHP\

I also get no errors when I start apache:

C:\PROGRA~1\APACHE~1\APACHE2\BIN>apache -w -n Apache2 -k start

C:\PROGRA~1\APACHE~1\APACHE2\BIN>apache -w -n Apache2 -k stop
The Apache2 service is stopping.
The Apache2 service has stopped.

Yet when I run some simple script to test mysql under php it fails:
script:

<?php
/
Created on May 1 2006

Connect to the MYSQL Database
/

$username = "daz";
$password = "letmein";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
mysql_close($dbh);
?>

this above script returns nothing to the browser whatsoever. the page source is blank. not a single character.

Also when i run phpinfo() nowhere does it mention anything about mysql being installed.

I dont understand I am getting no errors but nothing is working correctly.

Can someone please advise?

Thanks
Daz

Houdini

Standard answer for Window get XAMPP and be done with it!

bradgrafelman

In your PHP info, what's the value of "extension_dir" ? Is this indeed the location where you placed the php_mysql.dll file?

Also, is display_errors set to On and error_reporting set to E_ALL (or the integer 2047) ?

dazaaa

Here is the output of my phpinfo()
under configuration php core

enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 2047 2047
expose_php On On
extension_dir c:\PHP\ext c:\PHP\ext
file_uploads On On

the location of my php_mysql.dll is :

C:\PHP\ext
ext

according to a windows search.. so it can find my ext directory in the PATH

Any more ideas? do you think its because the c in the c:\PHP is case sensitive?

bradgrafelman

No, the C isn't case sensitive.

I'm somewhat at a loss as to why it's not working. Try switching to [man]MySQLi[/man] instead since you're using PHP5.

Houdini

Two reasons you don't see any change using phpinfo().
One you failed to restart your server.
Two you are not editing the "active" php.ini.
Do a hard disk search for php.ini and if there are more than one then edit them all to reflect the same changes. I would restart the server after editing each php.ini that you are changing and see which one is the proper or "active" one.

dazaaa

Thanks for the input, its much appreciated.

I need to run MySQL with PHP as I would like to use PHP for some pages for my sales funnel. I am already using Python and MySQL and Apache 2. And this all seems to be working fine. I have also removed python and it still does the same thing.

Unfortunatley I am still unable to get PHP and MySQL to work.
something weird is going on.

I checked to see if I had more than 1 php.ini and I only have 1.

Here is another example of some code.
It seems that everything is fine until the mysql functions are called.

<?php
/
Created on May 1 2006

Connect to the MYSQL Database
/
echo "test";
?>
Blah Blah Blah
<?php
$username = "daz";
$password = "letmein";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
mysql_close($dbh);
?>

this returns to the browser:

test Blah Blah Blah

and nothing else.
its possible I have missed something when installing the extension, but I have read most of the php faq's on MySQL and I believe I dont seem to be missing anything.

The only thing left seems to me that I should try MySQLi

Ill let you know how it goes.

delboy1978uk

i think i hav e the same problem i just posted a thread

try copying your php.ini to c:\windows, and restarting apache

i find that when i do that, mysql successfully connects

but the downside is that the phpinfo page (that once worked) displays blank

i cant seem to get both to work together, and the ini file in multiple location thing has something to do with it