Rsa97

const has = (object, key) => (key in object);
const gendiff = (file1, file2) => {
  const mergeFiles = { ...file1, ...file2 };

  const uniqueKeys = Object.keys(mergeFiles);

  const diff = uniqueKeys.map(key => {
    if (has(file1, key) && has(file2, key) && typeof file1[key] === 'object' && typeof file2[key] === 'object') {
      return { key, value: gendiff(file1[key], file2[key]), status: 'have a child' };
    } else if (has(file1, key) && has(file2, key) && file1[key] !== file2[key]) {
      return { key, value: { oldValue: file1[key], newValue: file2[key] }, status: 'changed' };
    } else if (has(file1, key) && !has(file2, key)) {
      return { key, value: file1[key], status: 'removed' };
    } else if (!has(file1, key) && has(file2, key)) {
      return { key, value: file2[key], status: 'new' };
    } else if (has(file1, key) && has(file2, key) && file1[key] === file2[key]) {
      return { key, value: file1[key], status: 'same' };
    }
  });
  
  return diff;
};

console.log(gendiff(
  { workshop: { data: '2.0000000', locales: 'zh-CN.pak' } },
  { workshop: { config: 'd7', locales: 'am.pak' } }
));

/*
[
  {
    key: "workshop",
​​    status: "have a child",
​​    value: [
​​​      { key: "data", value: "2.0000000", status: "removed" },
​​​      {
        key: "locales",
​​​​        status: "changed",
        value: { oldValue: "zh-CN.pak", newValue: "am.pak" },
​​​​      },
      { key: "config", value: "d7", status: "new" },
​​​    ],
  },
]
*/

SELECT COUNT(*) + 1 AS `position`
  FROM `table` 
  WHERE `RATING` > (
    SELECT `RATING`
      FROM `table`
      WHERE `NAME` = :name
      LIMIT 1
  )

SELECT AVG(`age`)
  FROM `CUSTOMER`
  WHERE `CUSTOMER_KEY` IN (
    SELECT `CUSTOMER_KEY`
      FROM `PURCHACE`
      WHERE `PRODUCT_KEY` IN (
        SELECT `PRODUCT_KEY`
          FROM `PRODUCT`
          WHERE `NAME` = 'плюшевый мишка'
      ) AND `DATE` BETWEEN '2018-01-01' AND '2018-12-31'
  )

SELECT AVG(`age`)
  FROM (
    SELECT DISTINCT `c`.`CUSTOMER_KEY`, `c`.`AGE` AS `age`
      FROM `PRODUCT` AS `p`
      JOIN `PURCHACE` AS `pu`
        ON `p`.`NAME` = 'плюшевый мишка'
        AND `pu`.`DATE` BETWEEN '2018-01-01' AND '2018-12-31'
        AND `pu`.`PRODUCT_KEY` = `p`.`PRODUCT_KEY`
      JOIN `CUSTOMER` AS `c`
        ON `c`.`CUSTOMER_KEY` = `pu`.`CUSTOMER_KEY`
  ) AS `t`

Данный модуль устарел, начиная с версии PHP 5.5.0, и удалён в PHP 7.0.0. Используйте вместо него MySQLi или PDO_MySQL.

<percentage>
The percentage is calculated with respect to the width of the generated box's containing block. Note that this is true for 'margin-top' and 'margin-bottom' as well. If the containing block's width depends on this element, then the resulting layout is undefined in CSS 2.1.

Percentages: refer to logical width of containing block

const sectionHtml = await fetch('hello.html');
document.querySelector('.top-section').innerHTML += await sectionHtml.text();