On Sat, 28 Aug 2004 16:57:27 -0700, gc <[EMAIL PROTECTED]> wrote: > Let me try this again, > > I'm Gene Candelaria and I'm a PHP and MySQL newbie. I have a feeling a lot > of you may have seen this before. I'm teaching myself > PHP/MySQL and trying to setup a guestbook. I'm running latest versions of > Apache, PHP and MySql on WIN 2000. PHP is installed from the zip file. When > serving php docs (code snippets below) I get the messages: > > "Fatal error: Call to undefined function mysql_connect() " > "Fatal error: Call to undefined function mysql_pconnect() " >
You need to enable the mysql dll in your php.ini > I've been reading and searching and trying all sorts of things to fix this > and can't find the solution. I've removed the comment from the line > "extension=php_mysql.dll" in php.ini. (Below is the MySQL section of > php.ini. It's pretty standard, I'm using defaults.) I edited my Apache > config file with the needed lines: > > ### Section 4: PHP 5 Module > # > ScriptAlias /cgi-bin/ "C:/Program Files/Apache > Group/Apache2/cgi-bin/" > LoadModule php5_module php/php5apache2.dll > AddType application/x-httpd-php .php > AddType application/x-httpd-php-source .phps > PHPIniDir "C:/Program Files/Apache Group/Apache2/PHP" > > When I run phpinfo, MySQL is not listed. Do I need to enable it in the > configure command? How do I edit the configure command. Per phpinfo, It now > reads: > > Configure Command cscript /nologo configure.js "--with-gd=shared" > "--enable-snapshot-build" > > I read these comments: > > Ok, your php.ini file is set to 'on' for mysql.allow_persistent, but > is > mysql really enabled? Does your configure command look something > like > this? > './configure' > '--with-mysql=/usr/local/mysql'............................................ > > If you don't have --with-mysql it means that you cannot use mysql > functions, > so compile PHP again with this option. > > How do I edit that pesky configure command. I searched, but couldn't find an > answer. So, where am I going wrong? Thanks for reading and big thanks for > any help. > > gene > [EMAIL PROTECTED] > > php.ini snippet (comments removed for easier reading: > [MySQL] > mysql.allow_persistent = On > mysql.max_persistent = -1 > mysql.max_links = -1 > mysql.default_port = > mysql.default_socket = > mysql.default_host = > mysql.default_user = > mysql.default_password = > mysql.connect_timeout = 60 > mysql.trace_mode = Off > > guest.php code snippet: > //connect > // change localhost to your db host name > mysql_pconnect( "http://aulon.dyndns.org/";, "$username", "$password") > or die( "Unable to connect to SQL server"); > mysql_select_db( "$db_name") or die( "Unable to select database"); > guestbook.php code snippet: > // Connect to DB > $li = mysql_connect($dbHost, $dbUser, $dbPass) or die("Could not connect"); > mysql_select_db($dbDatabase, $li) or die ("could not select DB"); > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > !DSPAM:4130ba8d143217233713689! > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
