PHP/MYSQL validate

Question

just a simple question. How can I show 1 specific error from this?

$search_query = mysql_query("SELECT * FROM users WHERE username = '$username' OR email = '$email'");
$num_row = mysql_num_rows($search_query);
if($num_row >= 1){
    $errors['username'] = "username is unavailable.";
    $errors['email'] = "Email address is unavailable.";
}else
{//insert.....

They both show the error, but not working with $username.

Just can't figure it out.

And if it's not asking too much, can you please add if the username/email is available?

Thanks in advance.

I'll put the $errors after the input tag:

                    <p>username:</p>
                    <input type="text" name="username" id="username" value="<?php if(isset($_POST['username'])){echo $_POST['username'];} ?>">
                    <?php if(isset($errors['username'])){echo "<h5>" .$errors['username']. "</h5>"; } ?></td>
            </tr>
                <td><p>email:</p>
                    <input type="text" name="email" id="email" value="<?php if(isset($_POST['email'])){echo $_POST['email'];} ?>">
                    <?php if(isset($errors['email'])){echo "<h5>" .$errors['email']. "</h5>"; } ?></td>
            </tr>

any errors from error reporting? and look at your html source and check for errors on the query — Funk Forty Niner
– Funk Forty Niner, Commented Jan 22, 2017 at 18:58
Do you mean you want to know which column matched? e.g. what is unavailable. — chris85
– chris85, Commented Jan 22, 2017 at 19:47
Select your 2 columns and do a check in PHP, or you do do a case in mysql. — chris85
– chris85, Commented Jan 23, 2017 at 4:21

M Maavia · Accepted Answer · 2017-01-22 19:46:52Z

3

 mysql_query() or die(mysql_error());

like

$search_query = mysql_query("SELECT * FROM users WHERE username = '$username' OR email = '$email'") or die(mysql_error());

And

  $num_row = mysql_num_rows($search_query)or die(mysql_error());

answered Jan 22, 2017 at 19:46

M Maavia

3401 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP/MYSQL validate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related