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.
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 [...]
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.
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.