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.