September 2014 archive

How to read large XML files efficiently using PHP?

Recently I was faced problem of parsing large XML file using PHP. While parsing small files are no problem and all its quickly parsed, an attempt to parse larger files often causes time-out or Internal Sever Error. We will not able to use DOM or SimpleXML extension to parse the large XML documents in PHP. …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/09/how-to-read-large-xml-files-efficiently-using-php/

How to remove Ubuntu option on the Windows Boot Manager menu?

Recently I have installed ubuntu using Wubi (Ubuntu installer) side by side with windows 7, After that I have uninstalled ubuntu successfully. However when I boot my machine, the Windows Boot Manager will displayed both Windows and Ubuntu. I have followed the below steps to remove Ubuntu from the Windows Boot Manager option: Step 1: …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/09/how-to-remove-ubuntu-option-on-the-windows-boot-manager-menu/

MySQL zerofill and lpad – Shape digits in DB

I’m working with an application to have the item code. Item code column is set as an INT(5) but not all the item code values are 5 digits. So I need to round off the item code based on 5-digits. If the item code is 199, it should be display as 00199. How to make …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/09/mysql-zerofill-and-lpad-shape-digits-in-db/