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

roc29a

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. //取出含數字字符串中最大的數字
   
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分割成數組
    
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);//把數組截取
    
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]);//字符串分割成數組
    
35.     $typeoption[$keys][rules]=$choices[$keys][rules];
    
36.   }
    
37. }
    
38. 
    
39. //$typeoptionvar，$optionids數組里的$choice分割成數組并替換
    
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最底層數組含數字元素替換成對應的$choices含有數字的元素并去除數字和=
    
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. }

復制代碼

roc29a

改進了一下，并把圖片的雜亂碼去掉

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

復制代碼