Exemple #1
0
 /**
  * U P D A T E
  */
 function doUpdate()
 {
     /* test if all keycolumn values are set */
     $uq = new UpdateQuery($this->dbConn, $this->relation);
     $uq->setKeyColumns($this->keyColumns);
     /* refill menu from post data */
     /* done in processResponse    $this->menu->setMenuValues($_POST); */
     $this->menu->prepareForUpdate($this->dbMessage);
     $cnames = $this->menu->getColumnNames();
     $arr = $this->menu->getColumnValues($cnames);
     $uq->setSubmitValueSet($arr);
     $uq->setUpdateSet($arr);
     if ($uq->areKeyColumnsSet()) {
         /* allow update */
         $query = $uq->getQuery();
         $result = doUpdate($this->dbConn, $query, $this->dbMessage);
         //$this->dbMessage .= $result . ' row(s) updated ' . $this->dbMessage;
     } else {
         $this->dbMessage .= "\n" . 'DB ERROR: Update failed.<br>Not all keyColumns have been set';
     }
 }