php-windows Digest 25 Jul 2007 13:19:11 -0000 Issue 3291

php-windows-digest-help Wed, 25 Jul 2007 06:20:12 -0700

php-windows Digest 25 Jul 2007 13:19:11 -0000 Issue 3291

Topics (messages 28238 through 28241):


Re: How do configure PHP support for MySQL on Windows?
        28238 by: M. Sokolewicz
        28239 by: Sean B. Durkin
        28240 by: Sean B. Durkin

Re: php-windows Digest 23 Jul 2007 22:52:16 -0000 Issue 3288
        28241 by: sandeep khokher

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


----------------------------------------------------------------------

--- Begin Message --- If that's literally from a book then I strongly suggest you burn thebook. I would never trust _anything_ learned from a book that activelydisables error-reporting on almost _all_ functions. Kick out all the @operators and you might start seeing errors (they force PHP to ignorethem silently), which are 90% likely to resolve your problem.


- Tul

Sean B. Durkin wrote:

Niel,

Thanks for your advise. I have tested the Apache web server, and it isworking 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 DatabaseDriven Web-site using PHP and MySQL".

================================================
<html>
<head>
<title>Our List of Jokes</title>
<meta http-equiv="content-type"
content="text/html; charset=iso-8859-1" />
</head>
<body>
<?php
// Connect to the database server
$dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
if (!$dbcnx) {
exit('<p>Unable to connect to the ' .
'database server at this time.</p>');
}
// Select the jokes database
if ([EMAIL PROTECTED]('ijdb')) {
exit('<p>Unable to locate the joke ' .
'database at this time.</p>');
}
?>
<p>Here are all the jokes in our database:</p>
<blockquote>
<?php
// Request the text of all the jokes
$result = @mysql_query('SELECT joketext FROM joke');
if (!$result) {
exit('<p>Error performing query: ' . mysql_error() . '</p>');
}
// Display the text of each joke in a paragraph
while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['joketext'] . '</p>';
}
?>
</blockquote>
</body>
</html>
================================================

I have followed Kevin Yank's book, which is a step-by-step
guide.

Any ideas anyone?


Faithfully,
Sean B. Durkin

Niel Archer wrote:

Hi

The MySQL is started. I have only one php.ini and it is in thecorrect 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

--- End Message ---

--- Begin Message ---

Thanks M. Sokolewicz.

Yes, it is literally from the book.

Also, I turned on
 [php]display_startup_errors=on
in my php.ini file, restarted Apache and got this interesting error message:
 "Unable to load <path>\php_mysql.dll - Invalid access to memory".

After googling around in other forums, I observed that this is a
common error, and it is most likely caused by incompatible versions
of PHP, php_mysql.dll and MySQL.

Do you agree? Would anyone else like to contribute an opinion as to
the cause of this error?

Anyway, I uninstalled everything, and started again with XAMPP(http://www.apachefriends.org/en/xampp.html). XAMPP is just Apache,

PHP and MySQL all in one bundle. I installed it and it just works!


Faithfully,
Sean B. Durkin

M. Sokolewicz wrote:

If that's literally from a book then I strongly suggest you burn thebook. I would never trust _anything_ learned from a book that activelydisables error-reporting on almost _all_ functions. Kick out all the @operators and you might start seeing errors (they force PHP to ignorethem silently), which are 90% likely to resolve your problem.


- Tul

Sean B. Durkin wrote:

Niel,

Thanks for your advise. I have tested the Apache web server, and it isworking 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 DatabaseDriven Web-site using PHP and MySQL".

================================================
<html>
<head>
<title>Our List of Jokes</title>
<meta http-equiv="content-type"
content="text/html; charset=iso-8859-1" />
</head>
<body>
<?php
// Connect to the database server
$dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
if (!$dbcnx) {
exit('<p>Unable to connect to the ' .
'database server at this time.</p>');
}
// Select the jokes database
if ([EMAIL PROTECTED]('ijdb')) {
exit('<p>Unable to locate the joke ' .
'database at this time.</p>');
}
?>
<p>Here are all the jokes in our database:</p>
<blockquote>
<?php
// Request the text of all the jokes
$result = @mysql_query('SELECT joketext FROM joke');
if (!$result) {
exit('<p>Error performing query: ' . mysql_error() . '</p>');
}
// Display the text of each joke in a paragraph
while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['joketext'] . '</p>';
}
?>
</blockquote>
</body>
</html>
================================================

I have followed Kevin Yank's book, which is a step-by-step
guide.

Any ideas anyone?


Faithfully,
Sean B. Durkin

Niel Archer wrote:

Hi

The MySQL is started. I have only one php.ini and it is in thecorrect 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

--- End Message ---

--- Begin Message ---

Thanks M. Sokolewicz.

Yes, it is literally from the book.

Also, I turned on
 [php]display_startup_errors=on
in my php.ini file, restarted Apache and got this interesting error message:
 "Unable to load <path>\php_mysql.dll - Invalid access to memory".

After googling around in other forums, I observed that this is a
common error, and it is most likely caused by incompatible versions
of PHP, php_mysql.dll and MySQL.

Do you agree? Would anyone else like to contribute an opinion as to
the cause of this error?

Anyway, I uninstalled everything, and started again with XAMPP(http://www.apachefriends.org/en/xampp.html). XAMPP is just Apache,

PHP and MySQL all in one bundle. I installed it and it just works!


Faithfully,
Sean B. Durkin

M. Sokolewicz wrote:


- Tul

Sean B. Durkin wrote:

Niel,

Thanks for your advise. I have tested the Apache web server, and it isworking 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 DatabaseDriven Web-site using PHP and MySQL".

================================================
<html>
<head>
<title>Our List of Jokes</title>
<meta http-equiv="content-type"
content="text/html; charset=iso-8859-1" />
</head>
<body>
<?php
// Connect to the database server
$dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
if (!$dbcnx) {
exit('<p>Unable to connect to the ' .
'database server at this time.</p>');
}
// Select the jokes database
if ([EMAIL PROTECTED]('ijdb')) {
exit('<p>Unable to locate the joke ' .
'database at this time.</p>');
}
?>
<p>Here are all the jokes in our database:</p>
<blockquote>
<?php
// Request the text of all the jokes
$result = @mysql_query('SELECT joketext FROM joke');
if (!$result) {
exit('<p>Error performing query: ' . mysql_error() . '</p>');
}
// Display the text of each joke in a paragraph
while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['joketext'] . '</p>';
}
?>
</blockquote>
</body>
</html>
================================================

I have followed Kevin Yank's book, which is a step-by-step
guide.

Any ideas anyone?


Faithfully,
Sean B. Durkin

Niel Archer wrote:

Hi

The MySQL is started. I have only one php.ini and it is in thecorrect 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

--- End Message ---

--- Begin Message ---

On 23 Jul 2007 22:52:16 -0000, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> 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:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]

----------------------------------------------------------------------

---------- Forwarded message ----------
From: "Sean B. Durkin" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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
([EMAIL PROTECTED]

---------- Forwarded message ----------
From: vikas batra <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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
([EMAIL PROTECTED]

--
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" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> 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
> ([EMAIL PROTECTED]
>

---------- Forwarded message ----------
From: Janet Valade <[EMAIL PROTECTED]>
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
> ([EMAIL PROTECTED]
>

---------- Forwarded message ----------
From: Niel Archer <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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".
================================================
<html>
<head>
<title>Our List of Jokes</title>
<meta http-equiv="content-type"
content="text/html; charset=iso-8859-1" />
</head>
<body>
<?php
// Connect to the database server
$dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
if (!$dbcnx) {
exit('<p>Unable to connect to the ' .
'database server at this time.</p>');
}
// Select the jokes database
if ([EMAIL PROTECTED]('ijdb')) {
exit('<p>Unable to locate the joke ' .
'database at this time.</p>');
}
?>
<p>Here are all the jokes in our database:</p>
<blockquote>
<?php
// Request the text of all the jokes
$result = @mysql_query('SELECT joketext FROM joke');
if (!$result) {
exit('<p>Error performing query: ' . mysql_error() . '</p>');
}
// Display the text of each joke in a paragraph
while ($row = mysql_fetch_array($result)) {
echo '<p>' . $row['joketext'] . '</p>';
}
?>
</blockquote>
</body>
</html>
================================================

I have followed Kevin Yank's book, which is a step-by-step
guide.

Any ideas anyone?

Faithfully,
Sean B. Durkin

Niel Archer wrote:
> 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



--
Regards
Sandeep Khokher

--- End Message ---

php-windows Digest 25 Jul 2007 13:19:11 -0000 Issue 3291

Reply via email to