NuSphere Forums Forum Index
NuSphere Forums
Reply to topic
MySql extention issues with PHP


Joined: 12 Sep 2006
Posts: 3
Reply with quote
Okay I have searched all over and have yet to solve this issue.

I have used the DB-form wizard to get data from my mysql database. I made the connection saw the data when I wrote the SQL statement.

I then went to run the form and it tells me to enable mysql extension. I have done this. I uncommented out the mysql.dll in both php.ini files in php4 and php 5. MySql is enabled.

I am not sure where else to look to enable mysql extentions.

Help!
Gina
View user's profileFind all posts by gsternerSend private message
Site Admin

Joined: 13 Jul 2003
Posts: 8334
Reply with quote
I'm not sure what you mean. Would you specify what particular problem you faced with?

BTW, there is no mysql.dll extension. Only php_mysql.dll and only for php5. It's built in into php4.

_________________
The PHP IDE team
View user's profileFind all posts by dmitriSend private messageVisit poster's website


Joined: 12 Sep 2006
Posts: 3
Reply with quote
;extension=php_yaz.dll
;extension=php_zip.dll
extension=php_mysql.dll
extension=php_dbg.dll-4.4.x


Okay Let me see how to explain. Above is from the php.ini file in the I have uncommented out the php_mysql.dll in both php.ini in php4 and php5.

below is the config.inc.php code the DB form wizard made and while making the form I was able to connect to the MySql database and see the data.



$site["path"] = "C:/Program Files/nusphere/phped"; #Change as reqired. /var/www/html/
$site["lang"] = 'en'; #you may need multilingual support.
$site["ext"] = '.php'; # extension for your php files
$site["dbhost"] = 'xxxxx';
$site["dbport"] = 'xxx';
$site["dbname"] = 'xxx';
$site["dblogin"] = 'xxx';
$site["dbpass"] = 'xxxx';

require_once $site["path"].'/include_lib/db_myutil.inc';

Then I stepped into F7 to run the form to see the data and when it came to the db_myutil.inc file the form died on the function I copied below.

The error states to enable mysql extension. My connection is good yet it still says to enable my extension. So I am at a loss here.


function ensureConnectionAvailable() {
if (isConnectionAvailable()) {
return(true);
} else {
die("Please enable MySQL extension !");
}
}

Output states: Please enable MySQL extension !

I hope this makes more sense. It is driving me nuts.
View user's profileFind all posts by gsternerSend private message
Site Admin

Joined: 13 Jul 2003
Posts: 8334
Reply with quote
yet it still makes very little sense Smile
probably you have php.ini in Windows directory or php.ini pointed by in the registry.
Would you just run phpinfo() somewhere in your script and make sure what php.ini is used?

Function isConnectionAvailable() is below, it just check if mysql_connect() is available.

Code:
  function isConnectionAvailable() {
    return(function_exists('mysql_connect'));
  }


From what you posted it's clear that mysql_connect is not available and clearly indicates that php_mysql.dll is not installed, probably due to the reason mentioned above.

_________________
The PHP IDE team
View user's profileFind all posts by dmitriSend private messageVisit poster's website
MySql extention issues with PHP
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 5 Hours  
Page 1 of 1  

  
  
 Reply to topic