PHP SQL - can't find if user exists

Question

I'm trying to find if a user exists using this code:

$usercheck = "SELECT * FROM profiles WHERE username = '$user'";
$rs = mysqli_query($con,$usercheck);
$data = mysqli_fetch_array($rs, MYSQLI_NUM);

echo "<script> console.log('data=' + " . $data[0] . " + ''); </script>";

Data always returns 0 despite $user being equal to a name which already exists.

Any ideas?

Your query is open to SQL injection. What's the actual query being executed at runtime? If you do a var_dump() on $data, what is being returned by that query? What does $data[0] actually contain in the results? — David
– David, Commented Mar 5, 2017 at 15:59

ScaisEdge · Accepted Answer · 2017-03-05 16:59:16Z

1

try iterate on your result and show more that the first column (should be the first column of the firts row is 0

while ($row = mysqli_fetch_array($rs, MYSQL_NUM)) {
   printf("col0: %s  col1: %s", $row[0], $row[1]);  
}

or try refer to column name istead of column position

while ($row = mysqli_fetch_array($rs, MYSQL_NUM)) {
   printf("colUsername: %s  col1: %s", $row['userane']);  
}

edited Mar 5, 2017 at 16:59

answered Mar 5, 2017 at 15:59

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

1 Comment

Mikey Over a year ago

The OP is using MySQLi not MySQL.

user2852575 · Accepted Answer · 2017-03-05 15:56:40Z

0

Try to replace

$data[0]

database field name, like

$data['username']
echo "<script> console.log('data=' + " . $data['username'] . " + ''); </script>";

Hope it will works for you.

answered Mar 5, 2017 at 15:56

user2852575

Collectives™ on Stack Overflow

PHP SQL - can't find if user exists

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related