mardi 29 décembre 2015

deleting specific record from the database in laravel

hi everyone i'm trying to make a simple delete function in my code , this is 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=Input::get('product_id');


        DB::table('wishlist')->insert(['id'=>$id,'user_id'=>$user_id,'product_id'=>$product_id]);
        return redirect()->action('listController@postCreate');
    }
    public function deleteProduct(Request $request,$id){
        $pro=$request->get('id');
        DB::table('wishlist')->where('id',$pro)->delete();
        return redirect('wishlist/'.$pro);
    }
}

and my view is like that :

@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($product as $p)
                                                @foreach($list as $l)
                                                @if($p->id == $l->product_id)
                                                @if($l->user_id == Auth::user()->id)
                                                <tr id="item_6">
                                                    <td>
                                                        <a class="product-image" href="product_detail" 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="DELETE" action="{{action('listController@deleteProduct','id='.$l->id)}}" enctype="multipart/form-code">
                                                    {!! csrf_field() !!}
                                                    <input type="hidden" name="id" value="{{$l->id}}">
                                                    <button type="submit" class="btn btn-danger">Remove item</button>
                                                    </form>
                                                    </td>
                                                </tr>
                                                @endif
                                                @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>&laquo; </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

there is a problem with my code it regenerate the view and pass the id right but it didn't delete the required row in database , can anyone help ?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire