PHP Classes

Arabic MySQL Query: Build SQL queries considering Arabic lexical rules

Recommend this page to a friend!
  Info   View files View files (6)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 67%Total: 3,071 All time: 1,183 This week: 69Up
Version License PHP version Categories
arquery 1.0GNU General Publi...4.0Databases, Text processing


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:

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: Egypt Egypt
Age: 48
All time rank: 481 in Egypt Egypt
Week rank: 84 Down4 in Egypt Egypt Down
Innovation award
Innovation award
Nominee: 10x

Winner: 4x

  Files folder image Files  
File Role Description
Files folder imagephp5 (1 file)
Files folder imagedocs (1 file)
Files folder imageimages (1 file)
Plain text file arquery.class.php Class Class file
Accessible without login Plain text file example.php Example Example script
Accessible without login Plain text file example.sql Data Example database

  Files folder image Files  /  php5  
File Role Description
  Plain text file arquery.class.php Class Class file

  Files folder image Files  /  docs  
File Role Description
  Accessible without login HTML file readme.html Doc. Documentation

  Files folder image Files  /  images  
File Role Description
  Accessible without login Image file Aljazeeralogo.gif Icon Image

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:1,183
This week:69Up
User Ratings User Comments (1)
 All time