localhost vs. IDE Execute problems.

cyclops_one-eye

Hi! I am brand new to PHP. I just installed Apache, MySQL, and PHP onto my machine. For editing purposes, I installed PHPDesigner2005.

My problem is this: I have some PHP code that uses some of the MySQL functions. When I use PHPDesigner's Build / Execute option from within the IDE, the code runs just fine. But when I try to run the script from a Browser through localhost, nothing happens.

I can run other code through a browser -- generally code that doesn't use the MySQL functions, but for some reason, this code just doesn't go.

Does anyone have any suggestions?

bastien

Well, just saying it doesn't work is a problem. Post code, post errors, post something...Gonna need more details to be able to start helping you

cyclops_one-eye

Well, actually, it is not my code. It is the code that I found at http://www.ikemcg.com/scripts/pec/downloads.html

The reason I did not mention or post this was because I figured that it is not a code issue. This is not code that I wrote. And I guess I am under the assumption that it has already been tested. I was wondering if there might be something wrong with my Apache, MySQL, PHP installation or configuration...

Let me know if you have any other questions.

bastien

what versions of php, mysql? New versions of php don't automatically include the mysql functions as they used to be

cyclops_one-eye

Yeah, I know... I had to struggle through figuring that out. But I did end up including the "--with" directive for MySQL in the php.ini ... and that's when the code even started working from the IDE (PHPDesigner2005) in the first place.

The disconnect is happening between the web browser and I assume the Server.

Versions:

Apache 2.x.x
PHP 4.1.7
MySQL 5.0.1a-alpha

I think that's what I have. My friend and I are just now starting to learn PHP, so we grabbed whatever we could to start up.

Does that help?

cyclops_one-eye

OK, so it's not just with mysql commands... I wrote some of my own code which did not work in IE, but it did work in FireFox.

I just can't figure out what is going on...

cyclops_one-eye

Scratch that last post. I'm back to thinking that it really is just MySQL.

I am running PHP 5.0.x... and if I try to enable the php_mysql.dll extension in php.ini, when I bring up the Apache server, it will not load it. It says that it is not found. I can load most or all of the other ones. I haven't tried them all so I don't know about all. But at one point I wasn't able to load the php_mssql.dll. so I went and copied all of those libs into the system32 directory. Now php_mssql.dll will load.

But not mysql. And then, I try the following code:


<?php 

if (!extension_loaded('mysql'))
{
    echo "not loaded.  loading...";
    $prefix = (PHP_SHLIB_SUFFIX == 'dll') ? 'php_' : '';
    enable_dl($prefix . 'mysql.' . PHP_SHLIB_SUFFIX);
}

if (extension_loaded('mysql'))
{
    echo "<br>loaded<br>";
}
else
{
    echo "<br>didn't load<br>";
}

print_r(get_loaded_extensions());

?>

PHPDesigner2005 will spit out the following:

not loaded. loading...
loaded

but when I try to access this page from a browser (either FireFox or IE 6.0) via localhost I get the following:

not loaded. loading...
didn't load

WHY???? does anyone have any clue what is going on? Please help if you do.

bastien

Could be the environment within the IDE. It may run PHP 4.0.x which does use the mysql library. You real environment is running 4.1.x which really should use the mysqli library. Try changing the ini file to use that new library

cyclops_one-eye

Well, I pointed the IDE to the php.exe for php 5.0.x (don't remember the x right now...)

So... what you are saying is that I should enable extensions for php_mysqli.dll?

Well, I will definitely give that a shot and let you know.

Thank you very much for your help!!!

cyclops_one-eye

Well, I don't know why my last post didn't show up... but....

I went ahead and tried your suggestion. I was able to enable mysqli, but that didn't help. I still cannot get a browser to be able to access (use) any of the mysql functions.

Is there something that I am overlooking?