Hatem’s Diaries

I remember I send Quraan translations years ago to a friend in
arabeyes, but I can’t find a copy today. Anyaway I’m just using the XML file
from Arabeyes (Arabic version). Then I’m trying to see for translations, tafsir
… etc. I found an English XML version of Tafsir Quraan in a wiki. I was
interested coz I read in the XML "A Summarized Version of At-Tabari,
Al-Qurtubi and Ibn Kathir with comments from Sahih Al-Bukhari By Dr. Muhammad
Taqi-ud-Din Al-Hilali, Ph.D. Dr. Muhammad Muhsin Khan" but have a look what
I have found at first parse :

 parsed (115 Surah) / 114  and (6372 Ayah) / 6236

There is already something wrong, I just opened the file and found At-Taubah
then Yûnus, Yûsuf, Hûd and then Yûsuf again.I don’t know how this error appeared
in the translation because the first Yûsuf don’t exist in quraan at all.

I’m making PHP code available with the arabic XML version from Quraan and the
SQL Dump.

The Schema is easy to understand, I make it so it can support Quraan,
translations and tafsir with unlimited number of books. Books should be in XML
format. Tags are described below :

• QURAN : every file should start with this tag and indicate a
  description and lang as attributes
• SURA : number of Sura in Quraan is 114, this tag have only an
  attribute NAME
• VERSE : which just contain the text related to the verse in its
  value

Exception made for the Arabic text which use tag AYA, SEARCHTEXT and
QURANTEXT to differenciate between them and make it easy for searching

Notice AYA tag cannot be used with VERSE tag in the
same XML document. I think  I have already made a DTD for XML Quraan
before, so maybe I can adapt it with this changes for translations and tafsir.

To use it make all books you have in XML format with different names. books
will be loaded with description in books table. The Sura table
will have its number, name and the book as foreign key. Aya table will
have two foreign keys book and Sura then the number of the Aya
inside the Surah. searchtext field is always used for content and qurantext for
the Quraan itself.

Download code (PHP Parser + SQL Dump + Arabic XML Quran)

Tags: No Tags