Nadeem Khan nadeem-khan

1. Use EXPLAIN keyword in your SELECT queries and then add index to all the search fields in the query:

  ALTER TABLE TABLE_NAME ADD INDEX (COLUMN_NAME);

//before using index

//after using index (not the dramatic decrease in the number of rows scanned)

Best way to use data fetched from DB with result_array()

$result = $this->db->get()->result_array(); // result_array() itself uses a for loop so we actually end up looping twice in the next line
foreach ($result as $row)
{
  ...
}

Instead use:

PHP API to return table names from a given SQL statement with multiple tables

Input

 $query = "SELECT `main_categories`.*, `categories_views`.`view` AS view_ctg, (SELECT COUNT(id_geo) FROM main_geo WHERE id_geo=geo_filter_ctg AND FIND_IN_SET('PK', `countries_geo` )) as countryCount
 FROM (`main_categories`)
 JOIN `categories_parents` ON `main_categories`.`id_ctg` = `categories_parents`.`id_ctg`
 JOIN `categories_views` ON `main_categories`.`id_ctg` = `categories_views`.`id_ctg`

WHERE categories_parents.parent_ctg = '8701'

Select similar (autofill) city names from maxmind cities list as compared to the input string in CodeIgniter

Model

     class Maxmind_model extends CI_Model {

     private $table = "maxmind";

public function __construct() {

Git Tagging and Branching 101

Here are the best practices for using Git Branches and Git Tags:

Git Tags

A ref pointing to a tag or commit object. To put simply, a tag is a way to mark a point in time in your repository. Here are some things that you should keep in mind when working with tags:

-You should add a tag to mark a released version. If you then need to make bug fixes to that release you would create a branch at the tag

How to Implement URL Signing for HighWinds CDN in PHP:

   //the input URL example taken from https://support.highwinds.com/display/DOCS/Content+Protection 
   $URL = parse_url("http://aaa.wdd3.cdn.net/secure123/content.mp4");
   
   // parse URL to separate the host and the rest of the url string
   $uri= $URL['path'];

   // set a secret pass

$secret = 'abcdef123';

git tree at default when we have not merged nor rebased:

we get by rebasing:

Generate Strong Password with PHP

    $length = 8;
    $characters_pool = 'luds';
    $sets = array();
    if (strpos($characters_pool, 'l') !== false) {
        $sets[] = 'abcdefghjkmnpqrstuvwxyz';
    }
    if (strpos($characters_pool, 'u') !== false) {

$sets[] = 'ABCDEFGHJKMNPQRSTUVWXYZ';


	$(function() {

	$('#sidebar-filters-submit').click(function(e) {
	$(".navigation").find(".error").remove();
	allOk = true;

	if ($("#search_page_keywords").val()) {
	var input = $("#search_page_keywords").val();
	if (/^[a-zA-Z0-9 ]*$/.test(input) === false) {


	function nk_thumbnail_upscale( $default, $orig_w, $orig_h, $new_w, $new_h, $crop ){
	if ( !$crop ) return null; // let the wordpress default function handle this

	$aspect_ratio = $orig_w / $orig_h;
	$size_ratio = max($new_w / $orig_w, $new_h / $orig_h);

	$crop_w = round($new_w / $size_ratio);
	$crop_h = round($new_h / $size_ratio);