Check user id Already exist in database Mysql

Question

I want to Check if User id is already exist in database print false

$token  = "token";
 $data = json_decode(get_html("https://graph.facebook.com/$user->id&access_token=$token"))->data;

  $id = echo "".$user->id;
  $result = mysql_query("SELECT * FROM token_all WHERE id = $id"); 
 while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
 $checkid = row[id];
  }
  if ($id == $checkid){
echo "true";
 }else{
echo "false";
 }

I don't think this code runs. Please provide a working version of the code. — Sohaib, Dec 10 '15 at 08:36
i want to get Facebook graph user id and check is already exist or not — Anil, Dec 10 '15 at 08:43

Alex Andrei · Accepted Answer · 2015-12-10T09:11:26.930

0

Just do a count and test if you get any results.
If you get results you already have the id in the database,
if you don't get any results the id is not there.

Also I removed $id = echo "" . $user->id; since we can use $user->id directly in the query.

One more thing, you should steer away from the mysql_* api since it has been deprecated and move towards mysqli_* or better PDO.

$token  = "token";
$data = json_decode(get_html("https://graph.facebook.com/$user->id&access_token=$token"))->data;

$result = mysql_query("SELECT * FROM token_all WHERE id = " . $user->id); 
$count = mysql_num_rows($result); // edited here

if ($count > 0){
    echo "ID already exists";
}else{
    echo "ID doesn't exist";
}

edited Dec 10 '15 at 09:11

answered Dec 10 '15 at 08:49

Alex Andrei

7,315
3
28
42

I edited a line, had a mistake in it, take a look again – Alex Andrei Dec 10 '15 at 09:12
Showing only true value – Anil Dec 10 '15 at 09:24
which one is the `true`, it exists or not? verify the query on your database and see how many users you have with that id. – Alex Andrei Dec 10 '15 at 09:27
Evey user have his own user Use deterrent ids – Anil Dec 10 '15 at 14:26
Evey User have his own id i am using his facebook user id Ex.,1100000454845 – Anil Dec 10 '15 at 14:37

score 0 · Answer 2 · answered Dec 10 '15 at 08:50

your code has bugs, try this:

    $token  = "token";
 $data = json_decode(get_html("https://graph.facebook.com/$user->id&access_token=$token"))->data;

  $id = $user->id;
  $result = mysql_query("SELECT * FROM token_all WHERE id = $id"); 
 while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
 $checkid = $row['id'];
  }
  if ($id == $checkid){
echo "true";
 }else{
echo "false";
 }

score 0 · Answer 3 · answered Dec 10 '15 at 08:50

0

why the double check? if your sql returns a result the id exists.

$id = $user->id;

$result = mysql_query("SELECT * FROM token_all WHERE id = '" . $id . "'"); 
if (mysql_num_rows($result) > 0)
{
    echo 'TRUE';
}
else
{
    echo 'FALSE';
}

answered Dec 10 '15 at 08:50

Bjoern

23
6

score 0 · Answer 4 · answered Dec 10 '15 at 09:20

To check if id already exists in db you just need to check its count. Please check the following code.

 $token  = "token";
 $data = json_decode(get_html("https://graph.facebook.com/$user->id&access_token=$token"))->data;

 $id = echo "".$user->id;
 $result = mysql_query("SELECT * FROM token_all WHERE id = $id"); 

 $count_user=mysql_num_rows($result); // this will give you the count

 if($count_user >= 1 ) { // if this id is already present in the db
     echo "user already exists";
 }
 else {
     echo "user not exists";
 }

Check user id Already exist in database Mysql

4 Answers4