Techie Zone

Links for 2009-10-21 [del.icio.us]

Thu, 22 Oct 2009 00:00:00 PDT

Reading Excel Sheet in PHP | Techie Zone
In this article we will learn on how we can read Microsoft Excel Sheet in PHP. To achieve this we will be using Open Source Tool PHPExcelReader. It provides us with necessary API that allow us to read the Excel Sheet in PHP.
1 Year Subscription of GRE/GMAT Word of Day with Great Bonuses
1 Year SMS Subscription for "GRE/GMAT Daily Word of Day". It includes Antonym, Synonym, Sentence Usage and Definition.

Prototype Design Pattern in Java

Hitesh Agrawal — Wed, 21 Oct 2009 09:43:36 +0000

As the same suggest prototype means some form of cloning and in this design pattern we will understand how we can achieve cloning of an java object. Normally we create an object using “new” operator but with new operator we are creating the whole new object from scratch and so all the necessary operation performed [...]

BackUp and Restore Mysql Database

Hitesh Agrawal — Wed, 07 Oct 2009 15:24:18 +0000

In this article we will learn on how we can perform following operations using MySQL. * Backup Database using MySQL * Backup specific tables using MySQL * Backup Multiple Database using MySQL * Backup Database Structure using MySQL * Restoring Backup using MySQL MySQL comes with an powerful console command called “mysqldump”. With this command we can achieve all the operation [...]

Column count doesn’t match value count in MySql

Hitesh Agrawal — Tue, 06 Oct 2009 17:19:51 +0000

When we try to insert/update data that exceeds column length, the default behavior should be to truncate the value and insert/update the column; though this was there in MySQL 4 by default but strangely in MySQL 5.x this feature is disabled by default. In this article will highlight how we can resolve this problem. To Highlight [...]

Manipulating Table using JavaScript

Hitesh Agrawal — Thu, 01 Oct 2009 15:49:54 +0000

In this article we will learn on how we can Manipulate HTML table using JavaScript. Following topic will be covered here: 1) Creating HTML Table in JavaScript 2) Adding new Row in HTML Table using JavaScript 3) Remove Row from HTML Table using JavaScript NOTE: All the operation happening through JavaScript resides in memory and user will not be able [...]

Change System TimeZone in Linux

Hitesh Agrawal — Thu, 24 Sep 2009 14:16:04 +0000

Web Servers are geographically located and their system date depends upon their location. But sometimes our application required to follow certain timezone and for that we will have to change the Time Zone of out system itself. In this article we will learn on how we can change the System Time Zone on Linux. There are [...]

UTF-8 Encoding Email Content using Java

Hitesh Agrawal — Thu, 03 Sep 2009 16:30:15 +0000

Strange but true, email gateway by default does not support utf-8 encoding for the body text. I also came to know about this when i found my email content containing garbage data along with mail content if any special character comes in the mail content. So i started my search on internet about this and found [...]

Reading Excel Sheet in PHP

Hitesh Agrawal — Thu, 03 Sep 2009 13:51:04 +0000

In this article we will learn on how we can read Microsoft Excel Sheet in PHP. To achieve this we will be using Open Source Tool PHPExcelReader. It provides us with necessary API that allow us to read the Excel Sheet in PHP. Directory Structure for ExcelReader: When you will unzip the excelreader, you will find example.php [...]

URL Connection Through Proxy in Java

Hitesh Agrawal — Tue, 21 Jul 2009 17:06:31 +0000

Sometimes we want to connect to remote URL from our java program but we are unable to connect due to proxy server. So in this article we will be learning: How to set the Proxy Connection Settings in Java. How to connect to remote URL using Proxy Settings defined using Java. Setting Proxy in Java: Proxy can be set [...]

Links for 2009-07-01 [del.icio.us]

Thu, 02 Jul 2009 00:00:00 PDT

Text To Speech (TTS) in JAVA
Festival, it allows us to convert Text to Speech (TTS) in wav format. In this article we will learn on how we can perform TTS from Java applications.

Text To Speech (TTS) in JAVA

Hitesh Agrawal — Tue, 30 Jun 2009 15:20:35 +0000

Festival, it allows us to convert Text to Speech (TTS) in wav format. In this article we will learn on how we can perform TTS from Java applications. What is Festival? It is an Open Source tool available that performs Text to Speech(TTS) Synthesis System. You can install Festival directly by directly calling: yum -y install festival This will [...]

Links for 2009-06-29 [del.icio.us]

Tue, 30 Jun 2009 00:00:00 PDT

I Like Linux but Loved Windows
I used to use Microsoft Windows for past 10 years and was quite addicted to it but recently due to job requirement i have switch to Linux operating system and was quite impressed with the Linux on the ease of development and use. But still there are few things which make Microsoft Windows go ahead of Linux.
MySql Prepared Statement in PHP
Sometimes we want to insert/update multiple records into MySql Database but due to performance issue we cannot call connect to MySql for every insert/update statement. In this article we will discuss how we can perform multiple insert/update on MySql Database.
MySql - Create Foreign Key
We all create tables in MySql but we can’t store all the details in single table, so we separate all the essential data into separate table and these table can be linked to the main table through FOREIGN KEY. Foreign Keys are special keys that acts as a reference between the tables. In this article we will learn how we can create an Foreign Key Constraint that will point to the Parent Table Primary Key.
Java Excel - Reading Excel Sheet in Java
For some reason i found Apache POI difficult to use for reading excel sheet, in terms of naming conventions and the code so i was searching for another Library for reading Excel Sheet in Java and i stopped at JXL.
Ajax Programming using Prototype Framework
Prototype is the most widely used framework for Ajax Operation. The main advantage of using Prototype Ajax Framework is its simplicity to use, automatically implements cross-browser and it offers bundle of utility function that can be used in your JavaScript code. This article will list down various ways by which you can make Ajax call using Prototype Framework.
Sending Email Using Apache Log4J
Apache Log4J is being widely used for performing logging in Java Application, while doing logging we also encounter errors and we write log.error() statements. This statement indicates that an serious error has occurred while executing the Java code. In a critical application checking for this message at runtime is a tedious job but thanks to Apache Log4J, they provide an provision for sending emails whenever an error statement is executed.
Reading POP3 Mails Using Java
Java provides with set of API called JavaMail that allows you to connect to and read POP3 Emails. This article will show you how we can read POP3 Emails using Java.
Calculating DIV Position in JavaScript
The following code snippet will return you the top and left position for DIV element used in your web page.
Reading Microsoft Word Document in JAVA
When it comes to reading Microsoft Office Word document Java does not have any in build classes to handle this but Apache POI Package developed by Apache Foundation gives you the power of reading Microsoft Word document in Java. More information on the Apache POI package can be found at Apache POI
Date Manipulation in JAVA
I had an requirement on date manipulation in Java and i had a very hard time searching on google. Finally i came to know on how to manipulate dates in Java and with this article i will be showing code snippets on the same. This code snippets is applicable in Core Java, JSP and Servlet Pages.

Execute Java Code From Shell Script

Hitesh Agrawal — Thu, 25 Jun 2009 14:27:45 +0000

Sometimes it becomes necessary to execute the java code from console but we cannot write everytime the whole java command including the classpath and properties in the console. There has to some easy way by which we can execute the java code from console. Similar to batch files that we have on windows linux has [...]

I Like Linux but Loved Windows

Hitesh Agrawal — Tue, 02 Jun 2009 17:52:30 +0000

I used to use Microsoft Windows for past 10 years and was quite addicted to it but recently due to job requirement i have switch to Linux operating system and was quite impressed with the Linux on the ease of development and use. But still there are few things which make Microsoft Windows go ahead [...]

Tracking User Session in Apache log4j

Hitesh Agrawal — Thu, 28 May 2009 17:25:33 +0000

Apache LOG4J is used for logging in Java but apart from logging we can also set value inside log4j that can appear in all the logs getting generated. This will help us in debugging complex distributed applications. In this article we will use this technique to keep track of users activity during the login session. In [...]

How to Implement Text to Speech in PHP

Hitesh Agrawal — Thu, 23 Apr 2009 08:59:47 +0000

I am now become a fan of Linux Operating System. It has all the variant of softwares available either Open Source or Commercial version, and the most important is that the software also runs from command console that means we can run the application from our web application. One such application is Festival, it allows [...]

Factory Design Pattern in Java

Hitesh Agrawal — Wed, 08 Apr 2009 14:34:09 +0000

Factory pattern comes into creational design pattern category, the main objective of the creational pattern is to instantiate an object and in Factory Pattern an interface is responsible for creating the object but the sub classes decides which class to instantiate. It is like the interface instantiate the appropriate sub-class depending upon the data passed. [...]

Singleton Design Pattern in Java

Hitesh Agrawal — Sun, 05 Apr 2009 13:48:31 +0000

Singleton pattern comes into creational design pattern category, the main objective of the creational pattern is to instantiate an object and with Singleton Pattern we will allow only one instance of the class to be created. Here in this article we will understand how we can create an Singleton class in Java. Singleton Class Code: package designpattern.creational.singleton; public [...]

Introduction to UML

Hitesh Agrawal — Sun, 29 Mar 2009 08:59:18 +0000

UML stands for Unified Modeling Language, the main objective of UML was to simplify the process of developing complex software systems through diagrams, documentation and construction. As UML is an Modeling language it gives you an broad view of the system and does not explains the internal working. Advantages Of UML: Independent of any programming language and [...]

UML Class Diagrams

Hitesh Agrawal — Sun, 29 Mar 2009 08:56:28 +0000

In this article we will learn about using Class Diagrams used in UML. The Class diagrams describes the structure of the system, these structures refers to the types of objects used in the system along with the relationships. Class diagrams are designed on basis if classes getting used in the System. Class diagrams are composed of [...]

Class Relationships in UML

Hitesh Agrawal — Sun, 29 Mar 2009 08:48:43 +0000

A systems are composed of Multiple Classes and each class defined inside the systems has a set of responsibility to perform so that the system can achieve the desired result. These classes communicate with each other and this communication needs to be depicted in UML as well. This article will list down all the class [...]

Association in UML

Hitesh Agrawal — Tue, 17 Mar 2009 15:19:10 +0000

Association defines the relationship between two or more classes in the System. These generally relates to the one object having instance or reference of another object inside it. This article discusses on how we can implement Association in UML. Associations in UML can be implemented using following ways: 1) Multiplicity 2) Aggregation 3) Composition Multiplicity in UML: Multiplicity indicates the no [...]

UML Use Case Diagrams

Hitesh Agrawal — Tue, 17 Mar 2009 15:07:24 +0000

In this we will understand the Use Case Diagrams used in UML, Use Case Diagrams describes the interaction of the user with the systems. There are two main components of Use Case Diagrams, “Actors” and “Use Cases“. Actors: An Actor represents the User/External World or may be another system that will interact with the System. Actor Symbol: Use Case: This [...]

Links for 2008-05-09 [del.icio.us]

Sat, 10 May 2008 00:00:00 PDT

JSON in JAVA
JSON is being widely used in Web Technology for data transfer in JavaScript. But with AJAX coming into picture JSON has become the most popular tool for sending data from remote page to the calling page. Well there are different packages available for imp
JavaScript XML Parsing on Mozilla Firefox / Opera Browsers
Today XML has become the backbone of many Web Applications. In JavaScript we can parse xml files at client end. But this parsing is different varies with browsers. In the tutorial we will understand how we can parse an xml file in JavaScript for Mozilla F

Links for 2008-04-09 [del.icio.us]

Thu, 10 Apr 2008 00:00:00 PDT

Relationship between Numerology and Planets
We often hear about the planets that exists in our solar system. But these planets plays an important role in Astrology and Numerology. These planets represents certain numbers that we use in day to day life viz 1 - 9.
Explore Linux Partitions from Windows
Sometime there is an urgent need to access the Linux Partition from Windows. This may be for getting important data or your linux partition has crashed and you want to take the backup of the data. But no need to worry there is an Open Source Software avai
Exploring Magic Methods in PHP 5
With PHP 5 Object Oriented Programming seems to becoming a reality in PHP but we all know that in PHP a variable can take any form depending on the data passed to it. Also PHP automatically creates variable and assigns values to it even is the variables a
FAQ on AJAX Technology
AJAX has become an hot technology with Web2.0 but before starting AJAX Programming developers needs to know some important FAQ on AJAX.
Debugging JavaScript Code for Errors
Debugging JavaScript code has always been an headache for the JavaScript programmers. This is mainly due to improper errors given by the browsers for errors in JavaScript code. You cannot rely on the line no given by the browser for JavaScript code errors
Check For Special Characters in JavaScript
Sometimes situation arises when you want to check for special characters in a string. But in JavaScript there is no direct methods that can check for Special Characters. To achieve this will have to use the JavaScript programming to develop an code that w

Links for 2008-01-25 [del.icio.us]

Sat, 26 Jan 2008 00:00:00 PST

Create Your Own Google Gadget
This tutorial will guide you on how to make your own Google Gadget for iGoogle Page. If you still not seen any Google Gadget on iGoogle you can see it online at iGoogle Page.
Showing Dynamic DIV above SELECT Box in JavaScript
This article will teach you on showing Dynamic Div Box above Select Control using JavaScript. Basically this problem is specific for Microsoft Browser i.e. Internet Explorer, In Microsoft Internet Explorer the POP UP DIV goes in background if there was an

Links for 2007-12-10 [del.icio.us]

Tue, 11 Dec 2007 00:00:00 PST

Converting Audio/Videos using FFMPEG
This article will guide you on how you can convert various audio video formats using FFMPEG.