dongtiao2976 2018-01-29 05:56
浏览 21
已采纳

否则如果不工作,如果总是返回true,则选择其他选项

I make a function to return int based on COUNT, but else if not working. Could I miss something?

   function kv_get_task_count() {
    global $wpdb;


            if (filter_status('new')):
                $count_post = (int) $wpdb->get_var( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'posts
                                            WHERE post_type ="screening"
                                                AND post_status ="new"
                                            ' );
            elseif (filter_status('pending_review')): 
                $count_post =  (int) $wpdb->get_var( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'posts
                                            WHERE post_type ="screening"
                                                AND post_status ="pending_review"
                                            ' );
            else:
                $count_post =  (int) $wpdb->get_var( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'posts
                                            WHERE post_type ="screening"
                                                AND post_status ="new"
                                                OR post_status ="pending_review"
                                            ' );
            endif;  

            return $count_post;
}
  • 写回答

1条回答 默认 最新

  • doucheng9634 2018-01-29 07:20
    关注

    QUESTION CLOSE !!

    I change my code to:

       function kv_get_task_count() {
        global $wpdb;
    
    
                if ($_REQUEST['post_status'] == 'new'):
                    $count_post = (int) $wpdb->get_var( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'posts
                                                WHERE post_type ="screening"
                                                    AND post_status ="new"
                                                ' );
                elseif ($_REQUEST['post_status'] == 'pending_review'): 
                    $count_post =  (int) $wpdb->get_var( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'posts
                                                WHERE post_type ="screening"
                                                    AND post_status ="pending_review"
                                                ' );
                else:
                    $count_post =  (int) $wpdb->get_var( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'posts
                                                WHERE post_type ="screening"
                                                    AND post_status ="new"
                                                    OR post_status ="pending_review"
                                                ' );
                endif;  
    
                return $count_post;
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 yolov8边框坐标
  • ¥15 matlab中使用gurobi时报错
  • ¥15 WPF 大屏看板表格背景图片设置
  • ¥15 这个主板怎么能扩出一两个sata口
  • ¥15 不是,这到底错哪儿了😭
  • ¥15 2020长安杯与连接网探
  • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
  • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
  • ¥16 mybatis的代理对象无法通过@Autowired装填
  • ¥15 可见光定位matlab仿真