Feb 13

Display ICC Cricket World Cup 2015 Live Scores & Schedule in your Website in PHP

Display ICC Cricket World Cup 2015 Live Scores & Schedule in your Website in PHP

Type 1
Get CricBuzz Live Score XML Feed:

Live Score Match:

http://synd.cricbuzz.com/j2me/1.0/livematches.xml

Gadget Scores:

http://synd.cricbuzz.com/score-gadget/gadget-scores-feed.xml

Gadget Scores:

http://synd.cricbuzz.com/j2me/1.0/sch_calender.xml

To change xml to array:

 

Type 2
Live Scorecard Widget

https://www.cricruns.com/widget/

Jan 23

If your using PHP >= 5.5 use array_column instead array_map for array column result

If your using PHP >= 5.5 use array_column instead array_map for array column result

Example:

The above example will output:

Jan 23

Split time slots between start time and end time in PHP

Creating time between start time and end time in interval of 30 Minutes in PHP

Check Result:

result:

Nov 19

MYSQL databases engines MYISAM Vs INNODB

MYISAM:

1. MYISAM supports Table-level Locking
2. MyISAM designed for need of speed
3. MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS
4. MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI)
5. MYISAM not supports transaction. You cannot commit and rollback with MYISAM. Once you issue a command it’s done.
6. MYISAM supports fulltext search
7. You can use MyISAM, if the table is more static with lots of select and less update and delete.

INNODB:

1. InnoDB supports Row-level Locking
2. InnoDB designed for maximum performance when processing high volume of data
3. InnoDB support foreign keys hence we call MySQL with InnoDB is RDBMS
4. InnoDB stores its tables and indexes in a tablespace
5. InnoDB supports transaction. You can commit and rollback with InnoDB
6. InnoDB is slower when it comes to SELECT
7. InnoDB enforces referential integrity (which is as very good thing)