Where Clause ARRAY in PHP - MongoDB

Question

I have one problem for Where clause in PHP - MongoDB.

i search in this forum and obtain some information.

My code is :

$condizioneMongoDB = "array('chrom'=>'chr7' )";
$whereClause = eval("\$str = \"$condizioneMongoDB\";");
$retval = $collection->distinct("p_id", $whereClause);

The Where clause is completely ignored.

This static code work:

$retval = $collection->distinct("p_id", array('chrom'=>'chr7' ));

vp_arth · Accepted Answer · 2016-06-09 08:35:51Z

1

$whereClause = eval("\$str = \"$condizioneMongoDB\";");

it is equal to $str = "array('chrom'=>'chr7' )",
but you want $str = array('chrom'=>'chr7')

You should to omit quotes for this.

Also, you need to return value from eval to use it, or you can use variable from eval directly.

$condizioneMongoDB = "array('chrom'=>'chr7' )";
$whereClause = eval("return $condizioneMongoDB;");
$retval = $collection->distinct("p_id", $whereClause);

Or:

$condizioneMongoDB = "array('chrom'=>'chr7' )";
eval("\$whereClause = $condizioneMongoDB;");
$retval = $collection->distinct("p_id", $whereClause);

edited Jun 9, 2016 at 8:35

answered Jun 9, 2016 at 8:25

vp_arth

15k4 gold badges43 silver badges72 bronze badges

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

3 Comments

mydb Over a year ago

i don't know why but if i write var_dump($whereClause); i obtain NULL

vp_arth Over a year ago

I add explanation about this. You didn't return anything from eval.

mydb Over a year ago

the second option seems to work perfectly thank you very much

Paresh Gami · Accepted Answer · 2016-06-09 08:21:41Z

0

this line is looks wrong

$condizioneMongoDB = "array('chrom'=>'chr7' )";

Why are you putting array in double quotes? Change it like following

 $condizioneMongoDB = array('chrom'=>'chr7' );

answered Jun 9, 2016 at 8:21

Paresh Gami

4,7926 gold badges28 silver badges44 bronze badges

5 Comments

mydb Over a year ago

thank's for answer . I obtain this string by form . The line with eval transform in array

Paresh Gami Over a year ago

$collection->distinct is taking second argument as array not string so passing array in string it is not working any more

mydb Over a year ago

I transform in array with this line $whereClause = eval("\$str = \"$condizioneMongoDB\";");

Paresh Gami Over a year ago

after eval array is not display from assigned variable

mydb Over a year ago

yes sorry in this post i simplify the answer but i get in input a string

Collectives™ on Stack Overflow

Where Clause ARRAY in PHP - MongoDB

2 Answers 2

3 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related