JC Botha wrote:
Ok, I did the phpinfo() and only the SQLlite is listed there, no MySQL is listed. I did enable the php_mysql.dll and set the windows path to c:\php. What else it there that I can look at. Thanks for all the links sent to me, I read them all and try to follow the instructions but some how I dont do someting tight on my XP computer.
In your php.ini file, you will find a line:
extension=php_mysql.dll
This line should not have a ; in the beginning of the line. If it does, remove it. Then, restart apache. That's all you need to do to enable MySQL support. After you do this, look at the phpinfo() output again. You will see that MySQL is now shown in the output.
Janet
On 4/15/05, Janet Valade <jvalade@xxxxxxxx> wrote:
JC Botha wrote:
This is the Browser error: Fatal error: Call to undefined function mysql_connect() in C:\apache\htdocs\cedarintranet\index.php on line 3
This error means that MySQL support is not enabled in your PHP. In PHP 4, this was done automatically. Now you need to enable it yourself when you install. You can tell whether it's enabled by running a phpinfo() statement in your PHP script. This statement outputs a long list of PHP settings. Somewhere in that list, it provides a block of MySQL settings for installations that have MySQL support enabled. If your output doesn't show the MySQL settings, then MySQL support is not enabled.
To enable it on a Windows machine, in your php.ini file, uncomment the "extension" line for mysql. You may need to restart Apache after you edit the php.ini file. Be sure you are making changes in the php.ini file that PHP is using. The output, mentioned above, from phpinfo() shows the path to the php.ini file that PHP is using.
Janet
This is my php code: // Connect to the database server $dbcnx = mysql_connect("localhost", "intranet", "1234"); if (!$dbcnx) { echo( "<P>Unable to connect to the " . "database server at this time. Please make use of the contact page.</P>" ); exit(); }
// Select the database if (!@mysql_select_db("cedarintranet") ) { echo( "<P>Unable to connect to the " . "database server at this time. Please contact webmaster at jcbotha@xxxxxxxxxxxx</P>" ); exit(); }
On 4/15/05, Kevin Smith <kevin@xxxxxxxxxxxxxxx> wrote:
Perhaps posting you code will help us resolve your problem.
JC Botha wrote:
Dear Users
I'm havin a problem to connect to MySQL through the use of PHP5. I followed all documentation and none seem to resolve the problem. I'm running WinXP on the computer that I use to develop the apps. Any advice out there that could be of help.
Thanks
-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- Janet Valade -- janet.valade.com
-- Janet Valade -- janet.valade.com
-- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
