Skip to content

Instantly share code, notes, and snippets.

View aalipar13's full-sized avatar

aalipar13

View GitHub Profile
@aalipar13
aalipar13 / missing-date.php
Created July 31, 2019 06:18
PHP - add missing date in array (from: https://stackoverflow.com/questions/46380370/add-missing-date-index-to-array-in-php)
<?php
$arr = [
['date' => '2019-07-31', 'total' => 4],
['date' => '2019-08-04', 'total' => 6],
['date' => '2019-08-05', 'total' => 7]
];
$result = [];
foreach ($arr as $k => $item) {
@aalipar13
aalipar13 / delete-duplicates.sql
Created September 25, 2019 07:42
SELECT
title, COUNT(title)
FROM
cities
GROUP BY
title
HAVING
COUNT(title) > 1;
DELETE t1 FROM cities t1