Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Bastien
Bastien Koert On 2012-04-19, at 4:11 PM, Silvio Siefke wrote: > On Thu, 19 Apr 2012 13:00:40 -0700 > Tommy Pham 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? > Read The Fine Manual

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Silvio Siefke
On Thu, 19 Apr 2012 13:00:40 -0700 Tommy Pham 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, visit: http://www.php.

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 wrote: >                Hello, > > On Thu, 19 Apr 2012 15:17:06 -0400 > "Steven Staples" wrote: > >> Ok, so I was wrong... ;)   it does happen >> >> Try this: >> $sql = "INSERT INTO bloggen (date, autor, title, teaser, content) >>        VALU

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 wrote: > On 19 Apr 2012, at 20:40, siefke_lis...@web.de wrote: > > > On Thu, 19 Apr 2012 15:17:06 -0400 > > "Steven Staples" wrote: > What does the script output? The only path through your script that doesn't > display something is if

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 -040

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" 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 siefke_lis...@web.de
Hello, On Thu, 19 Apr 2012 15:17:06 -0400 "Steven Staples" 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, :content);

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 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 >> &

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" wrote: &g

Re: [PHP] SqLite INSERT want not write

2012-04-19 Thread Silvio Siefke
On Thu, 19 Apr 2012 14:57:04 -0400 "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, :c

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);'; >

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 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 n

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 l

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 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: PDOException: SQLSTATE[HY0

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 Stuart Dallas
On 19 Apr 2012, at 18:54, Silvio Siefke wrote: > On Thu, 19 Apr 2012 18:39:00 +0100 > Stuart Dallas 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 sett

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 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 script.php to see t

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 >

[PHP] SqLite INSERT want not write

2012-04-19 Thread Silvio Siefke
Hello, 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 Database file has right 777. Has someone an idea