Re: SqLite INSERT want not write
| From: | siefke_listen@web.de | Date: | Thu, 19 Apr 2012 19:40:09 +0000 |
| Subject: | Re: SqLite INSERT want not write | ||
| References: | 1 2 3 4 5 6 7 8 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-317633@lists.php.net to get a copy of this message | ||
Hello,
On Thu, 19 Apr 2012 15:17:06 -0400
"Steven Staples" <sstaples@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, :content);";
No errors, but no entry in the database.
> Or
> $sql = "INSERT INTO bloggen (date, autor, title, teaser, content)
> VALUES (NOW(), :autor, :title, :teaser, :content);";
PDOException: SQLSTATE[HY000]: General error: 1 no such function: NOW
Now is not availible in Sqlite, can use date,
Which rights must have the database?
siefke@gentoo-desk db $ ls -l
insgesamt 4
-rw-rw-rw- 1 siefke siefke 4096 19. Apr 21:25 silviosiefke.db
Regards
Silvio