28.02.13

Tell Friends

Getting Attachments in Posts Under Specific Categories in WordPress with SQL

This post is actually a refinement to another post ‘Extracting Data From WordPress Database and Convert Into XML Format‘ that I wrote couple of years back. In that post I was using nested php-mysql calls to get attachments¬†of posts in Read the entire post…

25.08.11

Tell Friends

MySql Mass Convertion of Database Table’s Storage Engines from Other Types to InnoDB

A Few months back I had to convert moodle LMS database storage engine from MyISAM to InnoDB. Moodle has some 200+ databases and to manually convert each table takes an awful lot of time. My friend who was responsible for Read the entire post…

04.08.11

Tell Friends

Joining Three or More Tables in SQL With MySql (Nested Joins)

Joining three or more database tables seems a bit tricky. But once you know how to join three tables you can literally join any number of database tables. For the purpose of this tutorial I have four tables named Table1 Read the entire post…

12.07.11

Tell Friends

Simple Multiple Word Search Engine Concept With PHP & MYSQL

Searching the database for a single word is easy. How about if you want to have a multiple word search? With ordinary search it will only show the result if there is an exact match for the word sequence. What Read the entire post…

11.07.11

Tell Friends

How to Create and Handle an Array of Models or Objects in Codeigniter

In most object oriented programming situations we want to dynamically create varied number of instances(objects) of a specific class. Therefore its impossible to rely on predefined variable. The best solution is to use an array to hold the objects dynamically Read the entire post…

03.06.11

Tell Friends

Easily Convert PDF to Page Flip Book or Brochure at codebox (free online software)

Have you ever seen a ebook or e-brochure that can be flipped like a real book. Mostly its done with flash that requires a lot of action script knowledge and a good foundation in geometry to make the flip effect. Read the entire post…

12.03.11

Tell Friends

3D Visualization of Location and Magnitude of Earthquakes With EQuake3D Software

Just 3 months into the new year we have already experienced two devastating earth quakes. I wanted to get a visual presentation of the earthquake locations and their magnitudes. I found a free earthquake 3D model software that does just Read the entire post…

15.12.10

Tell Friends

Flash Actionscript 3.0 – Retrieve Directory URL Of The SWF File

adobe-acrionscript-30-swf-directory-icon

Usually when you want to load a resource like an xml or picture file from an SWF file you either specify the relative path or the absolute path to the resource. The relative path is the path that the resource Read the entire post…

01.12.10

Tell Friends

Adding Customizable and Controllable Website Background Music With Flash

website-background-sound-flash-icon

There are several ways to add a background sound or music to a website. The most popular and common way is to embed a midi sound file as follows. But this had got two draw back. First the browser and Read the entire post…

14.09.10

Tell Friends

Extracting Data From WordPress Database and Convert Into XML Format

wordpress-er-diagram-xml-icon

Recently I had to develop a dynamic website that lets the user update company information and upload product images to image gallery. I didn’t give a second that about which CMS I am going to use. The answer was obvious; Read the entire post…

04.09.10

Tell Friends

Label Inside Textbox That Disappears On Focus, With Javascript

label-inside-textbox-javascript

You might have come across many websites that have fields that display the label of the filed within the filed. The most common among this is the search box. Many websites also uses this technique with the registration forms and Read the entire post…

10.08.10

Tell Friends

Customizing and Embedding Google Docs Form in your website.

google-docs-form-icon

The advantages of using the google docs are many. When it comes to using the google form, thought there are many advantages there are some disadvantages as well. The advantage is that you can quickly build a form and get Read the entire post…

06.05.10

Tell Friends

Free Windows Mass String Search And Replace Software

turbosr-mass-search-string-replace-icon

Recently I was confronted with a tedious task of replacing texts in hundreds of configuration files on my server. As I didn’t find any point in waisting time by manually doing it, I looked for free string/text replacement programs. I Read the entire post…

05.05.10

Tell Friends

Edit MP3 Audio Files Online at cutmp3.net

online-mp3-cutter-editor-icon

CutMP3.net is a simple Web 2.0 utility that enables you to cut out pieces of a MP3 files without having to decode that MP3. The tool cuts the MP3 at the frame level without losing the quality of your MP3. Read the entire post…

09.03.10

Tell Friends

Free Video To Audio Converter (Soundtrack Extractor)

free-video-flv-avi-wmv-audio-mp3-wav-wma-aac-converter-icon

Free Video to Audio Converter is a powerful audio extractor extracting audio from video, like convert MPEG to MP3, convert MPEG to M4A, and AVI to MP3. The primary function of the video to audio converter is extracting audio from Read the entire post…