예제 #1
0
파일: job.php 프로젝트: preeti07/GetTheJob
 public static function selectRowsByKeywords($condition, $keywords)
 {
     $queryCondition = " WHERE {$condition}";
     $query = "SELECT *,(MATCH (`job_title`,`job_description`) AGAINST ('{$keywords}')) as `relevance` FROM " . static::tableName() . "{$queryCondition};";
     return MysqliConnection::getConnection()->query($query);
 }
예제 #2
0
 protected static function fieldSearch($fieldValue, $fieldName)
 {
     $query = "SELECT * FROM " . static::tableName() . " WHERE {$fieldName} = {$fieldValue}";
     return MysqliConnection::getConnection()->query($query);
 }