php-windows Digest 19 May 2001 19:15:20 -0000 Issue 607

Topics (messages 7746 through 7758):

Re: Any good editor for PHP in Windows?
        7746 by: elias
        7750 by: John Lim
        7756 by: PHPBeginner.com

how to exucute PHP file automatically on Window NT4.0 scheduler
        7747 by: Lalit
        7748 by: Mr. Adam ALLEN.
        7749 by: Steve Perrin'
        7754 by: Svensson, B.A.T.

Re: MS Access + Linux + PHP
        7751 by: John Lim

Re: Canceling a Query
        7752 by: John Lim

PHP/Javascript
        7753 by: Bob Sears
        7755 by: Mike Flynn
        7757 by: Mike Flynn

PHP & Domino?? (Lotus Notes)
        7758 by: Mike Kelley

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]


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


www.editplus.com
www.sapien.com (PrimalScript)

-elias

""news.php.net"" <[EMAIL PROTECTED]> wrote in message
9e4jua$526$[EMAIL PROTECTED]">news:9e4jua$526$[EMAIL PROTECTED]...
> Hello,
>   I wondering is they any good editor for PHP in windows, like Visual
> Interdev for ASP
>
> --
> Thank you
> Khaimun
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






Create a shortcut and run from the command-line:

php.exe -q <scriptname>

-q means suppress HTTP headers

""elias"" <[EMAIL PROTECTED]> wrote in message
9e57sk$9k$[EMAIL PROTECTED]">news:9e57sk$9k$[EMAIL PROTECTED]...
> www.editplus.com
> www.sapien.com (PrimalScript)
>
> -elias
>
> ""news.php.net"" <[EMAIL PROTECTED]> wrote in message
> 9e4jua$526$[EMAIL PROTECTED]">news:9e4jua$526$[EMAIL PROTECTED]...
> > Hello,
> >   I wondering is they any good editor for PHP in windows, like Visual
> > Interdev for ASP
> >
> > --
> > Thank you
> > Khaimun
> >
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






EditPlus is the best.


Sincerely,

 Maxim Maletsky
 Founder, Chief Developer

 PHPBeginner.com (Where PHP Begins)
 [EMAIL PROTECTED]
 www.phpbeginner.com




-----Original Message-----
From: elias [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 20, 2001 2:52 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Any good editor for PHP in Windows?


www.editplus.com
www.sapien.com (PrimalScript)

-elias

""news.php.net"" <[EMAIL PROTECTED]> wrote in message
9e4jua$526$[EMAIL PROTECTED]">news:9e4jua$526$[EMAIL PROTECTED]...
> Hello,
>   I wondering is they any good editor for PHP in windows, like Visual
> Interdev for ASP
>
> --
> Thank you
> Khaimun
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]






I am working with PHP, Mysql on WINDOWS NT4.0.(IIS 4.0)
My problem is regarding Window Scheduler. I want to send mail every day at
perticular time to the email address list stored in Mysql database
automatically. The subject and mail body is also stored in database.
Window scheduler invokes only executable files, not php file in which I have
written queries and mail function.

Does anybody know the solution ?
Thanks






I have the Task Scheduler on my computer - (maybe it's the same thing but
different names, I have IE 4.01 installed, it might be different in a newer
version of IE - I seem to recall it's a part of IE but it's not there on
another server I have by my side????). Anyhow.....


If you run the programs as

d:\php\bin\php.exe c:\my-php-scripts\phpscript.php3

that should work. I have a couple of scripts which parse the proxy server
log files into a MySQL database through the night.

Yours
Mr. Adam ALLEN.
[EMAIL PROTECTED]
http://www.dynamicinteraction.co.uk

> -----Original Message-----
> From: Lalit [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, May 19, 2001 9:33 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] how to exucute PHP file automatically on Window NT4.0
> scheduler
>
>
> I am working with PHP, Mysql on WINDOWS NT4.0.(IIS 4.0)
> My problem is regarding Window Scheduler. I want to send mail every day at
> perticular time to the email address list stored in Mysql database
> automatically.
>





Hi Lalit,

You should have no problem in running your script.

Just create a batch file, change drive then directory and add PHP
YOURSCRIPT.PHP.

eg: DOIT.BAT

@ECHO OFF
D:
CD\PHP4
PHP YOURSCRIPT.PHP
EXIT

Then use the AT command to invoke the batch file at the times required.

""Lalit"" <[EMAIL PROTECTED]> wrote in message
9e5b96$hgs$[EMAIL PROTECTED]">news:9e5b96$hgs$[EMAIL PROTECTED]...
> I am working with PHP, Mysql on WINDOWS NT4.0.(IIS 4.0)
> My problem is regarding Window Scheduler. I want to send mail every day at
> perticular time to the email address list stored in Mysql database
> automatically. The subject and mail body is also stored in database.
> Window scheduler invokes only executable files, not php file in which I
have
> written queries and mail function.
>
> Does anybody know the solution ?
> Thanks
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






>I am working with PHP, Mysql on WINDOWS NT4.0.(IIS 4.0)
>My problem is regarding Window Scheduler. I want to send mail 
>every day at perticular time to the email address list stored
>in Mysql database automatically.

Can't you solve it with AT.exe? (Works similar as cron under unix).




The ADODB database library implements a similar solution to Tim's, but using
HTTP as the transport layer, and a hybrid of CSV and the PHP serialize( )
function for the data.

It's very complete as you can perform select/delete/insert/update and get
the error messages from the windows server transparently.

http://php.weblogs.com/adodb for the software and
http://php.weblogs.com/adodb_csv for the instructions how to use it.

"Tim Uckun" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> At 10:53 AM 5/18/2001 +0200, you wrote:
> >Hi there,
> >cfg: linux, apache, php 4.04, MS Access
> >is there any chance to get any data from access (php) on linux machine ?
> >thank you for any help !!
>
> I wrote an article about this.. It's here
> http://www.phpbuilder.com/columns/timuckun20001207.php3
>
>
> :wq
> Tim Uckun
> Due Diligence Inc.  http://www.diligence.com/    Americas Background
> Investigation Expert.
> If your company isn't doing background checks, maybe you haven't
considered
> the risks of a bad hire.
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>






You mentioned that the results don't return many rows. So if you are using a
lot of
aggregate functions (max, min, etc), it's possible to precalculate them
every night
and join on the precalculated values.  Much faster. I also believe there are
data warehousing solutions that automatically precalculate these aggregates
for you, eg. Oracle's.

Regards, john






This is what my screen looks like:

                                   I want to order ...
description     image    dropdown box              @ 7.95 each = [text box]
                                   containing 0-20
                                   numerics

I had been contemplating using Javascript to perform the text box extension 
of the quantity * rate calculation. However, the
need is to also update a MySQL table with the session tracking number and 
other pertinent information about the selection
so a purchase order can be written in a subsequent module.

Can this be done with straight PHP or will it require a mix of Javascript 
for the calculation and PHP for the data base update?
If so, what might the code look like?

Bob





You can do it either way.

You can either have the user change values, then hit the "recalculate" or 
"update" button which calls the PHP script to update all values.. or you 
can use JavaScript to update some simple calculations immediately after the 
user makes any changes, but you still need to have them eventually submit 
it to actually record the changes anywhere meaningful -- i/e database, 
file, session/cookie, etc.

A nice combination of both is the most aesthetic.  For example, say you had 
a form with 3 inputs:
[item price]   [quantity]    [subtotal]
It would be nice to have the JavaScript update subtotal any time the user 
changes the item and/or quantity, to reflect the new subtotal.  But you 
would still need them to submit the form for PHP to take note of the 
submitted data and do whatever.

-Mike

At 07:55 AM 5/19/01 -0500, you wrote:
>This is what my screen looks like:
>
>                                   I want to order ...
>description     image    dropdown box              @ 7.95 each = [text box]
>                                   containing 0-20
>                                   numerics
>
>I had been contemplating using Javascript to perform the text box 
>extension of the quantity * rate calculation. However, the
>need is to also update a MySQL table with the session tracking number and 
>other pertinent information about the selection
>so a purchase order can be written in a subsequent module.
>
>Can this be done with straight PHP or will it require a mix of Javascript 
>for the calculation and PHP for the data base update?
>If so, what might the code look like?
>
>Bob
>
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]


               -=- Mike Flynn - Burlington, VT -=-
[EMAIL PROTECTED]  http://www.mikeflynn.net/  * Give blood *
  Wouldn't the free market, in its true form, be anarchy?





Good point.  I personally do that every time -- I never rely on client-side 
script-produced values, I just use them for aesthetics -- so the user can 
see the changes right before their eyes before submitting.  But if you say 
have 3 fields, A B and C where C is A*B, I will have PHP recalculate C upon 
submission even though the JavaScript may have set C to A*B beforehand.

Take care,
-Mike

At 04:20 PM 5/19/01 +0100, you wrote:

>One little warning, even if you are doing your calculations in javascript,
>do them again in PHP and check the two are correct. Somebody on the
>client-side could alter the data going into the PHP-script. I always think
>it's dangerous when people start using Javascript - what happens if the
>client has no javascript - are you going to detect that.
>
>Yours
>Mr. Adam ALLEN.
>[EMAIL PROTECTED]
>http://www.dynamicinteraction.co.uk
>
> > You can either have the user change values, then hit the "recalculate" or
> > "update" button which calls the PHP script to update all values.. or you
> > can use JavaScript to update some simple calculations immediately
> > after the
> > user makes any changes, but you still need to have them eventually submit
> > it to actually record the changes anywhere meaningful -- i/e database,
> > file, session/cookie, etc.
> >
> > A nice combination of both is the most aesthetic.  For example,
> > say you had
> > a form with 3 inputs:
> > [item price]   [quantity]    [subtotal]
> > It would be nice to have the JavaScript update subtotal any time the user
> > changes the item and/or quantity, to reflect the new subtotal.  But you
> > would still need them to submit the form for PHP to take note of the
> > submitted data and do whatever.
> >
> > -Mike
> >
> > At 07:55 AM 5/19/01 -0500, you wrote:
> > >This is what my screen looks like:
> > >
> > >                                   I want to order ...
> > >description     image    dropdown box              @ 7.95 each =
> > [text box]
> > >                                   containing 0-20
> > >                                   numerics
> > >
> > >I had been contemplating using Javascript to perform the text box
> > >extension of the quantity * rate calculation. However, the
> > >need is to also update a MySQL table with the session tracking
> > number and
> > >other pertinent information about the selection
> > >so a purchase order can be written in a subsequent module.
> > >
> > >Can this be done with straight PHP or will it require a mix of
> > Javascript
> > >for the calculation and PHP for the data base update?
> > >If so, what might the code look like?
> > >
> > >Bob
> > >
> > >
> > >--
> > >PHP Windows Mailing List (http://www.php.net/)
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> >                -=- Mike Flynn - Burlington, VT -=-
> > [EMAIL PROTECTED]  http://www.mikeflynn.net/  * Give blood *
> >   Wouldn't the free market, in its true form, be anarchy?
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >


               -=- Mike Flynn - Burlington, VT -=-
[EMAIL PROTECTED]  http://www.mikeflynn.net/  * Give blood *
  Wouldn't the free market, in its true form, be anarchy?





Anyone do anything in this arena yet? I searched the archives for 2001 
but have yet to go farther back. I know I can use the COM ability to get 
info from Domino but I'm looking for any success stories with Lotus Domino.



Reply via email to