Login   Register  
PHP Classes
elePHPant
Icontem

Arabic MySQL Query: Build SQL queries considering Arabic lexical rules

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (6)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2008-05-12 (6 years ago) RSS 2.0 feedStarStarStarStar 67%Total: 2,931 All time: 1,172 This week: 1,534Down
Version License PHP version Categories  
arquery 1.0GNU General Public Lice...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
Name: Khaled Al-Shamaa <contact>
Classes: 22 packages by
Country: Syria Syria
Age: 39
All time rank: 591 in Syria Syria
Week rank: 55 Up1 in Syria Syria Equal
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  
 0%Total:2,931All time:1,172
 This week:0This week:1,534Down
User Ratings User Comments (1)  
 All time
Utility:85%StarStarStarStarStar
Consistency:85%StarStarStarStarStar
Documentation:76%StarStarStarStar
Examples:80%StarStarStarStarStar
Tests:-
Videos:-
Overall:67%StarStarStarStar
Rank:370