note 114445 deleted from pdo.prepared-statements by cmb

Note Submitter: Anonymous ---- /** Добавить модификации документа */ public function insert_doc_modification($doc_id , array $notice ,array $modification_fields) { $fields = array_keys($modification_fields); $sql = "INSERT INTO doc_modification (doc_id , " . implode( ",", $fields ) . ") VALUES (:doc_id , :" . implode( ", :", $fields ) . " ) ON DUPLICATE KEY UPDATE hash = :hash ; "; $stmt = $this->pdo->prepare($sql); $stmt->bindParam(':doc_id',$doc_id); //Создать бинды по полям foreach($modification_fields as $name => $val) { $stmt->bindParam(':'.$name, $modification_fields[$name]); } //Обойти все модификации по документу foreach($notice as $value) { foreach($modification_fields as $name => $val) { if(empty($value[$name])) continue ; $modification_fields[$name] = $value[$name]; } $stmt->execute(); } }