HuasoFoundries / phpPgAdmin6

        // Populate the syntax arrays

        reset($vars);

        //while (list($key, $value) = each($vars)) {

        foreach ($vars as $key => $value) {

            $this->fieldClean($key);

            $this->clean($value);

            if ($setClause) {

                $setClause .= ", \"{$key}\"='{$value}'";

            } else {

                $setClause = "UPDATE \"{$table}\" SET \"{$key}\"='{$value}'";

            }

        }

        reset($nulls);

        //while (list(, $value) = each($nulls)) {

        reset($where);

        //while (list($key, $value) = each($where)) {

        foreach ($where as $key => $value) {

            $this->fieldClean($key);

            $this->clean($value);

            if ($whereClause) {

                $whereClause .= " AND \"{$key}\"='{$value}'";

            } else {

                $whereClause = " WHERE \"{$key}\"='{$value}'";

            }

        }

        // Check for failures

        if (!$this->conn->Execute($setClause.$whereClause)) {