php-general Digest 2 Aug 2013 21:04:10 -0000 Issue 8318 Topics (messages 321757 through 321771):
How to delete 3 months old records in my database? 321757 by: Karl-Arne Gjersøyen 321758 by: DuÅ¡an NovakoviÄ 321759 by: Simon Griffiths 321760 by: Karl-Arne Gjersøyen 321761 by: Simon Schick 321762 by: DuÅ¡an NovakoviÄ 321764 by: Jim Giner Re: Sending headers to server 321763 by: Matijn Woudt 321765 by: Miguel Guedes 321766 by: Karim Geiger 321767 by: Miguel Guedes 321768 by: Karim Geiger 321769 by: Miguel Guedes OT - Internet Troubles? 321770 by: dealTek Just passing this along: Free Book 321771 by: Tamara Temple Administrivia: To subscribe to the digest, e-mail: php-general-digest-subscr...@lists.php.net To unsubscribe from the digest, e-mail: php-general-digest-unsubscr...@lists.php.net To post to the list, e-mail: php-gene...@lists.php.net ----------------------------------------------------------------------
--- Begin Message ---Hello again, folks! I wish to delete records in my database that is older than 3 months. $todays_date = date('Y-m-d'); $old_records_to_delete = ??? if($old_records_to_delete){ include(connect.php); $sql = "DELETE FROM table WHERE date >= '$old_records_to_delete'"; mysql_query($sql, $connect_db) or die(mysql_error()); } Thank you very much for your help to understand also this question :) Karl
--- End Message ---
--- Begin Message ---$query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() - INTERVAL 3 MONTH AND NOW()" On Fri, Aug 2, 2013 at 12:58 PM, Karl-Arne Gjersøyen <karlar...@gmail.com>wrote: > Hello again, folks! > I wish to delete records in my database that is older than 3 months. > > $todays_date = date('Y-m-d'); > $old_records_to_delete = ??? > > if($old_records_to_delete){ > include(connect.php); > $sql = "DELETE FROM table WHERE date >= '$old_records_to_delete'"; > mysql_query($sql, $connect_db) or die(mysql_error()); > } > > Thank you very much for your help to understand also this question :) > > Karl > -- mob: + 46 7 230 230 19 web: http://novakovicdusan.com Please consider the environment before printing this email.
--- End Message ---
--- Begin Message ---Hello, Try something like: $oldDate = new DateTime(); $oldDate->sub(new DateInterval('P3M')); $old_records_to_delete = $oldDate->format('Y-m-d'); Hope this helps, Si Sent from my iPhone On 2 Aug 2013, at 11:58, Karl-Arne Gjersøyen <karlar...@gmail.com> wrote: > Hello again, folks! > I wish to delete records in my database that is older than 3 months. > > $todays_date = date('Y-m-d'); > $old_records_to_delete = ??? > > if($old_records_to_delete){ > include(connect.php); > $sql = "DELETE FROM table WHERE date >= '$old_records_to_delete'"; > mysql_query($sql, $connect_db) or die(mysql_error()); > } > > Thank you very much for your help to understand also this question :) > > Karl
--- End Message ---
--- Begin Message ---2013/8/2 Dušan Novaković <ndu...@gmail.com> > $query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() - > INTERVAL 3 MONTH AND NOW()" > This delete everything from now and 3months backwards. I want to store 3 months from now and delete OLDER than 3 months old records. Karl
--- End Message ---
--- Begin Message ---On Fri, Aug 2, 2013 at 2:02 PM, Karl-Arne Gjersøyen <karlar...@gmail.com> wrote: > > 2013/8/2 Dušan Novaković <ndu...@gmail.com> > > > $query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() - > > INTERVAL 3 MONTH AND NOW()" > > > > This delete everything from now and 3months backwards. I want to store 3 > months from now and delete OLDER than 3 months old records. > > Karl Hi, Karl You're right, but restructuring, to get it the way you want, isn't be that hard, is it? :) $query = "DELETE FROM `__table_name__` WHERE `__date__` < NOW() - INTERVAL 3 MONTH" @Dusan, Btw: What is "DELECT"? I assume it should've been "DELETE", right? Bye Simon
--- End Message ---
--- Begin Message ---Yeah, just spelling mistake :-) And yes, it should be: $query = "DELETE FROM `__table_name__` WHERE `__date__` <= NOW() - INTERVAL 3 MONTH" Cheers ;-) On Fri, Aug 2, 2013 at 2:35 PM, Simon Schick <simonsimc...@gmail.com> wrote: > On Fri, Aug 2, 2013 at 2:02 PM, Karl-Arne Gjersøyen <karlar...@gmail.com> > wrote: > > > > 2013/8/2 Dušan Novaković <ndu...@gmail.com> > > > > > $query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() - > > > INTERVAL 3 MONTH AND NOW()" > > > > > > > This delete everything from now and 3months backwards. I want to store 3 > > months from now and delete OLDER than 3 months old records. > > > > Karl > > Hi, Karl > > You're right, but restructuring, to get it the way you want, isn't be > that hard, is it? :) > > $query = "DELETE FROM `__table_name__` WHERE `__date__` < NOW() - > INTERVAL 3 MONTH" > > @Dusan, > Btw: What is "DELECT"? I assume it should've been "DELETE", right? > > Bye > Simon > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- mob: + 46 7 230 230 19 web: http://novakovicdusan.com Please consider the environment before printing this email.
--- End Message ---
--- Begin Message ---On 8/2/2013 6:58 AM, Karl-Arne Gjersøyen wrote:Hello again, folks! I wish to delete records in my database that is older than 3 months. $todays_date = date('Y-m-d'); $old_records_to_delete = ??? if($old_records_to_delete){ include(connect.php); $sql = "DELETE FROM table WHERE date >= '$old_records_to_delete'"; mysql_query($sql, $connect_db) or die(mysql_error()); } Thank you very much for your help to understand also this question :) KarlSo close! BUT - you need to reverse your test. where date <= '$old_records_to_delete'
--- End Message ---
--- Begin Message ---On Thu, Aug 1, 2013 at 4:04 PM, Miguel Guedes <miguel.a.gue...@gmail.com>wrote: > Hello List, > > > I'm running PHP 5.4.9 as CGI (via apache 2.2.22) and can't seem to be > able to send headers to the server. > > Both, > > header('Status: 500 Internal Server Error'); > > and, > > header('HTTP/1.1 500 Internal Server Error', true, 500); > > result in nothing happening on the client side. > > What am I missing? > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Did you print some data before using header? - Matijn
--- End Message ---
--- Begin Message ---On 02/08/13 14:10, Matijn Woudt wrote:Did you print some data before using header?No, not at all. I've PHP configured to complain about notices, warnings and errors; would've got a warning about headers already sent, which I don't get.
--- End Message ---
--- Begin Message ---Hi Miguel, On 08/02/2013 10:50 AM, Miguel Guedes wrote: > Hi Karim, > > On 01/08/13 15:40, Karim Geiger wrote: >> >> Works for me. What happens exactly? Do you get a 200? >> > > That's exactly right - I always get a 200. How can I diagnose this? > Try getting the complete header by using curl -v http://url.com and paste it here. In my example I'm getting this output: * About to connect() to ****** port 80 (#0) * Trying 213.***.***.***... * Connected to ****** (213.***.***.***) port 80 (#0) > GET /test.php HTTP/1.1 > User-Agent: curl/7.29.0 > Host: ****** > Accept: */* > < HTTP/1.1 500 Internal Server Error < Date: Fri, 02 Aug 2013 14:27:15 GMT < Server: Apache < Content-Length: 6 < Connection: close < Content-Type: text/html; charset=UTF-8 < * Closing connection 0 What is your output? Regards Karim -- Karim Geiger Auszubildender Fachinformatiker AE B1 Systems GmbH Osterfeldstraße 7 / 85088 Vohburg / http://www.b1-systems.de GF: Ralph Dehner / Unternehmenssitz: Vohburg / AG: Ingolstadt,HRB 3537signature.asc
Description: OpenPGP digital signature
--- End Message ---
--- Begin Message ---Great tip, Karim! On 02/08/13 15:29, Karim Geiger wrote:Try getting the complete header by using curl -v http://url.com and paste it here. What is your output?Here's my output: $ curl -v http://localhost/header-test.php * About to connect() to localhost port 80 (#0) * Trying 127.0.0.1... * Connected to localhost (127.0.0.1) port 80 (#0) > GET /header-test.php HTTP/1.1 > User-Agent: curl/7.29.0 > Host: localhost > Accept: */* > < HTTP/1.1 200 OK < Date: Fri, 02 Aug 2013 14:32:47 GMT < Server: Apache/2.2.22 (Ubuntu) < X-Powered-By: PHP/5.4.9-4ubuntu2.2 < Status: 500 Internal Server Error < Vary: Accept-Encoding < Content-Length: 0 < Content-Type: text/html < * Connection #0 to host localhost left intact Using the following test script: <?php header('Status: 500 Internal Server Error'); header('HTTP/1.1 500 Internal Server Error', true, 500); ?>
--- End Message ---
--- Begin Message ---Hi Miguel, On 08/02/2013 04:34 PM, Miguel Guedes wrote: > > Here's my output: > > $ curl -v http://localhost/header-test.php > * About to connect() to localhost port 80 (#0) > * Trying 127.0.0.1... > * Connected to localhost (127.0.0.1) port 80 (#0) >> GET /header-test.php HTTP/1.1 >> User-Agent: curl/7.29.0 >> Host: localhost >> Accept: */* >> > < HTTP/1.1 200 OK > < Date: Fri, 02 Aug 2013 14:32:47 GMT > < Server: Apache/2.2.22 (Ubuntu) > < X-Powered-By: PHP/5.4.9-4ubuntu2.2 > < Status: 500 Internal Server Error > < Vary: Accept-Encoding > < Content-Length: 0 > < Content-Type: text/html > < > * Connection #0 to host localhost left intact > > Using the following test script: > > <?php > > header('Status: 500 Internal Server Error'); > header('HTTP/1.1 500 Internal Server Error', true, 500); > > ?> allright, that's weird. I'm currently not able to reproduce your problem but I've found out that some others are experiencing the same problem like you do. They found this solution to work: header($_SERVER["SERVER_PROTOCOL"] . 'HTTP/1.1 500 Internal Server Error'); Might try this one.. Regards Karim -- Karim Geiger Auszubildender Fachinformatiker AE B1 Systems GmbH Osterfeldstraße 7 / 85088 Vohburg / http://www.b1-systems.de GF: Ralph Dehner / Unternehmenssitz: Vohburg / AG: Ingolstadt,HRB 3537signature.asc
Description: OpenPGP digital signature
--- End Message ---
--- Begin Message --- This is strange. I've just found out that the headers are sent correctly if I access the website outside of localhost. I don't understand why.
--- End Message ---
--- Begin Message ---OT Anyone having internet troubles? (also seems to be login database issues too at various places) like... http://forums.adobe.com/community/dreamweaver and try to sign in on upper right i get this We're sorry, the site area you've requested is unavailable. Please try again later. and - go to - http://bluehost.com and try LIVE CHAT in mid page and it also fails... i get Our chat service is currently undergoing maintenance and will be back online shortly. Call us (888) 401-4678 or open a ticket if you need further assistance. and other issues too like also http://www.downdetector.com/status/time-warner-cable/los-angeles Time Warner Cable Los Angeles reports ugh! #twc #timewarnercable connectivity issues again, and apparently it's effecting a lot of work from home coworkers..get it fixed!! — (@BloodBought3) 2013-08-02 07:37:59 -- Thanks, Dave - DealTek deal...@gmail.com [db-3]
--- End Message ---
--- Begin Message ---O'Reilly has a free download, apparently through a company called SAVVIS. No affiliation, just passing this along… http://go.savvis.net/paas You give them some contact info, and you get a download link. Nothing is actually checked to see if the info you fill in is real or not. (cross-posted: ruby-talk, rubyonrails-talk, php-general)
--- End Message ---