|
|
Posted by Johnny on 10/01/06 06:48
"Schmalz" <gpshea@hotmail.com> wrote in message
news:451d4489$0$4666$61c65585@un-2park-reader-01.sydney.pipenetworks.com.au.
...
> "Johnny" <removethis.huuanito@hotmail.com> wrote in message
> news:htTSg.463$UJ2.162@fed1read07...
> >
> > "Schmalz" <gpshea@hotmail.com> wrote in message
> >
news:451be14c$0$4666$61c65585@un-2park-reader-01.sydney.pipenetworks.com.au.
> > ..
> >> Hi all. Probably not an original posting but I have searched high and
> >> low
> >> for a satisfactory resolution to this problem. I am using Windows XP,
> >> IIS
> >> 5.1, PHP 5.1.4 and MySQL 5.0.23 and Dreamweaver 8. When I try to
create
> >> a
> >> database connection I get the "Your PHP server doesn't have the MySQL
> > module
> >> loaded or you can't use the mysql_(p)connect functions" error. I have
> >> downloaded the latest mysqli and mysql extensions (PHP 5.1.6 and MySQL
> >> Server 5.0.24a) and copied these into my C:\PHP\ext directory. I
believe
> > I
> >> have already made the required changes to the php.ini file however this
> > may
> >> not be 100% right. Any further advice and/or assistance would be
greatly
> >> appreciated.
> >>
> >>
> > make yourself a phpinfo.php file that has a call to phpinfo() and run
that
> > to see what's loaded, what points to where, the dir of your ini file,
> > etc.,
> > etc.
> >
> >
> Hi,
>
> I have done that now. What specifically should I be looking for? Let me
> know what particular information I need and I will tell you what it says.
>
> Thanks.
>
At the top there'll be an entry:
Configuration File (php.ini) Path
Under php core there'll be an entry:
extension_dir
check they all point where you think they should, that is that you are using
the ini file you think you are and that your extensions are coming from the
right directory (you think it's C:\PHP\ext but what does php think it is?),
etc.
Then scroll down, there are module enries in alphabetical order, see if you
can see an entry for MySql.
If there's not one there MySql isn't loaded (but you knew that already right
;-) which could be for any one of a number of reasons.
If it's the right extensions directory and PHP is reading the correct ini
file that you modified then perhaps you haven't done all the things they say
here http://us3.php.net/manual/en/ref.mysql.php under PHP 5+
I note that it says "The supporting DLLs for the PHP 5 extensions are also
not in a seperate directory." in the manual install instructions so you may
want to check where php_mysql.dll is and also libmysql.dll (this should be
either in the windows system dir [not recommended] or the PATH variable
should have an enry that points to where it is).
You may also want to set
display_startup_errors = On
in the ini file until you have finished debugging, so you can see any errors
that occur on start up.
Good luck.
Navigation:
[Reply to this message]
|