saquery.com
a web developer' s kung fu…

To get a distinct dataset in MySql and embed it into Javascript in JSON format with PHP we need 3 Steps. SQL Source Code 1st. A SQL query to get a unique domain-name list.

Categories: Nice to know | 1 Comment

Well, Symfony2 project provides a good source code generator. They call this “The Symfony2 bundle generator”. The are dozens of bundles available at http://bundles.knplabs.org/ For example we can execute the Symfony2 bundle generator tool from windows vista to create a new Symfony2 bundle / project from scratch. MS DOS COMMAND (cmd.exe): c:\xampp\php\php.exe c:\xampp\htdocs\Symfony\app\console generate:bundle –namespace=sa/SampleBrowserShop –format=yml You can now start using the [...]

Categories: docs | Add a Comment

As a software developer you can get very much trouble. http://cwe.mitre.org/ describes in detail what these problems can be and how to avoid them.

Categories: Snippets | Add a Comment

The following sample shows how to limit a GROUP_CONCAT string in MySql to a specific length. This methode is near to the better List Aggregate Function in Sybase SqlAnywhere. 

Categories: Nice to know | Add a Comment

DataSource: http://wordpress.org/extend/plugins

Just improved my scripts to compress Cascading Stylesheet and Javascript code with yuicompressor. I wrote 3 small MS Dos batches to compress all files in a specified folder. By executing _make.bat the script will compress all *.js and *.css files from a folder named "/src_debug/" to "src". Last but not least the script will store [...]
Categories: jQuery | Add a Comment
This is a simple function to toggle text contents of an HTML element with jQuery. It should be easy to equip the toggleText methode with an array of strings. /* * jQuery.toggleText Plugin. * Copyright (c) saquery.com * Licensed under MIT - http://www.opensource.org/licenses/MIT */ $.fn.toggleText = function(txt){ return this.each(function(){ var _=$(this),_current=_.text(),_txt=txt; if ( _current === [...]
Mr. abhilash posted a much better "how to" use Google Fonts in Your WordPress Blog on meabi.com for the WordPress Plugin WP Web Fonts. Nice to see that somebody cares, so thank you!
Categories: Nice to know | Add a Comment
It is easy to dive into the world of jQuery. It requires only little knowledge in javascript in order to achieve great results with this JavaScript library. Beginners using Visual Studio will benefit from the so-called Intellisense support for jQuery. http://weblogs.asp.net/scottgu/ explains in detail how to integrate jQuery in Visual Studio.
Categories: Nice to know | Add a Comment
A Google Chromebook' s Security