Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Stuart Dallas
On 19 Apr 2012, at 18:31, Silvio Siefke wrote: i have a script which should write articles in a Sqlite 0database. The script runs without errors, but nothing is written to the database. The Script: http://nopaste.info/09e68c7e37.html The db.php: http://nopaste.info/afd4dee47a.html The

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Silvio Siefke
Hello, On Thu, 19 Apr 2012 18:39:00 +0100 Stuart Dallas stu...@3ft9.com wrote: The script has syntax errors in it. You won't see those errors because PHP won't run a script with syntax errors, so it won't modify the error_reporting and display_errors settings. You can run php -l

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Stuart Dallas
On 19 Apr 2012, at 18:54, Silvio Siefke wrote: On Thu, 19 Apr 2012 18:39:00 +0100 Stuart Dallas stu...@3ft9.com wrote: The script has syntax errors in it. You won't see those errors because PHP won't run a script with syntax errors, so it won't modify the error_reporting and

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread tamouse mailing lists
Maybe this will make the syntax errors stand out more: http://dl.dropbox.com/u/571329/Screenshots/Picture%209.png -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Silvio Siefke
Hello, On Thu, 19 Apr 2012 13:21:46 -0500 tamouse mailing lists tamouse.li...@gmail.com wrote: Maybe this will make the syntax errors stand out more: http://dl.dropbox.com/u/571329/Screenshots/Picture%209.png ok i have change it to the function date, but now i has the error message:

RE: [PHP] SqLite INSERT want not write

2012-04-19 Thread Steven Staples
-Original Message- From: Silvio Siefke [mailto:siefke_lis...@web.de] Sent: April 19, 2012 2:53 PM To: php-general@lists.php.net Subject: Re: [PHP] SqLite INSERT want not write Hello, On Thu, 19 Apr 2012 13:21:46 -0500 tamouse mailing lists tamouse.li...@gmail.com wrote

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Stuart Dallas
On 19 Apr 2012, at 19:52, Silvio Siefke wrote: On Thu, 19 Apr 2012 13:21:46 -0500 tamouse mailing lists tamouse.li...@gmail.com wrote: Maybe this will make the syntax errors stand out more: http://dl.dropbox.com/u/571329/Screenshots/Picture%209.png ok i have change it to the function

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Stuart Dallas
On 19 Apr 2012, at 19:57, Steven Staples wrote: I think all you had to do was change this line: (line 27 in the original paste) $sql = 'INSERT INTO bloggen (date, autor, title, teaser, content) VALUES ('' . date( 'Y-m-s H:i:s', time() ) . '', :autor, :title, :teaser, :content);'; To

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Silvio Siefke
On Thu, 19 Apr 2012 14:57:04 -0400 Steven Staples sstap...@mnsi.net wrote: I think all you had to do was change this line: (line 27 in the original paste) $sql = 'INSERT INTO bloggen (date, autor, title, teaser, content) VALUES ('' . date( 'Y-m-s H:i:s', time() ) . '', :autor, :title,

RE: [PHP] SqLite INSERT want not write

2012-04-19 Thread Steven Staples
-Original Message- From: Silvio Siefke [mailto:siefke_lis...@web.de] Sent: April 19, 2012 3:11 PM To: php-general@lists.php.net Subject: Re: [PHP] SqLite INSERT want not write On Thu, 19 Apr 2012 14:57:04 -0400 Steven Staples sstap...@mnsi.net wrote: I think all you had to do

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread tamouse mailing lists
On Thu, Apr 19, 2012 at 2:17 PM, Steven Staples sstap...@mnsi.net wrote: -Original Message- From: Silvio Siefke [mailto:siefke_lis...@web.de] Sent: April 19, 2012 3:11 PM To: php-general@lists.php.net Subject: Re: [PHP] SqLite INSERT want not write On Thu, 19 Apr 2012 14:57:04 -0400

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread siefke_lis...@web.de
Hello, On Thu, 19 Apr 2012 15:17:06 -0400 Steven Staples sstap...@mnsi.net wrote: Ok, so I was wrong... ;) it does happen Try this: $sql = INSERT INTO bloggen (date, autor, title, teaser, content) VALUES (' . date('Y-m-d H:i:s') . ', :autor, :title, :teaser,

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Stuart Dallas
On 19 Apr 2012, at 20:40, siefke_lis...@web.de wrote: On Thu, 19 Apr 2012 15:17:06 -0400 Steven Staples sstap...@mnsi.net wrote: Ok, so I was wrong... ;) it does happen Try this: $sql = INSERT INTO bloggen (date, autor, title, teaser, content) VALUES (' . date('Y-m-d H:i:s') .

RE: [PHP] SqLite INSERT want not write

2012-04-19 Thread Steven Staples
-Original Message- From: siefke_lis...@web.de [mailto:siefke_lis...@web.de] Sent: April 19, 2012 3:40 PM To: php-general@lists.php.net Subject: Re: [PHP] SqLite INSERT want not write Hello, On Thu, 19 Apr 2012 15:17:06 -0400 Steven Staples sstap...@mnsi.net wrote

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Silvio Siefke
Hello, On Thu, 19 Apr 2012 20:43:52 +0100 Stuart Dallas stu...@3ft9.com wrote: On 19 Apr 2012, at 20:40, siefke_lis...@web.de wrote: On Thu, 19 Apr 2012 15:17:06 -0400 Steven Staples sstap...@mnsi.net wrote: What does the script output? The only path through your script that doesn't

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Tommy Pham
On Thu, Apr 19, 2012 at 12:40 PM, siefke_lis...@web.de siefke_lis...@web.de wrote:                Hello, On Thu, 19 Apr 2012 15:17:06 -0400 Steven Staples sstap...@mnsi.net wrote: Ok, so I was wrong... ;)   it does happen Try this: $sql = INSERT INTO bloggen (date, autor, title, teaser,

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Silvio Siefke
On Thu, 19 Apr 2012 13:00:40 -0700 Tommy Pham tommy...@gmail.com wrote: Technically, it's date('now') per [1] :) RTFM FTW! Yes its right, i have read it on sqlite.org. PS: Excuse me, what mean RTFM FTW? Regards Silvio -- PHP General Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Bastien
Bastien Koert On 2012-04-19, at 4:11 PM, Silvio Siefke siefke_lis...@web.de wrote: On Thu, 19 Apr 2012 13:00:40 -0700 Tommy Pham tommy...@gmail.com wrote: Technically, it's date('now') per [1] :) RTFM FTW! Yes its right, i have read it on sqlite.org. PS: Excuse me, what mean RTFM