Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.php > #7409

Re: cant use mysql_connect

Message-ID <4053820.uDPMeCtHly@PointedEars.de> (permalink)
From Thomas 'PointedEars' Lahn <PointedEars@web.de>
Organization PointedEars Software (PES)
Date 2012-11-01 00:56 +0100
Subject Re: cant use mysql_connect
Newsgroups comp.lang.php
References <k6jmij$jt1$1@dont-email.me> <k6piis$ren$1@dont-email.me>
Followup-To comp.lang.php

Followups directed to: comp.lang.php

Show all headers | View raw


Markus Grob wrote:

> Markus Grob wrote:
>> But if I now try to connect to the database, pypmyadmin tells me, that
>> mysql can't be found: Cannot load mysql extension.
> 
> I have read all the postings and now, I don't know, what I should do. I
> can rewrite my code, to use the mysqlnd locally, but I don't know, if
> normal webservers could use the new code. Will this normally be? How can
> I find it out?

The extensions need to be loaded.  phpinfo() can tell.
 
> The php_mysql.dll and php_mysqli.dll are in the /ext directory and I
> have pointed to them in the php.ini:
> 
> ...
> extension_dir = "C:\Program Files (x86)\php\ext"
> ...
> [PHP_MYSQL]
> extension=php_mysql.dll
> [PHP_MYSQLI]
> extension=php_mysqli.dll

The sections are optional (AFAIK), the `extension' directives are not.

> What special is, phpinfo tells me, that apache thinks, that the php.ini
> is in c:7windows, but this isn't true. It is in the php dir:
> C:\Program Files (x86)

Does phpinfo() say that the two extensions are loaded?  (Are there any 
occurrences of `mysql' or `mysqli' headings in the output?)

Are you sure there is only one php.ini?  It matters not if you write your 
directives into an .ini file that is not considered by PHP in the first 
place.

> Could it be, that the problem is coming from the "Program Files (x86)"
> path?

Yes.  Look in the phpinfo() output where it says where the .ini files are 
and modify *those* files.  As an alternative, you can set the PHPDIR system 
environment variable to your real PHP directory, then restart Apache.  (This 
has worked for me with the PHP ISAPI module on Windows.  It might also work 
with Apache on Windows.)

I am afraid your English is not so good, therefore not well readable and 
understandable; it is obviously based on German sentence structure (I can 
tell).  Why do you not post to de.comp.lang.php instead?


PointedEars
-- 
Prototype.js was written by people who don't know javascript for people
who don't know javascript. People who don't know javascript are not
the best source of advice on designing systems that use javascript.
  -- Richard Cornford, cljs, <f806at$ail$1$8300dec7@news.demon.co.uk>

Back to comp.lang.php | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

cant use mysql_connect Markus Grob <snoopy@ilnet.ch> - 2012-10-28 17:30 +0100
  Re: cant use mysql_connect "J.O. Aho" <user@example.net> - 2012-10-28 17:44 +0100
    Re: cant use mysql_connect Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-10-29 04:16 +0100
      Re: cant use mysql_connect "J.O. Aho" <user@example.net> - 2012-10-29 07:34 +0100
        Re: cant use mysql_connect Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-10-29 14:23 +0100
      Re: cant use mysql_connect The Natural Philosopher <tnp@invalid.invalid> - 2012-10-29 11:24 +0000
  Re: cant use mysql_connect Luuk <luuk@invalid.lan> - 2012-10-28 17:51 +0100
  Re: cant use mysql_connect Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-10-28 20:21 +0100
  Re: cant use mysql_connect "J.O. Aho" <user@example.net> - 2012-10-29 07:39 +0100
  Re: cant use mysql_connect Markus Grob <snoopy@ilnet.ch> - 2012-10-30 22:58 +0100
    Re: cant use mysql_connect Jerry Stuckle <jstucklex@attglobal.net> - 2012-10-30 19:18 -0400
    Re: cant use mysql_connect "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-10-31 10:07 +0100
      Re: cant use mysql_connect "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-10-31 10:15 +0100
    Re: cant use mysql_connect Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-11-01 00:56 +0100

csiph-web