RE: [PHP-DB] PHP Standalone? (fwd)
Take a look at http://gtk.php.net/apps. Lots of references to code that will work on both *nix and Win32 systems. - Frank > Hi there, > > Unfortunately I don't know much Perl at all ATM, and I've suddenly has this > job arise that needs me use an ACCESS Database (Yuck) but in a windows-style > interface and NOT web, so I have been looking hard to try to find > information on whether I can create an interface for 2000/XP that can > control and receive results from PHP. > > If you have any tips I would be really appreciative :-) I just download > PHP-GTK. > > Chris Payne > -- > [EMAIL PROTECTED] > [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 05, 2004 7:30 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP Standalone? (fwd) > > while php can be set up to do what you're after, i think that perl > would be a better choice. while i use both php and perl, i think that > perl is a much stronger general scripting language. > > if you need [web]server parsed pages, then php has an advantage (unless > you want to use mod_perl), but in a standalone environment i think that > perl will serve you better. > > > > > -- Forwarded Message -- > Date: Thursday, February 05, 2004 04:19:56 PM -0800 > From: "Frank M. Kromann" <[EMAIL PROTECTED]> > To: Chris Payne <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP Standalone? > > > http://gtk.php.net > > - Frank > > > Hi there everyone, > > > > > > > > I need to produce a system which uses databases but NOT on a > > webserver, > I > > heard something about a PHP distro that is being developed which acts > like > > an executable, does anyone know anything of this? > > > > > > > > Any help would really be appreciated :-) > > > > > > > > Chris Payne > > > > -- > > > > [EMAIL PROTECTED] > > > > [EMAIL PROTECTED] > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- End Forwarded Message -- > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Associated popup menu (php/mysql)
Actually, there is a way to do this with PHP. It may not be the best method, but it is possible. You could do it with one single source file, or multiple. With a single source file you could do something like this: The first time through would display the first popup with valid choices. Form action would post the results of the popup to the same page. Now you have a variable with a value from the first popup. You can then display your second popup choices based on the first. And so on for any remaining popups. With multiple source files: The first page displays the first popup. Form action would post the results to the next page. As with the first method, you now have a variable with a value from the first popup. Display your second popup choices based on the first. And so on... Pro: You don't need to learn Javascript. Con: The web page is redrawn for each new popup selection - not seamless like a pure Javascript solution may be. Using multiple source files may help you keep load time down as well as make it easier to maintain. It's a matter of personal choice, I think. If you don't program Javascript, this is one method you may consider - though I would encourage anyone writing web pages to learn Javascript. It can be a real lifesaver! :-) With either method (PHP or Javascript), you'll probably want to code in some way for the user to go back and re-select the first popup, i.e. start over. Sorry, I don't have sample code. I haven't had a need for this type of popups yet, but I have a project coming up soon that probably will. If I get a chance to code up a sample, I'll make it available. Good luck. :Mike S. :Austin TX On Thu February 5 2004 7:33pm, Micah Stevens wrote: > > Javascript is client side programming, PHP is server side and unable to > control actions and make decisions on what's happening in the browser > except in a 'third person' manner. > > Simply put, you can't do this with PHP. > > On Thu February 5 2004 5:21 pm, alb_shop wrote: >> Hello all, >> >> I've been searching for hours and cannot find the answer or sample in >> in any forum. >> >> What is the best method (any sample or help would be appreciated), to >> associate popup menus in a form. Choosing the first popup menu (Main >> categorie) should provide to me the results for the second popup menu >> (subcategory). >> >> Ie : Countries --> states >> >> I know that javascript can do this sort of things, but I would like to >> use only php. Is that possible ? >> >> I have two tables in mysql: Countries & states that can be associated >> by id_country. >> >> Thank you --- Sent: February 6, 2004, 12:09 am -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Acessing a excel worksheet from a php site
I'm making a site to a company and they have a excel worksheet where i have to get the data to a site in php. My question is simple, i think, how can i get it? Cumprimentos Bruno Pereira DSI [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Associated popup menu (php/mysql)
Javascript is client side programming, PHP is server side and unable to control actions and make decisions on what's happening in the browser except in a 'third person' manner. Simply put, you can't do this with PHP. On Thu February 5 2004 5:21 pm, alb_shop wrote: > Hello all, > > I've been searching for hours and cannot find the answer or sample in in > any forum. > > What is the best method (any sample or help would be appreciated), to > associate popup menus in a form. Choosing the first popup menu (Main > categorie) should provide to me the results for the second popup menu > (subcategory). > > Ie : Countries --> states > > I know that javascript can do this sort of things, but I would like to use > only php. Is that possible ? > > I have two tables in mysql: Countries & states that can be associated by > id_country. > > Thank you -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Associated popup menu (php/mysql)
Hello all, I've been searching for hours and cannot find the answer or sample in in any forum. What is the best method (any sample or help would be appreciated), to associate popup menus in a form. Choosing the first popup menu (Main categorie) should provide to me the results for the second popup menu (subcategory). Ie : Countries --> states I know that javascript can do this sort of things, but I would like to use only php. Is that possible ? I have two tables in mysql: Countries & states that can be associated by id_country. Thank you -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP Standalone? (fwd)
Hi there, Unfortunately I don't know much Perl at all ATM, and I've suddenly has this job arise that needs me use an ACCESS Database (Yuck) but in a windows-style interface and NOT web, so I have been looking hard to try to find information on whether I can create an interface for 2000/XP that can control and receive results from PHP. If you have any tips I would be really appreciative :-) I just download PHP-GTK. Chris Payne -- [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 05, 2004 7:30 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP Standalone? (fwd) while php can be set up to do what you're after, i think that perl would be a better choice. while i use both php and perl, i think that perl is a much stronger general scripting language. if you need [web]server parsed pages, then php has an advantage (unless you want to use mod_perl), but in a standalone environment i think that perl will serve you better. -- Forwarded Message -- Date: Thursday, February 05, 2004 04:19:56 PM -0800 From: "Frank M. Kromann" <[EMAIL PROTECTED]> To: Chris Payne <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP Standalone? http://gtk.php.net - Frank > Hi there everyone, > > > > I need to produce a system which uses databases but NOT on a > webserver, I > heard something about a PHP distro that is being developed which acts like > an executable, does anyone know anything of this? > > > > Any help would really be appreciated :-) > > > > Chris Payne > > -- > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- End Forwarded Message -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP Standalone?
http://gtk.php.net - Frank > Hi there everyone, > > > > I need to produce a system which uses databases but NOT on a webserver, I > heard something about a PHP distro that is being developed which acts like > an executable, does anyone know anything of this? > > > > Any help would really be appreciated :-) > > > > Chris Payne > > -- > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP Standalone?
http://us4.php.net/manual/en/features.commandline.php On Thu February 5 2004 3:17 pm, Chris Payne wrote: > Hi there everyone, > > > > I need to produce a system which uses databases but NOT on a webserver, I > heard something about a PHP distro that is being developed which acts like > an executable, does anyone know anything of this? > > > > Any help would really be appreciated :-) > > > > Chris Payne > > -- > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP Standalone?
Hi there everyone, I need to produce a system which uses databases but NOT on a webserver, I heard something about a PHP distro that is being developed which acts like an executable, does anyone know anything of this? Any help would really be appreciated :-) Chris Payne -- [EMAIL PROTECTED] [EMAIL PROTECTED]
Re: [PHP-DB] Help with an UPDATE query please
> > I have (among others) two DATE columns in a table; Booking_Date and > > Booking_Completion_Date. How can I run a query that updates > > Booking_Completion_Date to be 2 days after Booking_Date where > > Booking_Completion_Date is NULL? UPDATE table SET Booking_Completion_Date = Booking_Date + INTERVAL 2 DAY WHERE Booking_Completion_Date IS NULL; ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[Fwd: Re: [PHP-DB] Help with an UPDATE query please]
[Forwarded for Paxson Jr. because this was only sent to me.] you can also easily use the mysql date functions http://www.mysql.com/doc/en/Date_and_time_functions.html On 05. Feb 2004, at 11:23 Uhr, Stuart Gilbert wrote: Presuming you have the date in your PHP code you could simply add 172800 (seconds in 2 days) to the current value and insert it in the same way as you are doing with your current dates. If you post how you're inserting your dates, what format you're using and stuff like that then you'll probably get more concise help. Shaun wrote: Hi, I have (among others) two DATE columns in a table; Booking_Date and Booking_Completion_Date. How can I run a query that updates Booking_Completion_Date to be 2 days after Booking_Date where Booking_Completion_Date is NULL? Many thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Help with an UPDATE query please
Presuming you have the date in your PHP code you could simply add 172800 (seconds in 2 days) to the current value and insert it in the same way as you are doing with your current dates. If you post how you're inserting your dates, what format you're using and stuff like that then you'll probably get more concise help. Shaun wrote: Hi, I have (among others) two DATE columns in a table; Booking_Date and Booking_Completion_Date. How can I run a query that updates Booking_Completion_Date to be 2 days after Booking_Date where Booking_Completion_Date is NULL? Many thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Help with an UPDATE query please
Hi, I have (among others) two DATE columns in a table; Booking_Date and Booking_Completion_Date. How can I run a query that updates Booking_Completion_Date to be 2 days after Booking_Date where Booking_Completion_Date is NULL? Many thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php