脚本宝典收集整理的这篇文章主要介绍了php – 检查句子是否有相同的单词，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。
===================================== ================================ |id|sentence |sentence_id|content_id| |id|word|sentence_id|content_id| ===================================== ================================ | 1|sentence1| 0 | 1 | | 1| a | 0 | 1 | | 2|sentence2| 1 | 1 | | 2| b | 0 | 1 | | 3|sentence5| 0 | 2 | | 3| c | 1 | 1 | | 4|sentence6| 1 | 2 | | 4| a | 1 | 1 | | 5|sentence7| 2 | 2 | | 5| e | 1 | 1 | ===================================== | 6| f | 0 | 2 | | 7| g | 1 | 2 | | 8| h | 1 | 2 | | 9| i | 1 | 2 | |10| f | 2 | 2 | |11| h | 2 | 2 | |12| f | 2 | 2 | ================================
我需要检查每个句子是否由每个content_id中的其他句子所拥有的单词组成.
例如 ：
检查content_id = 1他们是sentence1和sentence2.从tb_word,我们可以看到sentence1和sentence2由相同的单词a组成.如果两个句子中的a的数量是> = 2,那么a将是结果.因此,如果我打印结果,它必须是：
00Array([0] => a [1] => b)01Array([3] => a)10Array([3] => a)11Array([0] => c [1] = > a [2] => e)其中00表示sentence_id = 0且sentence_id = 0
首先,我使functiontotal计算每个content_id所拥有的句子数：
$total = array(); $sql = MysqL_query('select content_id,count(*) as RowAmount From tb_content group by contente_id') or die(MysqL_error()); while ($row = MysqL_fetch_array($sql)) { $total[] = $row['Rowamount']; } return $total;
从这个函数我得到$total的值,从中我需要检查一些单词(来自tb_word)在2个句子的所有可能性之间的相似性
foreach ($total as $content_id => $totals){ for ($x=0; $x <= ($totals-1); $x++) { for ($y=0; $y <= ($totals-1); $y++) { $shared = getShared($x,$y); } }
getShared的功能是：
function getShared ($x,$y){
$token = array();
$shared = array();
$i = 0;
if ($x == $y) {
$query = MysqL_query("SELECT word From `tb_word`
WHERE sentence_id ='$x' ");
while ($row = MysqL_fetch_array($query)) {
$shared[$i] = $row['word'];
$i++;
}
} else {
$query = MysqL_query("SELECT word,count(word) as jML
FROM `tb_word` WHERE sentence_id ='$x'
OR sentence_id ='$y'
GROUP BY word ");
while ($row = MysqL_fetch_array($query)) {
$jml = $row['jml'];
$token[$i] = $row['word'];
if ($jml >= 2) {
$shared[$i] = $token[$i];
}
$i++;
}
但我得到的结果仍然是错误的.结果仍然在不同的content_id之间混合.结果必须也是由content_id分组.抱歉我的英语不好,我的解释也不好. cmiiw,请帮帮我..谢谢:)
SELECT a.content_id,a.sentence_id AS sentence_id_1,b.sentence_id AS sentence_id_2
FROM tb_content AS a
JOIN tb_content AS b
ON ( a.content_id = b.content_id
AND a.sentence_id <= b.sentence_id )
“< =”将保持相同的句子连接,如“1-1”或“2-2”,但避免双向重复,如“1-2”和“2-1”.接下来,您可以使用单词加入上述结果并计算出现次数.像那样：
SELECT s.content_id,s.sentence_id_1,s.sentence_id_2,c.word,Count(*) AS jml
FROM (SELECT a.content_id,b.sentence_id AS sentence_id_2
FROM tb_content AS a
JOIN tb_content AS b
ON ( a.content_id = b.content_id
AND a.sentence_id <= b.sentence_id )) AS s
JOIN tb_word AS c
ON ( s.content_id = c.content_id
AND ( c.sentence_id = s.sentence_id_1
OR c.sentence_id = s.sentence_id_2 ) )
GROUP BY s.content_id,c.word
HAVING Count(*) >= 2;
上述查询的结果将为您提供容器,句子1和2,单词和出现次数(2或更多).您现在需要的只是将结果收集到数组中,正如我所知道的那样.
如果我错过了你的目标,请告诉我.
以上是脚本宝典为你收集整理的php – 检查句子是否有相同的单词全部内容，希望文章能够帮你解决php – 检查句子是否有相同的单词所遇到的问题。
本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。