jQuery vs JavaScript
$(document).ready(function() {
// code…
});
document.addEventListener("DOMContentLoaded", function() {
// code…
});
SELECT id, username, score, | |
FIND_IN_SET( | |
score, (SELECT GROUP_CONCAT(DISTINCT score ORDER BY score DESC) FROM score) | |
) as rank | |
FROM scores; |
jQuery vs JavaScript
$(document).ready(function() {
// code…
});
document.addEventListener("DOMContentLoaded", function() {
// code…
});
/** | |
* Check whether an object is Array or not | |
* @type Boolean | |
* @param {object} subject is the variable that is | |
* tested for Array identity check | |
*/ | |
var isArray = (function () { | |
// Use compiler's own isArray when available | |
if (Array.isArray) { | |
return Array.isArray; |
<?php | |
$_SERVER[ 'HTTP_HOST' ] = 'localhost'; // or something like yourdomain.tld | |
require dirname(__DIR__) . '/config/bootstrap.php'; | |
use Cake\Network\Request; | |
use Cake\Network\Response; | |
use Cake\Routing\DispatcherFactory; | |
if(PHP_SAPI == "cli" && $argc == 2) { |
SET FOREIGN_KEY_CHECKS = 0; -- Disable foreign key checking. | |
TRUNCATE TABLE forums; | |
TRUNCATE TABLE dates; | |
TRUNCATE TABLE remarks; | |
SET FOREIGN_KEY_CHECKS = 1; -- Enable foreign key checking. |
SET @pos := 0; | |
UPDATE table SET position = ( SELECT @pos := @pos + 1 ) ORDER BY id ASC; |
/** | |
* A linear interpolator for hexadecimal colors | |
* @param {String} a | |
* @param {String} b | |
* @param {Number} amount | |
* @example | |
* // returns #7F7F7F | |
* lerpColor('#000000', '#ffffff', 0.5) | |
* @returns {String} | |
*/ |
<root> | |
<element>A</element> | |
<element>B</element> | |
</root> |
SELECT @i:=0; | |
UPDATE contacts SET position = @i:=@i+1 WHERE location_id=1 ORDER BY id; |