note 53527 added to ref.mysql
| From: | MicrosoulV3 at osu1 dot php dot net | Date: | Sat, 04 Jun 2005 22:47:46 +0000 |
| Subject: | note 53527 added to ref.mysql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-89926@lists.php.net to get a copy of this message | ||
I use IIS 6, PHP 5.04, Windows Server 2003 and MySQL 4.1.11. and here is what I was able to figure
out.
To get MySQL and PHP to talk to each other, in the php.cfg, dont forget to turn on the tag
cgi.force_redirect = 0, and make sure you set it at 0 (it is default at 1. just delete the
semi-colon from in front of it to activate it in the code) Then the phpinfo will say its reading the
cfg from your PHP install directory instead of your WINDOWS root. Then your phpinfo will show the
MySQL entry that some people may be having a hard time with. No registry settings or copying of
anything is needed. Also follow the rest of the excellent help from the user comments. Here's
what I did, to make it simple:
I made a folder in the folder tree just above program files (explore your computer) and named it
PHP. I extracted the .zip php version into it (not the auto install version). I edited the
php.ini-recommended, renamed it to just php, added my sql username, database name, etc.( you really
gotta look closely at the cfg file and make sure you dont overlook something). Turned on the
extension=php_mysql.dll (just delete the semi-colon thats in front of it). Added the php folder to
the PATH (instructions on how to do this are pretty simple, and documented above). I also made the
ext folder available to the PATH, but Im not sure if it's really necessary. The user comments
are what really helped me, so I thought I would return the favor, and try to expand on this topic a
little bit.
----
Manual Page -- http://www.php.net/manual/en/ref.mysql.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+53527
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+53527&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+53527&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+53527&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+53527&report=yes&reason=useless
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+53527&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+53527&report=yes
Search -- http://master.php.net/manage/user-notes.php