mongodb error in using php [duplicate]

Question

i can try to update the attempt to login in mongodb but it can showing error in php with my sql i can use this code:

$columns = "";
  foreach($toUpdate as $k => $v){
    $columns .= "$k = :$k, ";
  }
  $columns = substr($columns, 0, -2); // Remove last ","

  $sql = $this->dbh->prepare("UPDATE user  SET {$columns} WHERE id=:id");
  $sql->bindValue(":id", $user);
  foreach($toUpdate as $key => $value){
    $value = htmlspecialchars($value);
    $sql->bindValue(":$key", $value);
  }

  $sql->execute();

in this code it can display no.of attempt to login..but can write this code in php with mongodb it can showing error

$columns = "";
  foreach($toUpdate as $k => $v){
    $columns .= "$k = :$k, ";
  }
  $columns = substr($columns, 0, -2); // Remove last ","

                        $collection=user;//table name;
                        $set = array('$set' =>array(array($columns)));
                        $m->$collection->update(array(id=>$user),$set);

  foreach($toUpdate as $key => $value)
  {
      var_dump($toUpdate);
    $value = htmlspecialchars($value);
    $m->$collection->update(array(id=>$value),$set);

  }

i can try many way but it show error ....this is error

Uncaught exception 'MongoWriteConcernException' with message 'localhost:27017: Modifiers operate on fields but we found type array instead. For example: {$mod: {: ...}} not {$set: [ [ "attempt = :attempt" ] ]})

any one can know how to solve this

it can also showing same error ( Uncaught exception 'MongoWriteConcernException' with message 'localhost:27017: Modifiers operate on fields but we found type array instead. For example: {$mod: {<field>: ...}} not {$set: [ [ "attempt = :attempt" ] ]}) — Smart Singam
– Smart Singam, Commented Jun 22, 2017 at 12:57
$collection=$this->config['db']['table'];//table name; $set = array('$set' =>array(array($columns))); $this->dbh->$collection->update(array($this->config["db"]["columns"]["id"]=>$user),$set); — Smart Singam
– Smart Singam, Commented Jun 22, 2017 at 12:57

Ryosaku · Accepted Answer · 2017-06-22 12:51:33Z

1

This error is given to you because you are passing an array of array to $set instead of an array of data:

$set = array('$set' =>array(array($columns)));

Try with this:

$set = array('$set' =>array($columns));

answered Jun 22, 2017 at 12:51

Ryosaku

4654 silver badges14 bronze badges

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

1 Comment

Smart Singam Over a year ago

it can also showing same error ( Uncaught exception 'MongoWriteConcernException' with message 'localhost:27017: Modifiers operate on fields but we found type array instead. For example: {$mod: {<field>: ...}} not {$set: [ [ "attempt = :attempt" ] ]})

Collectives™ on Stack Overflow

mongodb error in using php [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related