php - 分组数组值，如 mysqli 'like' 功能

Question

friend 们，我不知道这是否可能，无论如何我想将具有相同偏好名称(mysql'like'功能)的用户分组

[0]=>
 array(5) {
  ["id"]=>"21"
  ["user_id"]=>"58"
  ["preference_id"]=>"4"
  ["sub_preference_id"]=>"7"
  ["preference_name"]=>"stephens collage"
}
[1]=>
 array(5) {
  ["id"]=>"22"
  ["user_id"]=>"52"
  ["preference_id"]=>"4"
  ["sub_preference_id"]=>"1"
  ["preference_name"]=>"st stephens"
}
[2]=>
 array(5) {
  ["id"]=>"25"
  ["user_id"]=>"61"
  ["preference_id"]=>"4"
  ["sub_preference_id"]=>"9"
  ["preference_name"]=>"joseph"
}

意味着我想要这样的输出:

1]斯蒂芬拼贴画，圣斯蒂芬

2]约瑟夫

我试过这段代码:

$school_preference ="SELECT * FROM gic_user_preference where preference_id='4'";

$result_school_preference = mysqli_query($createCon->connect(), $school_preference);

$school = array();

 while ($show_school_preference = mysqli_fetch_assoc($result_school_preference)) {

    $school_preference = $show_school_preference['sub_preference_id'];

    $get_all_school_preference =mysqli_query($createCon->connect(),"SELECT gic_user_preference.id,gic_user_preference.user_id,gic_user_preference.preference_id,gic_user_preference.sub_preference_id,gic_user_wise_school_preference.preference_name FROM gic_user_preference INNER JOIN gic_user_wise_school_preference ON gic_user_preference.sub_preference_id = gic_user_wise_school_preference.id where gic_user_preference.sub_preference_id='$school_preference'");

    while ($schools = mysqli_fetch_assoc($get_all_school_preference)) {
        $school[$schools['preference_name']][] = $schools;
    }
 }

输出结果

 array(4) {
 ["stephens collage"]=>
 array(1) {
  [0]=>
  array(5) {
  ["id"]=>
  string(2) "21"
  ["user_id"]=>
  string(2) "58"
  ["preference_id"]=>
  string(1) "4"
  ["sub_preference_id"]=>
  string(1) "7"
  ["preference_name"]=>
  string(16) "stephens collage"
   }
 }
  ["st stephens"]=>
  array(1) {
   [0]=>
   array(5) {
  ["id"]=>
  string(2) "22"
  ["user_id"]=>
  string(2) "52"
  ["preference_id"]=>
  string(1) "4"
  ["sub_preference_id"]=>
  string(1) "1"
  ["preference_name"]=>
  string(11) "st stephens"
  }
 }
 ["joseph"]=>
 array(1) {
  [0]=>
   array(5) {
  ["id"]=>
  string(2) "25"
  ["user_id"]=>
  string(2) "61"
  ["preference_id"]=>
  string(1) "4"
  ["sub_preference_id"]=>
  string(1) "9"
  ["preference_name"]=>
  string(6) "joseph"
  }
 }
}

知道如何将这些数据分组为类似 mysqli 的函数吗...

Answer 1

我认为您可以使用正则表达式匹配来查找相同的名称!