Articles Comments

Headline

Useful PHP functions

May 15th, 2012 | Add a Comment

date_default_timezone_set(‘Asia/Kuala_Lumpur’); … Read entire article »

Latest

what is APC in PHP

APC (Alternative PHP Cache) The Alternative PHP Cache (APC) is a free and open opcode cache for PHP. Its goal is to provide a free, open, and robust framework for caching and optimizing PHP intermediate code. more info- http://php.net/manual/en/book.apc.php … Read entire article »

sql concat function example

SELECT `name` , email, `client_url` , CONCAT( `address` , ' ', `city` , ' ', `state` , ' ', `zip` ) full_address, `phone` , `cell` , `fax` , CONCAT( `title` , ' ', `first_name` , ' ', `last_name` ) AS `contact_name` , `account_number` , `mod_accounts` , `mod_contacts` , `mod_leads` , `mod_opportunities` , `mod_quotes` , `mod_oss_leadclientdetail` , `mod_oss_proposaltracker` , `mod_calendar` , `mod_reports` , `mod_documents` , `mod_emails` , `mod_campaigns` , `mod_calls` , `mod_meetings` , `mod_tasks` , `mod_notes` , `mod_cases` , `mod_prospects` , `mod_prospectlists` , DATE_FORMAT( date_entered, '%m/%d/%Y %r' ) Created FROM `instance_access` WHERE `date_entered` = (SELECT max( date_entered ) new_date FROM `instance_access` ) AND state IN (${location_filter}) AND name like CONCAT(${client_filter},'%') ORDER BY name … Read entire article »

Convert 12 hour date-time into Mysql equivalent time-stamp by modified JavaScript step in Pentaho DI (Spoon)

function getMyDate(mydate,mytime) { var hh =""; var mm ="";var ampm = "";var a1;var ampm ="";var st="0"; if(mydate=="" || mydate==false || mydate =="?" || mydate ==null) { return(""); } a1 = mydate.split("/"); var reqDate = ""; if(mytime=="" || mytime=="?" || mytime==false) { reqDate = a1[2]+"-"+a1[0]+"-"+a1[1]; return(reqDate+" 00:00:00"); } else { ampm = mytime.substr(-2); a = mytime.split(":"); hh = a[0]; mm = parseInt(a[1]); //hh = addStrZero(hh); //mm = addStrZero(mm); hh = parseInt(hh); if(ampm=="PM") { if(hh<12) { hh = hh+12; } reqDate = a1[2]+"-"+a1[0]+"-"+a1[1]; if(hh==24) { //var dt = parseInt(a1[1])+1; //hh="00"; } else { //reqDate = a1[2]+"-"+a1[0]+"-"+a1[1]; } } else { if(hh==12) { hh=0; } } mmInt = parseInt(mm); … Read entire article »

Useful MySql Query

To login in Mysql: mysql -uroot -proot; where -u is username which is root and,-p is password which also root. To Add Index on Table “accounts” on field name “name”mysql> alter table accounts drop index name; #show table structure-show create table accounts; # or use desc tablename; # export database to sql file. # bb_master is database name. mysqldump -uroot -proot bb_master > bb_master_feb9.sql; #import from sql filemysql -uroot -proot bb_master < bb_master.sql; … Read entire article »

Soft Skill’s Importance in your job

Hi all, I had a good presentation regarding soft skills (Communications, behavior, etiquette  etc), and it is very important factor in one’s life if he/she is in IT fields or any field in which client interaction effects your work. So I upload the presentation recording audio file on website and providing you the link, please go through the url and download all clips, hope it will fruitful for you. wishing you luck in your life. Thanks BRIJ. download links- http://www.box.com/shared/sdlqd073s2vrery85fja no registration needed. Presentation given by: Shailendra Gupta Dated: Wed 25 Jan, 2012 Audience: Shashi, Brij Bhushan, Ganesh, Namita, Kawar, Mohit etc. … Read entire article »

Pentaho Data Integration (Kettle)

Pentaho Data Integration (Kettle) Welcome to the community home for Pentaho Data Integration Community Edition (PDI CE) also known as Kettle. Pentaho Data Integration delivers powerful Extraction, Transformation and Loading (ETL) capabilities using an innovative, metadata-driven approach. With an intuitive, graphical, drag and drop design environment, and a proven, scalable, standards-based architecture, Pentaho Data Integration is increasingly the choice for organizations over traditional, proprietary ETL or data integration tools. Click on the link to see attached PDF Tutorial. data-integration-doc … Read entire article »

Pentaho Report-Designer Tutorial

Pentaho is building the future of business analytics. Pentaho’s open source heritage drives our continued innovation in a modern, integrated, embeddable platform built for the future of analytics, including diverse and big data requirements. Powerful business analytics are made easy with Pentaho’s cost-effective suite for data access, visualization, integration, analysis and mining. Find the attached PDF Tutorial.pentahoReportDesigner … Read entire article »

Useful MySql String Functions

In this section you can learn about the uses of MySQL String functions. These functions can be used to manipulate the string data. Here we have compiled the almost all String functions that you can use to learn more about string functions supported by MySQL. ASCII (str) The ASCII(str) function returns the ASCII code value of the leftmost character of the String str. Returns 0 if str is the empty string. Returns NULL if str is NULL. Here are the some example of the ASCII(str) function: mysql> SELECT ASCII(’0′); -> 48 mysql> SELECT ASCII(0); -> 48 mysql> SELECT ASCII(‘d’); -> 100 BIN (N) The BIN string function return a string value … Read entire article »

Collation in MySql

When we create a database in MySql it ask for collation, So question is what is it? Collation denotes language, symbols or letters. For example if you want to save data on Tables in Arabic language you must select appropriate collation which supports Arabic language like UTF-8 etc. when you aware to case sensitive data store in your table, you must select correct collation for your specific language. Collation play very important role in Multi-Lingual Websites. … Read entire article »

Next Page »