Skip to main content

Posts

SQL Distributed Management Objects (SQL-DMO)

A SQL-DMO object exposes the attributes of a Microsoft® SQL Server™ 2000 component. Distributed Management Objects (DMO) is a set of programmable objects that come with SQL Server that make it easy to programatically administer your databases. SQL-DMO is actually the foundation of Enterprise Manager, so you can pretty much do anything programatically that you can do in the management tools. Some of these tasks include :

Google Chart API perfect way to visualize data in your web site

Google Chart API perfect way to visualize data in your web site JavaScript classes. Many Chat Types. Easily Customizable. Highly Interactive with events. Charts are rendered using HTML5/SVG technology to provide cross-browser compatibility (including VML for older IE versions) and cross platform portability to iPhones, iPads and Android. No plugins are needed. Perfect right? You should identify there are two types of charts are  provided by google. 1. http://code.google.com/apis/chart/ Google chart tools are powerful, simple to use, and free. Try out our rich gallery of interactive charts and data tools.  2. http://code.google.com/apis/chart/image/ The Google Chart API lets you dynamically generate charts with a URL string. You can embed these charts on your web page, or download the image for local or offline use. Its not hard  to build up a chart using google. Its easy. Google documentation gives you enough details to customize your chart. Sample example

Instalation of xdebug on Linux and Work with Eclipse (Ubuntu 11.04)

The Xdebug extension helps you debugging your script by providing a lot of valuable debug information.(http://pecl.php.net/package/xdebug) Installation of xdebug Open up ur terminal and do below sudo pecl install xdebug Output of terminal display like below Build process completed successfully Installing '/usr/lib/php5/20090626+lfs/xdebug.so' install ok: channel://pecl.php.net/xdebug-2.1.2 configuration option "php_ini" is not set to php.ini location You should add "extension=xdebug.so" to php.ini editing the php.ini sudo gedit /etc/php5/apache2/php.ini append below line to php.ini You can find xdebug.so from when you install pecl. (Output message in terminal) zend_extension=/usr/lib/php5/20090626+lfs/xdebug.so xdebug.remote_enable=1 eclipse configuration Debug Configuration (Run>Debug Configuration) Set Server Debugger to XDebug (not Zend Debugger) Start Debugging

Expire Session When the Browser Close [Codeigniter]

I wanted user to log again to the site whenever they close the browser. i searched everywhere and i found the easiest way. application/config/config.php sess_expire_on_close = TRUE Easy Session Preferences You'll find the following Session related preferences in your file: Preference Default Options Description sess_cookie_name ci_session None The name you want the session cookie saved as. sess_expiration 7200 None The number of seconds you would like the session to last. The default value is 2 hours (7200 seconds). If you would like a non-expiring session set the value to zero: 0 sess_expire_on_close FALSE TRUE/FALSE (boolean) Whether to cause the session to expire automatically when the browser window is closed. sess_encrypt_cookie FALSE TRUE/FALSE (boolean) Whether to encrypt the session data. sess_use_database FALSE TRUE/FALSE (boolean) Whether to save the session data to a database. You must

Date Difference in PHP

There is a easy method for find date difference in php. But this method didn't work after i hosted my files. So i came up with following. it is generating difference in days. but you can use other calculations for generate Months, years. This is a simple method. $from = date("Y-m-d",strtotime('2011-04-01')); $to= date("Y-m-d",strtotime('2011-04-06')); $diff = strtotime($from )-strtotime($to); echo floor($diff / (60*60*24)); 60*60*24 = Generate Days ( 86400 ) "year" = 29030400 , // seconds in a year (12 months) "month" = 2419200 , // seconds in a month (4 weeks) "week" = 604800 , // seconds in a week (7 days) "day" = 86400 , // seconds in a day (24 hours) "hour" = 3600 , // seconds in an hour (60 minutes) "minute" = 60 , // seconds in a minute (60 seconds) "second" = 1 // 1 second