php-windows Digest 11 Sep 2007 05:34:28 -0000 Issue 3328
Topics (messages 28468 through 28470):
Re: File-error code?
28468 by: John Mertic
Re: Memory leak occurs when exec() function is used on Windows platform
28469 by: Melmack
showing warnings
28470 by: Asim
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 ---
For the most part yes. Please elaborate if there is something
particular you are looking for?
John
On 9/10/07, Gustav Wiberg <[EMAIL PROTECTED]> wrote:
> Hi!
>
> Ok. That is the only option then?
>
> Best regards
> /Gustav Wiberg
>
>
> -----Original Message-----
> From: John Mertic [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 10, 2007 2:10 PM
> To: Gustav Wiberg; php windows
> Subject: Re: [PHP-WIN] File-error code?
>
> You can use is_file() and is_readable() to determine if the file
> exists and is readable. That's not really getting you any sort of
> "error code", but it least it helps narrow things down.
>
> John
>
> On 9/10/07, Gustav Wiberg <[EMAIL PROTECTED]> wrote:
> > Hi!
> >
> > Yes, that's correct.
> >
> > Best regards
> > /Gustav Wiberg
> >
> >
> > -----Original Message-----
> > From: John Mertic [mailto:[EMAIL PROTECTED]
> > Sent: Monday, September 10, 2007 1:55 PM
> > To: Gustav Wiberg
> > Subject: Re: [PHP-WIN] File-error code?
> >
> > I guess my question is from where ( HTTP error code, etc ) and what
> > choices are you looking for in terms of a sub code ( file not found,
> > not readable, etc ).
> >
> > On 9/10/07, Gustav Wiberg <[EMAIL PROTECTED]> wrote:
> > > Permission denied
> > >
> > > Best regards
> > > /Gustav Wiberg
> > >
> > >
> > > -----Original Message-----
> > > From: John Mertic [mailto:[EMAIL PROTECTED]
> > > Sent: Monday, September 10, 2007 1:30 PM
> > > To: Gustav Wiberg
> > > Subject: Re: [PHP-WIN] File-error code?
> > >
> > > Hi,
> > >
> > > What code are you looking for?
> > >
> > > John
> > >
> > > On 9/10/07, Gustav Wiberg <[EMAIL PROTECTED]> wrote:
> > > > Hi!
> > > >
> > > > I test using readfile($filename) and that's ok. When I'm logged in with
> > > > "incorrect user" I get permission denied... Is there any way of
> > > > retrieving the "permission denied" code? when using readfile? (or any
> > > > other error regarding to readfile-function?
> > > >
> > > > Best regards
> > > > /Gustav Wiberg
> > > >
> > > > No virus found in this outgoing message.
> > > > Checked by AVG Free Edition.
> > > > Version: 7.5.485 / Virus Database: 269.13.12/997 - Release Date:
> > > > 2007-09-09 10:17
> > > >
> > > >
> > > > --
> > > > PHP Windows Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > >
> > >
> > > --
> > > --
> > > John Mertic "Explaining a joke
> > > is like dissecting a frog: you
> > > [EMAIL PROTECTED] understand it better,
> > > but the frog dies in the
> > > process."
> > >
> > > -Mark Twain
> > >
> > > No virus found in this outgoing message.
> > > Checked by AVG Free Edition.
> > > Version: 7.5.485 / Virus Database: 269.13.12/997 - Release Date:
> > > 2007-09-09 10:17
> > >
> > >
> > >
> > >
> >
> >
> > --
> > --
> > John Mertic "Explaining a joke
> > is like dissecting a frog: you
> > [EMAIL PROTECTED] understand it better,
> > but the frog dies in the
> > process."
> >
> > -Mark Twain
> >
> > No virus found in this outgoing message.
> > Checked by AVG Free Edition.
> > Version: 7.5.485 / Virus Database: 269.13.12/997 - Release Date: 2007-09-09
> > 10:17
> >
> >
> >
> >
>
>
> --
> --
> John Mertic "Explaining a joke
> is like dissecting a frog: you
> [EMAIL PROTECTED] understand it better,
> but the frog dies in the
> process."
>
> -Mark Twain
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.485 / Virus Database: 269.13.12/997 - Release Date: 2007-09-09
> 10:17
>
>
>
>
--
--
John Mertic "Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process."
-Mark Twain
--- End Message ---
--- Begin Message ---
Thank you for your reply.
Unfortunately your method also causes memory leak.
I have tested operating system and I have discovered
that batch script listed below causes the same memory leak.
That is why I think now that it is however not PHP fault but Windows bug.
The Windows batch script contains:
for /L %%i in (1,1,500) do cmd /C test.bat
where test.bat is just an empty file.
Maybe someone knows how to solve this problem?
Best regards
Melmack
Uzytkownik "Elizabeth Smith" <[EMAIL PROTECTED]> napisal w
wiadomosci news:[EMAIL PROTECTED]
> melmack wrote:
>> Hi
>>
>> I have a big problem with shell commands execution via PHP.
>> I have written a very short PHP script ilustrating the problem:
>>
>>
>> <?php
>>
>>
>> for($i=0;$i<1000;$i++)
>> { exec("test.bat"); } ?> test.bat is just an empty file. This script
>> causes about 10 MB memory leak. It can be observed by usage of
>> performance system monitor. This problems occurs in all available
>> enviroments: - IIS Webserver. - Apache webserver - PHP command line
>> interpreter Memory leak is observable only on Windows platform (tested on
>> Windows XP). On Linux everything works OK. Does someone know how to solve
>> this problem? Any help appreciated Best regards Melmack
>
> I've found exec to be flaky enough on windows that instead I use com to
> spawn the new process.
>
> $shell = new COM('WScript.Shell');
> $return = $shell->Run($cmd, 0, false);
> unset ($shell);
>
> Faster and no leaks ;) Only downside is you have to wrap cross-platform
> code with windows detection.
--- End Message ---
--- Begin Message ---
Hi
this result is shown by mysql on running command prompt
mysql> explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
+--------------+------+---------------+------+---------+------+------+-------+
| table | type | possible_keys | key | key_len | ref | rows |
Extra |
+--------------+------+---------------+------+---------+------+------+-------+
| Mobile_Tunes | ALL | NULL | NULL | NULL | NULL | 4 |
|
+--------------+------+---------------+------+---------+------+------+-------+
1 row in set (0.00 sec)
mysql>
and
mysql> SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
+-----------+-----------+
| Tune_Name | Tune_Type |
+-----------+-----------+
| pakistani | midi |
| pakistan2 | midi |
| usa | midi |
| uk | midi |
+-----------+-----------+
4 rows in set (0.00 sec)
mysql>
now what next?
bye
John Mertic <[EMAIL PROTECTED]> wrote: Run the query through MySQL directly
prepending EXPLAIN to the query
and attach the results here.
John
On 9/10/07, Asim wrote:
> Hi
>
> i have added index on both columns but still same warning is issued by mysql
>
> then what i do now
>
> John Mertic wrote:
> Is the table 'Mobile_Tunes' indexed at all? If not, you may want to
> consider adding one at least one 'Tune_Type' and another on
> 'Tune_Name'.
>
> John
>
> On 9/10/07, Asim wrote:
> > Hi
> >
> > script is following
> >
> > if(isset($_GET['SearchTune']))
> > {
> > $tunename = substr($_GET['tune_name'],0,3);
> > $tunetype = $_GET['tune_type'];
> > $sql = "SELECT Tune_Name,Tune_Type FROM Mobile_Tunes WHERE Tune_Name LIKE
> > '".$tunename."%' AND Tune_Type = '".$tunetype."'";
> > }
> > else
> > {
> > $sql = "SELECT Tune_Name,Tune_Type FROM Mobile_Tunes";
> > }
> >
> >
> ...........................................................................
> >
> > function
> > max_page($sql,$total_rows,$rows_per_page,$max_pages)
> > {
> > $all_rs = mysql_query($sql);
> > if(!$all_rs)
> > {
> > echo "Sorry! Try again.";
> > return false;
> > }
> > $total_rows = mysql_num_rows($all_rs);
> > mysql_free_result($all_rs);
> > //mysql_close($link);
> > $max_pages = ceil($total_rows/$rows_per_page);
> > return $max_pages;
> > }
> >
> >
> > when i use this function it shows following warning
> >
> > Warning: mysql_query(): Your query requires a full tablescan (table
> > Mobile_Tunes, 5 rows affected). Use EXPLAIN to optimize your query. in
> > D:\Program Files\Apache
> > Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
> >
> >
> >
> > now can you tell me some solution
> >
> > bye
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > John Mertic wrote:
> > Can you provide the script you are running and the exact error message
> > you are getting?
> >
> > John
> >
> > On 9/9/07, Asim wrote:
> > > Hi
> > >
> > >
> > > in my script when i scan whole table for result set to display in my
> page
> > it shows warning that suggest me to use
> > >
> > >
> > > EXPLAIN statement but i donot need it as i have to show records on page
> > >
> > > how to avoid this warning?
> > >
> > > Bye
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Asim Jamil - 0092 345 4025907, Pakistan
> > >
> > > ---------------------------------
> > > Be a better Globetrotter. Get better travel answers from someone who
> > knows.
> > > Yahoo! Answers - Check it out.
> >
> >
> > --
> > --
> > John Mertic "Explaining a joke
> > is like dissecting a frog: you
> > [EMAIL PROTECTED] understand it better,
> > but the frog dies in the
> > process."
> >
> > -Mark Twain
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
> >
> > Asim Jamil - 0092 345 4025907, Pakistan
> >
> > ________________________________
> > Be a better Heartthrob. Get better relationship answers from someone who
> > knows.
> > Yahoo! Answers - Check it out.
> >
> >
>
>
> --
> --
> John Mertic "Explaining a joke
> is like dissecting a frog: you
> [EMAIL PROTECTED] understand it better,
> but the frog dies in the
> process."
>
> -Mark Twain
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
> Asim Jamil - 0092 345 4025907, Pakistan
>
> ________________________________
> Looking for a deal? Find great prices on flights and hotels with Yahoo!
> FareChase.
>
>
--
--
John Mertic "Explaining a joke
is like dissecting a frog: you
[EMAIL PROTECTED] understand it better,
but the frog dies in the
process."
-Mark Twain
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Asim Jamil - 0092 345 4025907, Pakistan
---------------------------------
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos & more.
--- End Message ---
