Arabic MySQL Query: Build SQL queries considering Arabic lexical rules

Recommend this page to a friend!
  Info   View files (6)   Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
67%Total: 3,054 All time: 1,178 This week: 158
Version License PHP version Categories
arquery 1.0GNU General Publi...4.0Databases, Text processing
Description Author
This package is specific mainly for applications used in Saudi Arabia Saudi Arabia .

This class can be used to build MySQL SQL query conditions to search for Arabic text considering Arabic lexical rules.

It uses the MySQL REGEXP and LIKE functions to retrieve better results from queries for Arabic text.

This class is part of Khaled Al-Shamaa project for PHP and Arabic language:
http://www.al-shamaa.com/php/arabic/

Innovation Award
PHP Programming Innovation award nominee
February 2006
Number 8
The Arabic idiom has its own lexical rules that differ from other idioms. This fact makes it more difficult to search for Arabic text in databases that were not ready to consider Arabic rules.

This class provides a solution for that problem by elaborating SQL search query clauses that are aware of the Arabic lexical rules.

Manuel Lemos
Picture of Khaled Al-Shamaa
  Performance   Level  
Name: Khaled Al-Shamaa <contact>
Classes: 22 packages by
Country: Syria Syria
Age: 45
All time rank: 491 in Syria Syria
Week rank: 771 1 in Syria Syria
Innovation award
Innovation award
Nominee: 10x

Winner: 4x

  Files  
File Role Description
php5 (1 file)
docs (1 file)
images (1 file)
arquery.class.php Class Class file
example.php Example Example script
example.sql Data Example database

  Files  /  php5  
File Role Description
   arquery.class.php Class Class file

  Files  /  docs  
File Role Description
   readme.html Doc. Documentation

  Files  /  images  
File Role Description
   Aljazeeralogo.gif Icon Image

 Version Control Unique User Downloads Download Rankings  
 0%
Total:3,054
This week:0
All time:1,178
This week:158
User Ratings User Comments (1)
 All time
Utility:85%
Consistency:85%
Documentation:76%
Examples:80%
Tests:-
Videos:-
Overall:67%
Rank:649
  

For more information send a message to info at phpclasses dot org.