PHP循环问题 [英] PHP Loop Problem
问题描述
我的代码出现问题,发生的事情是我正在显示来自用户表的成员以及我正在检查的foreach循环中的每个用户看看是否有任何品质与正在运行搜索的用户匹配。
它匹配的方式是检查大约25个字段,如果有匹配则每次增加1匹配。
然后它添加所有1'并将其分配给要使用的变量。
我遇到的问题每次循环时,它都会添加先前的结果和当前结果,并通过循环继续这样做。
我需要做的是不要添加以前的使用,以便每个用户的结果都是正确的。
代码在这里:
[PHP]
$ sql = mysql_query(" select * from users WHERE $ stored AND status =''active''" );
$ countrows = mysql_num_rows($ sql);
//从表中获取所有产品
$ result = array() ;
$ e = 0;
while($ r = mysql_fetch_array($ sql)){
$ resultsi = mysql_query(" SELECT * FROM users WHERE id =''$ _COOKIE [id]''");
$ rowi = mysql_fetch_assoc($ resultsi); //使用结果
$ resultsis = mysql_query(" SELECT * FROM users WHERE id =''$ r [id]''");
$ rowis = mysql_fetch_assoc($ resultsis); //使用结果
if($ rowi [''partner_charming''] ==''1''&& $ rowis [''charming''] == ''1''){$ i = $ i + 1; }
if($ rowi [''partner_sense_of_humour''] ==''1''&& $ rowis [''sense_of_humour''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_loyal''] ==''1''&& $ rowis [''loyal''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_honest''] ==''1''&& $ rowis [''honest''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_attractive''] ==''1''&& $ rowis [''attractive''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_optimistical''] =='''''&& $ rowis [''optimistical''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_realistic''] ==''1''&& $ rowis [''reality''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_sexy''] ==''1''&& $ rowis [''sexy''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_ambitious''] ==''1''&& $ rowis [''ambitious''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_visionary''] =='''''&& $ rowis [''visionary''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_quiet''] ==''1''&& $ rowis [''quiet''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_conservative''] ==''1''&& $ rowis [''保守''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_tolerant''] ==''1''&& $ rowis [''tolerant''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_curious''] ==''1''&& $ rowis [''curious''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_selfconfident''] ==''1''&& $ rowis [''selfconfident''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_athletic''] ==''1''&& $ rowis ['''运动''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_attentive''] ==''1''&& $ rowis ['''estive''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_shy''] ==''1''&& $ rowis [''shy''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_sociable''] ==''1''&& $ rowis [''sociable''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_dominant''] ==''1''&& $ rowis [''dominant''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_creative''] ==''1''&& $ rowis [''creative''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_active''] ==''1''&& $ rowis [''active''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_passive''] ==''1''&& $ rowis [''passive''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_domesticated''] ==''1''&& $ rowis [''omesticated''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_friendly''] ==''1''&& $ rowis [''friendly''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_sympathetic''] ==''1''&& $ rowis [''sympathetic''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_fond_of_children''] ==''1'&& $ rowis [''fond_of_children''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_fond_of_animals''] ==''1''&& $ rowis [''fond_of_animals''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_intelligent''] ==''1''&& $ rowis [''intelligent''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_romantic''] =='''''&& $ rowis [''romantic''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_talkative''] ==''1''&& $ rowis [''talkative''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_joyful''] ==''1''&& $ rowis [''joyful''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_humble''] ==''1''&& $ rowis [''humble''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_modest''] ==''1''&& $ rowis [''modest''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_caring''] ==''1''&& $ rowis [''caring''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_respectful''] ==''1''&& $ rowis [''尊重''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_generous''] ==''1''&& $ rowis [''慷慨''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_thoughtful''] ==''1''&& $ rowis [''thoughtful''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_down_to_earth''] ==''1''&& $ rowis [''down_to_earth''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_sensitive''] ==''1''&& $ rowis [''sensitive''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_professional''] ==''1''&& $ rowis [''professional''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_business_minded''] ==''1'&& $ rowis [''business_minded''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_solvent''] ==''1''&& $ rowis [''solvent''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_determined''] ==''1''&& $ rowis [''确定''] ==''1''){$ i = $ i + 1; }
if($ rowi [''partner_successful''] ==''1''&& $ rowis [''success''] ==''1''){$ i = $ i + 1; }
$ tmp =数组(
''id''=> $ r [''id''],
''introduction_title''=> $ r [''introduction_title''],
''image_1''=> $ r [''image_1''],
''body_type''=> $ r [''body_type''],
''职业''=> $ r [''职业'' ],
''sdate''=> $ r [''sdate''],
''age''=> $ r [''年龄''],
''个性'=> $ r [''个性''],
''用户名''=> $ r [' 'username''],
''匹配''=> $ i
);
$结果[$ e ++] = $ tmp;
}
//将结果传递给模板
$ smarty-> assign(''result'',$ result );
[/ PHP]
干杯,
Adam
Hi, 这篇关于PHP循环问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
stored AND status =''active''");
< blockquote> countrows = mysql_num_rows(
I am having a problem with my code, what is happening is i am displaying members from a users table and for every user in the foreach loop i am checking to see if any of there qualities match with the user that is running the search.
The way it matches is it checks about 25 fields and if there is a match then it adds 1 for every match.
Then it adds all the 1''s up and assigns that to a variable to use.
The problem i am having each time it loops it adds the previous results and the current results and keeps doing that through the loop.
What i need to do is for it not to add the previous entrys so that the result is correct for each users.
The code is here:
[PHP]
$sql = mysql_query("select * from users WHERE $stored AND status=''active''");
$countrows = mysql_num_rows($sql);
// get all the products from the table
$result = array();
$e=0;
while ($r=mysql_fetch_array($sql)) {
$resultsi = mysql_query("SELECT * FROM users WHERE id = ''$_COOKIE[id]''");
$rowi = mysql_fetch_assoc($resultsi); // Use the result
$resultsis = mysql_query("SELECT * FROM users WHERE id = ''$r[id]''");
$rowis = mysql_fetch_assoc($resultsis); // Use the result
if ($rowi[''partner_charming''] == ''1'' && $rowis[''charming''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_sense_of_humour''] == ''1'' && $rowis[''sense_of_humour''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_loyal''] == ''1'' && $rowis[''loyal''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_honest''] == ''1'' && $rowis[''honest''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_attractive''] == ''1'' && $rowis[''attractive''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_optimistical''] == ''1'' && $rowis[''optimistical''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_realistic''] == ''1'' && $rowis[''realistic''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_sexy''] == ''1'' && $rowis[''sexy''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_ambitious''] == ''1'' && $rowis[''ambitious''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_visionary''] == ''1'' && $rowis[''visionary''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_quiet''] == ''1'' && $rowis[''quiet''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_conservative''] == ''1'' && $rowis[''conservative''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_tolerant''] == ''1'' && $rowis[''tolerant''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_curious''] == ''1'' && $rowis[''curious''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_selfconfident''] == ''1'' && $rowis[''selfconfident''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_athletic''] == ''1'' && $rowis[''athletic''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_attentive''] == ''1'' && $rowis[''attentive''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_shy''] == ''1'' && $rowis[''shy''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_sociable''] == ''1'' && $rowis[''sociable''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_dominant''] == ''1'' && $rowis[''dominant''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_creative''] == ''1'' && $rowis[''creative''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_active''] == ''1'' && $rowis[''active''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_passive''] == ''1'' && $rowis[''passive''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_domesticated''] == ''1'' && $rowis[''omesticated''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_friendly''] == ''1'' && $rowis[''friendly''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_sympathetic''] == ''1'' && $rowis[''sympathetic''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_fond_of_children''] == ''1'' && $rowis[''fond_of_children''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_fond_of_animals''] == ''1'' && $rowis[''fond_of_animals''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_intelligent''] == ''1'' && $rowis[''intelligent''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_romantic''] == ''1'' && $rowis[''romantic''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_talkative''] == ''1'' && $rowis[''talkative''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_joyful''] == ''1'' && $rowis[''joyful''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_humble''] == ''1'' && $rowis[''humble''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_modest''] == ''1'' && $rowis[''modest''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_caring''] == ''1'' && $rowis[''caring''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_respectful''] == ''1'' && $rowis[''respectful''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_generous''] == ''1'' && $rowis[''generous''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_thoughtful''] == ''1'' && $rowis[''thoughtful''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_down_to_earth''] == ''1'' && $rowis[''down_to_earth''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_sensitive''] == ''1'' && $rowis[''sensitive''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_professional''] == ''1'' && $rowis[''professional''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_business_minded''] == ''1'' && $rowis[''business_minded''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_solvent''] == ''1'' && $rowis[''solvent''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_determined''] == ''1'' && $rowis[''determined''] == ''1''){ $i = $i+1; }
if ($rowi[''partner_successful''] == ''1'' && $rowis[''successful''] == ''1''){ $i = $i+1; }
$tmp = array(
''id'' => $r[''id''],
''introduction_title''=> $r[''introduction_title''],
''image_1''=> $r[''image_1''],
''body_type''=> $r[''body_type''],
''occupation''=> $r[''occupation''],
''sdate''=> $r[''sdate''],
''age''=> $r[''age''],
''personality''=> $r[''personality''],
''username''=> $r[''username''],
''match''=> $i
);
$result[$e++] = $tmp;
}
// pass the results to the template
$smarty->assign(''result'', $result);
[/PHP]
Cheers,
Adamsql = mysql_query("select * from users WHERE
stored AND status=''active''");
countrows = mysql_num_rows(