Verify

get_var( $wpdb->prepare( “SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key=’reference’ AND meta_value=%s”, $ref ) ); if ($post_id) { $status = get_post_meta($post_id, ‘_application_status’, true); echo “

Registration Verified

“; echo “

Reference ID: {$ref}

“; echo “

Status: “.ucfirst($status).”

“; } else { echo “

Invalid Reference

No registration found for this QR code.

“; } } else { echo “

No Reference Provided

“; } ?>