eV/6CwMRUғTPxG\qN;Om3&h.3Cދ?7*7E̦Υ%쥱# T" 6ı}%ndm}7!|pwcP,) 3c[Av>mwOnL71B̡U-fiþB" NgN8 7BK vbv>2D:_6 !nMI+]þ$#}b^P ,Q)w6 e;e%}[s#t緕*C@{>|XؙC`\P|;~8Lcs(:_qBaTR cazVm!|]Լ=-(c Ol[eǟYvEkÌ/ W&tT%VTߵ9q4-L0(v l3cfB 巢yț=rV^<%M2(8/g(+%0}6@j)P<ג'?VPHtBC;e {0 S$]䂵!@ @*Yp\p~畊⹎ Av:8sn[r-nr~,7) 񠀓ݞ(%k, )2Gql3cfB 巢J.mOyN72yUsh\O_ . \/nvPrd-M_?PNsUgݞ`Fhqgg~p陠ZbbOX.W @2ʚ|fC.fej%e J*Pݼ7Nnsmt 8н6Hqj%×C:ǖl&tUЁ1CGRh4p'l[Y n'R4[/t i8hB'B}~,MyAZtJگ:"||eCmoeQn33{B[;x[81_Rb4M! dc] Id_:߫5E.b;a%[A'`)n]/ɥ̱pMCFq b}dN۹,}on -8bIObt=$ŒnjL>ë2 Cq0@x;\^$<d4W%CPxJ66Xdحt/c'ɉg+A _(5,!u?ܣ P8p r37P7.//<׊MB5ٺq:l ]]`y]2ݖDR/MXˀ-ň2HgtχYŁpI~W %.Aw.'}Mx2φ d3:<,Tw}w%ڸAg8d>/IީFLYjjHa∾Ύ:H_/"[ <3H(O*wDR& ;7uBfb+aoNd~.أJ"[Yd<)5VizBm5LMXˀ-ň2y/OkͰmo^g&n2A0Ɂ*YNH_n @1HԢ{*icwKg)8] W㷉#B=wjy6k(J|Ҹl(}oJ~X8XDJcokHʓ1*\8@׸wb{EQXe 0)݁foVqtr f6ğ؛j{2Qow# ~aCmwѢS_@ |) FYʌf62F4U޻ ß"z,PJof4Cj=j8[H6%6.@%3{ƥ3F=dQ' LzBgAVΐ?;l3};jG7|>Cz|KG5}~έbWP=fvwu :k5yMGx3@%c:yS;!'8 D?9H+aYT6jnE-hDǰو }挓GMX}oLK DO$K^9@hƝͫm r8Ԛ-rn3Ұ\vNrw.sqlite.org/datatype3.html">learn more about SQLite’s built-in datatypes here.

CREATE TABLE items (id INTEGER PRIMARY KEY, name TEXT, price REAL);

  • Add some data to the new inventory table using INSERT commands, as shown below:

    INSERT INTO items VALUES ('1001', 'Salt', 3.15);
INSERT INTO items VALUES ('1002', 'Pepper', 2.75);
INSERT INTO items VALUES ('1003', 'Eggs', 2.00);
INSERT INTO items VALUES ('1004', 'Bacon', 7.25);
INSERT INTO items VALUES ('1005', 'Milk', 1.15);
INSERT INTO items VALUES ('1006', 'Strawberries', 8.73);
INSERT INTO items VALUES ('1007', 'Cereal', 2.65);

  • You can now also run a SELECT query on the data. For example, the query below returns all items that cost less than $3:

    SELECT * FROM items WHERE price < 3.00;
    image2

  • Once you’re done using the database, exit it by typing .quit at the sqlite> prompt.

    • The database file (in this example, mydb.sq3) contains all your tables and data, so you should remember to back it up regularly.

    The previous steps discussed how to create and use an SQLite database using the command-line client. However, more often than not, you’ll be using an SQLite database in combination with a PHP-powered Web application. XAMPP includes the PHP SQLite extension, so doing this is not very difficult at all.

    To connect to your SQLite database and execute queries on it with PHP, use your text editor to create an example script named sqlite.php in the htdocs subdirectory of your XAMPP installation directory and fill it with the following code:

    <?php
$db = new SQLite3('mydb.sq3');
$sql = "SELECT * FROM items WHERE price < 3.00";
$result = $db->query($sql);
while ($row = $result->fetchArray(SQLITE3_ASSOC)){
  echo $row['name'] . ': $' . $row['price'] . '<br/>';
}
unset($db);

    The first line of code creates a new SQLite3 object, using the mydb.sq3 database file you created earlier. Then, the object’s query() method is used to execute a SELECT query on the database, and the result object’s fetchArray() method is used to iterate over the result set. Adding the SQLITE3_ASSOC parameter to the fetchArray() method tells PHP to return the results as an associative array, making it easy to access individual fields of the result set and display them on a Web page.

    Once done, save your changes and ensure that your Apache server is running. Then, browse to http://localhost/sqlite.php to execute the script. You should see something like this:

    image3
    To find out more about SQLite’s powerful features, read the SQLite documentation.