I need a PHP Script to generate MySQL queries
- Posted:
- Proposals: 5
- Remote
- #1766162
- Awarded
have already sent a proposal. Description
Experience Level: Intermediate
General information for the business: We provide a web interface for users to search data
Description of requirements/functionality: I need a PHP script to convert a phrase with AND’s OR’s and parentheses () into a MySQL statement.
For example:
1. fish AND apple should convert to field LIKE “%fish%” AND field LIKE “%apple%”
2. (fish OR dog) AND (apple OR NOT pear) should convert to (field LIKE “%fish%” OR field LIKE “%dog%”) AND (field LIKE “%apple%” OR field NOT LIKE “%pear%”)
Other Requirements:
* The script should support any permutation of AND, OR and parenthesis.
* The script should validate the parentheses such that a database query error cannot occur.
* AND, OR and NOT (each in all caps) should be considered logical operators
* The script should be compatible with PHP 7 and MySQL 5.6.
Specific technologies required: PHP 7, MySQL 5.6
OS requirements: Windows
Extra notes:
Description of requirements/functionality: I need a PHP script to convert a phrase with AND’s OR’s and parentheses () into a MySQL statement.
For example:
1. fish AND apple should convert to field LIKE “%fish%” AND field LIKE “%apple%”
2. (fish OR dog) AND (apple OR NOT pear) should convert to (field LIKE “%fish%” OR field LIKE “%dog%”) AND (field LIKE “%apple%” OR field NOT LIKE “%pear%”)
Other Requirements:
* The script should support any permutation of AND, OR and parenthesis.
* The script should validate the parentheses such that a database query error cannot occur.
* AND, OR and NOT (each in all caps) should be considered logical operators
* The script should be compatible with PHP 7 and MySQL 5.6.
Specific technologies required: PHP 7, MySQL 5.6
OS requirements: Windows
Extra notes:
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.