Cross Plattform APP Entwicklung mit Frameworks

ionicframework.com – electron.atom.io – cordova.apache.org –

Weiterlesen →

Visuelles programmieren

Blockly – Beispiele Blockly Projektseite Blockly Developer Tool Blockly Code Builder – Codebuilder Blockly Code Builder 2

Weiterlesen →

jQuery map() Methode

JavascriptJavascript, jQuery

var optionsData = $.map(data, function (obj) {
    obj.id = obj.keyword_id;
    obj.text = obj.keyword_value; 
    return obj;
});

var optionsData = $.map(data, function (obj) {

obj.id = obj.keyword_id;

obj.text = obj.keyword_value;

return obj;

});

Weiterlesen →

Datenvisualisierung

DatenmodellierungDaten, Datenvisualisierung

3D Map mit LIVE Tracking Pointer LIVE Monitoring

Weiterlesen →

MySQL Query: Domain aus URL extrahieren

MySQLMySQL, Queries

SELECT 
    url,
    SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(url, '/', 3), '://', -1), '/', 1), '?', 1) AS domain,
    SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(url, '//', '.'), '/', 1), '.', -2) AS domain2 
FROM ( 
    SELECT       'http://testdomain.com' as url 
    UNION SELECT 'https://testdomain.com' 
    UNION SELECT 'http://testdomain.de/foo.bar/fold-test.html'
    UNION SELECT 'http://testdomain.de/foo' 
    UNION SELECT 'http://testdomain.de/?foo' 
    UNION SELECT 'https://testdomain.de/foo' 
    UNION SELECT 'https://testdomain.de/?foo' 
    UNION SELECT 'http://testdomain.de?http://anotherdomain.de'  
    UNION SELECT 'testdomain.de' 
    UNION SELECT 'testdomain.de/foo'
    UNION SELECT 'testdomain.de/foo/'
    UNION SELECT 'testdomain.de/foo?param=baz'
    UNION SELECT 'testdomain.de/foo/?param=baz'
    UNION SELECT 'testdomain.de/foo/bar'
    UNION SELECT 'testdomain.de/foo/bar/'
    UNION SELECT 'testdomain.de/foo/bar/?param=baz'
    UNION SELECT 'testdomain.de/foo/bar/three'
    UNION SELECT 'testdomain.de/foo/bar/three?u=http://anotherdomain.de'
    UNION SELECT 'http://sub.testdomain.de'
    UNION SELECT 'sub.testdomain.de/foo'
    UNION SELECT 'sub.sub.testdomain.de/foo' ) AS Testtable;

SELECT

url,

SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(url, '/', 3), '://', -1), '/', 1), '?', 1) AS domain,

SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(url, '//', '.'), '/', 1), '.', -2) AS domain2

FROM (

SELECT 'http://testdomain.com' as url

UNION SELECT 'https://testdomain.com'

UNION SELECT 'http://testdomain.de/foo.bar/fold-test.html'

UNION SELECT 'http://testdomain.de/foo'

UNION SELECT 'http://testdomain.de/?foo'

UNION SELECT 'https://testdomain.de/foo'

UNION SELECT 'https://testdomain.de/?foo'

UNION SELECT 'http://testdomain.de?http://anotherdomain.de'

UNION SELECT 'testdomain.de'

UNION SELECT 'testdomain.de/foo'

UNION SELECT 'testdomain.de/foo/'

UNION SELECT 'testdomain.de/foo?param=baz'

UNION SELECT 'testdomain.de/foo/?param=baz'

UNION SELECT 'testdomain.de/foo/bar'

UNION SELECT 'testdomain.de/foo/bar/'

UNION SELECT 'testdomain.de/foo/bar/?param=baz'

UNION SELECT 'testdomain.de/foo/bar/three'

UNION SELECT 'testdomain.de/foo/bar/three?u=http://anotherdomain.de'

UNION SELECT 'http://sub.testdomain.de'

UNION SELECT 'sub.testdomain.de/foo'

UNION SELECT 'sub.sub.testdomain.de/foo' ) AS Testtable;

Weiterlesen →

MySQL RAM Tables

MySQLMySQL, Optimierung, Queries

SELECT TABLE_NAME FROM `information_schema`.`partitions` WHERE `TABLE_SCHEMA` = 'TABLNAME' and `TABLE_NAME` LIKE 'ram_%'

1	SELECT TABLE_NAME FROM `information_schema`.`partitions` WHERE `TABLE_SCHEMA` = 'TABLNAME' and `TABLE_NAME` LIKE 'ram_%'

DROP TABLE IF EXISTS `ram_test`

1	DROP TABLE IF EXISTS `ram_test`

CREATE TABLE `ram_test` (  
  `fieldA` varchar(100) DEFAULT NULL,
  `fieldB` varchar(100) DEFAULT NULL,
) ENGINE=Memory DEFAULT CHARSET=utf8 PACK_KEYS=0 ROW_FORMAT=COMPACT;

CREATE TABLE `ram_test` (

`fieldA` varchar(100) DEFAULT NULL,

`fieldB` varchar(100) DEFAULT NULL,

) ENGINE=Memory DEFAULT CHARSET=utf8 PACK_KEYS=0 ROW_FORMAT=COMPACT;

INSERT INTO `ram_test` SELECT * FROM `test`

1	INSERT INTO `ram_test` SELECT * FROM `test`

Weiterlesen →

Google Image Search per REST API

ProgrammierungAPI, Google, Images API

Jetzt über die Custom Search API verfügbar. Referenz zur neuen API https://developers.google.com/custom-search/json-api/v1/reference/cse/list https://www.googleapis.com/customsearch/v1?searchType=image&q=Sonnenblume&key=KEY&cx=partner-pub-XXXXXX:XXXXX

Weiterlesen →

Bootstrap Cheat Sheet

Cheat Sheets, CSS, ProgrammierungBootstrap, Cheat Sheet, CSS

.well .well-sm .well-lg Mixins .text-overflow()

Weiterlesen →

Pure Javascript

JavascriptCheat Sheet, Javascript

var li = document.createElement('li');
var a = document.createElement('a');

/*------------------------------------------------------------------
  CSS Styles
------------------------------------------------------------------*/ 
element.style.float             = 'left';
element.style.left              = '0px';
element.style.top               = '0px';
element.style.width             = '100px';
element.style.height            = '100px';
element.style.backgroundColor   = '#cccccc';

var li = document.createElement('li');

var a = document.createElement('a');

/*------------------------------------------------------------------

CSS Styles

------------------------------------------------------------------*/

element.style.float = 'left';

element.style.left = '0px';

element.style.top = '0px';

element.style.width = '100px';

element.style.height = '100px';

element.style.backgroundColor = '#cccccc';

Weiterlesen →

Javascript Event Handler

Cheat Sheets, JavascriptCheat Sheet, Javascript

Select Element

Weiterlesen →

Thomas Eses

WEBDEVELOPER – PHP, JavaScript, Datenbanken…

Kategorie Tags:

Kategorie: Programmierung

Cross Plattform APP Entwicklung mit Frameworks

Visuelles programmieren

jQuery map() Methode

Datenvisualisierung

MySQL Query: Domain aus URL extrahieren

MySQL RAM Tables

Google Image Search per REST API

Bootstrap Cheat Sheet

Pure Javascript

Javascript Event Handler