Re: SqLite INSERT want not write
| From: | Silvio Siefke | Date: | Thu, 19 Apr 2012 19:11:22 +0000 |
| Subject: | Re: SqLite INSERT want not write | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-317630@lists.php.net to get a copy of this message | ||
On Thu, 19 Apr 2012 14:57:04 -0400
"Steven Staples" <sstaples@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,
> :teaser, :content);';
>
> To this:
> $sql = "INSERT INTO bloggen (date, autor, title, teaser, content)
> VALUES ('' . date( 'Y-m-s H:i:s', time() ) . '', :autor,
> :title,
> :teaser, :content);";
Thats end with:
PDOException: SQLSTATE[HY000]: General error: 1 near "(": syntax error
I has changed what say Stuart, no Sytax errors but in the database nothing
will write.
Regards
Silvio