Read Excel file and save details to database using PHP-Repost

How can you read excel file using php and save that details to the database? My other post is describing Read Excel file and save details to database using PHP.But it is not properly working in new version of excel 2007..etc.My readers are asked to do this for other excel versions.So I’m going to show how to read any format of excel file like 97-2003(xls) or 2007 (xlsx) formats excel files. Also I’ll show how to create/write excel file using php.

Continue reading Read Excel file and save details to database using PHP-Repost

Display latest recent posts in my facebook page into my website

How to display your facebook wall posts into your own web site.For a example you can display facebook page’s latest posts into your web site sidebar as “latest posts”. This is actually displaying as rss feeds.You can check my demo how this is implemented.

Continue reading Display latest recent posts in my facebook page into my website

Convert xml file into excel file using php

Here we are describing convert xml file into excel file using php.Simple way to convert xml file into excel file with php.If you have basic knowledge of xml and php(:D) this is very easy.My another post is showing how to read Excel file and save details to database using php. If you not good familiar with xml read this PHP Creating XML file post and Read XML file using PHP post to get and better idea.

Continue reading Convert xml file into excel file using php

PHP read XML file using SAX parser

How to php read xml file using SAX parser.SAX means Simple API for XML.The SAX parser is work differently with DOM parser, it either load any XML document into memory not create any object representation of the XML document.
The advantage of a SAX parser is that it’s really lightweight. The parser doesn’t keep anything in memory for very long, so it can be used for extremely large files. The disadvantage is that writing SAX parser callbacks is a big nuisance.
Continue reading PHP read XML file using SAX parser