basic open/read:
$sq = sqlite_open("miodb.db”, 0666, $sqlite_error);
if(!$sq){
die("Errore Sqlite: ".$sqlite_error);
}
sqlite_query($sq, "CREATE TABLE prova_tbl (campo varchar(10))”);
for($i = 0; $i < 10; ++$i){
sqlite_query($sq, "INSERT INTO prova_tbl VALUES (test ".$i.”‘)”);
}
$result = sqlite_query($sq, "SELECT * FROM prova_tbl”);
while($data = sqlite_fetch_array($result)){
echo $data['campo'].”<br />”;
}
sqlite_close($sq);
custom functions sql bind:
function trim_upper($string){
return strtoupper(trim($string));
}
$sq = sqlite_open("miodb.db”, 0666, $sqlite_error);
if(!$sq){
die("Errore Sqlite: ".$sqlite_error);
}
sqlite_create_function($sq, "trimup”, "trim_upper”, 1);
$result = sqlite_query($sq, "SELECT trimup(campo) AS campo FROM prova_tbl”);
while($data = sqlite_fetch_array($result)){
echo $data['campo'].”<br />”;
}
sqlite_close($sq);