Re: [PHP] SqLite INSERT want not write

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Re: [PHP] php sqlite

On Sat, Nov 5, 2011 at 3:33 AM, saeed ahmed wrote: > i want to start with php sqlite.which  light weight versions should i > download?i have win xp sp3. > I though sqlite came bundled... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] php sqlite

i want to start with php sqlite.which light weight versions should i download?i have win xp sp3.

Re: [PHP] sqlite if query changes to empty on a loop

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

[PHP] sqlite if query changes to empty on a loop

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 many querys the loop still has to run. So I want to detect when its

RE: [PHP] sqlite AND OR query ?

[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, "

Re: [PHP] sqlite AND OR query ?

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

Re: [PHP] sqlite AND OR query ?

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

[PHP] sqlite AND OR query ?

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, "SELECT * FROM domains WHERE date = '-0

Re: [PHP] php-sqlite W2K install problem

Marlin Unruh wrote: Marlin Unruh wrote: I am tiring to use sqlite which is [quote] bundled with php5 [unquote]. I am missing something somewhere. I modified the php.ini to include the php_extension=php_sqlite.dll. Following is the error I get. [05-Dec-2005 07:40:33] PHP Fatal error: Call to

Re: [PHP] php-sqlite W2K install problem

Marlin Unruh wrote: I am tiring to use sqlite which is [quote] bundled with php5 [unquote]. I am missing something somewhere. I modified the php.ini to include the php_extension=php_sqlite.dll. Following is the error I get. [05-Dec-2005 07:40:33] PHP Fatal error: Call to undefined function s

[PHP] php-sqlite W2K install problem

I am tiring to use sqlite which is [quote] bundled with php5 [unquote]. I am missing something somewhere. I modified the php.ini to include the php_extension=php_sqlite.dll. Following is the error I get. [05-Dec-2005 07:40:33] PHP Fatal error: Call to undefined function sqlite_open() in G:\ap

Re: [PHP] SQLite /how can I install on an Apache virtual host?

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

Re: [PHP] SQLite /how can I install on an Apache virtual host?

* 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

[PHP] SQLite /how can I install on an Apache virtual host?

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? My host makes it tough to run command line code to make files, etc. I've found a a Linux binary [sqlite.so]. And,

Re: [PHP] SQLite Support is library call?

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

[PHP] SQLite Support is library call?

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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] SQLite: getting field information (type etc)

I am trying to port a small database application (php, MySQL) to sqlite. How can I find the type of an arbitrary field? In other words, what is the equivalent of mysql_field_type() and mysql_field_flags() in sqlite? I read something on the sqlite group recently that recommended using pragma_show_

[PHP] [SQLite] safe_mode_gid or safe_mode_exec_dir

I want to be able to use SQLlite on my hosted (virtual) site. SQlite will be placed in my /home/www/bin. And need to be exicutable by Apache user or group? Would either safe_mode_gid or safe_mode_exec_dir accomplish this? TIA, David -- PHP General Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP] SQLITE

* 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

[PHP] RE: [PHP-DB] Re: [PHP] SQLITE

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'

Re: [PHP] SQLITE

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

[PHP] SQLITE

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 the same time (from different browser windows), both of t

[PHP] SQLite

Hi, I was trying to work with SQLite, everything is OK, but it seems not to vork in thread, but in sequences. I mean: I perform a question which tooks 2 minutes, then another, which tooks 3 minutes, then I perform them both from 2 separated browser windows and both of them stops at the same time an

Re: [PHP] sqlite

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

Re: [PHP] sqlite

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

Re: [PHP] sqlite

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

[PHP] sqlite

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 an error when used with sqlite_query() Is there any other method to get a sqlite dump?