connecting MySQL and PHP

Hi there! new to this newsgroup and need help!
i've installed php5 and mysql 5 on IIS 5(W XP prof),
i got php working fine and by using command line i can
create databases and tables fine!

Now trouble is i can't get my php files to fetch
information from databases/mysql server, i have uncommented
the php_mysql.dll in the php ext folder and also copied libmysql.dll in
window system
still nothing is howing up!

Where am i doing wrong!

Thanks

Re: connecting MySQL and PHP

landrik@gmail.com wrote:
>
> i've installed php5 and mysql 5 on IIS 5(W XP prof),
> i got php working fine and by using command line i can
> create databases and tables fine!
>
> Now trouble is i can't get my php files to fetch
> information from databases/mysql server, i have uncommented
> the php_mysql.dll in the php ext folder and also copied libmysql.dll in
> window system
> still nothing is howing up!
>
> Where am i doing wrong!

Did you get any error messages? What does mysql_error() return if you
call it?

Cheers,
NC

Re: connecting MySQL and PHP

landrik@gmail.com wrote:
>
> i've installed php5 and mysql 5 on IIS 5(W XP prof),
> i got php working fine and by using command line i can
> create databases and tables fine!
>
> Now trouble is i can't get my php files to fetch
> information from databases/mysql server, i have uncommented
> the php_mysql.dll in the php ext folder and also copied libmysql.dll in
> window system
> still nothing is howing up!
>
> Where am i doing wrong!

Did you get any error messages? What does mysql_error() return if you
call it?

Cheers,
NC

Re: connecting MySQL and PHP

ha scritto nel messaggio
news:1147772042.416082.278280@i40g2000cwc.googlegroups.com.. .
> Hi there! new to this newsgroup and need help!
> i've installed php5 and mysql 5 on IIS 5(W XP prof),
> i got php working fine and by using command line i can
> create databases and tables fine!
>
> Now trouble is i can't get my php files to fetch
> information from databases/mysql server, i have uncommented
> the php_mysql.dll in the php ext folder and also copied libmysql.dll in
> window system
> still nothing is howing up!
>

please post
phpinfo();
?>


> Where am i doing wrong!
>
> Thanks
>

Re: connecting MySQL and PHP

I'm having the same problem, only on Apache 2.

PHPMyAdmin works fine, so I know the three are communicating, but my
scripts seem to do nothing, or at least output nothing.

My test script:







$mysql = mysql_connect("localhost","cwrinn","password") or die('Unable
to Authenticate to ODBC'.mysql_error());
mysql_select_db(snapon_dev, $mysql) or die('Error Selecting
Database'.mysql_error());
$result = mysql_query("select * from branch limit 0,30", $mysql) or
die('Error querying database'.mysql_error());

while ($row = mysql_fetch_row($result))
{
for ($i=0; $i echo $row[$i] . " ";

echo "\n";
}
mysql_close($connection);
?>




I get no error message from my die() functions, no errors in my php
error_log. display_errors = On. Is there something I am missing?

Re: connecting MySQL and PHP

c.wrinn@gmail.com wrote:
>
> PHPMyAdmin works fine, so I know the three are communicating, but my
> scripts seem to do nothing, or at least output nothing.
>
> My test script:
>
>
>
>
>
>
>
> > $mysql = mysql_connect("localhost","cwrinn","password") or die('Unable
> to Authenticate to ODBC'.mysql_error());
> mysql_select_db(snapon_dev, $mysql) or die('Error Selecting
> Database'.mysql_error());
> $result = mysql_query("select * from branch limit 0,30", $mysql) or
> die('Error querying database'.mysql_error());
>
> while ($row = mysql_fetch_row($result))
> {
> for ($i=0; $i > echo $row[$i] . " ";
>
> echo "\n";
> }
> mysql_close($connection);
> ?>
>
>
>
>
> I get no error message from my die() functions, no errors in my php
> error_log. display_errors = On. Is there something I am missing?

Does your script file have a .php extension?
What happens if you replace "
Cheers,
NC

Re: connecting MySQL and PHP

Am 17 May 2006 14:03:56 -0700 schrieb c.wrinn@gmail.com:

> I'm having the same problem, only on Apache 2.
>
> PHPMyAdmin works fine, so I know the three are communicating, but my
> scripts seem to do nothing, or at least output nothing.
>
> My test script:
>
>
>
>
>
>
>
> > $mysql = mysql_connect("localhost","cwrinn","password") or die('Unable
> to Authenticate to ODBC'.mysql_error());
> mysql_select_db(snapon_dev, $mysql) or die('Error Selecting
> Database'.mysql_error());
> $result = mysql_query("select * from branch limit 0,30", $mysql) or
> die('Error querying database'.mysql_error());
>
> while ($row = mysql_fetch_row($result))
> {
> for ($i=0; $i > echo $row[$i] . " ";
>
> echo "\n";
> }
> mysql_close($connection);
> ?>
>
>
>
>
> I get no error message from my die() functions, no errors in my php
> error_log. display_errors = On. Is there something I am missing?


Try
mysql_select_db("snapon_dev", $mysql)
instead of mysql_select_db("snapon_dev", $mysql)
(regrad the quotes)

or what is snapon_dev doing? A function?

Re: connecting MySQL and PHP

Am Thu, 18 May 2006 19:59:13 +0200 schrieb -@-.--:

> From: -@-.--
> Subject: Re: connecting MySQL and PHP
> Newsgroups: alt.php.sql
> User-Agent: 40tude_Dialog/2.0.15.1de
> MIME-Version: 1.0
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: 7bit
> References: <1147772042.416082.278280@i40g2000cwc.googlegroups.com> <1147899836.554322.306210@g10g2000cwb.googlegroups.com>
> Date: Thu, 18 May 2006 19:59:13 +0200
> Message-ID:
> NNTP-Posting-Host: 83.228.131.194
> X-Trace: news.tiscalinet.ch 1147975154 83.228.131.194 (18 May 2006 19:59:14 +0200)
> Organization: Customers of VTX Datacomm AG - http://www.datacomm.ch/
> Lines: 50
> Path: news.tiscalinet.ch!not-for-mail
> Xref: news.tiscalinet.ch alt.php.sql:24729
>
> Am 17 May 2006 14:03:56 -0700 schrieb c.wrinn@gmail.com:
>
>> I'm having the same problem, only on Apache 2.
>>
>> PHPMyAdmin works fine, so I know the three are communicating, but my
>> scripts seem to do nothing, or at least output nothing.
>>
>> My test script:
>>
>>
>>
>>
>>
>>
>>
>> >> $mysql = mysql_connect("localhost","cwrinn","password") or die('Unable
>> to Authenticate to ODBC'.mysql_error());
>> mysql_select_db(snapon_dev, $mysql) or die('Error Selecting
>> Database'.mysql_error());
>> $result = mysql_query("select * from branch limit 0,30", $mysql) or
>> die('Error querying database'.mysql_error());
>>
>> while ($row = mysql_fetch_row($result))
>> {
>> for ($i=0; $i >> echo $row[$i] . " ";
>>
>> echo "\n";
>> }
>> mysql_close($connection);
>> ?>
>>
>>
>>
>>
>> I get no error message from my die() functions, no errors in my php
>> error_log. display_errors = On. Is there something I am missing?
>
>
> Try
> mysql_select_db("snapon_dev", $mysql)
> instead of mysql_select_db("snapon_dev", $mysql)
> (regrad the quotes)
>
> or what is snapon_dev doing? A function?

Uuups
Sorry mistakes
I meant
.... instead of mysql_select_db(snapon_dev, $mysql)

Re: connecting MySQL and PHP

I don't know if it was the " " around the database name or the but I applied both and it worked. Thanks, guys!