Discuz! X 数据库SQL查询语句例程 获取所有已启用(可用)的表情代码并返回单维索引数组

璁哄潧

1. <?php
   
2. require './source/class/class_core.php';
   
3. C::app()->init();
   
4. 
   
5. function get_global_available_smiley_code(){        //获取所有已启用的表情代码并返回数组
   
6. $return = array();
   
7. foreach(DB::fetch_all('SELECT typeid from '.DB::table('forum_imagetype').' WHERE type=\'smiley\' AND available=1') as $value){
   
8.         foreach(DB::fetch_all('SELECT code FROM '.DB::table('common_smiley').' WHERE type=\'smiley\' AND typeid='.$value['typeid']) as $value2){
   
9.                 array_push($return,$value2['code']);
   
10.         }
    
11. }
    
12. return $return;
    
13. }
    
14. 
    
15. print_r(get_global_available_smiley_code());
    
16. ?>

复制代码

返回:

1. 
   
2. Array ( [0] => {:1_1:} [1] => {:1_2:} [2] => {:1_3:} [3] => {:1_4:} [4] => {:1_5:} [5] => {:1_6:} [6] => {:1_7:} [7] => {:1_8:} [8] => {:1_9:} [9] => {:1_10:} [10] => {:1_11:} [11] => {:1_12:} [12] => {:1_13:} [13] => {:1_14:} [14] => {:1_15:} [15] => {:1_16:} [16] => {:1_17:} [17] => {:1_18:} [18] => {:1_19:} [19] => {:1_20:} [20] => {:1_21:} [21] => {:1_22:} [22] => {:1_23:} [23] => {:1_24:} [24] => {:2_25:} [25] => {:2_26:} [26] => {:2_27:} [27] => {:2_28:} [28] => {:2_29:} [29] => {:2_30:} [30] => {:2_31:} [31] => {:2_32:} [32] => {:2_33:} [33] => {:2_34:} [34] => {:2_35:} [35] => {:2_36:} [36] => {:2_37:} [37] => {:2_38:} [38] => {:2_39:} [39] => {:2_40:} [40] => {:3_41:} [41] => {:3_42:} [42] => {:3_43:} [43] => {:3_44:} [44] => {:3_45:} [45] => {:3_46:} [46] => {:3_47:} [47] => {:3_48:} [48] => {:3_49:} [49] => {:3_50:} [50] => {:3_51:} [51] => {:3_52:} [52] => {:3_53:} [53] => {:3_54:} [54] => {:3_55:} [55] => {:3_56:} [56] => {:3_57:} [57] => {:3_58:} [58] => {:3_59:} [59] => {:3_60:} [60] => {:3_61:} [61] => {:3_62:} [62] => {:3_63:} [63] => {:3_64:} )
   

复制代码