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

How to Optimize Your PHP Setup?

Currently many big, small applications are running with LAMP technology. Here in an article, I am trying to explain, how to optimize PHP set up. In this we make some changes in php.ini file to achieve the same. Things need to disable in PHP There are several php.ini settings that should be disabled, since they […]

PHP How to Upload Large Files

There is always a need to upload large files in our application, With PHP how to upload large files is the main topic here, Initially, PHP have default 2MB file limit for upload, So we have to change that setting to allow application to upload larger files than 2MB. How we change this, there are […]

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, […]

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); […]

Apple Learned after I Am Rich iPhone App Scam??

I am rich, the scam application, $999 app, eight people bought it, hot topic over days. Many articles are writing over the scam, Company has removed application but the damage has been already done on company’s image, approval system. This can cost company customer trust that uses apple store. This is the big question on […]