http://www.gauravjassal.com/index.php/site/index/ en hello@gauravjassal.com Copyright 2008 2008-11-15T17:59:12+00:00 http://www.gauravjassal.com/index.php/site/filter_array_into_categorized_format/ http://www.gauravjassal.com/index.php/site/filter_array_into_categorized_format/#When:17:59:12Z This simple yet powerful class to filters an array and breaks in to a categorized array format.You can use this class if you are dealing with large and complex array and want to convert it into and simple array that is easy to understand and use. Recently i required a function that can categorize an array and break it into categorize format.I couldn't find any core function to do that so i decided to create my own class that can do this job for me. I have also added an example to demonstrate the usage to its benefit. Make sure you comment it if you find it useful. Original Array $arrProducts=array( array( "product_id" => "007", "product_name" => "Blackberry R-900 Mobile", "product_price" => "£450", "product_status" =>"1", "product_category" =>"Mobile" ), array( "product_id" => "033", "product_name" => "8 GB Pendrive", "product_price" => "£14.99", "product_status" => "0", "product_category" => "Computers" ) ); PHP 2008-11-15T17:59:12+00:00 http://www.gauravjassal.com/index.php/site/why_use_constraints_in_sql/ http://www.gauravjassal.com/index.php/site/why_use_constraints_in_sql/#When:14:19:57Z Constraints enables business rules to be enforced by the database instead of via application code. Through the judicious use of constraints, application and SQL coding can be minimized and data integrity can be maximized. Constraints may be applied to columns in the form of uniqueness requirements, relational integrity constraints to other tables/rows, allowable values and data types.For example, a column containing a product price should probably only accept positive values. But there is no standard data type that accepts only positive numbers. Another issue is that you might want to constrain column data with respect to other columns or rows. For example, in a table containing product information, there should be only one row for each product number. With constraints you can have much control over the data and you can have it the way you want to be. You can have same rules in your web applications that you are writing in whatever language like PHP, ASP.NET, Perl, Python but constraints can save your alot of valuable time. Constraints, in SQL Server, can be used to: # Enforce the range of data values that can be stored in a column (check constraints)  # Enforce the uniqueness of a column or group of columns within a table (unique / primary key constraints)  # Eenforce referential integrity (primary key and foreign key constraints) A PRIMARY KEY constraint is a unique identifier for a row within a database table. Every table should have a primary key constraint to uniquely identify each row and only one primary key constraint can be created for each table. The primary key constraints are used to enforce entity integrity. CREATE TABLE products ( product_no integer PRIMARY KEY, name text, price numeric ); MySQL, PostgresSQL 2008-10-01T14:19:57+00:00 http://www.gauravjassal.com/index.php/site/googles_project10tothe100/ http://www.gauravjassal.com/index.php/site/googles_project10tothe100/#When:10:09:41Z Google  came up with a new project called Project10tothe100  Google has sent an invitation to all the people who has an idea or ideas to change the world, just share the same with Google and help the people in all. Daily Digest, News 2008-09-29T10:09:41+00:00 http://www.gauravjassal.com/index.php/site/catch_errors_in_actionscript_30/ http://www.gauravjassal.com/index.php/site/catch_errors_in_actionscript_30/#When:09:53:41Z Errors One thing you may notice about ActionScript 3 how error prone it is or, rather, how error prone it perceives you to be. You’ll see a lot more errors, not only during compile, but also runtime. ActionScript 3 is much less lenient in letting you get away with mistakes or code conflicts. Whereas ActionScript 1 and 2 may silently fail or ignore many errors, ActionScript 3 will be sure to let you know something went wrong. Synchronous Errors Normal errors in code which occur as a code block is being executed are synchronous errors. When the Flash player encounters one of these errors in code, an error, or exception, is thrown. At that point the Flash player will suspend all code in the current block and prevent it from continuing unless the exception is taken care of or caught. To catch exceptions in ActionScript, you use a try..catch..finally statement. The try..catch..finally statement lets you try a block of code possible of throwing an error and react accordingly if an error occurs. It consists of 2 or more blocks of code: an initial try block, consisting of the code that could throw an error, 1 or more catch blocks that catch errors of different types and run if that type of error is thrown, and an optional finally block which is run after the try and any catches whether or not an error occurs. Its format is as follows: Actionscript 3.0, Daily Digest, Flash 8, Flex 3 2008-09-26T09:53:41+00:00 http://www.gauravjassal.com/index.php/site/what_makes_a_great_developer/ http://www.gauravjassal.com/index.php/site/what_makes_a_great_developer/#When:09:18:58Z What makes a truly great developer? Some might say a positive attitude. Some might say a high-sugar, high-caffeine, high-bacon diet. Some might say an absence of sunlight and as many monitors as a desk can support. Certainly, everyone has anecdotes about developers they’ve worked with who they thought were brilliant. Unfortunately, most of the time that judgement is made not based on code quality, or hitting of deadlines, but on less relevant criteria, like whether or not the developer knew the names of their colleagues, how many lines of code they output or how confident they sounded when talking about their work. Unfortunately, the best developers don’t always come across positively. While this list may not be applicable to every development environment, here are a few of the traits to look out for to spot a great developer. Daily Digest, PHP, Personal, PostgresSQL, Regular Expression 2008-09-26T09:18:58+00:00 http://www.gauravjassal.com/index.php/site/who_invented_ctrl_alt_del/ http://www.gauravjassal.com/index.php/site/who_invented_ctrl_alt_del/#When:09:58:35Z Have you ever thought of the person who invented “CTRL + ALT + DEL ” key combination? “David Bradley” — He is the One who spent 1 minute and 23 seconds in writing the source code that rescues the world’s PC users for decades. This extraordinary IBM employee is retiring on Friday after a prolong service of 29 years. His formula forces obstinate computers to restart when they no longer follow other commands. By 1980, Bradley was one of 12 people working to create the debut. The engineers knew they had to design a simple way to restart the computer when it fails to respond the user — Bradley wrote the code to make it work.  Daily Digest 2008-09-23T09:58:35+00:00 http://www.gauravjassal.com/index.php/site/understanding_root_scope/ http://www.gauravjassal.com/index.php/site/understanding_root_scope/#When:08:48:43Z Recently was called up to fix an issue with a client’s SWF file that we were trying to use on one of our channels. The file worked on its own, but not in the container SWF on our site. Jumping into the client’s code, I immediately spotted the problem where their developer declared a class instance used in their movie on the “_root ” timeline. Since we loaded their SWF into a movieclip within our SWF , the scope had changed, breaking the entire file. Actionscript 2.0, Actionscript 3.0, Flash 8, Flex 3 2008-09-23T08:48:43+00:00 http://www.gauravjassal.com/index.php/site/php_regular_expression_to_parse_image_path_on_flickr_page/ http://www.gauravjassal.com/index.php/site/php_regular_expression_to_parse_image_path_on_flickr_page/#When:09:58:47Z Recently i wrote a function to parse image path from a flickr page without using any API. I use magical preg_match_all function in php to look for a particular tag. This preg_match_all function is so usefull you can try it for YouTube too. I will post a similar function for youtube very soon.   public static function getImageURL()   {       $url = 'http://www.flickr.com/photos/22401332@N05/2861372233';       $pagina = @file_get_contents($url);       if (preg_match_all('!!Usi’,         $pagina, $info, PREG_SET_ORDER)) {         print ($info[0][0]);       }   } PHP, Regular Expression 2008-09-22T09:58:47+00:00 http://www.gauravjassal.com/index.php/site/2008_email_design_guidelines/ http://www.gauravjassal.com/index.php/site/2008_email_design_guidelines/#When:21:02:59Z As web designers, we’ve grown pretty good at understanding how to create a modern, semantic, accessible website using XHTML and CSS. We understand what makes a good website, and how to make it happen.When it comes time to design emails though, do all the same rules apply? Are there things we should be doing specifically for email that don’t make sense on a website? In this article we’ll discuss the technical, design and information elements that make up a successful HTML email. CSS, Daily Digest 2008-09-19T21:02:59+00:00 http://www.gauravjassal.com/index.php/site/install_postgresql_on_ubuntu/ http://www.gauravjassal.com/index.php/site/install_postgresql_on_ubuntu/#When:18:54:35Z Installing Mysql is very easy just one step but postgres can mess you around,so here is the quick walk-through for installing the PostgreSQL database server and the PgAdmin administration application on Ubuntu Linux, and also set up the server so it allows access to other PC’s on your network. Before we move on, this guide was tested on the current release of Ubuntu Linux, (7.10 - Gutsy Gibbon) and PostgreSQL 8.2, but it should also be applicable to older versions (of Ubuntu and PostgreSQL) and other Debian based distros. PostgresSQL 2008-08-03T18:54:35+00:00