Re: mysql_connect() Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux