Tagged: MySQL


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

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

How to Increase Google Adsense CTR

The simple way to earn money with Google Adsense is to learn how to get clicks of valuable visitors. Here are some of the tips How to Increase Google Adsense CTR. 1. Remove Other Service Ads First of all to make sure that you get a high CTR and earning per click is to make […]

How do You Automatically Run a Program with Administrator Privileges Upon User Login in Windows?

I am using Windows 8.1 (64-bit) and I would like to automatically run a program with administrator privileges upon user login. I tried to make a shortcut of the program and ticked the run as administrator check box in the properties of the program shortcut itself, then tried placing the shortcut in the two locations […]

User Signup Using Facebook

Using Facebook registration plug-in where users can easily sign up on your website using Facebook data. With one simple Facebook login the form will be filled with user appropriate data. This plug-in is a simple iframe you can place it anywhere on your webpage. You can also add a custom field if Facebook doesn’t have. […]