Sorry. I can't really help you with server and PHP installation and configuration issues. I use XAMPP w/ a separate installation of MySQL. http://www.apachefriends.org/en/xampp.html But, find the following in your php.ini: extension_dir=... extension=php_mysql.dll You may already have an "ext/" folder, just not where you were thinking it'd be. And, the extension may be commented out (semicolon at the beginning of the line). Theoretically, you should've recieved an "undefined function" error if it was commented. If the folder that extension_dir points to is empty or undefined, then I'd say go download the Windows ZIP and rebuild the folder. As for the script, do you have an example output? If you're up for it, I wrote test script that outputs a few more details. <?php header('Content-type: text/plain'); $hostname = 'localhost'; $mysql_login = 'admin'; $mysql_password = 'admin'; $dbname = 'sampleapp'; echo "PHP: " . phpversion() . "\n\n"; echo "Connecting to (MySQL) $hostname (user: $mysql_login)\n"; $link = @mysql_connect($hostname, $mysql_login, $mysql_password); echo "--------------------------------\n"; echo "Status: " . serialize($link) . " ($link)\n"; echo "Error : '" . mysql_error() . "' (" . mysql_errno() . ")\n"; echo "\n"; echo "Server: " . @mysql_get_server_info() . "\n"; echo "Host : " . @mysql_get_host_info() . "\n"; echo "\n"; echo "Select database `$dbname`\n"; $dbselect = @mysql_select_db($dbname); echo "--------------------------------\n"; echo "Status: " . serialize($dbselect) . " ($dbselect)\n"; echo "Error : '" . mysql_error() . "' (" . mysql_errno() . ")\n"; echo "\n"; echo "Closing connection\n"; $dbclose = @mysql_close($link); echo "--------------------------------\n"; echo "Status: " . serialize($dbclose) . " ($dbclose)\n"; echo "Error : '" . mysql_error() . "' (" . mysql_errno() . ")\n"; ?> The output should be something like this: PHP: 5.2.5 Connecting to (MySQL) localhost (user: admin) -------------------------------- Status: i:0; (Resource id #2) Error : '' (0) Server: 5.0.45-community-nt Host : localhost via TCP/IP Select database `sampleapp` -------------------------------- Status: b:1; (1) Error : '' (0) Closing connection -------------------------------- Status: b:1; (1) Error : '' () - Jon L. On Sat, Mar 8, 2008 at 5:53 PM, Manysh <geminish@xxxxxxxxx> wrote: > Thanks for your input, Jon. Few more observations... > > Yes, I have PHP+Apache+MySQL installed for private use. I am just > trying to connect to the database successfully first and will create > other users when I make a successful connection. I made the changes as > below and still cannot connect to the database. The echo "After > connecting to the database..." is not in an if statement. I modified > the script to make it real simple for me.... > > I found this document: > http://www.artfulsoftware.com/php_mysql_win.html which outlines > installation and configuration steps for MySQL and PHP. Unfortunately, > I can't get it to work. One thing I noticed is that my PHP > inatallation didn't have any "ext" directory so I manually created one > and copied php_mysqli.dll to this directory and restarted my computer. > It didn't work still. Any comments/ideas? > ---- > <?php > /*--------- DATABASE CONNECTION INFO---------*/ > $hostname="localhost"; > $mysql_login="admin"; > $mysql_password="admin"; > > echo "Connected successfully yet? Probably not."; > > $link = @mysql_connect($hostname,$mysql_login,$mysql_password); > if (!$link) { > //die('Could not connect: ' . mysql_error()); > echo "Some problem here...."; > } > else > echo "Connected?"; > > $dbname = 'sampleapp'; > $dbselect = @mysql_select_db($dbname); > > if ($dbselect) > echo "Connected to the database"; > else > echo "Still not connected to the database"; > mysql_close($link); > ?> > ---- > > > > > > On Sat, Mar 8, 2008 at 3:07 PM, Jon L. <jonllmsed@xxxxxxxxx> wrote: > > Since you seem to want to handle the errors yourself, you may try using > the > > @ operator on the mysql functions. > > It'll silence any errors or warning that the functions might usually > > generate; but, of course, you'll be left to test for errors yourself. > > > > > > $link = @mysql_connect($hostname,$mysql_login,$mysql_password); > > > > @mysql_select_db($dbname); > > > > With that, the following statement should return any errors that MySQL > would > > otherwise generate: > > > > > > if (!$link) { > > die (mysql_error()); > > } > > > > > > Now, I don't see any reason for the 2nd echo (i.e., echo " After > connecting > > to the database...";) to not be called. > > Is it in an if statement or other structure/scope in your actual script? > > > > However, I do see a reason for another to never be called: > > > > > > if (!$link) { > > die('Could not connect: ' . mysql_error()); > > echo "Some problem here...."; > > } > > > > Once you call die, script execution discontinues. > > The echo after it will never be called, either by !$link returning false > to > > if or by die being called first. > > > > > > On another note... > > This sounds like you have PHP & MySQL installed for private use. > > But, even if that's the case, I don't recommend connecting to the admin > > account unless you really need to. > > > > You should check out the following page on adding users: > > http://dev.mysql.com/doc/refman/5.0/en/adding-users.html > > > > And read up on the following commands: > > CREATE USER: http://dev.mysql.com/doc/refman/5.0/en/create-user.html > > GRANT: http://dev.mysql.com/doc/refman/5.0/en/grant.html > > > > - Jon L. > > > > > > > > On Sat, Mar 8, 2008 at 1:36 PM, Manysh <geminish@xxxxxxxxx> wrote: > > > > > > > > > > > > Hi, > > > > > > I am trying to make a connection to the MySQL database from PHP but it > > > seems like I am missing a step or something and hence cannot connect > > > to the database. I have tried everything but I can't figure out why. > > > Please suggest/help (I am a beginner in PHP/MySQL/Apache). > > > > > > I am using MySQL 5.0.51a-community-nt on my Windows XP machine. PHP > > > version used is 5.2 and Apache version is 2.2. > > > > > > Code Snippet: > > > > > > $hostname="localhost"; > > > $mysql_login="admin"; > > > $mysql_password="admin"; > > > //$database="sampleapp"; > > > > > > echo "Print this..."; // THIS MESSAGE IS PRINTED > > > > > > $link = mysql_connect($hostname,$mysql_login,$mysql_password); > > > > > > echo " After connecting to the database..."; // THIS DOES NOT PRINT > > > if (!$link) { > > > die (mysql_error()); // NOR THIS ONE > > > } > > > > > > $dbname = 'sampleapp'; > > > mysql_select_db($dbname); > > > > > > echo $link; > > > > > > if (!$link) { > > > die('Could not connect: ' . mysql_error()); > > > echo "Some problem here...."; > > > } > > > //echo 'Connected successfully'; > > > mysql_close($link); > > > ?> > > > > > > Any help is appreciated. > > > Thanks, > > > Manysh > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > >
