Laravel Upgrading To 5 From 4.2

Laravel 5 update from 4.2 – My Experience *********

composer create-project laravel/laravel –prefer-dist

NotFoundHttpException in RouteCollection.php line 161: in laravel 5 – Routing Problem

Class form or html not found in Laravel 5 :
http://tutsnare.com/class-form-or-html-not-found-in-laravel-5/

In laravel 4 it included the following two styles: “{{” and “{{{“. The double curly bracket was a raw echo and the triple curly bracket escaped. Currently in laravel 5 both the double and triple curly brackets escape the variable and a new “{!! $var !!}” is for raw.

*****************************************************
TokenMismatchException in VerifyCsrfToken.php

Add:

http://laravel.io/forum/01-30-2015-laravel5-tokenmismatchexception-in-verifycsrftoken

“I had this problem because the server was throwing a 500 error. ”

Nagyon becsapós is lehet az üzenet. A logban is kell keresni a hibát.

****************************************************

Laravel 4.2 VS Laravel 5.0 : https://www.linkedin.com/groups/4419933/4419933-6125514300493750273

Upgrading To 5.0 From 4.2: http://laravel.com/docs/master/upgrade#upgrade-5.0

Laravel 4 to Laravel 5 – The Simple Upgrade Guide: http://www.sitepoint.com/laravel-4-laravel-5-simple-upgrade-guide/

Upgrading from Laravel 4.2 to Laravel 5: http://stackoverflow.com/questions/28380678/upgrading-from-laravel-4-2-to-laravel-5

Laravel 5 Fundamentals: https://laracasts.com/series/laravel-5-fundamentals

Benchmarks: Laravel 5 vs Laravel 4: https://kanecohen.github.io/laravel-5-vs-laravel-4.html

The Ultimate Guide to Sending Email in Laravel : https://scotch.io/tutorials/ultimate-guide-on-sending-email-in-laravel

I found the best description for PHP 7 upgrade

I did the upgrade by this article but the PHP did’nt work:

http://askubuntu.com/questions/705880/how-to-install-php-7

This works for me: 1. Re-Install PHP 5.6

sudo add-apt-repository ppa:ondrej/php

sudo apt-get update

sudo apt-get install php7.0 php5.6 php5.6-mysql php-gettext php5.6-mbstring php-xdebug libapache2-mod-php5.6 libapache2-mod-php7.0

From php5.6 to php7.0 :

Apache:
sudo a2dismod php5.6 ; sudo a2enmod php7.0 ; sudo service apache2 restart

http://askubuntu.com/questions/761713/how-can-i-downgrade-from-php-7-to-php-5-6-on-ubuntu-16-04

********************************

PHP7: Mcrypt PHP extension required.

sudo apt-get update
sudo apt-get install mcrypt php7.0-mcrypt
sudo apt-get upgrade

http://stackoverflow.com/questions/34083470/php7-laravel-mcrypt-issue

***********************************

php7 CURL PHP extension:

sudo apt-get install php7.0-curl

install GD:

sudo apt-get install php7.0-gd
************************************
max_file_uploads 2 -> 20M

sudo nano /etc/php/7.0/apache2/php.ini

I edited in nano.

sudo service apache2 restart

*************************************

PHP7 Install SQLITE

sudo apt-get install php7.0-sqlite3
sudo service apache2 restart

*************************************

SQLITE and Laravel Query Builder and Eloquent

,

CREATE TABLE token (
id INTEGER PRIMARY KEY NOT NULL ,
baz varchar(255) NOT NULL,
user_id INTEGER DEFAULT NULL,
status varchar(255) NOT NULL,
created_at timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’ ,
updated_at timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’

) ;
+ Add index foo

Eloquent:
$token = new Token;
$token->foo = ‘ghgfhfghfghfg’;
$token->status = ‘sfdsfsdsd’;
$token->save();

echo $token->foo; /// !

QueryBuilder:

DB::table(‘token’)->insert(
array(‘foo’ => ‘dsadasdasdasdaf’, ‘status’ => ‘dsfdsfsdfasfdsafasd’)
);

SQLITE insert

How do I create an AUTOINCREMENT field? : A column declared INTEGER PRIMARY KEY will autoincrement.

http://www.sqlite.org/faq.html#q1

In SQLite, table rows normally have a 64-bit signed integer ROWID which is unique among all rows in the same table.

If a table contains a column of type INTEGER PRIMARY KEY, then that column becomes an alias for the ROWID.

http://www.sqlite.org/autoinc.html

Inserting, updating, and deleting data in SQLite : http://zetcode.com/db/sqlite/datamanipulation/

sqlite info – Migration from MySQL

Autoincrement is not prefered.

Autoincrement In SQLite : https://www.sqlite.org/autoinc.html

The AUTOINCREMENT keyword imposes extra CPU, memory, disk space, and disk I/O overhead and should be avoided if not strictly needed. It is usually not needed.

update: this bad definition
CREATE TABLE `baz` (
`id` int(11) NOT NULL ,
`bazoo` varchar(255) NOT NULL,
`status` varchar(255) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’ ,
`updated_at` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
PRIMARY KEY (`id`)
) ;

the good definition:

CREATE TABLE baz (
id INTEGER PRIMARY KEY NOT NULL ,
foo varchar NOT NULL, // OR TEXT

status varchar NOT NULL,
created_at timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’ ,
updated_at timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’

) ;

Create index:
CREATE INDEX bazoo ON baz (bazoo);

Show table info:
PRAGMA table_info(tokens);

Show index info:
PRAGMA index_list(tokens);

SQLite – INDEXES : http://www.tutorialspoint.com/sqlite/sqlite_indexes.htm

Laravel – Setting up the SQLite Database Driver : http://laravel-recipes.com/recipes/118/setting-up-the-sqlite-database-driver

phpliteadmin: https://www.phpliteadmin.org/