Re: [sqlite] New to SQLite...............2....3..4 Thank you

[Witold Czarnecki]

You should read SQLite docs: http://www.sqlite.org/docs.html and faq: 
http://www.sqlite.org/faq.html . TCL interface to SQLite is documented here: 
http://www.sqlite.org/tclsqlite.html

I hope it will help to start.
Best regards,
Witold
----- Original Message ----- 
From: "Jan Ekström" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, February 23, 2005 9:56 PM
Subject: Re: [sqlite] New to SQLite...............2....3..4 Thank you


Thank you for that. I like what I am reading there. Still, TCL is 
mentioned together with SQLite. Is TCL an alternative to look into?
Best regards
Jan

----- Original Message ----- 
From: "Witold Czarnecki" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:45 PM
Subject: Re: [sqlite] New to SQLite...............2....3


There is good PHP/SQLite introduction here: 
http://www.zend.com/php5/abs/php101-9.php

Best regards,
Witold
----- Original Message ----- 
From: "Jan Ekström" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:36 PM
Subject: Re: [sqlite] New to SQLite...............2....3


Is the code below the best way of making programs with SQLite?
I don't want to use a command window.
As you see I am new to SQLite.
Not too knew I hope.
jan
<?php
$db = sqlite_open("litetest.db")or
die("Gick inte att skapa filen!");
echo "Det gick finfint!<br>";
/*  sqlite_query($db,"CREATE TABLE exempel(fornamn char(20), efternamn 
char(20), alder int)");   */

sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Kalle','Anka', 40)");
sqlite_query($db,"INSERT INTO exempel(fornamn , efternamn , alder) 
VALUES('Mårten',' Gås ', 32)");

$res = sqlite_query($db, "SELECT fornamn, efternamn, alder from 
exempel");
while ($row = sqlite_fetch_array($res)) {
echo "rad:$row[fornamn]-> $row[efternamn]-> $row[alder]<br>";
}

?>

----- Original Message ----- 
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 4:18 PM
Subject: Re: [sqlite] New to SQLite...............2


Hi Jan,
Jan Ekström wrote:
I am using Windows Home Edition.
I think the SQLite cammand shell is the same as windows command shell.
The SQLite command shell is the sqlite.exe or sqlite3.exe file that you 
can download from the "Precompiled Binaries for Windows" section of the 
SQLite download page:

http://www.sqlite.org/download.html
HTH
Ulrik Petersen