How to enable CORS in Laravel 5

https://www.youtube.com/watch?v=PozYTvmgcVE

1. Add middleware
php artisan make:middleware Cors

return $next($request)
->header('Access-Control-Allow-Origin', '*')
->header('Access-Control-Allow-Methods', 'GET, POST, PUT, DELETE, OPTIONS');

2. Register middleware as a route middleware

3. Use middleware in routes which support CORS

Up and Running MapServer in Windows

https://www.youtube.com/watch?v=S0HXW89dZ4c

How to Convert Shape file into geojson

https://www.youtube.com/watch?v=VL38816h4tU

Social Networks Token Playground

Facebook

Generate Token:
https://developers.facebook.com/tools/explorer/145634995501895/?method=GET&path=me%3Ffields%3Did%2Cfirst_name%2Clast_name%2Cemail&version=v2.8

Get user by access token:

https://graph.facebook.com/me?fields=id,first_name,last_name,email,picture&access_token={ACCESS_TOKEN}

 

Google

Generate Token:
https://developers.google.com/oauthplayground/


Get user by access token:
https://www.googleapis.com/oauth2/v1/userinfo?access_token={ACCESS_TOKEN}

Laravel 5.1 Useful Resources

• Update account password - http://teamnik.org/how-to-update-user-password-in-laravel5/
  


• User ACL with Entrust - http://itsolutionstuff.com/post/laravel-52-user-acl-roles-and-permissions-with-middleware-using-entrust-from-scratch-tutorialexample.html


• Track user last login time - http://coffeecupweb.com/capture-last-login-time-in-laravel-5/
  


• Retain old input & object state with create edit form - https://laracasts.com/discuss/channels/code-review/clean-way-to-inject-old-input
  


• Load settings from database -
  http://stackoverflow.com/questions/32824781/laravel-load-settings-from-database
  https://laracasts.com/discuss/channels/general-discussion/l5-best-way-to-load-settings-from-database
  


• Custom Helper -
  http://laravel-recipes.com/recipes/50/creating-a-helpers-file
  http://stackoverflow.com/questions/28290332/best-practices-for-custom-helpers-on-laravel-5
  


• Cron Jobs
  https://www.sitepoint.com/managing-cronjobs-with-laravel/
  http://www.easylaravelbook.com/blog/2015/01/27/introducing-the-laravel-5-command-scheduler/
  http://blog.mauriziobonani.com/laravel-cron-jobs-on-shared-hosting/

 

Hosting

• Host in a shared server - http://laraveldaily.com/laravel-and-shared-hosting-working-with-ftp-and-phpmyadmin/

Lumen

https://github.com/lucadegasperi/oauth2-server-laravel

http://esbenp.github.io/2015/05/26/lumen-web-api-oauth-2-authentication/

http://mrgott.com/joomla/24-integrate-oauth2-server-into-lumen-to-secure-your-restful-api-with-access-tokens

http://loige.co/developing-a-web-application-with-lumen-and-mysql/

 

MySQL Database Design for i18n

http://www.apphp.com/tutorials/index.php?page=multilanguage-database-design-in-mysql

Handle Cloning with jQuery Uniform

If you try to apply uniform styles for cloned elements, you may come across some weird situations where you don't get the expected output. Just try this if it applies to you also.

The bold text is the most important and it should be applied in the same order.

$.uniform.restore('.is_variant_enabled');
$('.is_variant_enabled').uniform();

 

[sourcecode language="javascript"]
$.uniform.restore('.is_variant_enabled');
var row = $("#tbl_variants").find('tr:eq(1)').clone();
$("#tbl_variants tbody").prepend(row);
$('.is_variant_enabled').uniform();
[/sourcecode]

Export Magento Product Categories to custom table

[sourcecode language="php"]
<?php

ini_set('max_execution_time', 1500);
error_reporting(-1);
ini_set('display_errors', 1);

require_once 'app/Mage.php';
umask(0);
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
$userModel = Mage::getModel('admin/user');
$userModel->setUserId(0);


$categories = Mage::getModel('catalog/category')->getCollection()
        ->addAttributeToSelect('id')
        ->addAttributeToSelect('name')
        ->addAttributeToSelect('url_key')
        ->addAttributeToSelect('url')
        ->addAttributeToSelect('is_active');

foreach ($categories as $category) {

    $entity_id = $category->getId();
    $name = mysql_real_escape_string($category->getName());
    $url_key = $category->getUrlKey();
    $url_path = $category->getUrl();
    $is_active = $category->getIsActive();
    $now = time();

    $catids = array();
    foreach ($category->getParentCategories() as $parent) {
        $catids[] = $parent->getId();
    }
    unset($catids[count($catids) - 1]);

    $parent = NULL;
    if (empty($catids)) {
        $parent = NULL;
    } else {
        $parent = array_pop($catids);
    }

$con = mysql_connect("HOST", "USER", "PASSWORD");
mysql_select_db("DB", $con) or die("");

mysql_query("INSERT INTO `categories`(`id`, `name`, `slug`, `parent_id`, `enabled`, `modified_at`, `modified_by`) VALUES ('$entity_id', '$name', '$url_key', '$parent' ,'$is_active', '$now', 1)")  or die(mysql_error());
}

[/sourcecode]

Survey of the Best Online Mapping Tools for Web Developers: The Roadmap to Roadmaps

Survey of the Best Online Mapping Tools for Web Developers: The Roadmap to Roadmaps

Change Database Collation with PHP

This little sql statement can change the collation in your database including tables, columns and everywhere. This is something phpMyAdmin can not handle completely.

Credits goes to original poster.

[sourcecode language="php"]

$conn1=new MySQLi("localhost","root","","exam_db");
if($conn1->connect_errno){
    echo mysqli_connect_error();
    exit;
}
$res=$conn1->query("show tables") or die($conn1->error);
while($tables=$res->fetch_array()){
    $conn1->query("ALTER TABLE $tables[0] CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci") or die($conn1->error);
}
echo "The collation of your database has been successfully changed!";

$res->free();
$conn1->close();


[/sourcecode]

CodeIgniter Resize and Crop Image

http://kennykee.com/138/codeigniter-resize-and-crop-image-to-fit-container-div-example/