Monday, September 5, 2016
How to upload file into Dropbox in Laravel | Working with Dropbox API to upload file | Laravel 5 dropbox api file upload
Dropbox a popular file hosting provider provides cloud storage till 2GB for free user. In this tutorial we'll use dropbox api to upload file into dropbox. By using dropbox we can keep backup of out project files, database and so on. So let's start how we can do it ..
1. First we need to install thephpleague/flysystem-dropbox package in our project.
2. Then we need to create a dropbox app and after creating we need to get the App's secret key and token.
3. Let's put this in .env file as following:
DROPBOX_TOKEN=app_token
DROPBOX_SECRET=app_secret
4. Now go to vendor\dropbox\dropbox-sdk\lib\dropbox\RequestUtil.php in your project directory and comment out the following lines :
/*
if (strlen((string) PHP_INT_MAX) < 19) {
// Looks like we're running on a 32-bit build of PHP. This could cause problems because some of the numbers
// we use (file sizes, quota, etc) can be larger than 32-bit ints can handle.
throw new \Exception("The Dropbox SDK uses 64-bit integers, but it looks like we're running on a version of PHP that doesn't support 64-bit integers (PHP_INT_MAX=" . ((string) PHP_INT_MAX) . "). Library: \"" . __FILE__ . "\"");
}*/
otherwise later when you run the project you'll get following error:
The Dropbox SDK uses 64-bit integers, but it looks like we're running on a version of PHP that doesn't support 64-bit integers
5. Now let's create the routes in routes.php
Route::get('dropboxUpload', 'dropController@dropboxUpload'); Route::post('dropboxFileUpload', 'dropController@dropboxFileUpload');
6. Now we gonna make the dropController.php with the following command:
php artisan make:controller dropController
7. Change the following code with the existing code in dropController.php<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use Illuminate\Http\UploadedFile; use Illuminate\Support\Facades\Input; use Validator; use Illuminate\Support\Facades\Redirect; use League\Flysystem\Dropbox\DropboxAdapter; use League\Flysystem\Filesystem; use Dropbox\Client; use Dropbox\WriteMode; class dropController extends Controller { public function dropboxUpload() { return view('droboxUpload'); } public function dropboxFileUpload() { $Client = new Client(env('DROPBOX_TOKEN'), env('DROPBOX_SECRET')); $file = fopen(Input::file('image'), 'rb'); $size = filesize(Input::file('image')); $dropboxFileName = '/'.Input::file('image')->getClientOriginalName(); $Client->uploadFile($dropboxFileName,WriteMode::add(),$file, $size); $links['share'] = $Client->createShareableLink($dropboxFileName); $links['view'] = $Client->createTemporaryDirectLink($dropboxFileName); print_r($links); } }
8. Now we gonna create the dropboxUpload.blade.php :
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Dropbox with Laravel 5</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" >
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="#">Upload File to Dropbox using Laravel </a>
</div>
</div>
</nav>
<div class="container">
<form style="border: 4px solid #a1a1a1;margin-top: 15px;padding: 10px;" action="{{ URL::to('dropboxFileUpload') }}" class="form-horizontal" method="post" enctype="multipart/form-data" >
<input type="file" name="image" />
{!! Form::token(); !!}
{!! csrf_field() ; !!}
<button class="btn btn-primary">Import File</button>
</form>
</div>
</body>
</html>Hope this tutorial will help you to upload file into DropBox.
Sunday, September 4, 2016
How to Export CSV/xls/xlsx from Model in Laravel | How to Download Table Data / Database to CSV /xls / xlsx in Laravel?
In this tutorial I have shown you how you can download/ Export database to CSV/ xls/ xlsx. Sometimes we need to download the database as csv or excel format for seeing the report of the project. Here we used Maatwebsite/Laravel-Excel package for generating the csv or excel format.
So lets see how we can do it..
1. First we need to install the Maatwebsite/Laravel-Excel package in our laravel project. Installing process has fully described in documentation itself. Bu if you find any difficulty you can comment it here.
3. Let's create a Model and database with name 'Item' with the following command in cmd inside of your project :
php artisan make:model Item -m
4. Use following code in Model name Item.php :<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Item extends Model
{
public $fillable = ['title','description'];
}<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateItemsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('items', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->text('description');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('items');
}
}php artisan migrate
7. Let's put some demo data on your database table in phpmyadmin.
8. Now go to route and write the following code in routes.php
<?php Route::get('importExport', 'ImportController@importExport'); Route::get('downloadExcel/{type}', 'ImportController@downloadExcel');
9. Now let's create Importcontroller.php using following code:
php artisan make:controller ImportController
10. Now change the following code with the existing code of Importcontroller.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Requests;
use DB;
use Excel;
use App\Item;
use Illuminate\Support\Facades\Input;
use Validator;
use Illuminate\Support\Facades\Redirect;
class ImportController extends Controller
{
public function importExport()
{
return view('importExport');
}
public function downloadExcel($type)
{
if($type == 'csv'){
$data = Item::get()->toArray();
return Excel::create('demo_example', function($excel) use ($data) {
$excel->sheet('mySheet', function($sheet) use ($data)
{
$sheet->fromArray($data);
header('Content-Encoding: UTF-8');
header('Content-type: text/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename=itsolutionstuff_example.csv');
echo "\xEF\xBB\xBF";
});
})->download($type);
}
else {
$data = Item::get()->toArray();
return Excel::create('itsolutionstuff_example', function($excel) use ($data) {
$excel->sheet('mySheet', function($sheet) use ($data)
{
$sheet->fromArray($data);
});
})->download($type);
}
}
}
* The above code is UTF-8 support. So anytime language is suitable for the above code.
11. Now let's create the view page and name it as importExpor.blade.php and use the following code:
11. Now let's create the view page and name it as importExpor.blade.php and use the following code:
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Export Laravel </title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" >
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="#"> Export in Excel and CSV in Laravel </a>
</div>
</div>
</nav>
<div class="container">
<a href="{{ URL::to('downloadExcel/xls') }}"><button class="btn btn-success">Download Excel xls</button></a>
<a href="{{ URL::to('downloadExcel/xlsx') }}"><button class="btn btn-success">Download Excel xlsx</button></a>
<a href="{{ URL::to('downloadExcel/csv') }}"><button class="btn btn-success">Download CSV</button></a>
</div>
</body>
</html>
12. Now if you access the route you'll see the view page and by clicking on any button you can download the required data from the table.
I hope this tutorial will help you to download the excel or csv from database.
Sunday, August 28, 2016
How to check php version on xampp? | How to know what version of PHP is used on my xampp?
XAMPP is a popular web server for running PHP script. Sometimes we need to know which version of PHP we used in XAMPP. So in this tutorial I am gonna show how you can check PHP version on XAMPP.
1. Go to your htdocs folder on XAMPP.
2. Create a txt file, write down the following code in it and save it as phpinfo.php .
<?php
phpinfo();
?>
3. Now run the server and access the file from url ( like: localhost/phpinfo.php )
4. You'll see the version of PHP in the webpage.
4. You'll see the version of PHP in the webpage.
Saturday, August 27, 2016
How to make Laravel Authentication | Laravel 5 Authentication | How to Make User Login and Registration Laravel 5
In laravel you can use Laravel Authentication for authenticate user. By a single command you gen generate full authentication system with resources and routes. Let's see how you can do it ..
Go to your project directory -->> open cmd and run the following command:
php artisan make:auth
you'll see the list of views, route and controller generated in your command prompt.
Now if you access the project in url ..you'll see the login and register page like this:
Register Page:
Register Page:
Login Page:
So this is the process how you can make simple Authentication system using Laravel Authentication.
Tuesday, August 23, 2016
How to import csv/ excel file into database in laravel? | Upload CSV / Excel file and import it to database using Laravel
In this tutorial I have shown you how you can Import CSV/ excel file into Database Sometimes we need to import csv / excel file into database for update purpose or new data has came which we need to save in database . Here we used Maatwebsite/Laravel-Excel package for generating the csv or excel format.
So lets see how we can do it..
1. First we need to install the Maatwebsite/Laravel-Excel package in our laravel project. Installing process has fully described in documentation itself. Bu if you find any difficulty you can comment it here.
3. Let's create a Model and database with name 'Item' with the following command in cmd inside of your project :
php artisan make:model Item -m
4. Use following code in Model name Item.php :<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Item extends Model
{
public $fillable = ['title','description'];
}<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateItemsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('items', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->text('description');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('items');
}
}php artisan migrate
7. Now go to route and write the following code in routes.php
<?php Route::get('importExport', 'ImportController@importExport'); Route::post('importExcel', 'ImportController@importExcel');
8. Now let's create Importcontroller.php using following code:
php artisan make:controller ImportController
9. Now change the following code with the existing code of Importcontroller.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Requests;
use DB;
use Excel;
use App\Item;
use Illuminate\Support\Facades\Input;
use Validator;
use Illuminate\Support\Facades\Redirect;
class ImportController extends Controller
{
public function importExport()
{
return view('importExport');
}
public function importExcel()
{
// Get current data from items table
$titles = Item::lists('title')->toArray();
if(Input::hasFile('import_file')){
$path = Input::file('import_file')->getRealPath();
$data = Excel::load($path, function($reader) {
})->get();
if(!empty($data) && $data->count()){
$insert = array();
foreach ($data as $key => $value) {
// Skip title previously added using in_array
if (in_array($value->title, $titles))
continue;
$insert[] = ['title' => $value->title, 'description' => $value->description];
// Add new title to array
$titles[] = $value->title;
}
if(!empty($insert)){
DB::table('items')->insert($insert);
}
}
}
return back();
}
}
* The above code will help you to resist from uploading redundant data.
10. Now let's create the view page and name it as importExpor.blade.php and use the following code:
10. Now let's create the view page and name it as importExpor.blade.php and use the following code:
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Import Laravel </title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" >
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="#"> Import Excel or CSV into Database</a>
</div>
</div>
</nav>
<div class="container">
<form style="border: 4px solid #a1a1a1;margin-top: 15px;padding: 10px;" action="{{ URL::to('importExcel') }}" class="form-horizontal" method="post" enctype="multipart/form-data" >
<input type="file" name="import_file" />
{!! Form::token(); !!}
{!! csrf_field() ; !!}
<button class="btn btn-primary">Import File</button>
</form>
</div>
</body>
</html>
11. Now if you access the route you'll see the view page and by clicking on 'choose file' button you can choose the file and by clicking on 'import file' you can import the file into database successfully.
12. Here is a demo of Excel file which you can upload:
I hope you like the tutorial. By this tutorial you can import the csv or excel file easily into database.
