Audio Qur'an English Translation
Ayet ayet Kur'an:
http://www.quranflash.com/data/translation/en_sahih/2/275
http://www.quranflash.com/assets/audio/verses/EnIbrahimWalk/
http://www.everyayah.com/data/English/Sahih_Intnl_Ibrahim_Walk_192kbps/
http://www.quranflash.com/books/MedinaOld/?en
Browsable:
https://download.quranicaudio.com/verses/Minshawi/Mujawwad/
https://www.quranflash.com/assets/audio/verses/
Verse audio example:
English:
192kbps: https://everyayah.com/data/English/Sahih_Intnl_Ibrahim_Walk_192kbps/008022.mp3
64kbps: http://www.quranflash.com/assets/audio/verses/EnIbrahimWalk/002041.mp3
Arabic:
https://download.quranicaudio.com/verses/Alafasy/mp3/002014.mp3
https://download.quranicaudio.com/verses/Alafasy/ogg/002026.ogg
https://download.quranicaudio.com/verses/Minshawi/Mujawwad/mp3/002061.mp3
MORE RECITERS:
https://www.tvquran.com/en/quran/recitations/reciters-list
LIKED RECITERS:
Hani Rifai
192kbps, verse: https://everyayah.com/data/Hani_Rifai_192kbps/008022.mp3
128kbps, surah: https://download.quranicaudio.com/qdc/hani_ar_rifai/murattal/8.mp3
Mohammad Rashad Alshareef
96kbps, verse: https://www.quranflash.com/assets/audio/verses/MohammadRashadAlshareef/017053.mp3
128kbps, surah: https://download.tvquran.com/download/recitations/317/233/019.mp3
Mishari al Afasy
128kbps, surah: https://download.quranicaudio.com/qdc/mishari_al_afasy/murattal/17.mp3
128kbps, surah: https://download.tvquran.com/download/recitations/85/226/014.mp3
From Android App: Quran Vocabulary Memorization
insert arabic and english words into vav db.
ATTACH '/var/www/ovz/quran-vocabulary/vocabulary.db' AS dbx;
INSERT INTO tblword (word, mean, username, flag, langword, langmean)
SELECT ArabicWord, EnglishMeaning, "m1gin", 0, "ar", "en" FROM dbx.tbl_commonwords WHERE id<500;
DETACH dbx;
---
prepare list to rename pronunciation files to id.mp3
ATTACH '/var/www/ovz/quran-vocabulary/vocabulary.db' AS dbx;
SELECT "mv " || audio || " /var/www/staticdata/vav.mbirgin.com/word/ar/" || tblword.id ||".mp3" FROM tblword, dbx.tbl_commonwords WHERE tblword.word=dbx.tbl_commonwords.ArabicWord AND tblword.mean=dbx.tbl_commonwords.EnglishMeaning LIMIT 1111;
DETACH dbx;
---
update flag for words .. mark there is an audio pronunciation
ATTACH '/var/www/ovz/quran-vocabulary/vocabulary.db' AS dbx;
UPDATE tblword SET flag=(flag|4)
WHERE langword="ar" AND langmean="en" AND id IN (SELECT tblword.id FROM tblword, dbx.tbl_commonwords WHERE tblword.word=dbx.tbl_commonwords.ArabicWord AND tblword.mean=dbx.tbl_commonwords.EnglishMeaning LIMIT 1111);
DETACH dbx;
FELData.db FunEasyLearn Sqlite DB:
select * from words where languageID IN(16,3,59) order by mediaid limit 111;
kranirab2 SQLite DB:
select * from kelimeler t1, irabtable t2 WHERE t1.arapca=t2.arapca GROUP BY t1.harekesiz ORDER BY tekrarsayisi DESC LIMIT 22;
Verileri INSERT için hazırlamak.
$ sqlite3 db.sqlite
sqlite> .output out.txt;
sqlite> select '("'||harekesiz ||'","'|| anlam ||""",'misti',0,'ar','tr')," from kelimeler t1, irabtable t2 WHERE t1.arapca=t2.arapca AND tekrarsayisi>9 GROUP BY t1.harekesiz ORDER BY tekrarsayisi DESC LIMIT 2222;
---
Elde edilen dosya içeriği kullanılarak şu şekilde INSERT yapılabilir:
insert into tblword (word, mean, username, flag, langword, langmean) VALUES ....
Eklenen bu kelimeler daha sonra bir listeye eklenebilir.
insert or ignore into tblvirtualword (idword, idwordset, username)
select id, 499, "m1gin" from tblword where langword="ar" AND username="misti";
http://www.houseofquran.com/qsys/quranteacher1.html
recitors[0].audiodir
//"http://1c.houseofquran.com/01/"
WINFO[84163]
(5) [73, 13, "73S_13_2.mp3", "84162", "84164"]
Load WINFO
http://www.houseofquran.com/qsys/include/073.js
Quran Arabic Text and word id
http://www.houseofquran.com/qsys/text/qtext29.js
WINFO[84163][2]
"73S_13_2.mp3"
Audio: http://1c.houseofquran.com/01/73S_13_2.mp3
QTEXT[5242]="تَبَـٰرَكَ ٱلَّذِى بِيَدِهِ "
---------------------
Verse audio example:
https://everyayah.com/data/English/Sahih_Intnl_Ibrahim_Walk_192kbps/031033.mp3