将我的表单字符串与 php 数据库中的条件相匹配

Question

这是来自我的表单字段：

$subject="physics with maths";

这是我的数据库：

$keywordsindatabse="(physics && electronics) || (electronics & communication) || (electronics and communication)";

提交表格后，我想将条件$keywordsindatabse与$subject相匹配。有什么想法吗？

任何帮助将不胜感激。

法典：

<form id="myform" name="myform">
<select name="sselect"  id="itmn">
                        <option value="">Select</option>
            <option value='1'>1</option>
                        <option value='2'>2</option>
                        <option value='3'>3</option>
                        <option value='4'>4</option>
                        <option value='5'>5</option>
                        <option value='6'>6</option>
                        <option value='7'>7</option>            
          </select>
<input  type='text' name='gmajorsub' id=""" value="" onblur="chkdegree(document.getElementById('itmn').value,this.value);">
</form>
<script>
 function chkdegree(item_id,keyword)
 {

 $.ajax({
            type: "GET",
            url: "degree_match.php",
            dataType: 'html',
        data: {item_id : item_id,keyword : keyword},
            success: function(data){
                if(data=="0")
        {
         alert("Dear Applicant, You are not allowed to register.You Subject not matching our essential qualification requirements.");
                  document.getElementById("gmajorsub").value="";
                  document.getElementById("gmajorsub").focus();
                  return false;
        }
            }
    });
 }
</script>

degree_match.php：

<?php
include("../../lib/dbc/dbConnection.php");
require('../../lib/dbc/commonFunc.php');
require('../../lib/dbc/dbHandler.class.php');
$dbObject = new dbHandler();
$dbObject->connect();
$query="select * from advt_110_post_details where recNo='".$_REQUEST['item_id']."'";
$result=mysql_query($query);
$num=mysql_fetch_array($result);
$keyword=strtolower($_REQUEST['keyword']);
$degree=$num['subject_keywords'];
$degree1=explode("|",$degree);


$max = array(null, 0); // category, occurences
/*foreach($degree1 as $k => $v) {
  $replaced = str_replace($v, '##########', $keyword);
  preg_match_all('/##########/i', $replaced, $matches);
  if(count($matches[0]) > $max[1]) {
    $max[0] = $k;
    $max[1] = count($matches[0]);
  }
}

if($max[1]>=count($degree1))
{
  echo"1";  
}
else{
    echo"0";
}
*/
/*foreach($degree1 as $k => $v) {
if ( strstr( $membership, "member" ) )
{
}
}
*/
?>

Answer 1

注意：你的代码是SQL注入的主题。查看使用 PDO 准备语句或 mySQLi 准备语句。至少，将字符串输入包装到数据库中mysql_real_escape_string。

---

查看代码，你从数据库中获取项，然后进行筛选。我假设是mySQL。

最好在数据库端执行此操作。查看"全文搜索"。这仅适用于MyISAM表，因此请根据需要进行更改。然后将 FullText 索引添加到"subject_keywords"上的表中，您需要使用全文设置布尔值。有关布尔搜索的详细信息，请参见此处。

（如果做不到这一点，Rishi上面的回答已经引入了您需要的循环 - 这是您的尝试中缺少的。

Answer 2

据我从您的帖子中了解到，下面的代码可能会有所帮助。

$subject="physics with maths";
$keywordsindatabse="(physics && electronics) ||
(electronics & communication) ||
(electronics and communication)";
$pieces = explode(" ", $subject);
$piecesDB = explode("||", $keywordsindatabse);
$subsDBv=array();
foreach($piecesDB as $key=>$subsDB){
    $subsDBv[$key] = str_replace(array("(",")"),"",explode(" ", $subsDB));
    }
foreach($subsDBv as $subslvd){
foreach($subslvd as $subslv){
    $ao = next($subslvd);
foreach($pieces as $subs){
if((strpos($subslv,$subs) !== false) AND (strpos($ao,$subs) !== false)){
    echo "Match found..<br />"; 
    }
    else{       
        echo "Sorry, no match found..<br />";
        }
}
}
}