OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
php-general Digest 14 Jul 2005 19:00:43 -0000 Issue 3567

php-general-digest-helplists.php.net
Date: Thu Jul 14 2005 - 14:00:43 CDT


php-general Digest 14 Jul 2005 19:00:43 -0000 Issue 3567

Topics (messages 218659 through 218707):

searching multiple fields
        218659 by: Ross
        218661 by: Richard Davey
        218669 by: Lawrence Kennon
        218677 by: Brent Baisley
        218706 by: Amir Mohammad Saied

Re: Echo array string index?
        218660 by: Joe Harman

Big file encryption
        218662 by: david forums
        218670 by: Jay Blanchard
        218671 by: david forums
        218672 by: Mikey
        218673 by: Jay Blanchard
        218674 by: Ahmed Saad
        218685 by: Skippy
        218686 by: Ahmed Saad
        218687 by: david forums
        218688 by: david forums

Refresh
        218663 by: Miguel Guirao
        218664 by: david forums
        218665 by: Mark Rees
        218668 by: Matt Darby

$PHP_SELF or echo $PHP_SELF
        218666 by: Ross
        218667 by: Richard Davey
        218681 by: Matthew Weier O'Phinney

Re: How to run .sql files using php
        218675 by: Rory Browne
        218678 by: Ahmed Saad
        218679 by: Raffael Wannenmacher

Re: How to read PHP variables.
        218676 by: Rory Browne

Re: 404 error - DLL files needed ??
        218680 by: Kristen G. Thorson
        218695 by: Grosz, Steve (IPG IT)

gettext best practice
        218682 by: Skippy
        218683 by: Mark Rees
        218684 by: Skippy

Overriding __soapCall
        218689 by: Marcus Bointon
        218697 by: Marcus Bointon

cannot connect to MySQL server and not sure why
        218690 by: Bruce Gilbert
        218691 by: John Nichel
        218692 by: Stephen Johnson
        218693 by: Raz
        218694 by: Richard Davey
        218696 by: Kristen G. Thorson
        218704 by: Aaron Greenspan

Dynamic Images and File Permissions
        218698 by: Adam Hubscher
        218703 by: Edward Vermillion

Win2000 easier than Win2003 ??
        218699 by: Grosz, Steve (IPG IT)
        218700 by: Mark Rees
        218701 by: Jay Blanchard
        218702 by: Richard Davey

php5 built-in soap - apache performance & wsdl generation
        218705 by: Victor Alvarez

Tired and feeling dumb...maths question....
        218707 by: Ryan A

Administrivia:

To subscribe to the digest, e-mail:
        php-general-digest-subscribelists.php.net

To unsubscribe from the digest, e-mail:
        php-general-digest-unsubscribelists.php.net

To post to the list, e-mail:
        php-generallists.php.net

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

attached mail follows:


Is there a way to use like to search various fields at one time.

For example I want the search field to search by name or area or
organisation. If the (minimum)three letter string matches any of these I
want the record to show. $search_field is my textbox

$query = "SELECT * FROM sheet1 WHERE 'name' LIKE '$search_field%'";

but really I want it to do the folowing.

$query = "SELECT * FROM sheet1 WHERE 'name' or 'area or 'organisation LIKE
'$search_field%'";

Cheers,

R.

attached mail follows:


Hello Ross,

Thursday, July 14, 2005, 9:37:10 AM, you wrote:

R> $query = "SELECT * FROM sheet1 WHERE 'name' or 'area or 'organisation LIKE
R> '$search_field%'";

SELECT * FROM blah WHERE name LIKE '$search%' OR area LIKE '$search%'
OR blahblah LIKE '$search%'

etc

If you want to add extra conditions you can do so like this:

SELECT * FROM blah WHERE (name LIKE '$search%' AND id > 10) OR area LIKE '$search%'

Best regards,

Richard Davey
--
 http://www.launchcode.co.uk - PHP Development Services
 "I do not fear computers. I fear the lack of them." - Isaac Asimov

attached mail follows:


>...I want it to do the folowing.
>
>$query = "SELECT * FROM sheet1 WHERE 'name' or 'area or 'organisation LIKE
>'$search_field%'";
>

"SELECT * FROM sheet1 WHERE 'name' LIKE '$search_field%'
OR 'organization' LIKE '$search_field%'"

lk

attached mail follows:


Sounds like you want to use full text indexing. Create one full text
index spanning name, area, organisation. Then search on all three
fields at once.
SELECT * FROM sheet1 MATCH(name,area,organisation) AGAINST
('textstring* otherstring* etc*). The * means use LIKE searching.
There are a bunch of other options you can use and also limitations.
Read the manual for all the details.

On Jul 14, 2005, at 4:37 AM, Ross wrote:

> Is there a way to use like to search various fields at one time.
>
> For example I want the search field to search by name or area or
> organisation. If the (minimum)three letter string matches any of
> these I
> want the record to show. $search_field is my textbox
>
> $query = "SELECT * FROM sheet1 WHERE 'name' LIKE '$search_field%'";
>
>
> but really I want it to do the folowing.
>
>
> $query = "SELECT * FROM sheet1 WHERE 'name' or 'area or
> 'organisation LIKE
> '$search_field%'";
>
> Cheers,
>
> R.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

attached mail follows:


Brent Baisley wrote:
> Sounds like you want to use full text indexing. Create one full text
> index spanning name, area, organisation. Then search on all three
> fields at once.
> SELECT * FROM sheet1 MATCH(name,area,organisation) AGAINST ('textstring*
> otherstring* etc*). The * means use LIKE searching. There are a bunch
> of other options you can use and also limitations. Read the manual for
> all the details.
>
>
> On Jul 14, 2005, at 4:37 AM, Ross wrote:
>
Just to remember!
this method works just with MyISAM table types.

attached mail follows:


Hey Matt,
 you can print out the contents of your array by using print_r($arr)
 but more useful is using this
 foreach ($arr as $key => $value)
 {
 echo "Key : ".$key." Value : ".$value;
}
 Adios
Joe
 On 7/13/05, Adam Hubscher <webmasteroffbeat-zero.net> wrote:
>
> Matt Darby wrote:
> > I have an array setup as such: *$arr['generated text']='generated
> number';*
> >
> > What would be the best way to echo the key in a loop?
> > Seems pretty easy but I've never attempted...
> >
> > Thanks all!
> > Matt Darby
> >
> I'm not sure I understand the question.
>
> You could do foreach($arr as $key => $value) { print($key); }.
>
> There are also a number of functions that get the current key on the
> array's pointer:
>
> http://us2.php.net/manual/en/function.key.php
> http://us2.php.net/manual/en/function.array-keys.php
>
> But once again, it really comes down to what exactly it is you want to
> do...
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
Joe Harman
---------
Do not go where the path may lead, go instead where there is no path and
leave a trail. - Ralph Waldo Emerson

attached mail follows:


Hello every body

I'm in the ...

well I have a big file (around 12M), and I have to encrypt this file, and
to decrypt some time after.

How could I do? Is it possible to encrypt and decrypt a file line by line ?

Please help

david

attached mail follows:


[snip]
well I have a big file (around 12M), and I have to encrypt this file,
and
to decrypt some time after.

How could I do? Is it possible to encrypt and decrypt a file line by
line ?
[/snip]

Start with the manual at http://us2.php.net/manual/en/ref.mcrypt.php

attached mail follows:


Hihihihi

Of course I already has the whole object to encrypt and decrypt, my
problem is link to the size of the file.

There is no mcrypt function to load directly a file, so it's need to
preload it in a variable and then encrypt or decrypt it.

But when the file is 12M size it failed.

So I need to know a way to be able to encrypt large file.

regards

david

Le Thu, 14 Jul 2005 13:33:25 +0200, Jay Blanchard
<jay.blanchardniicommunications.com> a écrit:

> [snip]
> well I have a big file (around 12M), and I have to encrypt this file,
> and
> to decrypt some time after.
>
> How could I do? Is it possible to encrypt and decrypt a file line by
> line ?
> [/snip]
>
> Start with the manual at http://us2.php.net/manual/en/ref.mcrypt.php
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

attached mail follows:


david forums wrote:

> Hihihihi
>
> Of course I already has the whole object to encrypt and decrypt, my
> problem is link to the size of the file.
>
> There is no mcrypt function to load directly a file, so it's need to
> preload it in a variable and then encrypt or decrypt it.
>
> But when the file is 12M size it failed.
>
> So I need to know a way to be able to encrypt large file.
>
> regards
>
> david
>
>
>
> Le Thu, 14 Jul 2005 13:33:25 +0200, Jay Blanchard
> <jay.blanchardniicommunications.com> a écrit:
>
>> [snip]
>> well I have a big file (around 12M), and I have to encrypt this file,
>> and
>> to decrypt some time after.
>>
>> How could I do? Is it possible to encrypt and decrypt a file line by
>> line ?
>> [/snip]
>>
>> Start with the manual at http://us2.php.net/manual/en/ref.mcrypt.php
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
You could try upping the max memory limit in your php.ini file, or with
ini_set() if you only want to allow this for your one script...

hth,

Mikey

attached mail follows:


[snip]
There is no mcrypt function to load directly a file, so it's need to
preload it in a variable and then encrypt or decrypt it.

But when the file is 12M size it failed.
[/snip]

What do you mean "it failed"? What kind of error did you get?

attached mail follows:


hi david,

On 7/14/05, david forums <dforumsvieonet.com> wrote:
> So I need to know a way to be able to encrypt large file.

function readfile_chunked ($filename) {

  $chunksize = 1*(1024*1024); // it reads 1 mb per chunck. adjust this
if u need.
  $buffer = '';
  $handle = fopen($filename, 'rb');

  if ($handle === false)
  {
        return false;
  }

  while (!feof($handle))
  {
    $buffer = fread( $handle, $chunksize );
    
    // do whatever with the chuck you read.
    // you can encrypt it and write all the chunks to the same file
    // (open a file for writing before the loop)
  }

  return fclose( $handle );
}

-ahmed

attached mail follows:


Quoting Ahmed Saad <myanywheregmail.com>:
> // do whatever with the chuck you read.
> // you can encrypt it and write all the chunks to the same file

But if you encrypt one chunk at a time and concatenate them later, or if you
encrypt the whole thing, will you still get the same result?

--
Romanian Web Developers - http://ROWD.ORG

attached mail follows:


hi Skippy

On 7/14/05, Skippy <skippyzuavra.net> wrote:
> Quoting Ahmed Saad <myanywheregmail.com>:
> > // do whatever with the chuck you read.
> > // you can encrypt it and write all the chunks to the same file
>
> But if you encrypt one chunk at a time and concatenate them later, or if you
> encrypt the whole thing, will you still get the same result?

i think the point is encrypting/decrypting the file contents not *how*
to encrypt/decrypt it but I'll do some experiments :)

-ahmed

attached mail follows:


Ok tx

And you mean that I can concatenate every chunck in the same file ?

And what about decryption, could I take the same way ?

david

Le Thu, 14 Jul 2005 14:25:48 +0200, Ahmed Saad <myanywheregmail.com> a
écrit:

> hi david,
>
> On 7/14/05, david forums <dforumsvieonet.com> wrote:
>> So I need to know a way to be able to encrypt large file.
>
> function readfile_chunked ($filename) {
>
> $chunksize = 1*(1024*1024); // it reads 1 mb per chunck. adjust this
> if u need.
> $buffer = '';
> $handle = fopen($filename, 'rb');
>
> if ($handle === false)
> {
> return false;
> }
>
> while (!feof($handle))
> {
> $buffer = fread( $handle, $chunksize );
> // do whatever with the chuck you read.
> // you can encrypt it and write all the chunks to the same file
> // (open a file for writing before the loop)
> }
>
> return fclose( $handle );
> }
>
> -ahmed
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

attached mail follows:


Not at all cause the chunk are beeing free every time it is write in the
file.
  so it does not excide the amount you set.

regards

Le Thu, 14 Jul 2005 16:10:17 +0200, Skippy <skippyzuavra.net> a écrit:

> Quoting Ahmed Saad <myanywheregmail.com>:
>> // do whatever with the chuck you read.
>> // you can encrypt it and write all the chunks to the same file
>
> But if you encrypt one chunk at a time and concatenate them later, or if
> you
> encrypt the whole thing, will you still get the same result?
>

attached mail follows:


Hello people,

I need to have a web page (PHP) that displays a status about electric
facilities, this status is read from a database (MySQL), the thing is that
these status may change from time to time in the DB so I need to re read the
DB and display the according status on the web page.

So, Is there a way to refresh or reload the page every 10 minutes
automatically?

Regards,

-----------------------
Miguel Guirao Aguilera
Logistica R8 TELCEL
Tel. (999) 960.7994
Cel. 9931 600.0000

Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta dirigido; contiene informacion estrictamente confidencial y legalmente protegida, cuya divulgacion es sancionada por la ley. Si el lector de este mensaje no es a quien esta dirigido, ni se trata del empleado o agente responsable de esta informacion, se le notifica por medio del presente, que su reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio este comunicado por error, favor de notificarlo inmediatamente al remitente y destruir el mensaje. Todas las opiniones contenidas en este mail son propias del autor del mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos.

This message is for the sole use of the person or entity to whom it is being sent. Therefore, it contains strictly confidential and legally protected material whose disclosure is subject to penalty by law. If the person reading this message is not the one to whom it is being sent and/or is not an employee or the responsible agent for this information, this person is herein notified that any unauthorized dissemination, distribution or copying of the materials included in this facsimile is strictly prohibited. If you received this document by mistake please notify immediately to the subscriber and destroy the message. Any opinions contained in this e-mail are those of the author of the message and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries companies. No part of this message or attachments may be used or reproduced in any manner whatsoever.

attached mail follows:


well I see two way.

First is to make a php script without end, which will run continuously.

second way is to add refresh html tag, in your page, or a js script to
reload automaticaly.

I'm not seeing other solution in php.

regards

Le Thu, 14 Jul 2005 02:27:47 +0200, Miguel Guirao
<miguel.guiraomail.telcel.com> a écrit:

>
>
> Hello people,
>
> I need to have a web page (PHP) that displays a status about electric
> facilities, this status is read from a database (MySQL), the thing is
> that
> these status may change from time to time in the DB so I need to re read
> the
> DB and display the according status on the web page.
>
> So, Is there a way to refresh or reload the page every 10 minutes
> automatically?
>
> Regards,
>
> -----------------------
> Miguel Guirao Aguilera
> Logistica R8 TELCEL
> Tel. (999) 960.7994
> Cel. 9931 600.0000
>
>
> Este mensaje es exclusivamente para el uso de la persona o entidad a
> quien esta dirigido; contiene informacion estrictamente confidencial y
> legalmente protegida, cuya divulgacion es sancionada por la ley. Si el
> lector de este mensaje no es a quien esta dirigido, ni se trata del
> empleado o agente responsable de esta informacion, se le notifica por
> medio del presente, que su reproduccion y distribucion, esta
> estrictamente prohibida. Si Usted recibio este comunicado por error,
> favor de notificarlo inmediatamente al remitente y destruir el mensaje.
> Todas las opiniones contenidas en este mail son propias del autor del
> mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A.
> de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y
> subsidiarias. Este mensaje intencionalmente no contiene acentos.
>
> This message is for the sole use of the person or entity to whom it is
> being sent. Therefore, it contains strictly confidential and legally
> protected material whose disclosure is subject to penalty by law. If
> the person reading this message is not the one to whom it is being sent
> and/or is not an employee or the responsible agent for this information,
> this person is herein notified that any unauthorized dissemination,
> distribution or copying of the materials included in this facsimile is
> strictly prohibited. If you received this document by mistake please
> notify immediately to the subscriber and destroy the message. Any
> opinions contained in this e-mail are those of the author of the message
> and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de
> C.V. or any of its control, controlled, affiliates and subsidiaries
> companies. No part of this message or attachments may be used or
> reproduced in any manner whatsoever.
>

attached mail follows:


""david forums"" <dforumsvieonet.com> wrote in message
news:op.stwdo2u7kmgc14localhost.localdomain...
> well I see two way.
>
> First is to make a php script without end, which will run continuously.

I don't recommend this way at all. Why take up all that energy

>
> second way is to add refresh html tag, in your page, or a js script to
> reload automaticaly.

Much better and simpler idea, you can use an http header to do this.

http://4umi.com/web/html/httpheaders.htm has a list of them

Third idea, which may be overkill, depending on how important this
information is, how many people will be accessing it, and whether people
_need_ to see it real time.

set up a cron job/scheduled task to read the db value every 30 seconds, say,
and write out a flat html page with the latest data in. This is only of
value if your db is getting hammered by requests.

I only really mention this as it's the Open Golf Championship this week, and
I used to work on their live scoring app, which pretty much worked as above.

>
> I'm not seeing other solution in php.
>
> regards
>
> Le Thu, 14 Jul 2005 02:27:47 +0200, Miguel Guirao
> <miguel.guiraomail.telcel.com> a écrit:
>
> >
> >
> > Hello people,
> >
> > I need to have a web page (PHP) that displays a status about electric
> > facilities, this status is read from a database (MySQL), the thing is
> > that
> > these status may change from time to time in the DB so I need to re read
> > the
> > DB and display the according status on the web page.
> >
> > So, Is there a way to refresh or reload the page every 10 minutes
> > automatically?
> >
> > Regards,
> >
> > -----------------------
> > Miguel Guirao Aguilera
> > Logistica R8 TELCEL
> > Tel. (999) 960.7994
> > Cel. 9931 600.0000
> >
> >
> > Este mensaje es exclusivamente para el uso de la persona o entidad a
> > quien esta dirigido; contiene informacion estrictamente confidencial y
> > legalmente protegida, cuya divulgacion es sancionada por la ley. Si el
> > lector de este mensaje no es a quien esta dirigido, ni se trata del
> > empleado o agente responsable de esta informacion, se le notifica por
> > medio del presente, que su reproduccion y distribucion, esta
> > estrictamente prohibida. Si Usted recibio este comunicado por error,
> > favor de notificarlo inmediatamente al remitente y destruir el mensaje.
> > Todas las opiniones contenidas en este mail son propias del autor del
> > mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A.
> > de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y
> > subsidiarias. Este mensaje intencionalmente no contiene acentos.
> >
> > This message is for the sole use of the person or entity to whom it is
> > being sent. Therefore, it contains strictly confidential and legally
> > protected material whose disclosure is subject to penalty by law. If
> > the person reading this message is not the one to whom it is being sent
> > and/or is not an employee or the responsible agent for this information,
> > this person is herein notified that any unauthorized dissemination,
> > distribution or copying of the materials included in this facsimile is
> > strictly prohibited. If you received this document by mistake please
> > notify immediately to the subscriber and destroy the message. Any
> > opinions contained in this e-mail are those of the author of the message
> > and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de
> > C.V. or any of its control, controlled, affiliates and subsidiaries
> > companies. No part of this message or attachments may be used or
> > reproduced in any manner whatsoever.
> >

attached mail follows:


Put this between the page's <head> tags:
<meta http-equiv="REFRESH" content="1;url=http://somesite_to_refresh_to">

The "1" in the above line controls the time to refresh; the higher the
number, the longer to refresh.

Matt Darby

Miguel Guirao wrote:

>Hello people,
>
>I need to have a web page (PHP) that displays a status about electric
>facilities, this status is read from a database (MySQL), the thing is that
>these status may change from time to time in the DB so I need to re read the
>DB and display the according status on the web page.
>
>So, Is there a way to refresh or reload the page every 10 minutes
>automatically?
>
>Regards,
>
>-----------------------
>Miguel Guirao Aguilera
>Logistica R8 TELCEL
>Tel. (999) 960.7994
>Cel. 9931 600.0000
>
>
>Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta dirigido; contiene informacion estrictamente confidencial y legalmente protegida, cuya divulgacion es sancionada por la ley. Si el lector de este mensaje no es a quien esta dirigido, ni se trata del empleado o agente responsable de esta informacion, se le notifica por medio del presente, que su reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio este comunicado por error, favor de notificarlo inmediatamente al remitente y destruir el mensaje. Todas las opiniones contenidas en este mail son propias del autor del mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos.
>
>This message is for the sole use of the person or entity to whom it is being sent. Therefore, it contains strictly confidential and legally protected material whose disclosure is subject to penalty by law. If the person reading this message is not the one to whom it is being sent and/or is not an employee or the responsible agent for this information, this person is herein notified that any unauthorized dissemination, distribution or copying of the materials included in this facsimile is strictly prohibited. If you received this document by mistake please notify immediately to the subscriber and destroy the message. Any opinions contained in this e-mail are those of the author of the message and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries companies. No part of this message or attachments may be used or reproduced in any manner whatsoever.
>
>
>

attached mail follows:


Hi PHPers,

Just a quick thing that is bugging me. In some of my older textbooks a form is returned to the same page by using

echo $PHP_SELF no just $PHP_SELF

is this just used in older versions of php?? Does the it make a difference what one is used?

Ta,

Ross

attached mail follows:


Hello Ross,

Thursday, July 14, 2005, 11:11:25 AM, you wrote:

R> Just a quick thing that is bugging me. In some of my older
R> textbooks a form is returned to the same page by using

R> echo $PHP_SELF no just $PHP_SELF

R> is this just used in older versions of php?? Does the it make a
R> difference what one is used?

PHP_SELF is part of the $_SERVER super global, you should really
access it like this:

$_SERVER['PHP_SELF']

To answer your question though, it's just a variable - if you want to
output it into your form action then you can do either:

<? echo $_SERVER['PHP_SELF'] ?> or <?=$_SERVER['PHP_SELF']?>

Either would work.

Best regards,

Richard Davey
--
 http://www.launchcode.co.uk - PHP Development Services
 "I do not fear computers. I fear the lack of them." - Isaac Asimov

attached mail follows:


* Richard Davey <richlaunchcode.co.uk>:
> Hello Ross,
>
> Thursday, July 14, 2005, 11:11:25 AM, you wrote:
>
> R> Just a quick thing that is bugging me. In some of my older
> R> textbooks a form is returned to the same page by using
>
> R> echo $PHP_SELF no just $PHP_SELF
>
> R> is this just used in older versions of php?? Does the it make a
> R> difference what one is used?
>
> PHP_SELF is part of the $_SERVER super global, you should really
> access it like this:
>
> $_SERVER['PHP_SELF']
>
> To answer your question though, it's just a variable - if you want to
> output it into your form action then you can do either:
>
> <? echo $_SERVER['PHP_SELF'] ?> or <?=$_SERVER['PHP_SELF']?>
>
> Either would work.

Actually, to be truly portable, it should be:

    <?php echo $_SERVER['PHP_SELF']; ?>

Not all hosts have short tags enabled in their PHP installations.

Additionally, you have to be careful with PHP_SELF. On web servers that
allow PATH_INFO -- i.e., arguments to the script in the form of path
information, like '/path/to/script.php/more/path/info -- PHP_SELF will
contain the path to the script PLUS the contents of
$_SERVER['PATH_INFO'] -- which leaves PHP_SELF vulnerable to cross-site
scripting attacks. For some discussion on this, see:

    http://blog.phpdoc.info/archives/13-XSS-Woes.html

If you're using Apache, the safer bet is to use $_SERVER['SCRIPT_NAME'];
otherwise, use PHP_SELF, but filter it to exclude the path information.

--
Matthew Weier O'Phinney
Zend Certified Engineer
http://weierophinney.net/matthew/

attached mail follows:


phpmyadmin

On 7/13/05, glumtail <glumtailgmail.com> wrote:
> I think it's better to split the SQL into pieces
> line 1: create table ....
> line 2: insert into .....
> $sql = 'create table....'
> $sql = 'insert into ...'
>
> 2005/7/13, Shaw, Chris - Accenture <cshawrevenue.ie>:
> >
> >
> > Can you use mysqli_multi_query for mysql in php5?
> >
> > hth
> >
> > -----Original Message-----
> > From: babu [mailto:garavindbabuyahoo.co.uk]
> > Sent: 13 July 2005 16:39
> > To: php-generallists.php.net
> > Subject: [PHP] How to run .sql files using php
> >
> >
> > Hi ,
> >
> > i have a set of queries which i have placed them in one .sql file.i want
> > to
> > run this file using php's mssql and oracle(oci) functions.
> > any idea pls.
> >
> > thanks.
> > babu
> >
> >
> >
> > ---------------------------------
> > How much free photo storage do you get? Store your holiday snaps for FREE
> > with Yahoo! Photos. Get Yahoo! Photos
> >
> >
> > ************************
> >
> > This message has been delivered to the Internet by the Revenue Internet
> > e-mail service
> >
> > *************************
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>

attached mail follows:


hi babu

On 7/13/05, babu <garavindbabuyahoo.co.uk> wrote:
> i have a set of queries which i have placed them in one .sql file.i want to run this file using php's mssql and oracle(oci) functions.

you need a database abstraction layer to help you with that (adodb for example)

function fireSQL( $driver )
{

// establish the connection to the database using the specified driver

// read SQL from the file (probably tokenizing it into sql statements)

// feed the sql into the connection

}

-ahmed

attached mail follows:


or execute a shell command

$ret = `mysql -u[user] -p[password] -h[host] [db_name] < file.sql`;

glumtail wrote:
> I think it's better to split the SQL into pieces
> line 1: create table ....
> line 2: insert into .....
> $sql = 'create table....'
> $sql = 'insert into ...'
>
> 2005/7/13, Shaw, Chris - Accenture <cshawrevenue.ie>:
>
>>
>>Can you use mysqli_multi_query for mysql in php5?
>>
>>hth
>>
>>-----Original Message-----
>>From: babu [mailto:garavindbabuyahoo.co.uk]
>>Sent: 13 July 2005 16:39
>>To: php-generallists.php.net
>>Subject: [PHP] How to run .sql files using php
>>
>>
>>Hi ,
>>
>>i have a set of queries which i have placed them in one .sql file.i want
>>to
>>run this file using php's mssql and oracle(oci) functions.
>>any idea pls.
>>
>>thanks.
>>babu
>>
>>
>>
>>---------------------------------
>>How much free photo storage do you get? Store your holiday snaps for FREE
>>with Yahoo! Photos. Get Yahoo! Photos
>>
>>
>>************************
>>
>>This message has been delivered to the Internet by the Revenue Internet
>>e-mail service
>>
>>*************************
>>
>>--
>>PHP General Mailing List (http://www.php.net/)
>>To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
>

attached mail follows:


Thsi is way, way WAY too vague.

What exactly do you need a patern for?

If you simply want to change it, then just do a $var['whatever'] =
value; again in the module you want to change it in. If you want to
redo the config file, then you can just loop through the array,
printing out, each value of the array as you go. Otherwise you could
just use var_export().

On 7/12/05, Bruno B B Magalhães <brunobbmrio.com.br> wrote:
> Hi you all!
>
> That's my problem: I have a configuration files with the following
> structure...
>
> $vars['varname'] = 'varvalue';
>
> And I would like to have a module to change those parameters, but I
> don't know how to write a pattern to match it...
>
> Thanks in advance...
>
> Best Regards,
> Bruno B B Magalhaes
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

attached mail follows:


In the extension manager for the site/directory where this is not
working, make sure the check box "Verify file exists" is not checked. I
think I ran into a similar problem with a different extension and had
the same issue.

kgt

Grosz, Steve (IPG IT) wrote:

> Tjoekbezoer,
>
>I can tell you that it is there, because I manually added it, and it is
>set to 'allowed'.
>
>Steve
>
>-----Original Message-----
>From: Tjoekbezoer van Damme [mailto:tjoekbezoergmail.com]
>Sent: Wednesday, July 13, 2005 3:52 PM
>To: php-generallists.php.net
>Subject: Re: [PHP] 404 error - DLL files needed ??
>
>On 7/13/05, Grosz, Steve (IPG IT) <steve.groszhp.com> wrote:
>
>
>>I tried that, renamed a txt file to .php, but when I try to get the
>>
>>
>.php file, I just get a 404 error.
>
>Grosz, this might very well be your webserver invoking. By default, IIS
>6.0 all webserver extensions (like PHP). To check if your server still
>does, open up your IIS manager
>(Start->Run->'c:\windows\system32\inetsrv\iis.msc') Then browse to Web
>Service Extensions on the left. If you did install PHP correctly you
>should see PHP appearing in the list on the right. Set it to 'Allowed'.
>Now try requesting the page via your browser again.
>
>
>Good luck!
>
>Tjoekbezoer
>
>--
>PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:
>http://www.php.net/unsub.php
>
>
>

attached mail follows:


I pretty sure that it isn't checked, but I'll double check
again....anything else? I can't imagine that it should be this
difficult to get PHP running.....

Steve

-----Original Message-----
From: Kristen G. Thorson [mailto:kthorsonallegroconsultants.com]
Sent: Thursday, July 14, 2005 7:09 AM
Cc: php-generallists.php.net
Subject: Re: [PHP] 404 error - DLL files needed ??

In the extension manager for the site/directory where this is not
working, make sure the check box "Verify file exists" is not checked. I
think I ran into a similar problem with a different extension and had
the same issue.

kgt

Grosz, Steve (IPG IT) wrote:

> Tjoekbezoer,
>
>I can tell you that it is there, because I manually added it, and it is

>set to 'allowed'.
>
>Steve
>
>-----Original Message-----
>From: Tjoekbezoer van Damme [mailto:tjoekbezoergmail.com]
>Sent: Wednesday, July 13, 2005 3:52 PM
>To: php-generallists.php.net
>Subject: Re: [PHP] 404 error - DLL files needed ??
>
>On 7/13/05, Grosz, Steve (IPG IT) <steve.groszhp.com> wrote:
>
>
>>I tried that, renamed a txt file to .php, but when I try to get the
>>
>>
>.php file, I just get a 404 error.
>
>Grosz, this might very well be your webserver invoking. By default, IIS

>6.0 all webserver extensions (like PHP). To check if your server still
>does, open up your IIS manager
>(Start->Run->'c:\windows\system32\inetsrv\iis.msc') Then browse to Web
>Service Extensions on the left. If you did install PHP correctly you
>should see PHP appearing in the list on the right. Set it to 'Allowed'.
>Now try requesting the page via your browser again.
>
>
>Good luck!
>
>Tjoekbezoer
>
>--
>PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:
>http://www.php.net/unsub.php
>
>
>

attached mail follows:


How do you people best deal with text meant for i18n via gettext, which is
either large or contains HTML tags, or both?

The GNU gettext manual, in section 3.2, recommends to split long texts at
paragraph level, or in the case of long --help screens, in batches of 5-10
lines at most. I can dig this, but I'd still appreciate some feedback.

Formatting, however, is a slightly different issue. The manual seems to have
been written mainly for C users, and as such only deals with spaces, tabs and
newlines.

Of course, structural HTML is a big no-no IMO (ie. the likes of <p>, <li> or
tables). But styling HTML is often needed (<strong>, <em> ...). Am I right in
assuming that a small set of pure style-related HTML should be allowed? I'm
thinking <strong>, <em>, <del> and <ins>. The alternative of replacing them
with %s instead and inserting them in the code on the fly looks like an
attrocity to me.

And allowing any tags still doesn't make me 100% happy; consider borderline
complications due to HTML vs XHTML, or the very principle of separating
content from presentation, which seems to be breached.

And how should <br> be dealt with? Allow it, or go with newlines instead, and
decide in the code if I want to apply a nl2br() or not?

--
Romanian Web Developers - http://ROWD.ORG

attached mail follows:


"Skippy" <skippyzuavra.net> wrote in message
news:1121343285.42d6573527140imp.pro.proxad.net...
> How do you people best deal with text meant for i18n via gettext, which is
> either large or contains HTML tags, or both?
>
> The GNU gettext manual, in section 3.2, recommends to split long texts at
> paragraph level, or in the case of long --help screens, in batches of 5-10
> lines at most. I can dig this, but I'd still appreciate some feedback.
>
> Formatting, however, is a slightly different issue. The manual seems to
have
> been written mainly for C users, and as such only deals with spaces, tabs
and
> newlines.
>
> Of course, structural HTML is a big no-no IMO (ie. the likes of <p>, <li>
or
> tables). But styling HTML is often needed (<strong>, <em> ...). Am I right
in
> assuming that a small set of pure style-related HTML should be allowed?
I'm
> thinking <strong>, <em>, <del> and <ins>. The alternative of replacing
them
> with %s instead and inserting them in the code on the fly looks like an
> attrocity to me.
>

Consider whether you will always display the information in a web browser.
If there is any possibility that another program may be used for display,
you don't want the HTML tags in the database.

> And allowing any tags still doesn't make me 100% happy; consider
borderline
> complications due to HTML vs XHTML, or the very principle of separating
> content from presentation, which seems to be breached.
>
> And how should <br> be dealt with? Allow it, or go with newlines instead,
and
> decide in the code if I want to apply a nl2br() or not?
>
> --
> Romanian Web Developers - http://ROWD.ORG

attached mail follows:


Quoting Mark Rees <mreesitsagoodprice.com>:
> Consider whether you will always display the information in a web browser.
> If there is any possibility that another program may be used for display,
> you don't want the HTML tags in the database.

In this particular situation I'm dealing with I only have web browsers to
worry about.

However, for the sake of argument: couldn't I still allow those styling tags
and do some post-processing in the code? Such as stripping the tags, or
converting them to something else. Things like bold and italic are almost
universally meaningful.

--
Romanian Web Developers - http://ROWD.ORG

attached mail follows:


I'm working on a soap client in PHP5, which I'm building by
subclassing the built-in SoapClient class. However, it seems my
overridden __soapCall method is never being called. My class looks
something like this:

class myClient extends SoapClient {
     public function __construct($wsdl = 'http://www.example.com/
my.wsdl', $options = NULL) {
     if (!is_array($options))
         $options = array('soap_version' => SOAP_1_1, 'trace' =>
true, 'exceptions' => true);
         parent::__construct($wsdl, $options);
     }
     public function __soapCall($function_name, $arguments = array(),
$options = array(), $input_headers = NULL, &$output_headers = array()) {
         echo "doing __soapCall\n";
         return parent::__soapCall($function_name, $arguments,
$options, $input_headers, $output_headers);
     }
}

The constructor works fine. As you can see __soapCall does nothing
but pass through the call to the parent, but it's just not being
called. I've found various references to overriding the __call
function (which is now completely obsolete as it clashes with a magic
method) for the same kind of reason that I need to. So, it seems as
if __soapCall is NOT called internally when calling a WSDL function,
so if my client has a login function:

$sc = new myClient();
$sc->login(array('username' => 'abc', 'password' => 'xyz'));

but this does not seem to go via the internal __soapCall function,
thus denying me the ability to tweak the request on its way through.
If I call it manually (i.e. non-WSDL way), something like:

$sc->__soapCall('login', array('username' => 'abc', 'password' =>
'xyz'));

then it works, but in that simple gesture I've lost most of the WSDL
advantage.

What am I supposed to do?

Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you in the picture
marcussynchromedia.co.uk | http://www.synchromedia.co.uk

attached mail follows:


On 14 Jul 2005, at 16:07, Marcus Bointon wrote:

> I've found various references to overriding the __call function
> (which is now completely obsolete as it clashes with a magic
> method) for the same kind of reason that I need to. So, it seems as
> if __soapCall is NOT called internally when calling a WSDL function

Answering my own question - __soapCall is not called internally, but
you can force it by using __call (that is the magic method, not the
obsolete __call function in SoapClient) by adding this function to
the class:

     function __call($function, $args) {
         return $this->__soapCall($function, $args, null);
     }

This means that I can finally get to pass stuff though my own
__soapCall method, though I have the feeling that it may prevent me
doing other stuff later on (I'm not normally relying on __call
functionality).

Phew.

Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you in the picture
marcussynchromedia.co.uk | http://www.synchromedia.co.uk

attached mail follows:


I am having trouble connecting to MySQL server through a PHP script
and I am not sure why.

the error I receive is:

Warning: mysql_pconnect(): Access denied for user:
'bruceg_webmaster69.90.88.155' (Using password: YES) in
/hsphere/local/home/bruceg/inspired-evolution.com/search/include/connect.php
on line 6
Cannot connect to database, check if username, password and host are correct.

trying to connect with the following script:

?php
        $database="bruceg_search";
        $mysql_user = "bruceg_webmaster";
        $mysql_password = " password";
        $mysql_host = "server-10.existhost.com";
        mysql_pconnect ($mysql_host, $mysql_user, $mysql_password);
        if (!$success)
                die ("<b>Cannot connect to database, check if username, password and
host are correct.</b>");
    $success = mysql_select_db ($database);
        if (!$success) {
                print "<b>Cannot choose database, check if database name is correct.";
                die();
        }
?>

I double checked the database and I have created a database called
bruceg_search and added a user called bruceg_webmaster with all of the
editing privileges. Of course 'password' is changes with the password
used to connect in the actual script. and I double checked that to be
correct as well. Any suggestions?

--
::Bruce::

attached mail follows:


Bruce Gilbert wrote:
> I am having trouble connecting to MySQL server through a PHP script
> and I am not sure why.
>
> the error I receive is:
>
> Warning: mysql_pconnect(): Access denied for user:
> 'bruceg_webmaster69.90.88.155' (Using password: YES) in
> /hsphere/local/home/bruceg/inspired-evolution.com/search/include/connect.php
> on line 6
> Cannot connect to database, check if username, password and host are correct.
>
> trying to connect with the following script:
>
> ?php
> $database="bruceg_search";
> $mysql_user = "bruceg_webmaster";
> $mysql_password = " password";
> $mysql_host = "server-10.existhost.com";
> mysql_pconnect ($mysql_host, $mysql_user, $mysql_password);
> if (!$success)
> die ("<b>Cannot connect to database, check if username, password and
> host are correct.</b>");
> $success = mysql_select_db ($database);
> if (!$success) {
> print "<b>Cannot choose database, check if database name is correct.";
> die();
> }
> ?>
>
> I double checked the database and I have created a database called
> bruceg_search and added a user called bruceg_webmaster with all of the
> editing privileges. Of course 'password' is changes with the password
> used to connect in the actual script. and I double checked that to be
> correct as well. Any suggestions?
>

Did you restart MySQL after you added the permissions?

--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
johnkegworks.com

attached mail follows:


Where do you populate $success ?

It looks too me that $success would always be empty no matter whether you
connected or not.

On 7/14/05 8:27 AM, "Bruce Gilbert" <webguyncgmail.com> wrote:

> mysql_pconnect ($mysql_host, $mysql_user, $mysql_password);
> if (!$success)
>

--
Stephen Johnson
The Lone Coder

stephenthelonecoder.com
http://www.thelonecoder.com

*Continuing the struggle against bad code*
--

attached mail follows:


Bruce,

looks like
> mysql_pconnect ($mysql_host, $mysql_user, $mysql_password);

wants to read

$success = mysql_pconnect ($mysql_host, $mysql_user, $mysql_password);

Raz

attached mail follows:


Hello Bruce,

Thursday, July 14, 2005, 4:27:12 PM, you wrote:

BG> ?php
BG> $database="bruceg_search";
BG> $mysql_user = "bruceg_webmaster";
BG> $mysql_password = " password";
BG> $mysql_host = "server-10.existhost.com";
BG> mysql_pconnect ($mysql_host, $mysql_user, $mysql_password);
BG> if (!$success)
BG> die ("<b>Cannot connect to database, check if username, password and
BG> host are correct.</b>");
BG> $success = mysql_select_db ($database);
BG> if (!$success) {
BG> print "<b>Cannot choose database, check if database name is correct.";
BG> die();
BG> }
?>>

BG> I double checked the database and I have created a database called
BG> bruceg_search and added a user called bruceg_webmaster with all of
BG> the editing privileges. Of course 'password' is changes with the
BG> password used to connect in the actual script. and I double
BG> checked that to be correct as well. Any suggestions?

Sure.. where is $success set?

I don't see it being set anywhere :)

Best regards,

Richard Davey
--
 http://www.launchcode.co.uk - PHP Development Services
 "I do not fear computers. I fear the lack of them." - Isaac Asimov

attached mail follows:


MySQL authentication is user+host+password. Make sure user
brucer_webmaster has host 69.90.88.155.

kgt

Bruce Gilbert wrote:

>I am having trouble connecting to MySQL server through a PHP script
>and I am not sure why.
>
>the error I receive is:
>
>Warning: mysql_pconnect(): Access denied for user:
>'bruceg_webmaster69.90.88.155' (Using password: YES) in
>/hsphere/local/home/bruceg/inspired-evolution.com/search/include/connect.php
>on line 6
>Cannot connect to database, check if username, password and host are correct.
>
>trying to connect with the following script:
>
>?php
> $database="bruceg_search";
> $mysql_user = "bruceg_webmaster";
> $mysql_password = " password";
> $mysql_host = "server-10.existhost.com";
> mysql_pconnect ($mysql_host, $mysql_user, $mysql_password);
> if (!$success)
> die ("<b>Cannot connect to database, check if username, password and
>host are correct.</b>");
> $success = mysql_select_db ($database);
> if (!$success) {
> print "<b>Cannot choose database, check if database name is correct.";
> die();
> }
>?>
>
>I double checked the database and I have created a database called
>bruceg_search and added a user called bruceg_webmaster with all of the
>editing privileges. Of course 'password' is changes with the password
>used to connect in the actual script. and I double checked that to be
>correct as well. Any suggestions?
>
>
>

attached mail follows:


Bruce,

Do you mean to have a space before the word "password"?

Aaron

Aaron Greenspan
President & CEO
Think Computer Corporation

http://www.thinkcomputer.com

attached mail follows:


I have a script that generates, creates, and updates dynamic banner
images for users of a service.

Recently I have run into a problem with file permissions... that has
thoroughly annoyed me. I found a solution to fix the problem, however,
it was then hit with another problem, and I'm not sure how secure I find
my solution to be.

During the image creation process, the files are given the normal image
permission of 644 (rw-r--r--). Of course, this makes updating impossible.

I attempted to use a simple chmod();, however, the script didnt have the
permissions to do this. I couldnt figure out a way to fix this, so I
moved on to looking for other solutions.

I ended up with somethign that worked, slightly, but did not provide me
with an actual fix due to another problem. I would connect to the folder
via local FTP, then using ftp_site run a direct CHMOD on the files.

However, in doing this, I feel that the script itself is insecure. Also,
it didnt work in the end. After running the update script, to test out
my new solution, I was confronted with a new problem that I didnt
understand.

The FTP command returned "Bad File Descriptor" after executing the
CHMOD. After attempting in a few other of my own FTP clients, I ran into
-exactly- the same problem.

My questions are this:

A) Is there any way to set the permissions on the file on creation of
the image?
B) If no, is there a way I can do the CHMOD, even though chmod();
returned insufficient permissions to do so?
C) If no, is there a way I can fix the bad file descriptor, to fix the
ftp solution I have?

Any other solutions would be able as well, given that they're somewhat
secure.

attached mail follows:


Adam Hubscher wrote:
> I have a script that generates, creates, and updates dynamic banner
> images for users of a service.
>
> Recently I have run into a problem with file permissions... that has
> thoroughly annoyed me. I found a solution to fix the problem, however,
> it was then hit with another problem, and I'm not sure how secure I find
> my solution to be.
>
> During the image creation process, the files are given the normal image
> permission of 644 (rw-r--r--). Of course, this makes updating impossible.
>

How are those permissions getting set? What program is creating the
image files? I would think that if PHP is generating the images, then
PHP would be the owner? So PHP should be able to overwrite/delete those
files.

> I attempted to use a simple chmod();, however, the script didnt have the
> permissions to do this. I couldnt figure out a way to fix this, so I
> moved on to looking for other solutions.
>
> I ended up with somethign that worked, slightly, but did not provide me
> with an actual fix due to another problem. I would connect to the folder
> via local FTP, then using ftp_site run a direct CHMOD on the files.
>
> However, in doing this, I feel that the script itself is insecure. Also,
> it didnt work in the end. After running the update script, to test out
> my new solution, I was confronted with a new problem that I didnt
> understand.
>
> The FTP command returned "Bad File Descriptor" after executing the
> CHMOD. After attempting in a few other of my own FTP clients, I ran into
> -exactly- the same problem.
>

Is this a windows server? All of the ftp clients I've used that have a
CHMOD feature only work on *nix servers. As far as I know windows
doesn't have a CHMOD.

> My questions are this:
>
> A) Is there any way to set the permissions on the file on creation of
> the image?

If PHP is doing the image creation you can use the chmod() function to
change the permissions. I think it will even try to do a resonable
attempt on windows machines too. I'm doing this on the images that I
create on a *nix server.

> B) If no, is there a way I can do the CHMOD, even though chmod();
> returned insufficient permissions to do so?
> C) If no, is there a way I can fix the bad file descriptor, to fix the
> ftp solution I have?
>
> Any other solutions would be able as well, given that they're somewhat
> secure.
>

attached mail follows:


Is setting up PHP easier on Windows 2000 server rather than Win2003?
I'm having nothing but problems getting PHP files to show up in IE on
the Win2003 server, I get nothing but 404 - file not found errors.

attached mail follows:


""Grosz, Steve (IPG IT)"" <steve.groszhp.com> wrote in message
news:4C69D6E11B774547BA152B6CA31D64E0028402FAidbexc01.americas.cpqcorp.net.
..
Is setting up PHP easier on Windows 2000 server rather than Win2003?
I'm having nothing but problems getting PHP files to show up in IE on
the Win2003 server, I get nothing but 404 - file not found errors.

Can you install Apache? It's straightforward to set up. I've done it on
three different win2k boxes without any problems. Top tip is to stop IIS
before attempting to install Apache

attached mail follows:


[snip]
Is setting up PHP easier on Windows 2000 server rather than Win2003?
I'm having nothing but problems getting PHP files to show up in IE on
the Win2003 server, I get nothing but 404 - file not found errors.
[/snip]

http://www.webhostgear.com/203.html step by step for 2003

attached mail follows:


Hello Steve,

Thursday, July 14, 2005, 5:15:01 PM, you wrote:

GSII> Is setting up PHP easier on Windows 2000 server rather than
GSII> Win2003? I'm having nothing but problems getting PHP files to
GSII> show up in IE on the Win2003 server, I get nothing but 404 -
GSII> file not found errors.

Just don't use IIS - use Apache instead. It's an extremely easy
install process, one I documented fully on this mailing list no more
than a few weeks ago.

Best regards,

Richard Davey
--
 http://www.launchcode.co.uk - PHP Development Services
 "I do not fear computers. I fear the lack of them." - Isaac Asimov

attached mail follows:


Hello,
 
 I'm successfully playing with php 5 and Its built-in soap but I still have a couple of questions.

 The most important one is regarding the performance. It is something I also found using php 4 and nusoap. Most of the time for a call is being spend on loading the code. Aprox 0.000025 sec per code line. This could be a problem if you have a lot of code for your server. Why Apache is loading all the code for each call? Is It possible to configure Apache to load the Soap Server just once?

 Second one is regarding wsdl generation. I unsuccessfully tried to find a tool to do it. I gave a try to Webservice Helper (jool.nl) and I didn't find the result convenient for my purpose. Is there any simple and useful tool to automatic generate the wsdl? I finally did it manually from scratch.

Thank you very much in advance.
Kind regards,
 Victor.

attached mail follows:


Hey,
At this stage am pretty much brain dead and getting a simple percentage is
too much for me now.

Basically, I have these two fields:
$pic_no_of_votes
$vote_total_pts

and this totals them up and keeps the average:
$average_pts

people vote on a scale of 1-5, so the average should be between 1-5 (right??
am not even sure of this!)

I was thinking of rounding it with a 2 decimal point...eg:
 round(5.045, 2)

Just need to solve this and them am hitting the sack, any help appreciated.

Thanks,
Ryan