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.
11.13.2011
10.27.2011
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.
10.25.2011
Categories: Web Developer' s Kung-Fu | Add a Comment
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 [...]
07.04.2011
Categories: more skills | Add a Comment
TIFFANY B. BROWN published on alistapart.com a realy good post about how to debug Javascript on mobile devices. The following links are a must-read for both aspiring web developer and also for advanced programmers. Modern Debugging Tips and Tricks - Advanced Debugging With JavaScript by H. R.M. STEEN , C. MILLS
05.10.2011
Categories: Snippets | Add a Comment
Because I've nothing found to get the folder of the current active wordpress theme on web server' s filesystem I wrote my own from scratch called get_wp_theme_folder(); PHP Source code: function get_wp_theme_folder(){ $tmp = get_bloginfo("template_url"); $tmp = explode("wp-content/themes/",$tmp); $result = $tmp[1]; // Windows returns slashes in path strings. return str_replace("\\", "/", get_theme_root()."/".$result) ; }
03.23.2011
After using Node.js for simple network service written in JavaScript I must say. Node.js realy rocks! The advantages to write server-side code in Javascript are obvious. As you can see in the following video, there are a lot of advantages over other server systems. The major differences are that Node.js is a server-side JavaScript environment. Node.js uses an asynchronous event-driven model. This allows to get an excellent performance based on the architectures of many Internet applications. Source: http://nodejs.org/ - https://github.com/joyent/node/wiki
01.18.2011
This is a nice way to get the Domainname form a Url String in Python. import urlparse return urlparse.urlparse(self.request.url)
01.08.2011
See how smart we can handle Web Requests in SQL Anywhere with a few lines of SQL Code. [inline] Specify HTTP Web service protocol and Port in SQL Anywhere The Database Start Parameter -xs specifies server-side Web service communication protocols. With the internal Webserver we can handle web requests within a SQL Anywhere Server. Simply [...]
12.15.2010
In the development environment of a Sybase SQL Anywhere Database, it is simple to analyze and describe the rules of foreign keys. All necessary informations are stored in the system tables of the database. The information can be combined into a useful view.
10.30.2010
jDrums A few months ago, I studied the possibilities to play audio files such as wave or mp3 in a Web browser. I quickly came to the conclusion that it is a difficult project. As a test scenario I had imagined a very simple drum machine.