Login   Register  
PHP Classes
elePHPant
Icontem

Arabic MySQL Query

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author  
Picture of Khaled Al-Shamaa
Name: Khaled Al-Shamaa <e-mail contact>
Packages: 22 Browse all classes by Khaled Al-Shamaa Browse all classes by
Country: Syria Syria - PHP jobs in Syria
Age: 37
All time rank: 631 in Syria Syria
Week rank: 79 Down1 in Syria Syria Equal
Innovation award
Innovation award
Nominee: 10x

Winner: 4x


  Detailed description   Download .zip .tar.gz  
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/

  Classes of Khaled Al-Shamaa  >  Arabic MySQL Query  >  Download .zip .tar.gz  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Arabic MySQL Query
Base name: arquery
Description: Build SQL queries considering Arabic lexical rules
Version: 1.0
PHP version: 4.0
License: GNU General Public License (GPL)
All time users: 2851 users
All time rank: 1150
Week users: 3 users
Week rank: 921 Up
Country specific: This package is specific mainly for applications used in Saudi Arabia Saudi Arabia .
 
  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Text processing Manipulating and validating text data View top rated classes


  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

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (92.3%)
Good (90.4%)
Good (82.7%)
Good (84.6%)
-
-
Sufficient (71.9%)
140
Month:
Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  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  /  Files folder image php5  
File Role Description
  Plain text file arquery.class.php Class Class file

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

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

Download all files: arquery.tar.gz arquery.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.