i'm trying to use join here but when i used it it didn't allow any other function in my controller can anyone help me in using join , and that's my controller :
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Requests;
use App\Http\Controllers\Controller;
use Input;
use Auth;
use App\User;
use App\Product;
use DB;
class listController extends Controller
{
//
public function getIndex(){
$list=DB::table('wishlist')->get(['id','product_id','user_id']);
$product=Product::get(['name','id','salary','image_name']);
$user=DB::table('users')->get(['id']);
return view('contents.wishlist')->with('list',$list)
->with('product',$product)
->with('user',$user);
}
public function postIndex(Request $request){
$id=$request->input('id');
$user_id=Auth::user()->id;
$product_id = $request['product_id'];
DB::table('wishlist')->insert(['id'=>$id,'user_id'=>$user_id,'product_id'=>$product_id]);
return redirect()->action('listController@getIndex');
}
public function deleteDeleteProduct(Request $request,$id){
$pro=$request->get('id');
DB::table('wishlist')->where('id',$pro)->delete();
return redirect('wishlist');
}
}
and that's also my view :
@extends('master')
@section('content')
<div class="wrapper-breadcrums">
<div class="container">
<div class="row">
<div class="col-sm-24">
<div class="breadcrumbs">
<ul>
<li class="home"> <a href="http://localhost/shopsite/public/home" title="Go to Home Page"><span >Home</span></a> <span class="separator">/ </span>
</li>
<li class="cms_page"> <strong>My Account</strong>
</li>
</ul>
</div>
</div>
</div>
</div>
</div><!-- /.wrapper-breadcrums -->
<div class="em-wrapper-main">
<div class="container container-main">
<div class="em-inner-main">
<div class="em-wrapper-area02"></div>
<div class="em-main-container em-col2-left-layout">
<div class="row">
<div class="col-sm-18 col-sm-push-6 em-col-main">
<div class="em-wrapper-area03"></div>
<div class="my-account">
<div class="my-wishlist">
<div class="page-title title-buttons">
<h1>My Wishlist</h1>
</div>
<fieldset>
<table class="data-table" id="wishlist-table">
<thead>
<tr>
<th></th>
<th>Product Details and Comment</th>
<th>Add to Cart</th>
<th></th>
</tr>
</thead>
<tbody>
@foreach($list as $l)
@foreach($product as $p)
@if($l->product_id == $p->id)
<tr id="item_6">
<td>
<a class="product-image" href="{{action('productdetailController@getIndex','id='.$p->id)}}" title=" {{$p->name}} "> <img src="{{asset('images/')}}/{{$p->image_name}}" width="113" height="113" alt=" {{$p->name}} " /> </a>
</td>
<td>
<h3 class="product-name"><a href="product_detail" title=" {{$p->name}} "> {{$p->name}} </a></h3>
<div class="description std">
<div class="inner">The must-have tee for his third birthday!</div>
</div>
<textarea name="description[6]" rows="3" cols="5" title="Comment" placeholder="Please, enter your comments..."></textarea>
</td>
<td>
<div class="cart-cell">
<div class="price-box" itemscope itemtype="http://ift.tt/GXPmjp"> <span class="regular-price" id="product-price-258"> <span class="price" content="{{$p->salary}}">${{$p->salary}}</span> </span>
</div>
<div class="add-to-cart-alt">
<input type="text" class="input-text qty validate-not-negative-number" name="qty[6]" value="1" />
<button type="button" title="Add to Cart" onclick="addWItemToCart(6);" class="button btn-cart"><span><span>Add to Cart</span></span>
</button>
</div>
<p><a class="link-edit" href="#">Edit</a>
</p>
</div>
</td>
<td>
<form method="POST" action="{{ action('listController@deleteDeleteProduct', $l->id) }}">
{!! csrf_field() !!}
<input type="hidden" name="id" value="{{$l->id}}">
<input type="hidden" name="_method" value="delete">
<button type="submit" class="btn btn-danger">Remove item</button>
</form>
</td>
</tr>
@endif
@endforeach
@endforeach
</tbody>
</table>
<div class="buttons-set buttons-set2">
<button type="submit" name="save_and_share" title="Share Wishlist" class="button btn-share"><span><span>Share Wishlist</span></span>
</button>
<button type="button" title="Add All to Cart" class="button btn-add"><span><span>Add All to Cart</span></span>
</button>
<button type="submit" name="do" title="Update Wishlist" class="button btn-update"><span><span>Update Wishlist</span></span>
</button>
</div>
</fieldset>
</form>
</div>
<div class="buttons-set">
<p class="back-link"><a href="home"><small>« </small>Back</a>
</p>
</div>
</div>
</div><!-- /.em-col-main -->
<div class="col-sm-6 col-sm-pull-18 em-col-left em-sidebar">
<div class="em-wrapper-area02"></div>
<div class="em-line-01 block block-account">
<div class="block-title em-block-title"> <strong><span>My Account</span></strong>
</div>
<div class="block-content">
<ul>
<li><a href="#">Account Dashboard</a>
</li>
<li><a href="#it/">Account Information</a>
</li>
<li><a href="#">Address Book</a>
</li>
<li><a href="#">My Orders</a>
</li>
<li><a href="#">Billing Agreements</a>
</li>
<li><a href="#">Recurring Profiles</a>
</li>
<li><a href="#">My Product Reviews</a>
</li>
<li><a href="#">My Tags</a>
</li>
<li class="current"><strong>My Wishlist</strong>
</li>
<li><a href="#">My Applications</a>
</li>
<li><a href="#">Newsletter Subscriptions</a>
</li>
<li class="last"><a href="#">My Downloadable Products</a>
</li>
</ul>
</div>
</div><!-- /.em-line-01 -->
</div><!-- /.em-sidebar -->
</div>
</div>
</div>
</div>
</div><!-- /.em-wrapper-main -->
@stop
that's the code can any one help ?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire