Tagged: programming


Import Data from Excel Using PHP

Import data from Excel using PHP. It is many time we need to import Excel data to your mysql in our most of applications. There is a simple code to Import data from Excel using PHP Here is the attachment which will help you guys to do this. Files: <a href=”http://mobicrumbz.com/downloads/files/excelReadExample.zip”>excelReadExample</a>

Export Data to CSV Using PHP

It is many time we need to export table data to CSV in our most of applications. There is a simple code to export data to CSV using PHP Code: if($_GET[‘action’] == ‘export’) { $titlearr = array(“Heading 1″,”Heading 2″,”Heading 3″,”Heading 3″,”Heading 4″); $q = mysql_query(“select field1, field2, field3. field4 from where table”); $columns = count($titlearr); […]

Optimizing MySQL: Queries and Indexes

The database is just too slow. Queries are queuing up, backlogs growing, users being refused connection. Management is ready to spend millions on “upgrading” to some other system, when the problem is really that MySQL is simply not being used properly. Badly defined or non-existent indexes are one of the primary reasons for poor performance, […]

How to Change The Value of a PHP Setting

You can apply custom PHP settings on a per-folder basis using a local php.ini file. For example, you need register_globals set to Off in a directory. For this purpose you should log in your cPanel and go to the File Manager. There navigate to the directory where you’d like this setting applied. In this directory […]

jQuery Advantages and Disadvantages

What is jQuery? jQuery is basically a JavaScript library and it was designed to make the client-side scripting of HTML more simple. The person responsible for its birth is John Resig at BarCamp NYC in 2006. It is an open-source software and dual-licensed by MIT License and the GNU General Public License. Version 2. jQuery […]

Easy Steps to Optimize Your Website

You can write million things on website optimization for speed. Here are few of them important steps which need to consider for the same. 1. Run your images through smushit.com. While it’s obvious to keep your image sizes down as low as possible, it’s not as obvious that some image editing programs like photoshop can […]


Page 1 of 212

Getting Started with HTML 5

HTML5 is coming quicker than a lot of web designers are probably aware. You’ve probably seen the stories that it won’t actually be usable until 2022 but in reality, you can actually start using it today. Not all web browsers support CSS2.1, not all visitors are using software capable of using JavaScript but that doesn’t […]

How to Start with PHP

Here I have describe how to easily start programming with PHP. First What exactly needed to start, 1) Webserver – Apache 2) MySql 3) PHP All these you can get from one package called WAMP you can download it from here http://www.wampserver.com/en/download.php Download suitable file and install into your local system, then start wamp server, […]

jQuery Against Flash

On near 1996, Macromedia realsed their product called Macromedia Flash which is vector based animation platform. Using Flash, web designer were now able to make animation using a timeline as video. Only one thing is annoying to enjoy flash stuff is macromedia flash player, that need to install. When, Javascript is arrive on around 1997, […]

How to Learn from Open Source Projects and Frameworks

Many beginners have question, they are new in industry and how to start, open sources which seems bit complex for them to learn, but they can learn basics from that. I have some steps to follow which may help into this. Consider a PHP Programmer wants to learn other Database integration rather than orthodox MySQL, […]

How to Make and Submit Google Sitemap

Now days Google Sitemap is very primary thing which need to do for site promotion in google search engine. This is the fast way to get indexed your site in Google. Google Sitemap is the special format which tells google the name of URLs, recent modifications on each page of your site. This must be […]