最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

plugins - Wordpress Standard Fix Errors

programmeradmin0浏览0评论

I get the following error while fixing my wordpress plugin standards.

 Use placeholders and $wpdb->prepare(); found $sql

Below is my code...

public function get_db_value() {
    //getting meta_value from wp_usermeta
    global $wpdb;
    $billing_phone = isset($_POST['billing_phone']);
    $sql           = "
    SELECT  user_id,meta_key, meta_value
    FROM {$wpdb->usermeta} 
    WHERE ({$wpdb->usermeta}.meta_key = 'billing_phone'";
    $ansatte       = $wpdb->prepare($wpdb->get_results( $sql ));
    $users         = array();
    foreach ( $ansatte as $a ) {
        $users[ $a->user_id ][ $a->meta_key ] = $a->meta_value;
    }
    foreach ( $users as $u ) {
        $nums[] = $u['billing_phone']; //Saving phone numbers in $nums variable

    }
    return $nums;
}
发布评论

评论列表(0)

  1. 暂无评论