Re: php-windows Digest 23 Jul 2007 22:52:16 -0000 Issue 3288

On 23 Jul 2007 22:52:16 -0000, php-windows-digest-help@lists.php.net
wrote:
>
> php-windows Digest 23 Jul 2007 22:52:16 -0000 Issue 3288
>
> Topics (messages 28227 through 28232):
>
> How to configure PHP support for MySQL on Windows?
> 28227 by: Sean B. Durkin
>
> Re: How do configure PHP support for MySQL on Windows?
> 28228 by: vikas batra
> 28229 by: Sean B. Durkin
> 28230 by: Janet Valade
> 28231 by: Niel Archer
> 28232 by: Sean B. Durkin
>
> Administrivia:
>
> To subscribe to the digest, e-mail:
> php-windows-digest-subscribe@lists.php.net
>
> To unsubscribe from the digest, e-mail:
> php-windows-digest-unsubscribe@lists.php.net
>
> To post to the list, e-mail:
> php-windows@lists.php.net
>
>
> ------------------------------------------------------------ ----------
>
>
> ---------- Forwarded message ----------
> From: "Sean B. Durkin"
> To: php-windows@lists.php.net
> Date: Mon, 23 Jul 2007 15:10:20 +1000
> Subject: How to configure PHP support for MySQL on Windows?
> Hi,
>
>
> How does one configure PHP support for MySQL on Windows?
>
> My host operating system is Windows Server 2003.
> 1. I have installed Apache 2.2 via the msi installer
> (apache_2.2.4-win32-x86-no_ssl.msi).
> 2. I have installed MySQL 5.1 via the windows installer
> (mysql-5.1.20-bet-win32.zip).
> 3. I have installed PHP 5 via the msi installer
> (php-5.2.3-win32-installer.msi)
> 4. I have enabled the php_mysql.dll extension inside of php.ini
> 5. I have ensured that libmysql.dll in on the system path.
>
> I have done all of this correctly, but I still cannot open
> a database from php script! What am I doing wrong? Can any one
> please advise?
>
>
> Please help a PHP/MySQL newbie.
>
> Faithfully,
> Sean B. Durkin
> (s.durkin@{removeThis}gridsense.net
>
>
> ---------- Forwarded message ----------
> From: vikas batra
> To: php-windows@lists.php.net
> Date: Mon, 23 Jul 2007 10:38:52 +0530 (IST)
> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> Pls ensure that ur mysql service has ben started or not if not started then start it from control panel->Administrative tools->services. and then see the results. u r editing right php.ini or not, pls ensure also this one.
>
>
> Vikas Batra
> contact: +91-9818439935
>
> ----- Original Message ----
> From: Sean B. Durkin
> To: php-windows@lists.php.net
> Sent: Sunday, 22 July, 2007 9:52:15 PM
> Subject: [PHP-WIN] How do configure PHP support for MySQL on Windows?
>
> Hi,
>
>
> How does one configure PHP support for MySQL on Windows?
>
> My host operating system is Windows Server 2003.
> 1. I have installed Apache 2.2 via the msi installer
> (apache_2.2.4-win32-x86-no_ssl.msi).
> 2. I have installed MySQL 5.1 via the windows installer
> (mysql-5.1.20-bet-win32.zip).
> 3. I have installed PHP 5 via the msi installer
> (php-5.2.3-win32-installer.msi)
> 4. I have enabled the php_mysql.dll extension inside of php.ini
> 5. I have ensured that libmysql.dll in on the system path.
>
> I have done all of this correctly, but I still cannot open
> a database from php script! What am I doing wrong? Can any one
> please advise?
>
>
> Please help a PHP/MySQL newbie.
>
> Faithfully,
> Sean B. Durkin
> (s.durkin@{removeThis}gridsense.net
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
>
>
>
>
> Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools- 08.html/
>
> ---------- Forwarded message ----------
> From: "Sean B. Durkin"
> To: php-windows@lists.php.net
> Date: Mon, 23 Jul 2007 17:52:56 +1000
> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> Vikas,
>
> The MySQL is started. I have only one php.ini and it is in the correct
> location.
>
> My problem must be something else. But thanks anyway.
>
> Faithfully,
> Sean
>
>
>
> vikas batra wrote:
> > Pls ensure that ur mysql service has ben started or not if not started then start it from control panel->Administrative tools->services. and then see the results. u r editing right php.ini or not, pls ensure also this one.
> >
> >
> > Vikas Batra
> > contact: +91-9818439935
> >
> > ----- Original Message ----
> > From: Sean B. Durkin
> > To: php-windows@lists.php.net
> > Sent: Sunday, 22 July, 2007 9:52:15 PM
> > Subject: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> >
> > Hi,
> >
> >
> > How does one configure PHP support for MySQL on Windows?
> >
> > My host operating system is Windows Server 2003.
> > 1. I have installed Apache 2.2 via the msi installer
> > (apache_2.2.4-win32-x86-no_ssl.msi).
> > 2. I have installed MySQL 5.1 via the windows installer
> > (mysql-5.1.20-bet-win32.zip).
> > 3. I have installed PHP 5 via the msi installer
> > (php-5.2.3-win32-installer.msi)
> > 4. I have enabled the php_mysql.dll extension inside of php.ini
> > 5. I have ensured that libmysql.dll in on the system path.
> >
> > I have done all of this correctly, but I still cannot open
> > a database from php script! What am I doing wrong? Can any one
> > please advise?
> >
> >
> > Please help a PHP/MySQL newbie.
> >
> > Faithfully,
> > Sean B. Durkin
> > (s.durkin@{removeThis}gridsense.net
> >
>
>
> ---------- Forwarded message ----------
> From: Janet Valade
> To:
> Date: Mon, 23 Jul 2007 01:02:21 -0700
> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> Sean B. Durkin wrote:
>
> > Hi,
> >
> >
> > How does one configure PHP support for MySQL on Windows?
> >
> > My host operating system is Windows Server 2003.
> > 1. I have installed Apache 2.2 via the msi installer
> > (apache_2.2.4-win32-x86-no_ssl.msi).
> > 2. I have installed MySQL 5.1 via the windows installer
> > (mysql-5.1.20-bet-win32.zip).
> > 3. I have installed PHP 5 via the msi installer
> > (php-5.2.3-win32-installer.msi)
> > 4. I have enabled the php_mysql.dll extension inside of php.ini
> > 5. I have ensured that libmysql.dll in on the system path.
> >
> > I have done all of this correctly, but I still cannot open
> > a database from php script! What am I doing wrong? Can any one
> > please advise?
>
>
> What error message do you get?
>
> Janet
>
>
> >
> >
> > Please help a PHP/MySQL newbie.
> >
> > Faithfully,
> > Sean B. Durkin
> > (s.durkin@{removeThis}gridsense.net
> >
>
>
> ---------- Forwarded message ----------
> From: Niel Archer
> To: php-windows@lists.php.net
> Date: Mon, 23 Jul 2007 16:44:46 +0100
> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> Hi
>
> > The MySQL is started. I have only one php.ini and it is in the correct
> > location.
>
> That statement is only true, provided your not working under a
> misconception, the usual cause of problems.
>
> Your initial post told us very little useful info, just that you'd
> install this, that and the other. Did you test each component along the
> way to ensure it was working?
>
> If so, what errors does PHP give when attempting to use a MySQl db?
>
> You might try looking at this step by step guide also to see if you
> missed anything
>
> http://wamp.corephp.co.uk/
>
> --
> Niel Archer
>
>
> ---------- Forwarded message ----------
> From: "Sean B. Durkin"
> To: php-windows@lists.php.net
> Date: Tue, 24 Jul 2007 08:53:56 +1000
> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> Niel,
>
> Thanks for your advise. I have tested the Apache web server, and it is
> working fine. I have tested MySQL through a console window, and used it
> to create a database, and it is working fine. I have tested PHP on
> Apache by viewing php pages, and it is working fine.
>
> However if I use a php script to call any php mysql database functions,
> then parsing bombs out without returning an error message. For example,
> the following script returns an blank page to the browser. There is not
> even an error message.
>
>
> The following code is from Kevin Yank's book "Build Your Own Database
> Driven Web-site using PHP and MySQL".
> ================================================
>
>
>
> > content="text/html; charset=iso-8859-1" />
>
>
> > // Connect to the database server
> $dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
> if (!$dbcnx) {
> exit('

Unable to connect to the ' .
> 'database server at this time.

Unable to locate the joke ' .
> 'database at this time.

Here are all the jokes in our database:

> > // Request the text of all the jokes
> $result = @mysql_query('SELECT joketext FROM joke');
> if (!$result) {
> exit('

Error performing query: ' . mysql_error() . '

');
> }
> // Display the text of each joke in a paragraph
> while ($row = mysql_fetch_array($result)) {
> echo '

' . $row['joketext'] . '

';
> }
> ?>
>

Re: Re: php-windows Digest 23 Jul 2007 22:52:16 -0000Issue 3288

Hi Sandeep,

Make a new script called phpinfo.php and save it with this code:


phpinfo();

?>

(end of file)

View that script in your web browser. What is the value next to "Configuration File (php.ini) Path"? Is it what you expected?

Scroll down and look for a section named "MySQL". Is it present? Is it marked as enabled? If it is enabled, we would need to see the error message your PHP script shows when trying to connect to MySQL.

Regards,
Carlton


----- Original Message -----
From: "sandeep khokher"
To: php-windows@lists.php.net
Sent: Wednesday, July 25, 2007 9:18:58 AM (GMT-0500) America/New_York
Subject: [PHP-WIN] Re: php-windows Digest 23 Jul 2007 22:52:16 -0000 Issue 3288

On 23 Jul 2007 22:52:16 -0000, php-windows-digest-help@lists.php.net
wrote:
>
> php-windows Digest 23 Jul 2007 22:52:16 -0000 Issue 3288
>
> Topics (messages 28227 through 28232):
>
> How to configure PHP support for MySQL on Windows?
> 28227 by: Sean B. Durkin
>
> Re: How do configure PHP support for MySQL on Windows?
> 28228 by: vikas batra
> 28229 by: Sean B. Durkin
> 28230 by: Janet Valade
> 28231 by: Niel Archer
> 28232 by: Sean B. Durkin
>
> Administrivia:
>
> To subscribe to the digest, e-mail:
> php-windows-digest-subscribe@lists.php.net
>
> To unsubscribe from the digest, e-mail:
> php-windows-digest-unsubscribe@lists.php.net
>
> To post to the list, e-mail:
> php-windows@lists.php.net
>
>
> ------------------------------------------------------------ ----------
>
>
> ---------- Forwarded message ----------
> From: "Sean B. Durkin"
> To: php-windows@lists.php.net
> Date: Mon, 23 Jul 2007 15:10:20 +1000
> Subject: How to configure PHP support for MySQL on Windows?
> Hi,
>
>
> How does one configure PHP support for MySQL on Windows?
>
> My host operating system is Windows Server 2003.
> 1. I have installed Apache 2.2 via the msi installer
> (apache_2.2.4-win32-x86-no_ssl.msi).
> 2. I have installed MySQL 5.1 via the windows installer
> (mysql-5.1.20-bet-win32.zip).
> 3. I have installed PHP 5 via the msi installer
> (php-5.2.3-win32-installer.msi)
> 4. I have enabled the php_mysql.dll extension inside of php.ini
> 5. I have ensured that libmysql.dll in on the system path.
>
> I have done all of this correctly, but I still cannot open
> a database from php script! What am I doing wrong? Can any one
> please advise?
>
>
> Please help a PHP/MySQL newbie.
>
> Faithfully,
> Sean B. Durkin
> (s.durkin@{removeThis}gridsense.net
>
>
> ---------- Forwarded message ----------
> From: vikas batra
> To: php-windows@lists.php.net
> Date: Mon, 23 Jul 2007 10:38:52 +0530 (IST)
> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> Pls ensure that ur mysql service has ben started or not if not started then start it from control panel->Administrative tools->services. and then see the results. u r editing right php.ini or not, pls ensure also this one.
>
>
> Vikas Batra
> contact: +91-9818439935
>
> ----- Original Message ----
> From: Sean B. Durkin
> To: php-windows@lists.php.net
> Sent: Sunday, 22 July, 2007 9:52:15 PM
> Subject: [PHP-WIN] How do configure PHP support for MySQL on Windows?
>
> Hi,
>
>
> How does one configure PHP support for MySQL on Windows?
>
> My host operating system is Windows Server 2003.
> 1. I have installed Apache 2.2 via the msi installer
> (apache_2.2.4-win32-x86-no_ssl.msi).
> 2. I have installed MySQL 5.1 via the windows installer
> (mysql-5.1.20-bet-win32.zip).
> 3. I have installed PHP 5 via the msi installer
> (php-5.2.3-win32-installer.msi)
> 4. I have enabled the php_mysql.dll extension inside of php.ini
> 5. I have ensured that libmysql.dll in on the system path.
>
> I have done all of this correctly, but I still cannot open
> a database from php script! What am I doing wrong? Can any one
> please advise?
>
>
> Please help a PHP/MySQL newbie.
>
> Faithfully,
> Sean B. Durkin
> (s.durkin@{removeThis}gridsense.net
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
>
>
>
>
> Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools- 08.html/
>
> ---------- Forwarded message ----------
> From: "Sean B. Durkin"
> To: php-windows@lists.php.net
> Date: Mon, 23 Jul 2007 17:52:56 +1000
> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> Vikas,
>
> The MySQL is started. I have only one php.ini and it is in the correct
> location.
>
> My problem must be something else. But thanks anyway.
>
> Faithfully,
> Sean
>
>
>
> vikas batra wrote:
> > Pls ensure that ur mysql service has ben started or not if not started then start it from control panel->Administrative tools->services. and then see the results. u r editing right php.ini or not, pls ensure also this one.
> >
> >
> > Vikas Batra
> > contact: +91-9818439935
> >
> > ----- Original Message ----
> > From: Sean B. Durkin
> > To: php-windows@lists.php.net
> > Sent: Sunday, 22 July, 2007 9:52:15 PM
> > Subject: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> >
> > Hi,
> >
> >
> > How does one configure PHP support for MySQL on Windows?
> >
> > My host operating system is Windows Server 2003.
> > 1. I have installed Apache 2.2 via the msi installer
> > (apache_2.2.4-win32-x86-no_ssl.msi).
> > 2. I have installed MySQL 5.1 via the windows installer
> > (mysql-5.1.20-bet-win32.zip).
> > 3. I have installed PHP 5 via the msi installer
> > (php-5.2.3-win32-installer.msi)
> > 4. I have enabled the php_mysql.dll extension inside of php.ini
> > 5. I have ensured that libmysql.dll in on the system path.
> >
> > I have done all of this correctly, but I still cannot open
> > a database from php script! What am I doing wrong? Can any one
> > please advise?
> >
> >
> > Please help a PHP/MySQL newbie.
> >
> > Faithfully,
> > Sean B. Durkin
> > (s.durkin@{removeThis}gridsense.net
> >
>
>
> ---------- Forwarded message ----------
> From: Janet Valade
> To:
> Date: Mon, 23 Jul 2007 01:02:21 -0700
> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> Sean B. Durkin wrote:
>
> > Hi,
> >
> >
> > How does one configure PHP support for MySQL on Windows?
> >
> > My host operating system is Windows Server 2003.
> > 1. I have installed Apache 2.2 via the msi installer
> > (apache_2.2.4-win32-x86-no_ssl.msi).
> > 2. I have installed MySQL 5.1 via the windows installer
> > (mysql-5.1.20-bet-win32.zip).
> > 3. I have installed PHP 5 via the msi installer
> > (php-5.2.3-win32-installer.msi)
> > 4. I have enabled the php_mysql.dll extension inside of php.ini
> > 5. I have ensured that libmysql.dll in on the system path.
> >
> > I have done all of this correctly, but I still cannot open
> > a database from php script! What am I doing wrong? Can any one
> > please advise?
>
>
> What error message do you get?
>
> Janet
>
>
> >
> >
> > Please help a PHP/MySQL newbie.
> >
> > Faithfully,
> > Sean B. Durkin
> > (s.durkin@{removeThis}gridsense.net
> >
>
>
> ---------- Forwarded message ----------
> From: Niel Archer
> To: php-windows@lists.php.net
> Date: Mon, 23 Jul 2007 16:44:46 +0100
> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> Hi
>
> > The MySQL is started. I have only one php.ini and it is in the correct
> > location.
>
> That statement is only true, provided your not working under a
> misconception, the usual cause of problems.
>
> Your initial post told us very little useful info, just that you'd
> install this, that and the other. Did you test each component along the
> way to ensure it was working?
>
> If so, what errors does PHP give when attempting to use a MySQl db?
>
> You might try looking at this step by step guide also to see if you
> missed anything
>
> http://wamp.corephp.co.uk/
>
> --
> Niel Archer
>
>
> ---------- Forwarded message ----------
> From: "Sean B. Durkin"
> To: php-windows@lists.php.net
> Date: Tue, 24 Jul 2007 08:53:56 +1000
> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
> Niel,
>
> Thanks for your advise. I have tested the Apache web server, and it is
> working fine. I have tested MySQL through a console window, and used it
> to create a database, and it is working fine. I have tested PHP on
> Apache by viewing php pages, and it is working fine.
>
> However if I use a php script to call any php mysql database functions,
> then parsing bombs out without returning an error message. For example,
> the following script returns an blank page to the browser. There is not
> even an error message.
>
>
> The following code is from Kevin Yank's book "Build Your Own Database
> Driven Web-site using PHP and MySQL".
> ================================================
>
>
>
> > content="text/html; charset=iso-8859-1" />
>
>
> > // Connect to the database server
> $dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
> if (!$dbcnx) {
> exit('

Unable to connect to the ' .
> 'database server at this time.

Unable to locate the joke ' .
> 'database at this time.

Here are all the jokes in our database:

> > // Request the text of all the jokes
> $result = @mysql_query('SELECT joketext FROM joke');
> if (!$result) {
> exit('

Error performing query: ' . mysql_error() . '

');
> }
> // Display the text of each joke in a paragraph
> while ($row = mysql_fetch_array($result)) {
> echo '

' . $row['joketext'] . '

';
> }
> ?>
>

Re: Re: php-windows Digest 23 Jul 2007 22:52:16 -0000Issue3288

I'm not sure what you're replying to exactly. First of all, Sandeep just
sent back the mailinglist-digest mail from last week which is a
combination of all mails posted to this mailinglist in the last 7 days.
He did not actually _ask_ anything or even _say anything at all_
(Sandeep, don't do that again, please).

I assume your response was directed at Sean B. Durkin who asked the
question a few days ago and recieved many responses already (including
the one you just wrote).

- Tul

Carlton Whitehead wrote:
> Hi Sandeep,
>
> Make a new script called phpinfo.php and save it with this code:
>
> >
> phpinfo();
>
> ?>
>
> (end of file)
>
> View that script in your web browser. What is the value next to "Configuration File (php.ini) Path"? Is it what you expected?
>
> Scroll down and look for a section named "MySQL". Is it present? Is it marked as enabled? If it is enabled, we would need to see the error message your PHP script shows when trying to connect to MySQL.
>
> Regards,
> Carlton
>
>
> ----- Original Message -----
> From: "sandeep khokher"
> To: php-windows@lists.php.net
> Sent: Wednesday, July 25, 2007 9:18:58 AM (GMT-0500) America/New_York
> Subject: [PHP-WIN] Re: php-windows Digest 23 Jul 2007 22:52:16 -0000 Issue 3288
>
> On 23 Jul 2007 22:52:16 -0000, php-windows-digest-help@lists.php.net
> wrote:
>> php-windows Digest 23 Jul 2007 22:52:16 -0000 Issue 3288
>>
>> Topics (messages 28227 through 28232):
>>
>> How to configure PHP support for MySQL on Windows?
>> 28227 by: Sean B. Durkin
>>
>> Re: How do configure PHP support for MySQL on Windows?
>> 28228 by: vikas batra
>> 28229 by: Sean B. Durkin
>> 28230 by: Janet Valade
>> 28231 by: Niel Archer
>> 28232 by: Sean B. Durkin
>>
>> Administrivia:
>>
>> To subscribe to the digest, e-mail:
>> php-windows-digest-subscribe@lists.php.net
>>
>> To unsubscribe from the digest, e-mail:
>> php-windows-digest-unsubscribe@lists.php.net
>>
>> To post to the list, e-mail:
>> php-windows@lists.php.net
>>
>>
>> ------------------------------------------------------------ ----------
>>
>>
>> ---------- Forwarded message ----------
>> From: "Sean B. Durkin"
>> To: php-windows@lists.php.net
>> Date: Mon, 23 Jul 2007 15:10:20 +1000
>> Subject: How to configure PHP support for MySQL on Windows?
>> Hi,
>>
>>
>> How does one configure PHP support for MySQL on Windows?
>>
>> My host operating system is Windows Server 2003.
>> 1. I have installed Apache 2.2 via the msi installer
>> (apache_2.2.4-win32-x86-no_ssl.msi).
>> 2. I have installed MySQL 5.1 via the windows installer
>> (mysql-5.1.20-bet-win32.zip).
>> 3. I have installed PHP 5 via the msi installer
>> (php-5.2.3-win32-installer.msi)
>> 4. I have enabled the php_mysql.dll extension inside of php.ini
>> 5. I have ensured that libmysql.dll in on the system path.
>>
>> I have done all of this correctly, but I still cannot open
>> a database from php script! What am I doing wrong? Can any one
>> please advise?
>>
>>
>> Please help a PHP/MySQL newbie.
>>
>> Faithfully,
>> Sean B. Durkin
>> (s.durkin@{removeThis}gridsense.net
>>
>>
>> ---------- Forwarded message ----------
>> From: vikas batra
>> To: php-windows@lists.php.net
>> Date: Mon, 23 Jul 2007 10:38:52 +0530 (IST)
>> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
>> Pls ensure that ur mysql service has ben started or not if not started then start it from control panel->Administrative tools->services. and then see the results. u r editing right php.ini or not, pls ensure also this one.
>>
>>
>> Vikas Batra
>> contact: +91-9818439935
>>
>> ----- Original Message ----
>> From: Sean B. Durkin
>> To: php-windows@lists.php.net
>> Sent: Sunday, 22 July, 2007 9:52:15 PM
>> Subject: [PHP-WIN] How do configure PHP support for MySQL on Windows?
>>
>> Hi,
>>
>>
>> How does one configure PHP support for MySQL on Windows?
>>
>> My host operating system is Windows Server 2003.
>> 1. I have installed Apache 2.2 via the msi installer
>> (apache_2.2.4-win32-x86-no_ssl.msi).
>> 2. I have installed MySQL 5.1 via the windows installer
>> (mysql-5.1.20-bet-win32.zip).
>> 3. I have installed PHP 5 via the msi installer
>> (php-5.2.3-win32-installer.msi)
>> 4. I have enabled the php_mysql.dll extension inside of php.ini
>> 5. I have ensured that libmysql.dll in on the system path.
>>
>> I have done all of this correctly, but I still cannot open
>> a database from php script! What am I doing wrong? Can any one
>> please advise?
>>
>>
>> Please help a PHP/MySQL newbie.
>>
>> Faithfully,
>> Sean B. Durkin
>> (s.durkin@{removeThis}gridsense.net
>>
>> --
>> PHP Windows Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>>
>>
>>
>>
>>
>> Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools- 08.html/
>>
>> ---------- Forwarded message ----------
>> From: "Sean B. Durkin"
>> To: php-windows@lists.php.net
>> Date: Mon, 23 Jul 2007 17:52:56 +1000
>> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
>> Vikas,
>>
>> The MySQL is started. I have only one php.ini and it is in the correct
>> location.
>>
>> My problem must be something else. But thanks anyway.
>>
>> Faithfully,
>> Sean
>>
>>
>>
>> vikas batra wrote:
>>> Pls ensure that ur mysql service has ben started or not if not started then start it from control panel->Administrative tools->services. and then see the results. u r editing right php.ini or not, pls ensure also this one.
>>>
>>>
>>> Vikas Batra
>>> contact: +91-9818439935
>>>
>>> ----- Original Message ----
>>> From: Sean B. Durkin
>>> To: php-windows@lists.php.net
>>> Sent: Sunday, 22 July, 2007 9:52:15 PM
>>> Subject: [PHP-WIN] How do configure PHP support for MySQL on Windows?
>>>
>>> Hi,
>>>
>>>
>>> How does one configure PHP support for MySQL on Windows?
>>>
>>> My host operating system is Windows Server 2003.
>>> 1. I have installed Apache 2.2 via the msi installer
>>> (apache_2.2.4-win32-x86-no_ssl.msi).
>>> 2. I have installed MySQL 5.1 via the windows installer
>>> (mysql-5.1.20-bet-win32.zip).
>>> 3. I have installed PHP 5 via the msi installer
>>> (php-5.2.3-win32-installer.msi)
>>> 4. I have enabled the php_mysql.dll extension inside of php.ini
>>> 5. I have ensured that libmysql.dll in on the system path.
>>>
>>> I have done all of this correctly, but I still cannot open
>>> a database from php script! What am I doing wrong? Can any one
>>> please advise?
>>>
>>>
>>> Please help a PHP/MySQL newbie.
>>>
>>> Faithfully,
>>> Sean B. Durkin
>>> (s.durkin@{removeThis}gridsense.net
>>>
>>
>> ---------- Forwarded message ----------
>> From: Janet Valade
>> To:
>> Date: Mon, 23 Jul 2007 01:02:21 -0700
>> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
>> Sean B. Durkin wrote:
>>
>>> Hi,
>>>
>>>
>>> How does one configure PHP support for MySQL on Windows?
>>>
>>> My host operating system is Windows Server 2003.
>>> 1. I have installed Apache 2.2 via the msi installer
>>> (apache_2.2.4-win32-x86-no_ssl.msi).
>>> 2. I have installed MySQL 5.1 via the windows installer
>>> (mysql-5.1.20-bet-win32.zip).
>>> 3. I have installed PHP 5 via the msi installer
>>> (php-5.2.3-win32-installer.msi)
>>> 4. I have enabled the php_mysql.dll extension inside of php.ini
>>> 5. I have ensured that libmysql.dll in on the system path.
>>>
>>> I have done all of this correctly, but I still cannot open
>>> a database from php script! What am I doing wrong? Can any one
>>> please advise?
>>
>> What error message do you get?
>>
>> Janet
>>
>>
>>>
>>> Please help a PHP/MySQL newbie.
>>>
>>> Faithfully,
>>> Sean B. Durkin
>>> (s.durkin@{removeThis}gridsense.net
>>>
>>
>> ---------- Forwarded message ----------
>> From: Niel Archer
>> To: php-windows@lists.php.net
>> Date: Mon, 23 Jul 2007 16:44:46 +0100
>> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
>> Hi
>>
>>> The MySQL is started. I have only one php.ini and it is in the correct
>>> location.
>> That statement is only true, provided your not working under a
>> misconception, the usual cause of problems.
>>
>> Your initial post told us very little useful info, just that you'd
>> install this, that and the other. Did you test each component along the
>> way to ensure it was working?
>>
>> If so, what errors does PHP give when attempting to use a MySQl db?
>>
>> You might try looking at this step by step guide also to see if you
>> missed anything
>>
>> http://wamp.corephp.co.uk/
>>
>> --
>> Niel Archer
>>
>>
>> ---------- Forwarded message ----------
>> From: "Sean B. Durkin"
>> To: php-windows@lists.php.net
>> Date: Tue, 24 Jul 2007 08:53:56 +1000
>> Subject: Re: [PHP-WIN] How do configure PHP support for MySQL on Windows?
>> Niel,
>>
>> Thanks for your advise. I have tested the Apache web server, and it is
>> working fine. I have tested MySQL through a console window, and used it
>> to create a database, and it is working fine. I have tested PHP on
>> Apache by viewing php pages, and it is working fine.
>>
>> However if I use a php script to call any php mysql database functions,
>> then parsing bombs out without returning an error message. For example,
>> the following script returns an blank page to the browser. There is not
>> even an error message.
>>
>>
>> The following code is from Kevin Yank's book "Build Your Own Database
>> Driven Web-site using PHP and MySQL".
>> ================================================
>>
>>
>>
>> >> content="text/html; charset=iso-8859-1" />
>>
>>
>> >> // Connect to the database server
>> $dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
>> if (!$dbcnx) {
>> exit('

Unable to connect to the ' .
>> 'database server at this time.

Unable to locate the joke ' .
>> 'database at this time.

Here are all the jokes in our database:

>> >> // Request the text of all the jokes
>> $result = @mysql_query('SELECT joketext FROM joke');
>> if (!$result) {
>> exit('

Error performing query: ' . mysql_error() . '

');
>> }
>> // Display the text of each joke in a paragraph
>> while ($row = mysql_fetch_array($result)) {
>> echo '

' . $row['joketext'] . '

';
>> }
>> ?>
>>