medoo::replace PHP Method

replace() public method

public replace ( $table, $columns, $search = null, $replace = null, $where = null )
    public function replace($table, $columns, $search = null, $replace = null, $where = null)
    {
        if (is_array($columns)) {
            $replace_query = array();
            foreach ($columns as $column => $replacements) {
                foreach ($replacements as $replace_search => $replace_replacement) {
                    $replace_query[] = $column . ' = REPLACE(' . $this->column_quote($column) . ', ' . $this->quote($replace_search) . ', ' . $this->quote($replace_replacement) . ')';
                }
            }
            $replace_query = implode(', ', $replace_query);
            $where = $search;
        } else {
            if (is_array($search)) {
                $replace_query = array();
                foreach ($search as $replace_search => $replace_replacement) {
                    $replace_query[] = $columns . ' = REPLACE(' . $this->column_quote($columns) . ', ' . $this->quote($replace_search) . ', ' . $this->quote($replace_replacement) . ')';
                }
                $replace_query = implode(', ', $replace_query);
                $where = $replace;
            } else {
                $replace_query = $columns . ' = REPLACE(' . $this->column_quote($columns) . ', ' . $this->quote($search) . ', ' . $this->quote($replace) . ')';
            }
        }
        return $this->exec('UPDATE "' . $table . '" SET ' . $replace_query . $this->where_clause($where));
    }

Usage Example

コード例 #1
0
ファイル: Medoo.php プロジェクト: larryli/ipv4-medoo
 /**
  * @param $table
  * @param $columns
  * @param null $search
  * @param null $replace
  * @param null $where
  * @return bool|int
  */
 public function replace($table, $columns, $search = null, $replace = null, $where = null)
 {
     return parent::replace($this->prefix . $table, $columns, $search, $replace, $where);
 }
All Usage Examples Of medoo::replace