php-windows Digest 26 Jul 2007 13:17:05 -0000 Issue 3292 Topics (messages 28242 through 28244):
Re: php-windows Digest 23 Jul 2007 22:52:16 -0000 Issue 3288
28242 by: Carlton Whitehead
28244 by: M. Sokolewicz
can php on windows correctly set and return 777 permissions values?
28243 by: Stephen Ford
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 ---Hi Sandeep, Make a new script called phpinfo.php and save it with this code: <?php 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" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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, [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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message --- 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: <?php 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" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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, [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? JanetPlease 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? HiThe 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:HiThe 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
--- End Message ---
--- Begin Message ---I'm trying to run an install script for some software that I bought and the install script checks that some file permission settings are correctly set. In this case they must be set to "777". I have not been able to run the script successfully and my hosting company has said that it cannot be successfully be run on their site because "our php running in windows always returns 666 for a file instead of the required 777. Directories return the required 777 permissions." Does this sound credible? Are there settings that they could change to make this work? Thanks in advance.
--- End Message ---
