Custom Formdata matching with user table

Question

Custom Formdata matching with user table

Amar Verma

2020年3月19日 13:01

I am writing a code to match form input data with user table in wp, but its not working proper, either condition is true or false, its giving same message. please help me to resolve it.

  function email_form_code() {
    echo 'form action="' . esc_url( $_SERVER['REQUEST_URI'] ) . '" method="post"';
    echo 'p';
    echo 'p';
    echo 'Your Email (required) br /';
    echo 'input type="email" name="email" value="' . ( isset( $_POST["email"] ) ? esc_attr( $_POST["email"] ) : '' ) . '" size="40" /';
    echo '/p';
    echo 'pinput type="submit" name="submit" value="Send"//p';
    echo '/form';
}

function checkpoint_email() {
    global $wpdb;
    if(isset($_POST['submit'])){
    $email = sanitize_email($_POST['email']);
    if(!is_email($email)) {
        echo 'div class="error"pInvalid e-mail!/p/div';
     }
    $datum = $wpdb-get_results("SELECT COUNT(*) FROM wp8p_users WHERE $current_user-user_email = $email");
    if($datum  0) {
       echo "Email Verified";
    }
    else {
         echo "Email Not Verified";
    }   
}
}
function ec_shortcode() {
    ob_start();
    checkpoint_email();
    email_form_code();
    return ob_get_clean();
}
add_shortcode( 'av_email_cform', 'ec_shortcode' );
?

Topic input forms plugins Wordpress

Category Web

Tom J Nowell · Accepted Answer · 2020年3月19日 13:01

Your conditional check is the wrong way around, it should be > not <.

But more importantly, why are you doing a raw SQL query at all, just use the standard functions, e.g. get_user_by:

$user = get_user_by( 'email', $email );
if ( !$user ) {
    // there is no user with that email
}

Also, submit is an incredibly generic name for a form input to check, use something more specific, like av_email_cform_submit.

You can also replace your action="' . esc_url( $_SERVER['REQUEST_URI'] ) . '" with action="". You also have a double <p><p> in your form.

Custom Formdata matching with user table

About