note 114445 added to pdo.prepared-statements

/** Добавить модификации документа */ 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(); } } ---- Server IP: 195.54.192.44 Probable Submitter: 195.144.216.37 ---- Manual Page -- http://php.net/manual/en/pdo.prepared-statements.php Edit -- https://master.php.net/note/edit/114445 Del: integrated -- https://master.php.net/note/delete/114445/integrated Del: useless -- https://master.php.net/note/delete/114445/useless Del: bad code -- https://master.php.net/note/delete/114445/bad+code Del: spam -- https://master.php.net/note/delete/114445/spam Del: non-english -- https://master.php.net/note/delete/114445/non-english Del: in docs -- https://master.php.net/note/delete/114445/in+docs Del: other reasons-- https://master.php.net/note/delete/114445 Reject -- https://master.php.net/note/reject/114445 Search -- https://master.php.net/manage/user-notes.php