check array values exist in mysql table

Question

I need to check the array values which contains more than 400 values which is existing in the MySQL table where i should get result for all the values which I am passing even if it not exist in the column.

for example:

cont table
----------
Column1                  
---------             

9xxxxxxxxx

91xxxxxxxx

92xxxxxxxx

my array contains 9xxxxxxxxx & 91xxxxxxxx. How can i iterate to get the column exist or not.

I tried with foreach and building query

$sql = 'SELECT cont WHERE num IN(';

foreach($jsonString as $val){ 

$sql = $sql . "'$val', ";

echo $val;

}

if(mysqli_query($con,$sql)){  
    echo "exist";
}else {
    echo "error";
}

Is there any efficient way other than the above which is faster in time?

what is this?if(mysqli_query($con,$sql)){ echo "exist"; }else { echo "error"; } — madankundu
– madankundu, Commented Nov 17, 2016 at 12:35
You will always have a trailing comma and space at the end of the sql statement. You would be better off imploding the array implode( ',', $jsonString ) — Blinkydamo
– Blinkydamo, Commented Nov 17, 2016 at 12:42

devpro · Accepted Answer · 2016-11-17 12:42:35Z

4

First of all if cont is your table name than where is FROM keyword.

If cont is column name than where is TABLE name?

As per your question, you have 400+ ids, than why are you using loop here? you can simply use implode() with comma seperated values, like

<?php
$ids = implode(",",$jsonString);
$sql = "SELECT * FROM cont WHERE num IN ($ids)"; // assuming cont is table name
?>

In your loop you will get the "," in last iteration at the end this will break your query.

answered Nov 17, 2016 at 12:42

devpro

16.1k3 gold badges29 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

check array values exist in mysql table

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