分類信息字段中的選擇和多選的數(shù)據(jù)庫表，123替換

roc29a

$tid=任意帖子ID;
pre_forum_typeoptionvar表：$typeoption = DB::fetch_all("SELECT rules FROM %t WHERE optionid > %d", array('forum_typeoption', 6));
pre_forum_typeoptionvar表：$typeoptionvar = DB::fetch_all("SELECT value FROM %t WHERE tid = %d", array('forum_typeoptionvar', $tid));
pre_forum_optionvalue1表：$optionvalue1= DB::fetch_first("SELECT * FROM %t WHERE tid = %d", array('forum_optionvalue1', $tid));
這時$typeoption的選擇和多選的字段對應(yīng)的元素中會出現(xiàn)1=xx2=yy3=zz還有其他不知道什么碼包圍。$typeoptionvar和$optionvalue1的選擇和多選的元素中會有某個選項1或2或3或23或13或23或123等等。其實123就是代表值，怎么能讓這兩個變量$typeoptionvar和$optionvalue1，1替換為xx，2替換為yy，3替換為zz等等

roc29a

roc29a 發(fā)表于 2023-9-27 08:53
$tid=任意帖子ID;
pre_forum_typeoptionvar表：$typeoption = DB::fetch_all("SELECT rules FROM %t WHERE  ...

這是一個PHP處理數(shù)組的問題

roc29a

科站網(wǎng) 發(fā)表于 2023-9-27 08:37
直接寫一個插件不就完事了

正是在寫插件代碼，可是不大會

科站網(wǎng)

roc29a 發(fā)表于 2023-9-27 09:08
正是在寫插件代碼，可是不大會

定制或者開發(fā)文檔：https://www.discuzlab.com/x-docs/develop/dev.html

酷畫創(chuàng)意

roc29a 發(fā)表于 2023-9-27 08:29
帖子內(nèi)容頁的內(nèi)容能調(diào)到門戶文章內(nèi)嗎？想把帖子的分類信息模板和內(nèi)容調(diào)到文章里去。我這是在走數(shù)據(jù)庫表去 ...

打擾，再見！

roc29a

酷畫創(chuàng)意 發(fā)表于 2023-9-27 09:19
打擾，再見！

想把發(fā)帖投稿到文章中去，有這個插件，但不能滿足分類信息投稿到文章，是在解決這個問題。并不是DIY調(diào)用帖子。感謝參與我的問題，剛才說的急，冒犯了。

roc29a

科站網(wǎng) 發(fā)表于 2023-9-27 09:15
定制或者開發(fā)文檔：https://www.discuzlab.com/x-docs/develop/dev.html

只需處理數(shù)組問題就行了，需要PHP知識處理，我匱乏這方面知識。感謝大力支持

roc29a

rules部分：[rules]={1=xx2=yy3=zz}
value部分：[value]={123}
某字段值：[字段]={123}
需求結(jié)果：
value部分：[value]={xx,yy,zz}
某字段值：[字段}={xx,yy,zz}

roc29a

<!-- forum_typeoption表中所有1 = xx 2 = yy 3 = zz更改為 [rules]xx yy zz -->
$typeoption = DB::fetch_all("SELECT optionid,rules FROM %t WHERE optionid > %d", array('forum_typeoption', 6));
$typeoptionvar = DB::fetch_all("SELECT optionid,value FROM %t WHERE tid = %d", array('forum_typeoptionvar', $tid));
//取出含數(shù)字字符串中最大的數(shù)字
function extractMaxNumber($str) {
  $maxNumber = '';
  $isNumber = false;
  for ($i = 0; $i < strlen($str); $i++) {
    if (is_numeric($str[$i])) {
      if (!$isNumber) {
        $maxNumber = $str[$i];
        $isNumber = true;
      } else {
        $maxNumber .= $str[$i];
      }
    } else {
      $isNumber = false;
    }
  }
  return (int) $maxNumber;
}
//$typeoption的[rules],$choices分割成數(shù)組
foreach ($typeoption as $keys => $types) {
  if (strpos($types[rules], 'choices') !== false) {//$typeoption找出選擇和多選的rules
    $choices[$keys][rules]=$types[rules];
    $optionids[$keys]=$types[optionid];
    $optionids=array_values($optionids);
    $choices[$keys][rules]=strstr($choices[$keys][rules],'1 = ');
    $choices[$keys][rules]=strstr($choices[$keys][rules],'"',true);//把數(shù)組截取
      for($i=1;$i<=extractMaxNumber($choices[$keys][rules]);$i++){
        $choices[$keys][rules]=str_replace("$i = ", ",$i=", $choices[$keys][rules]);
      }
    $choices[$keys][rules]=substr($choices[$keys][rules],1);//去除第一個字符
    $choices[$keys][rules]=explode(",",$choices[$keys][rules]);//字符串分割成數(shù)組
    $typeoption[$keys][rules]=$choices[$keys][rules];
  }
}

//$typeoptionvar，$optionids數(shù)組里的$choice分割成數(shù)組并替換
foreach ($typeoptionvar as $key => $type){
  if (in_array($type[optionid], $optionids)){
    $choice[$key][rules]=$type[value];
      for($i=1;$i<=extractMaxNumber($choice[$key][rules]);$i++){
        $choice[$key][rules]=preg_replace('/\s+/','', $choice[$key][rules]);
      }
    $choice[$key][rules]=str_split($choice[$key][rules]);
    //把$choice最底層數(shù)組含數(shù)字元素替換成對應(yīng)的$choices含有數(shù)字的元素并去除數(shù)字和=
    foreach($choice[$key][rules] as $tion => $rule){
      foreach($choices[$key][rules] as $tions => $rules){
        if (strpos($rules, "$rule") !== false) {
          $choice[$key][rules][$tion]=$choices[$key][rules][$choice[$key][rules][$tion]-1];
        }
      }
      for($i=1;$i<=extractMaxNumber($choice[$key][rules][$tion]);$i++){
        $choice[$key][rules][$tion]=str_replace("$i=", " ", $choice[$key][rules][$tion]);
      }
      
      
    }
    $choice[$key][rules]=implode(" ", $choice[$key][rules]);
    $typeoptionvar[$key][value]=$choice[$key][rules];
  }
}

roc29a

roc29a 發(fā)表于 2023-10-6 09:34
$typeoption = DB::fetch_all("SELECT optionid,rules FROM %t WHERE optionid > %d", array('forum_typeo ...

1. <!-- forum_typeoption表中所有1 = xx 2 = yy 3 = zz更改為 [rules]xx yy zz -->
   
2. $typeoption = DB::fetch_all("SELECT optionid,rules FROM %t WHERE optionid > %d", array('forum_typeoption', 6));
   
3. $typeoptionvar = DB::fetch_all("SELECT optionid,value FROM %t WHERE tid = %d", array('forum_typeoptionvar', $tid));
   
4. //取出含數(shù)字字符串中最大的數(shù)字
   
5. function extractMaxNumber($str) {
   
6.   $maxNumber = '';
   
7.   $isNumber = false;
   
8.   for ($i = 0; $i < strlen($str); $i++) {
   
9.     if (is_numeric($str[$i])) {
   
10.       if (!$isNumber) {
    
11.         $maxNumber = $str[$i];
    
12.         $isNumber = true;
    
13.       } else {
    
14.         $maxNumber .= $str[$i];
    
15.       }
    
16.     } else {
    
17.       $isNumber = false;
    
18.     }
    
19.   }
    
20.   return (int) $maxNumber;
    
21. }
    
22. //$typeoption的[rules],$choices分割成數(shù)組
    
23. foreach ($typeoption as $keys => $types) {
    
24.   if (strpos($types[rules], 'choices') !== false) {//$typeoption找出選擇和多選的rules
    
25.     $choices[$keys][rules]=$types[rules];
    
26.     $optionids[$keys]=$types[optionid];
    
27.     $optionids=array_values($optionids);
    
28.     $choices[$keys][rules]=strstr($choices[$keys][rules],'1 = ');
    
29.     $choices[$keys][rules]=strstr($choices[$keys][rules],'"',true);//把數(shù)組截取
    
30.       for($i=1;$i<=extractMaxNumber($choices[$keys][rules]);$i++){
    
31.         $choices[$keys][rules]=str_replace("$i = ", ",$i=", $choices[$keys][rules]);
    
32.       }
    
33.     $choices[$keys][rules]=substr($choices[$keys][rules],1);//去除第一個字符
    
34.     $choices[$keys][rules]=explode(",",$choices[$keys][rules]);//字符串分割成數(shù)組
    
35.     $typeoption[$keys][rules]=$choices[$keys][rules];
    
36.   }
    
37. }
    
38. 
    
39. //$typeoptionvar，$optionids數(shù)組里的$choice分割成數(shù)組并替換
    
40. foreach ($typeoptionvar as $key => $type){
    
41.   if (in_array($type[optionid], $optionids)){
    
42.     $choice[$key][rules]=$type[value];
    
43.       for($i=1;$i<=extractMaxNumber($choice[$key][rules]);$i++){
    
44.         $choice[$key][rules]=preg_replace('/\s+/','', $choice[$key][rules]);
    
45.       }
    
46.     $choice[$key][rules]=str_split($choice[$key][rules]);
    
47.     //把$choice最底層數(shù)組含數(shù)字元素替換成對應(yīng)的$choices含有數(shù)字的元素并去除數(shù)字和=
    
48.     foreach($choice[$key][rules] as $tion => $rule){
    
49.       foreach($choices[$key][rules] as $tions => $rules){
    
50.         if (strpos($rules, "$rule") !== false) {
    
51.           $choice[$key][rules][$tion]=$choices[$key][rules][$choice[$key][rules][$tion]-1];
    
52.         }
    
53.       }
    
54.       for($i=1;$i<=extractMaxNumber($choice[$key][rules][$tion]);$i++){
    
55.         $choice[$key][rules][$tion]=str_replace("$i=", " ", $choice[$key][rules][$tion]);
    
56.       }
    
57.       
    
58.       
    
59.     }
    
60.     $choice[$key][rules]=implode(" ", $choice[$key][rules]);
    
61.     $typeoptionvar[$key][value]=$choice[$key][rules];
    
62.   }
    
63. }

復(fù)制代碼