This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| https://www.codeproject.com/Articles/231132/Difference-between-And-clause-along-with-on-and-Wh | |
| */ | |
| +--------+---------------+ | |
| | DeptId | DeptName | | |
| +--------+---------------+ | |
| | 1 | HR | | |
| | 2 | Payroll | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- static | |
| SELECT | |
| product_id, | |
| SUM(CASE WHEN month = 'January' THEN sales_amount ELSE 0 END) AS January, | |
| SUM(CASE WHEN month = 'February' THEN sales_amount ELSE 0 END) AS February, | |
| SUM(CASE WHEN month = 'March' THEN sales_amount ELSE 0 END) AS March | |
| FROM sales | |
| GROUP BY product_id; | |
| -- dynamic |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE `standing` ( | |
| `team` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', | |
| `pts` INT(11) NULL DEFAULT NULL, | |
| `season` INT(11) NULL DEFAULT NULL | |
| ) | |
| COLLATE='utf8mb4_general_ci' | |
| ENGINE=MyISAM | |
| ; | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- 1 | |
| SELECT 'Mon' | |
| UNION | |
| SELECT 'Tue' | |
| UNION | |
| SELECT 'Web' | |
| UNION | |
| SELECT 'Thu' | |
| UNION |
Kcko
/ index.html
Created
February 20, 2024 08:27
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!-- | |
| - https://www.youtube.com/watch?v=sxxUK0l8jKE | |
| - https://play.tailwindcss.com/4cuLPqCv05 | |
| --> | |
| <div class="p-20 flex justify-center items-center gap-12"> | |
| <img class="avatar-sm" src="https://res.cloudinary.com/thirus/image/upload/v1705061543/images/avatar.png" alt="" /> | |
| <img class="avatar" src="https://res.cloudinary.com/thirus/image/upload/v1705061543/images/avatar.png" alt="" /> | |
| <img class="avatar-lg" src="https://res.cloudinary.com/thirus/image/upload/v1705061543/images/avatar.png" alt="" /> | |
| <img class="avatar-xl" src="https://res.cloudinary.com/thirus/image/upload/v1705061543/images/avatar.png" alt="" /> |
Kcko
/ IconListPresenter.php
Last active
February 5, 2024 11:37
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| class IconListPresenter extends \App\Presenters\BasePresenter | |
| { | |
| /** | |
| * @var Context | |
| * @inject | |
| */ | |
| public $connection; | |
| public function actionDefault() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /* | |
| https://www.nidup.io/blog/manipulate-google-sheets-in-php-with-api | |
| */ | |
| require './vendor/autoload.php'; | |
| // configure the Google Client |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Adjustable grid */ | |
| .grid { | |
| --column-count: 3; | |
| display: grid; | |
| grid-template-columns: repeat(var(--column-count), 1fr); | |
| } | |
| /* modifiers */ | |
| .grid-3 { --column-count: 3; } | |
| .grid-4 { --column-count: 4; } |
Kcko
/ index.html
Created
January 8, 2024 07:49
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8" /> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0" /> | |
| <title>Document</title> | |
| </head> | |
| <body> | |
| <button>CLICK ME</button> | |
Kcko
/ delete-recursively-from-child.php
Last active
January 5, 2024 11:41
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| private function deleteDuplicateRecursive(Tables\Navigation $duplicateItem) | |
| { | |
| /* | |
| // OLD | |
| $findDescendants = function(Tables\Navigation $parent, array $stack = [], $level = 1) use (&$findDescendants) { | |
| $children = $this->navigation->getAdjacencyList($parent->domain_id)->getChildren($parent->id); | |
| foreach ($children as $child) { |