Facing issue to search a specific character into database about ar-php HOT 4 CLOSED

this should works

$result=DB::table('verses')->select(DB::raw($strCondition))->orderBy(DB::raw($strOrderBy))->limit(10)->get();

also, you can try this package for easy integration with laravel
https://github.com/atm-code/ar-php-laravel

from ar-php.

https://github.com/atm-code/ar-php-laravel this package is really helpful for me

from ar-php.

Thank you, Ashraf, for your help in this issue. I highly appreciate your valuable efforts in integrating the Ar-PHP library with the Laravel framework. I also try to do my homework and come with a different suggestion that might work:

$result = DB::table('verses')->whereRaw($strCondition)->orderByRaw($strOrderBy)->limit(10)->get();

The biggest danger in Raw Queries is that they are not automatically secured, so if you are passing any parameters to the query, please triple-check and validate. Therefore, before calling the arQueryWhereCondition and arQueryOrderBy methods from the Ar-PHP library, you have to escape special characters within the input string:

$keyword = DB::connection()->getPdo()->quote($keyword);

from ar-php.

I have no experience in Laravel ORM, but following your example code, the SQL statement generated by Ar-PHP library functionality will be (for the "text" field in the "verses" table):

SELECT `text` FROM `verses` WHERE ( REPLACE(text, 'ـ', '') REGEXP '((ا|أ|إ|آ)ل)?ل(ة|ه)') ORDER BY ((CASE WHEN  REPLACE(text, 'ـ', '') REGEXP '((ا|أ|إ|آ)ل)?ل(ة|ه)' THEN 1 ELSE 0 END)) DESC

Try it directly on your database using phpMyAdmin. If you get the expected records (just like what I did), then the issue that you have is related to how to configure Laravel ORM properly.

I will highly appreciate it if you (or any Laravel expert) find out a solution and share it with us, so we can add it to our knowledge base as Laravel currently is one of the most popular PHP frameworks.

from ar-php.