Sabid Barahona sabid

## laravel_instalation_laravel.phar
$curl -O  http://laravel.com/laravel.phar
$ chmod 755 laravel.phar
$ mv laravel.phar /usr/local/bin/
$ sudo laravel new myl4site
Crafting application...
Application ready! Build something amazing.
$ ls myl4site

Permissions for laravel storage folder

## Laravel Query Listenen
Event::listen('illuminate.query), function($slq)
{
  var_dump($sql);
}

## 0_reuse_code.js
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

## Laravel Artisan tinker
Example:

$user= User::find(1);
var_dump($user->projects);


## Laravel Form select populate.php
Controller Create
$ciudades_opciones = \Ciudad::orderBy('nombre', 'asc')->lists('nombre','id');

View of create
{{  Form::select('ciudad_id', array('default' => 'Seleccione') +  $ciudades_opciones,  null, array('class' => 'form-control select2me')) }}

Note: the null options is the default value

## Laravel: Blade: Limit foreach loop
@foreach ($posts->slice(0, 5) as $post)

  <h1>{{ $post['title'] }}</h1>

@endforeach

## Database
CREATE TABLE `paises` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

CREATE TABLE `ciudades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pais_id` int(11) DEFAULT NULL,
  `nombre` varchar(50) DEFAULT NULL,

## .htaccess
<IfModule mod_rewrite.c>
    RewriteEngine On

    RewriteRule ^(.*)$ public/$1 [L]
</IfModule>

## part_of_date
$parts = explode('-', '2068-06-15');
echo $parts[0];

## Filter records by year
Route::get('/year',function()
{
   $year= '2013';
    return Post::whereRaw('YEAR(`posted_date`) = ?', array($year))->get();
});

Auto:
http://albertokempis.com/content/filter-records-according-year-using-laravel-eloquent-orm
	$curl -O http://laravel.com/laravel.phar
	$ chmod 755 laravel.phar
	$ mv laravel.phar /usr/local/bin/
	$ sudo laravel new myl4site
	Crafting application...
	Application ready! Build something amazing.
	$ ls myl4site

	Permissions for laravel storage folder
	Event::listen('illuminate.query), function($slq)
	{
	var_dump($sql);
	}
	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console
	Controller Create
	$ciudades_opciones = \Ciudad::orderBy('nombre', 'asc')->lists('nombre','id');

	View of create
	{{ Form::select('ciudad_id', array('default' => 'Seleccione') + $ciudades_opciones, null, array('class' => 'form-control select2me')) }}

	Note: the null options is the default value
	@foreach ($posts->slice(0, 5) as $post)

	<h1>{{ $post['title'] }}</h1>

	@endforeach
	CREATE TABLE `paises` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`nombre` varchar(50) DEFAULT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

	CREATE TABLE `ciudades` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`pais_id` int(11) DEFAULT NULL,
	`nombre` varchar(50) DEFAULT NULL,
	<IfModule mod_rewrite.c>
	RewriteEngine On

	RewriteRule ^(.*)$ public/$1 [L]
	</IfModule>
	Route::get('/year',function()
	{
	$year= '2013';
	return Post::whereRaw('YEAR(`posted_date`) = ?', array($year))->get();
	});

	Auto:
	http://albertokempis.com/content/filter-records-according-year-using-laravel-eloquent-orm