[PHP] something about dates in mysql

2011-03-03 Thread Webforlaget.dk
I need help to know Why this dont work ? - $thisdate =date(Y-m-d,mktime(0,0,0,$mth, $day, $year)); $sql = SELECT id,case,startdate,enddate FROM table WHERE startdate=$thisdate AND enddate=$thisdate ORDER BY startdate;

Re: [PHP] something about dates in mysql

2011-03-03 Thread Richard Quadling
On 3 March 2011 10:09, Webforlaget.dk i...@web-forlaget.dk wrote: I need help to know Why this dont work ? -  $thisdate =date(Y-m-d,mktime(0,0,0,$mth, $day, $year));  $sql  = SELECT id,case,startdate,enddate FROM table WHERE

Re: [PHP] something about dates in mysql

2011-03-03 Thread Nathan Rixham
Richard Quadling wrote: On 3 March 2011 10:09, Webforlaget.dk i...@web-forlaget.dk wrote: I need help to know Why this dont work ? - $thisdate =date(Y-m-d,mktime(0,0,0,$mth, $day, $year)); $sql = SELECT id,case,startdate,enddate

Re: [PHP] something about dates in mysql

2011-03-03 Thread Alex
Just a correction, dates in mysql are not strings by any means, they are stored in 3 bytes (date and time or 8 bytes for datetime) and that's nowhere enough for a string, however the representation of the date is a formatted string, so for all intents and purposes any comparison to a date field

Re: [PHP] something about dates in mysql

2011-03-03 Thread Gerardo Benitez
Hi Webforlaget! $thisdate is today? $today = date('Y-m-d); else why, you dont use $thisdate as: $thisdate = $year-$mth-$day ? use quotes for $thisdate in sql query. Regards. Gerardo On Thu, Mar 3, 2011 at 7:09 AM, Webforlaget.dk i...@web-forlaget.dk wrote: I need help to know Why this

Re: [PHP] something about dates in mysql

2011-03-03 Thread Richard Quadling
On 3 March 2011 12:33, Alex niks...@gmail.com wrote: Just a correction, dates in mysql are not strings by any means, they are stored in 3 bytes (date and time or 8 bytes for datetime) and that's nowhere enough for a string, however the representation of the date is a formatted string, so

[PHP] PHP 5.3.6RC2 Released for Testing

2011-03-03 Thread Johannes Schlüter
The second release candidates of 5.3.6 was just released for testing and can be downloaded here: http://downloads.php.net/johannes/php-5.3.6RC2.tar.bz2 (md5sum: f870685b8715600e056d2dbb22920576) http://downloads.php.net/johannes/php-5.3.6RC2.tar.gz (md5sum: 32e88f8a2dd1e756d386b7fe625c7e8b) The

[PHP] Delaying $(document).ready() in jQuery until php script finish

2011-03-03 Thread Richard Sharp
I have been banging my head trying to figure out how to delay $(document).ready() command until my php script finish running and load data into a csv file. Any ideas Thanks Richard Sharp Database Administrator PH: 316-942-8604 ext 108 Tenderness is what love looks like in private,

Re: [PHP] Delaying $(document).ready() in jQuery until php script finish

2011-03-03 Thread Daniel Brown
On Thu, Mar 3, 2011 at 09:52, Richard Sharp rsh...@aerotecheng.org wrote: I have been banging my head trying to figure out how to delay $(document).ready() command until my php script finish running and load data into a csv file.  Any ideas Just one: ask on a jQuery list. Just because PHP

RE: [PHP] Delaying $(document).ready() in jQuery until php script finish

2011-03-03 Thread Jay Blanchard
[snip] Just one: ask on a jQuery list. Just because PHP is running somewhere in the mix doesn't mean it's appropriate for this list. [/snip] Agreed. The list for jQuery is http://forum.jquery.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP] Delaying $(document).ready() in jQuery until php script finish

2011-03-03 Thread HallMarc Websites
Maybe I misread this and it seems to me he is asking how they could trigger the jQuery event after the necessary PHP script is called. Maybe it is being over-thought, have you tried placing the javascript call after the PHP script? Maybe wrap it in a conditional statement that isn't satisfied

RE: [PHP] Delaying $(document).ready() in jQuery until php script finish

2011-03-03 Thread Steve Staples
On Thu, 2011-03-03 at 10:42 -0500, HallMarc Websites wrote: Maybe I misread this and it seems to me he is asking how they could trigger the jQuery event after the necessary PHP script is called. Maybe it is being over-thought, have you tried placing the javascript call after the PHP script?

RE: [PHP] Delaying $(document).ready() in jQuery until php script finish

2011-03-03 Thread HallMarc Websites
-Original Message- From: Steve Staples [mailto:sstap...@mnsi.net] Sent: Thursday, March 03, 2011 11:00 AM To: php-general@lists.php.net Subject: RE: [PHP] Delaying $(document).ready() in jQuery until php script finish On Thu, 2011-03-03 at 10:42 -0500, HallMarc Websites wrote: Maybe

RE: [PHP] Delaying $(document).ready() in jQuery until php script finish OT

2011-03-03 Thread Jay Blanchard
[snip] What I don't get about the question is, is the document.ready() shouldn't fire, until the page has completely loaded, and if the PHP script is still running, the document shouldn't be ready yet, should it? [/snip] The document ready function fires once the DOM is loaded - which might not

RE: [PHP] Delaying $(document).ready() in jQuery until php script finish OT

2011-03-03 Thread Ashley Sheridan
Jay Blanchard jblanch...@pocket.com wrote: [snip] What I don't get about the question is, is the document.ready() shouldn't fire, until the page has completely loaded, and if the PHP script is still running, the document shouldn't be ready yet, should it? [/snip] The document ready function

Re: [PHP] Delaying $(document).ready() in jQuery until php script finish OT

2011-03-03 Thread Richard Quadling
On 3 March 2011 17:25, Ashley Sheridan a...@ashleysheridan.co.uk wrote: Jay Blanchard jblanch...@pocket.com wrote: [snip] What I don't get about the question is, is the document.ready() shouldn't fire, until the page has completely loaded, and if the PHP script is still running, the document

[PHP] Somewhat OT - Stored Procedures

2011-03-03 Thread Nathan Nobbe
Hey gang, (Yes Tedd, I like your style, when it pertains to how you address the list :)) I have a new curiosity that's arisen as a result of a new contract I'm working on, I'd like to bounce around some thoughts off the list and see what you folks think if interested. The topic at hand is

Re: [PHP] Help! Made a boo-boo encrypting credit cards

2011-03-03 Thread Brian Dunning
My merchant provider levies monthly fines based on how many of their security restrictions you fail to follow. I follow as many as are reasonably practical, but I think it's virtually impossible to follow them all, such as absurdly expensive (and probably unnecessary) hardware. IMHO, some of

Re: [PHP] Help! Made a boo-boo encrypting credit cards

2011-03-03 Thread Brian Dunning
That's a great suggestion. I will try this and report back. It's also been suggested to me that I should have base64_encoded the encryptions before storing them in MySQL, so I'll try this option at the same time. On Mar 1, 2011, at 2:04 PM, Ashley Sheridan wrote: Onto the problem of the data

Re: [PHP] Somewhat OT - Stored Procedures

2011-03-03 Thread Steve Staples
On Thu, 2011-03-03 at 11:30 -0700, Nathan Nobbe wrote: Hey gang, (Yes Tedd, I like your style, when it pertains to how you address the list :)) I have a new curiosity that's arisen as a result of a new contract I'm working on, I'd like to bounce around some thoughts off the list and see

RE: [PHP] Help! Made a boo-boo encrypting credit cards

2011-03-03 Thread Bob McConnell
From: Brian Dunning My merchant provider levies monthly fines based on how many of their security restrictions you fail to follow. I follow as many as are reasonably practical, but I think it's virtually impossible to follow them all, such as absurdly expensive (and probably unnecessary)

Re: [PHP] Somewhat OT - Stored Procedures

2011-03-03 Thread Paul M Foster
On Thu, Mar 03, 2011 at 11:30:49AM -0700, Nathan Nobbe wrote: Hey gang, (Yes Tedd, I like your style, when it pertains to how you address the list :)) I have a new curiosity that's arisen as a result of a new contract I'm working on, I'd like to bounce around some thoughts off the list

[PHP] Check for open file

2011-03-03 Thread Ashley M. Kirchner
Is there a clean or reliable way of checking to see if a file is still being written to before doing anything with it? Here's the scenario: we have a Samba share that we can copy files to (from within Windows or Macs). The server picks up the file and does

RE: [PHP] Check for open file

2011-03-03 Thread Bob McConnell
From: Ashley M. Kirchner Is there a clean or reliable way of checking to see if a file is still being written to before doing anything with it? Here's the scenario: we have a Samba share that we can copy files to (from within Windows or Macs). The server picks up the file and does some

RE: [PHP] Check for open file

2011-03-03 Thread Ashley M. Kirchner
Write the file with a temporary name and extension. Once the file is closed, change the name to the pattern your server is looking for. Once you finish processing it, either change the name again, or move it to a different directory. Don't reuse the same file name, but add a numeric value

RE: [PHP] Check for open file

2011-03-03 Thread Steve Staples
On Thu, 2011-03-03 at 13:23 -0700, Ashley M. Kirchner wrote: Write the file with a temporary name and extension. Once the file is closed, change the name to the pattern your server is looking for. Once you finish processing it, either change the name again, or move it to a different

Re: [PHP] Somewhat OT - Stored Procedures

2011-03-03 Thread Nathan Nobbe
On Thu, Mar 3, 2011 at 12:23 PM, Steve Staples sstap...@mnsi.net wrote: On Thu, 2011-03-03 at 11:30 -0700, Nathan Nobbe wrote: Hey gang, (Yes Tedd, I like your style, when it pertains to how you address the list :)) I have a new curiosity that's arisen as a result of a new contract

RE: [PHP] Check for open file

2011-03-03 Thread Ashley Sheridan
On Thu, 2011-03-03 at 15:29 -0500, Steve Staples wrote: On Thu, 2011-03-03 at 13:23 -0700, Ashley M. Kirchner wrote: Write the file with a temporary name and extension. Once the file is closed, change the name to the pattern your server is looking for. Once you finish processing it,

Re: [PHP] Somewhat OT - Stored Procedures

2011-03-03 Thread Nathan Nobbe
On Thu, Mar 3, 2011 at 12:59 PM, Paul M Foster pa...@quillandmouse.comwrote: On Thu, Mar 03, 2011 at 11:30:49AM -0700, Nathan Nobbe wrote: Hey gang, (Yes Tedd, I like your style, when it pertains to how you address the list :)) I have a new curiosity that's arisen as a result of a

RE: [PHP] Check for open file

2011-03-03 Thread Ashley M. Kirchner
As far as I was aware, if you're in the middle of writing to a file and another script was attempting to write to it, the OS would prevent that as you had an open lock on it. -- Thanks, Ash http://www.ashleysheridan.co.uk I guess I would have to test that. -- PHP General

Re: [PHP] something about dates in mysql

2011-03-03 Thread Webforlaget.dk
In this case $mth, $day, $year is userinput that needs to be validated before use. thanks for all help, the quotes proved helpfull Med venlig hilsen Rolf Brejner Web-forlaget.dk - Original Message - From: Richard Quadling rquadl...@gmail.com To: Alex niks...@gmail.com Cc:

[PHP] Overriding session length in existing session?

2011-03-03 Thread Scott Baker
I have a global header.php file that sets up a bunch of stuff: DB, global variables, and does session_start(). My header.php looks like this: #header.php $cookie_life = (86400 * 7); // Cookies last for seven days session_set_cookie_params($cookie_life,/,.domain.com,true); session_start(); This

Re: [PHP] executing external php script

2011-03-03 Thread tedd
At 5:14 PM +0900 3/2/11, ƒAƒ-ƒxƒ-ƒg wrote: hi! what I want to do is execute php script and don't wait for output. found something like this - ?php `php /var/www/secend.php /dev/null 21 `; ? html body text /body /html

Re: [PHP] Overriding session length in existing session?

2011-03-03 Thread tedd
At 2:58 PM -0800 3/3/11, Scott Baker wrote: I have a global header.php file that sets up a bunch of stuff: DB, global variables, and does session_start(). My header.php looks like this: #header.php $cookie_life = (86400 * 7); // Cookies last for seven days

Re: [PHP] Overriding session length in existing session?

2011-03-03 Thread Scott Baker
On 03/03/2011 04:31 PM, tedd wrote: At 2:58 PM -0800 3/3/11, Scott Baker wrote: I have a global header.php file that sets up a bunch of stuff: DB, global variables, and does session_start(). My header.php looks like this: #header.php $cookie_life = (86400 * 7); // Cookies last for seven

Re: RE: [PHP] Check for open file

2011-03-03 Thread Peter Lind
On Mar 4, 2011 4:53 AM, Ashley M. Kirchner ash...@pcraft.com wrote: -Original Message- From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] Sent: Thursday, March 03, 2011 2:03 PM To: sstap...@mnsi.net Cc: php-general@lists.php.net Subject: RE: [PHP] Check for open file