note 53527 added to ref.mysql

From: 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

« previous php.notes (#89926) next »