RESTfull - Server Side CRUD Script in Laravel 5.0:
add the following route in app/Http/route.php
Route::get('service/glist/{limit}',['uses'=>'Web\WebserviceController@getGallaryAsJson', 'as'=>'service/glist/limit']);
Route::get('service/gedit/{id}',['uses'=>'Web\WebserviceController@editGallaryAsJson', 'as'=>'service/gedit/id']);
Route::put('service/gupdate',['uses'=>'Web\WebserviceController@postUpdateGallary', 'as'=>'service/gupdate']);
Route::post('service/gupdatebyajax',['uses'=>'Web\WebserviceController@postUpdateGallaryByAjax', 'as'=>'service/gupdatebyajax']);
Route::post('service/ginsert',['uses'=>'Web\WebserviceController@inImage', 'as'=>'service/ginsert']);
Route::post('service/ginsertbyajax',['uses'=>'Web\WebserviceController@inImageByAjax', 'as'=>'service/ginsertbyajax']);
Route::delete('service/delete/{id}',['uses'=>'Web\WebserviceController@destroy', 'as'=>'service/delete/id']);
add a controller to operate CRUD operation as App/Http/Controllers/Web/WebserviceController.php
<?php namespace App\Http\Controllers\Web;
use Auth;
use Illuminate\Contracts\Auth\Guard;
use App\Http\Controllers\Controller;
use App\Models\Web\Web_Content;
use Illuminate\Http\Request;
use App\User;
use App;
use URL;
use App\Models\Web\WebImageGallery;
use App\Models\Web\Web_Section;
use App\Models\Web\Web_Category;
use Carbon\Carbon;
use DB;
use Illuminate\Support\Facades\Input;
use App\Services\Web\WebServices;
use Illuminate\Support\Facades\File;
class WebserviceController extends Controller {
public function getGallaryAsJson(Request $request){
$data = array();
$location = URL::to('/').'/public/images/upload/gallery/';
$limit = $request->route()->parameter('limit')?:'';
$userIns = WebImageGallery::orderBy('id','desc')
->limit($limit)
->get();
foreach($userIns as $userI){
$basePath = null;
if($userI->web_section_id && $userI->web_category_id){
$basePath = $location.$userI->web_sections->section_name.'/'.$userI->web_categorys->category_name.'/';
}else{
$basePath = $location.$userI->web_sections->section_name.'/';
}
$data[] = array(
'id'=>$userI->id,
'title'=>$userI->title,
'image'=>$basePath.$userI->thumb_path,
);
}
if($userIns) {
header('Content-type: application/json');
return json_encode(array('posts'=>$data));
}else{
return json_encode(array('posts'=>"no data found"));
}
}
public function editGallaryAsJson(Request $request,$id){
$userIns = WebImageGallery::find($id);
if($userIns) {
header('Content-type: application/json');
return json_encode($userIns);
}else{
return json_encode(array('posts'=>"no data found"));
}
}
public function postUpdateGallary(Request $request){
$id = $request->input('id');
$insert =null;
$galleryission = null;
$location = null;
$fileObject = null;
if($request->input('file_name')){
$fileObject = new \Symfony\Component\HttpFoundation\File\UploadedFile($request->input('fup_ukmFile'),$request->input('file_name'),$request->input('type'),$request->input('size'),null,TRUE);
}
//$fileObjectTT = new \Symfony\Component\HttpFoundation\File\UploadedFile('G:/image/one_and_all/shari/s1 - Copy - Copy.jpeg',$request->input('file_name'),$request->input('type'),$request->input('size'),null,TRUE);
try{
if ($request->input('id')) {
$location = base_path()."/public/images/upload/gallery/";
if($fileObject){
if($request->input('web_section_id') && $request->input('web_category_id')){
$location = $location.DB::select("select * from web_sections where id='".$request->input('web_section_id')."'")[0]->section_name."/";
$location = $location.DB::select("select * from web_categorys where id='".$request->input('web_category_id')."'")[0]->category_name."/";
if(!File::exists($location)) {
File::makeDirectory($location, 0775, true);
}
}else{
$location = $location.DB::select("select * from web_sections where id='".$request->input('web_section_id')."'")[0]->section_name."/";
if(!File::exists($location)) {
File::makeDirectory($location, 0775, true);
}
}
}
$galleryission = WebImageGallery::find($id);
$galleryission->title = $request->input('fup_title');
if($fileObject){
$galleryission->thumb_path = WebServices::fileUploadThumb($fileObject,true,$location,100,70);
$galleryission->medium_path = WebServices::fileUploadMedium($fileObject,true,$location,300,210);
$galleryission->large_path = WebServices::fileUpload($fileObject,true,$location);
$galleryission->web_section_id= $request->input('web_section_id');
$galleryission->web_category_id= ($request->input('web_category_id'))? $request->input('web_category_id'):null;
}
$galleryission->active = $request->input('fup_active');
$galleryission->update_date = Carbon::now();
$insert = $galleryission->update();
} // end if
if($insert){
return 'true';
}
}catch(Exception $e){
return 'false';
}
}
public function postUpdateGallaryByAjax(Request $request){
$id = $request->input('id');
$insert =null;
$galleryission = null;
$location = null;
$fileObject = null;
$fup_ukmFile = @$_FILES['file'];
if($fup_ukmFile['name']){
$fileObject = new \Symfony\Component\HttpFoundation\File\UploadedFile($fup_ukmFile['tmp_name'],$fup_ukmFile['name'],$fup_ukmFile['type'],$fup_ukmFile['size'],null,TRUE);
}
try{
if ($request->input('id')) {
$location = base_path()."/public/images/upload/gallery/";
if($fileObject){
if($request->input('web_section_id') && $request->input('web_category_id')){
$location = $location.DB::select("select * from web_sections where id='".$request->input('web_section_id')."'")[0]->section_name."/";
$location = $location.DB::select("select * from web_categorys where id='".$request->input('web_category_id')."'")[0]->category_name."/";
if(!File::exists($location)) {
File::makeDirectory($location, 0775, true);
}
}else{
$location = $location.DB::select("select * from web_sections where id='".$request->input('web_section_id')."'")[0]->section_name."/";
if(!File::exists($location)) {
File::makeDirectory($location, 0775, true);
}
}
}
$galleryission = WebImageGallery::find($id);
$galleryission->title = $request->input('fup_title');
if($fileObject){
$galleryission->thumb_path = WebServices::fileUploadThumb($fileObject,true,$location,100,70);
$galleryission->medium_path = WebServices::fileUploadMedium($fileObject,true,$location,300,210);
$galleryission->large_path = WebServices::fileUpload($fileObject,true,$location);
$galleryission->web_section_id= $request->input('web_section_id');
$galleryission->web_category_id= ($request->input('web_category_id'))? $request->input('web_category_id'):null;
}
$galleryission->active = $request->input('fup_active');
$galleryission->update_date = Carbon::now();
$insert = $galleryission->update();
} // end if
if($insert){
return 'true';
}
}catch(Exception $e){
return 'false';
}
}
public function inImage(Request $request){
$insert =null;
$galleryission = null;
$location = null;
$fileObject = new \Symfony\Component\HttpFoundation\File\UploadedFile($request->input('fup_ukmFile'),$request->input('file_name'),$request->input('type'),$request->input('size'),null,TRUE);
//$fileObjectTT = new \Symfony\Component\HttpFoundation\File\UploadedFile('G:/image/one_and_all/shari/s1 - Copy - Copy.jpeg',$request->input('file_name'),$request->input('type'),$request->input('size'),null,TRUE);
try{
if ($request->input('fup_title') && $fileObject) {
$location = base_path()."/public/images/upload/gallery/";
if($request->input('web_section_id') && $request->input('web_category_id')){
$location = $location.DB::select("select * from web_sections where id='".$request->input('web_section_id')."'")[0]->section_name."/";
$location = $location.DB::select("select * from web_categorys where id='".$request->input('web_category_id')."'")[0]->category_name."/";
if(!File::exists($location)) {
File::makeDirectory($location, 0775, true);
}
}else{
$location = @$location.DB::table('web_sections')->select('section_name')->where("web_section_id",$request->input('web_section_id'))->first()->section_name."/";
if(!File::exists($location)) {
File::makeDirectory($location, 0775, true);
}
}
$galleryission = new WebImageGallery();
$galleryission->title = $request->input('fup_title');
$galleryission->thumb_path = WebServices::fileUploadThumb($fileObject,true,$location,100,70);
$galleryission->medium_path = WebServices::fileUploadMedium($fileObject,true,$location,300,210);
$galleryission->large_path = WebServices::fileUpload($fileObject,true,$location);
$galleryission->web_section_id= $request->input('web_section_id');
$galleryission->web_category_id= ($request->input('web_category_id'))? $request->input('web_category_id'):null;
$galleryission->active = $request->input('fup_active');
$galleryission->create_date = Carbon::now();
//$galleryission->create_by = Auth::user()->id ;
$insert = $galleryission->save();
} // end if
if($insert){
return 'true';
}
}catch(Exception $e){
return 'false';
}
}
public function inImageByAjax(Request $request){
$insert =null;
$galleryission = null;
$location = null;
$fup_ukmFile = @$_FILES['file'];
if($fup_ukmFile['name']){
$fileObject = new \Symfony\Component\HttpFoundation\File\UploadedFile($fup_ukmFile['tmp_name'],$fup_ukmFile['name'],$fup_ukmFile['type'],$fup_ukmFile['size'],null,TRUE);
}
try{
if ($fup_ukmFile['name'] && $fileObject) {
$location = base_path()."/public/images/upload/gallery/";
if($request->input('web_section_id') && $request->input('web_category_id')){
$location = $location.DB::select("select * from web_sections where id='".$request->input('web_section_id')."'")[0]->section_name."/";
$location = $location.DB::select("select * from web_categorys where id='".$request->input('web_category_id')."'")[0]->category_name."/";
if(!File::exists($location)) {
File::makeDirectory($location, 0775, true);
}
}else{
$location = @$location.DB::table('web_sections')->select('section_name')->where("web_section_id",$request->input('web_section_id'))->first()->section_name."/";
if(!File::exists($location)) {
File::makeDirectory($location, 0775, true);
}
}
$galleryission = new WebImageGallery();
$galleryission->title = $request->input('fup_title');
$galleryission->thumb_path = WebServices::fileUploadThumb($fileObject,true,$location,100,70);
$galleryission->medium_path = WebServices::fileUploadMedium($fileObject,true,$location,300,210);
$galleryission->large_path = WebServices::fileUpload($fileObject,true,$location);
$galleryission->web_section_id= $request->input('web_section_id');
$galleryission->web_category_id= ($request->input('web_category_id'))? $request->input('web_category_id'):null;
$galleryission->active = $request->input('fup_active');
$galleryission->create_date = Carbon::now();
$insert = $galleryission->save();
}
if($insert){
return 'true';
}
}catch(Exception $e){
return 'false';
}
}
public function destroy(Request $request,$id){
$del = null;
$location ="public/images/upload/gallery/";
$webImageGallerys = WebImageGallery::find($id);
if($webImageGallerys->web_section_id && $webImageGallerys->web_category_id){
$location = $location.DB::select("select * from web_sections where id='".$webImageGallerys->web_section_id."'")[0]->section_name."/";
$location = $location.DB::select("select * from web_categorys where id='".$webImageGallerys->web_category_id."'")[0]->category_name."/";
$thumb_file = $location.$webImageGallerys->thumb_path;
$medium_file = $location.$webImageGallerys->medium_path;
$large_file = $location.$webImageGallerys->large_path;
if(File::exists($thumb_file) || File::exists($medium_file) || File::exists($large_file)) {
File::delete($thumb_file);
File::delete($medium_file);
File::delete($large_file);
}
}else{
$location = $location.DB::select("select * from web_sections where id='".$webImageGallerys->web_section_id."'")[0]->section_name."/";
$thumb_file = $location.$webImageGallerys->thumb_path;
$medium_file = $location.$webImageGallerys->medium_path;
$large_file = $location.$webImageGallerys->large_path;
if(File::exists($thumb_file) || File::exists($medium_file) || File::exists($large_file)) {
File::delete($thumb_file);
File::delete($medium_file);
File::delete($large_file);
}
}
if($webImageGallerys->delete()){
return 'true';
}else{
return 'false';
}
}
}
RESTful - Client Side Script with HTTPClient:
Download:HTTPClient lib
file url:http://localhost/restclient/request.php
<?php
require_once('/HttpClient.class.php');
error_reporting("all");
class Request{
public $response = null;
public $resu = null;
public $instance = null;
function __construct() {
$this->instance = new HttpClient();
}
function listAll(){
$url = 'http://localhost/rest/service/glist/10';
$this->response = $this->instance->get($url);
return json_decode($this->response);
}
function insert($data){
$url = 'http://localhost/rest/service/ginsert';
$this->response = $this->instance->post($url,$data);
return json_decode($this->response);
}
function edit($id){
$url = 'http://localhost/rest/service/gedit/'.$id.'';
$this->response = $this->instance->get($url);
if($this->response){
return json_decode($this->response);
}else{
return false;
}
}
function update($data){
$url = 'http://localhost/rest/service/gupdate';
$this->response = $this->instance->put($url,$data);
return json_decode($this->response);
}
function delete($id){
$url = 'http://localhost/rest/service/delete/'.$id.'';
$this->response = $this->instance->delete($url);
return json_decode($this->response);
}
}
?>
file url:http://localhost/restclient/list.php
<?php
<?php
require('request.php');
$requestIns = new Request();
?>
<html>
<title>upload</title>
<head >
<link href="bootstrap-3.3.7/dist/css/bootstrap.css" rel="stylesheet" type="text/css">
<script src="http://code.jquery.com/jquery-1.11.1.min.js"></script>
<script>
function previewFile() {
var preview = document.querySelector('img');
var file = document.querySelector('input[type=file]').files[0];
var reader = new FileReader();
reader.addEventListener("load", function () {
preview.src = reader.result;
}, false);
if (file) {
var dd = reader.readAsDataURL(file);
}
}
</script>
<script>
jQuery(function(){
jQuery('#ukm').change( function(event) {
var tmppath = URL.createObjectURL(event.target.files[0]);
jQuery("img").fadeIn("fast").attr('src',tmppath);
alert(json.stringfy(event.target.files[0]));
});
});
</script>
</head>
<body>
<div class="panel panel-success">
<div class="panel-heading">New Gallery</div>
<div class="panel-body">
<?php
if($requestIns->listAll()){
?>
<table class="table">
<caption> By HTTPClient</caption>
<tr>
<th>Title</th>
<th>Image</th>
<th>action</th>
</tr>
<?php
foreach($requestIns->listAll() as $respon1){
foreach($respon1 as $resp){
echo'<tr>';
echo'<td>'.$resp->title.'</td>';
echo'<td><img style="width:100px;" src="'.$resp->image.'"></td>';
$edit ="http://localhost/restclient/edit.php?id=".$resp->id."";
$delete ="http://localhost/restclient/insertUpdate.php?delete=d&id=".$resp->id."";
$add ="http://localhost/restclient/upload.php";
echo"<td><a class='btn btn-sm btn-primary' href=".$edit.">edit</a>";
echo"<a class='btn btn-sm btn-warning' href=".$delete.">delete</a>";
echo"<a class='btn btn-sm btn-warning' href=".$add.">Add</a></td>";
echo'</tr>';
}
}
echo'<table>';
}
?>
</div>
</div>
</body>
</html>
file url:http://localhost/restclient/edit.php
<?php
require_once('request.php');
$requestIns = new Request();
?>
<html>
<title>upload</title>
<head>
<link href="bootstrap-3.3.7/dist/css/bootstrap.css" rel="stylesheet" type="text/css" >
<script src="http://code.jquery.com/jquery-1.11.1.min.js"></script>
<script>
function previewFile() {
var preview = document.querySelector('img');
var file = document.querySelector('input[type=file]').files[0];
var reader = new FileReader();
reader.addEventListener("load", function () {
preview.src = reader.result;
}, false);
if (file) {
var dd = reader.readAsDataURL(file);
getFilePath();
}
}
function getFilePath(){
var file = document.querySelector('input[type=file]').files[0];
var filePath=jQuery('#ukm').val();
var path = (window.URL || window.webkitURL).createObjectURL(file);
const reader = new FileReader();
alert(reader.readAsText(path));
}
</script>
<script>
jQuery(function(){
jQuery('#ukm').change( function(event) {
var tmppath = URL.createObjectURL(event.target.files[0]);
jQuery("img").fadeIn("fast").attr('src',tmppath);
alert(json.stringfy(event.target.files[0]));
});
});
</script>
</head>
<body>
<?php
$id = $_GET['id'];
$galleryIns = $requestIns->edit($id);
if($galleryIns){
?>
<div class="panel panel-success">
<div class="panel-heading">Update Gallery</div>
<div class="panel-body">
<form class="form-horizontal" role="form" method="POST" action="http://localhost/restclient/insertUpdate.php" enctype="multipart/form-data">
<div class="form-group col-md-4">
<label>Web Section</label>
<div>
<select name="web_section_id" class="form-control" value="web_section_id; ?>">
<option value="39">Image Gallery</option>
</select>
</div>
</div>
<div class="form-group col-md-4">
<label>Web Category</label>
<div>
<select name="web_category_id" class="form-control" value="web_category_id;?>">
<option value="20">Image Gallery</option>
</select>
</div>
</div>
<div class="col-md-12 col-lg-12 cls">
<div class="form-group col-md-4">
<label>Upload File</label>
<div>
<input type="file" name="fup_ukmFile" id="ukm" accept=".gif,.jpg,.jpeg,.png" onchange="previewFile()">
<img src="" height="200" alt="Image preview...">
</div>
</div>
<div class="form-group col-md-4">
<label>Title</label>
<div>
<input type="hidden" name="id" value="id; ?>"/>
<input type="text" pattern="^[A-Za-z_-\\]{5,50}" class="form-control" id="fup_title" name="fup_title" value="title; ?>">
</div>
</div>
<div class="form-group col-md-4">
<label>Is Publish</label>
<div>
<select name="fup_active" class="form-control" value="active; ?>">
<option value="1">Publish</option>
<option value="0">Unpublish</option>
</select>
</div>
</div>
</div>
<div class="form-group">
<div class="col-md-12" align="center">
<input type="hidden" name="update" value="update"/>
<button type="submit" class="btn btn-primary">
Submit
</button>
</div>
</div>
</form>
</div>
</div>
</body>
<?php
}
?>
</html>
file url:http://localhost/restclient/insertUpdate.php
<?php
require_once('request.php');
if(@$_POST['update']=='update'){
$data = array(
'id'=>$_POST['id'],
'web_category_id'=>$_POST['web_category_id'],
'web_section_id'=>$_POST['web_section_id'],
'fup_ukmFile'=>$_FILES['fup_ukmFile']["tmp_name"],
'tmp_path'=>$_FILES['fup_ukmFile']["tmp_name"],
'file_name'=>$_FILES['fup_ukmFile']["name"],
'type'=>$_FILES['fup_ukmFile']["type"],
'size'=>$_FILES['fup_ukmFile']["size"],
'fup_title'=>$_POST['fup_title'],
'fup_active'=>$_POST['fup_active']
);
$requestIns = new Request();
if($requestIns->update($data)){
return header("Location: http://localhost/restclient/list.php", true, 301);
}else{
header("Location: http://localhost/restclient/edit.php?id=".$_POST['id']."", true, 301);
}
}else if(@$_POST['insert']=='insert'){
$data = array(
'web_category_id'=>$_POST['web_category_id'],
'web_section_id'=>$_POST['web_section_id'],
'fup_ukmFile'=>$_FILES['fup_ukmFile']["tmp_name"],
'tmp_path'=>$_FILES['fup_ukmFile']["tmp_name"],
'file_name'=>$_FILES['fup_ukmFile']["name"],
'type'=>$_FILES['fup_ukmFile']["type"],
'size'=>$_FILES['fup_ukmFile']["size"],
'fup_title'=>$_POST['fup_title'],
'fup_active'=>$_POST['fup_active']
);
$requestIns = new Request();
if($requestIns->insert($data)){
return header("Location: http://localhost/restclient/list.php", true, 301);
}else{
header("Location: http://localhost/restclient/upload.php", true, 301);
}
}else if(@$_GET['delete']=='d'){
$requestIns = new Request();
if($requestIns->delete($_GET['id'])=='true'){
return header("Location: http://localhost/restclient/list.php", true, 301);
}else{
return header("Location: http://localhost/restclient/list.php", true, 301);
}
}
?>
file url:http://localhost/restclient/upload.php
<html>
<title>upload</title>
<head>
<link href="bootstrap-3.3.7/dist/css/bootstrap.css" rel="stylesheet" type="text/css">
<script src="http://code.jquery.com/jquery-1.11.1.min.js"></script>
<script>
function previewFile() {
var preview = document.querySelector('img');
var file = document.querySelector('input[type=file]').files[0];
var reader = new FileReader();
reader.addEventListener("load", function () {
preview.src = reader.result;
}, false);
if (file) {
var dd = reader.readAsDataURL(file);
}
}
</script>
<script>
jQuery(function(){
jQuery('#ukm').change( function(event) {
var tmppath = URL.createObjectURL(event.target.files[0]);
jQuery("img").fadeIn("fast").attr('src',tmppath);
//alert(json.stringfy(event.target.files[0]));
});
});
</script>
</head>
<body>
<div class="panel panel-success">
<div class="panel-heading">New Gallery</div>
<div class="panel-body">
<form class="form-horizontal" role="form" method="POST" action="http://localhost/restclient/insertUpdate.php" enctype="multipart/form-data">
<div class="form-group col-md-4">
<label>Web Section</label>
<div>
<select name="web_section_id" class="form-control" value="">
<option value="39">Image Gallery</option>
</select>
</div>
</div>
<div class="form-group col-md-4">
<label>Web Category</label>
<div>
<select name="web_category_id" class="form-control" value="">
<option value="20">Image Gallery</option>
</select>
</div>
</div>
<div class="col-md-12 col-lg-12 cls">
<div class="form-group col-md-4">
<label>Upload File</label>
<div>
<input type="file" name="fup_ukmFile" id="ukm" accept=".gif,.jpg,.jpeg,.png" onchange="previewFile()">
<img src="" height="200" alt="Image preview...">
</div>
</div>
<div class="form-group col-md-4">
<label>Title</label>
<div>
<input type="text" pattern="^[A-Za-z_-\\]{5,50}" class="form-control" id="fup_title" name="fup_title" value="">
</div>
</div>
<div class="form-group col-md-4">
<label>Is Publish</label>
<div>
<select name="fup_active" class="form-control" value="">
<option value="1">Publish</option>
<option value="0">Unpublish</option>
</select>
</div>
</div>
</div>
<div class="form-group">
<div class="col-md-12" align="center">
<input type="hidden" name="insert" value="insert"/>
<button type="submit" class="btn btn-primary">
Submit
</button>
</div>
</div>
</form>
</div>
</div>
</body>
</html>
