Dictionary App by Flutter
About The Project
I have made a Turkish-English dictionary app in this project. I can receive dictionaries from the database thanks to sqlite. And You can search words in this application. I also did this thanks to sqlite.
With the following sql query,I can search the words from database
Future<List<Words>> searchWord(String searchWord) async {
var db = await DatabaseHelper.databaseAccess();
List<Map<String,dynamic>> maps = await db.rawQuery("SELECT * FROM kelimeler WHERE ingilizce like '%$searchWord%' or turkce like '%$searchWord%'");
return List.generate(maps.length, (index) {
var row = maps[index];
return Words(row["kelime_id"], row["ingilizce"], row["turkce"]);
});