Awesome... that worked! The PHPIniDir was pointing to my earlier
installation. Thanks Matt and Jon! Your help is much appreciated.
Jon, thanks for sending the script.
Manysh
On Sat, Mar 8, 2008 at 9:57 PM, Matt Anderton <manderton@xxxxxxxxx> wrote:
> httpd.conf should have something like this:
>
> PHPIniDir "C:/Program Files/PHP/"
> LoadModule php5_module "C:/Program Files/PHP/php5apache2.dll"
> AddType application/x-httpd-php .php
>
> ... but all that should have been taken care of by the PHP installer.
>
> -- matt
>
>
>
> On Sat, Mar 8, 2008 at 9:16 PM, Manysh <geminish@xxxxxxxxx> wrote:
>
> > Matt - you're right! I did the manual install and its "partially"
> > working now. I say partially because it works fine when I run it from
> > the command window however when I run it from the web browser I get a
> > blank page. I restarted Apache but that didn't help. The script is
> > pasted below. Am I missing from the Apache side now? I have configured
> > http.conf too... is there anything else I need to take care of?
> > Thanks
> >
> > ----
> > <?php
> > /*--------- DATABASE CONNECTION INFO---------*/
> > $hostname="localhost";
> > $mysql_login="testuser";
> > $mysql_password="testuser";
> >
> >
> > 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 7:22 PM, Matt Anderton <manderton@xxxxxxxxx> wrote:
> > > Manysh -- maybe you missed the MySQL extension installation?
> > >
> > > 2nd or 3rd screen in the setup process there is a list of extensions --
> none
> > > of them are installed by default.
> > >
> > > Your manual method of creating the 'ext' directory is a step in the
> right
> > > direction, but you probably have a missing directive or two in your
> php.ini.
> > >
> > > something like...
> > > [PHP_MYSQL]
> > > extension=php_mysql.dll
> > >
> > > but there may be some other directives you are missing - port numbers,
> etc.
> > > best to just reinstall.
> > >
> > > -- matt
> > >
> > >
> > >
> > >
> > > 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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > >
> > >
> >
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
