#_HPg2Z${#B+vld]>@FhFTW +35--J=ځ"O1^f+P>`E>R?G~n Lo2>Z<ff$SF t̘r퇎M|OE3IF{+%J[?@B7hs58xhVYV> 6{r`3+ܐqXNo#Ϝ6Ϸ# JvPc>2tWcqܧ'cCEEJ46+v)5- x+ _XwJo|@ᤏY!KqW`Z@R S*ɞ@ZEs :fMQȼ-Gb ū=?/ ] wh"a"_5fcCua.| U#㉮l rg툖O=faáztP9P4{BֺMϴ\Rr3D?9}^ˮ'0p4B_ь*̼m^ Bb%J\2aFFz u$x3| ;,l*?%hv}OJ*УVԨ?k-t2w~q0V#2q;LfsI{0ߋӿSS^{!Xq9lU˹A7AS|}g }} ;x`A{,Aw.BB}F"_X/1:$48lZؾ]PUD1+x4ΪO{\iQmPT:M eJ};ِNq6vٰDls#cw^cR9Y]vͤ1UPQJzh v[{<֫Hܿ|%S~07u^Ju20bʇ- rHTֈ~%,`,!#oNij HI/yv➙y-PB M eS%A55Wf 8Ar-GX8ZZՄ5WϴF_?XA-kUx@;:-,̏'5Y?"p3 O&S^խ*̼m^ BfVsH鷿!zBO,3 KYU#5(}gkw !Yahxrn qj82{Ң_c !ޛ  pՌnGj2;ƟC ^Y)GPW)~8崲;_86|0Ë#G.2YJ%A% vx('z)~h6lP";;Z`J)Z)x迀,N* jI/8V0AO B"Ml]QȶРt9Y>P CvI l 5 qkǕp%=gOk얇ۀey/.ʑ1]aP'D).~3|]@vbF^àb'`I ȟ+zC9P6yD˿#6?1.v.oP eZSdA-KI7۲9M\-cv|bPiY]: [x],ӛ߷M3~/?A3-R@\b$:i5<~5O(1jR cͺm"},ea5ލPyMR1f᯼ a:(8bxDᚦs>ĚݻCS}0' \rIWҚ?-w բЊ7*9+OU{%' (ImBF![`wbg8cdž^NrHw`l(e'C8YL+#~?4iL>#Hc lȀCCLCE9&&x&A6O; sfO[z]u};Iash Ł |#2OB5GDfy1E ؿ-MB ̘l,Ŷ+$T] Cd>į[[D8{o4<(%%DtKm@O]ӫ+kBRphS3lԥ73Daq +R,sl87U+{YH $EӧsRK?PE4׏ 6*x5sn EZ\ՠG-e2DFym^806VlGrI5>5\|VaT>`<;ut!2S:&aSq"O|P"}WC|-&d>R|Kq-BsB' vGX;i WƷlyrg+UtwF9 +'ݚW:Ժ!xO-N#ޫSHaě+cta=(#ݑ&I)UCqce!#Gje*,CFnfKi&b @ate the table, and you can 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.