PHP Classes

Arabic MySQL Query: Build SQL queries considering Arabic lexical rules

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 67%Total: 3,071 All time: 1,184 This week: 69Up
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: Egypt Egypt
Age: 49
All time rank: 481 in Egypt Egypt
Week rank: 46 Up1 in Egypt Egypt Equal
Innovation award
Innovation award
Nominee: 10x

Winner: 4x

  Files folder image Files (6)  
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 (6)  /  php5  
File Role Description
  Plain text file arquery.class.php Class Class file

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

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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:3,071
This week:0
All time:1,184
This week:69Up
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:458