Thread

Does anyone know how I could check whether a username that is in segment_2 is actually a legitimate username?  And, if it isn’t, how to redirect to a 404?

I’ve got the query module checking the DB, but I can’t seem to get the logic correct if it returns nothing.

{exp:query sql="SELECT exp_members.username AS query_username
                FROM exp_members
                WHERE '{segment_2}' = exp_members.username;"}
                {query_username}
{/exp:query}

Thank you!

What do you mean by can’t get the logic correct when it returns nothing?

Have you tried using the {if no_results} tag pair?

Best wishes,

Mark

Geez… thanks Mark.  I’m not sure how I missed that!

I did all sorts of stuff trying conditionals and php…

Anyhow- here’s the code that is currently working to check if {segment_3} is a valid username.  If not, it redirects to a 404.

{exp:query sql="
    SELECT  exp_members.username AS query_username
        FROM exp_members
        WHERE '{segment_3}' = exp_members.username
"}

{if no_results}
    {redirect="404"}
{/if}

{/exp:query}

Big thanks to Mark Bowen for pointing out the {if no_results} 😊

Geez… thanks Mark.  I’m not sure how I missed that!

I did all sorts of stuff trying conditionals and php…

Excellent news. Glad that got it working for you.

Best wishes,

Mark