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
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.
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
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
> -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
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') . "'
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);
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
>>
&
> -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
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
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);';
>
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
> -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
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
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
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
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
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
>
On Thu, May 10, 2007 2:55 pm, [EMAIL PROTECTED] wrote:
> Hello,
>
> I have a loop on an sqlite query which checks $domain until the status
> of
> $domain changes and then it deletes $domain.
>
> However when all the $domain items have been deleted I need the script
> to
> stop.. regardless of how
[EMAIL PROTECTED] wrote:
> Hello,
>
> I want to select two dates one being todays date and the
> other being -00-00 which just a date in the database when
> no proper date has been entered.
>
> Ive tried this but it does not work...
>
> $today = date('Y-m-d');
> $result = sqlite_query($db, "
Thanks Richard.
- Original Message -
From: "Richard Lynch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, May 09, 2007 1:49 AM
Subject: Re: [PHP] sqlite AND OR query ?
On Tue, May 8, 2007 7:09 pm, [EMAIL PROTECTED] wrote:
I want to sele
On Tue, May 8, 2007 7:09 pm, [EMAIL PROTECTED] wrote:
> I want to select two dates one being todays date and the other being
> -00-00 which just a date
> in the database when no proper date has been entered.
>
> Ive tried this but it does not work...
>
> $today = date('Y-m-d');
> $result = sqli
Many thanks.
Several good points you made.
I should recompile rather than use just any old binary. I found it on
the net.
I wasn't clear how to tell the php.ini how to interpret the extension.
I can't to run command lines on the host, so its a bit of a bother to
compile stuff there. I've ha
* Thus wrote Al ([EMAIL PROTECTED]):
> I've got a website on an Apache virtual host and would like to install
> the SQLite library.
>
> Can someone give me a brief outline of what I need to do or point me to
> a good writeup?
some info on sqlite:
http://php.net/sqlite
You can compile and ins
DAvid Jackson wrote:
Howdy --
SQLite supported by a direct call the sqlite library?
As apposed to calling the executable?
Could I use ini_set(include_path=) to tall PHP where the SQLite lib is
located?
TIA,
David
I have never worked with SQLite but I bet you cannot.
1. the library is linked at
* Thus wrote Bronislav Kluèka ([EMAIL PROTECTED]):
> Hi, I've got questions:
>
> I've got sqlite like PHP module (under windows). I tried this:
> a)execute script 1 (selecting from some table), it tooks 2 minutes
> b)execute script 2 , it tooks 3 minutes
> c)execute them both at
That's my code:
$dbfile="db.sdb";
$db=sqlite_open($dbfile);
$res=sqlite_query($db,"select a.*,b.* from a left join b on a.id=b.id_a
where a.name like \"%1%\" or b.street like \"%1%\" order by cellphone");
echo sqlite_num_rows($res).CRLF;
sqlite_close($db);
It's realy just "benchmark" I've done. I'
--- Bronislav_Kluèka <[EMAIL PROTECTED]> wrote:
> Hi, I've got questions:
I only noticed one.
> I've got sqlite like PHP module (under windows). I tried this:
> a)execute script 1 (selecting from some table), it tooks 2 minutes
> b)execute script 2 , it tooks 3 minutes
> c)execute them both at th
On Sun, 24 Aug 2003 14:44:19 +1000
Kevin Waterson <[EMAIL PROTECTED]> wrote:
> This one time, at band camp, andu <[EMAIL PROTECTED]> wrote:
>
> > $command="sqlite db_name '.dump'";
> > exec($command,$result);
> > print_r( $result);// shows the dump array
>
> As sqlite is bundled with php5, I gu
This one time, at band camp, andu <[EMAIL PROTECTED]> wrote:
> $command="sqlite db_name '.dump'";
> exec($command,$result);
> print_r( $result);// shows the dump array
As sqlite is bundled with php5, I guess command line type commands
are not available because it is compiled in.
Kevin
--
__
On Sun, 24 Aug 2003 13:09:55 +1000
Kevin Waterson <[EMAIL PROTECTED]> wrote:
> I am writing an admin for sqlite but have struck a
> problem with exporting data. I wish to simply
> get a dump of the current sql database. from
> the commandline this would be done with .dump
> however this causes a
31 matches
Mail list logo
