lundi 12 octobre 2020

SQLSTATE[42S22]: Column not found: 1054 Unknown column '1' in 'order clause'

I got this error when i run edit method.

SQLSTATE[42S22]: Column not found: 1054 Unknown column '1' in 'order clause' (SQL: select * from tbl_departement order by 1 desc limit 15 offset 0)

here is the method in my controller:

public function edit($id){
    $page = session('departementPage');
    $edit = Departement::find($id);
    $departement = Departement::orderBy('id_departement','asc')->paginate($page);
    return view('/akun/admin_0/departement/index')->with('edits',$edit)->with('departements',$departement)->with('sort','1')->with('page',$page);
}

public function update(Request $request, $id){
    if ($request->input_id_departement != '') {
        $get_id_departement = Departement::where('id_departement','=',$request->input_id_departement)->where('id_departement','!=',$id)->count();
        if ($get_id_departement > 0) {
            return redirect()->back()->with('message','ID Departement sudah digunakan \n silahkan masukan ID Departement lainnya!');
        }else{
            Departement::find($id)->update([
                'id_departement' => $request->input_id_departement,
                'nama_departement' => $request->input_nama_departement
            ]   );
            return redirect('/departement')->with('message','Data departement berhasil diupdate');
        }
    }else{
        Departement::find($id)->update([
            'id_departement' => $id,
            'nama_departement' => $request->input_nama_departement
        ]   );
        return redirect('/departement')->with('message','Data departement berhasil diupdate');
    }
}

here is the Departement.php:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Departement extends Model
{
    protected $table="tbl_departement";
    protected $primaryKey="id_departement";
    public $incrementing=false;
    public $timestamps=false;
    protected $fillable=[
    'id_departement','nama_departement'
    ];
}

here is the blade :

@extends('layouts.default')
@section('head')
<a href="/home">
    <div class="menu_logo" style="background-image: url(../../../../assets/gambar/kembali.png);"></div>
</a>
@endsection
@section('content')
<script type="text/javascript">
    var cek = "tampil";
    function opennav(){
        if (cek == "tampil") {
            document.getElementById("sidebar").style.width = "20px";
            document.getElementById("table_container").style.width = "auto";
            document.getElementById("table_container").style.right = "20px";
            document.getElementById("table_container").style.transition = "all 0.5s";
            cek = "tutup";
        }else{
            document.getElementById("sidebar").style.width = "25%";
            document.getElementById("table_container").style.width = "75%";
            document.getElementById("table_container").style.right = "25%";
            document.getElementById("table_container").style.transition = "all 0.5s";
            cek = "tampil";
        }
    }
</script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
<div class="table_container" style="left: 0px;" id="table_container">
    <div style="margin-left: 50px; margin-top: 50px">
        
    </div>
    <form method="post" action="/departement/pilih_page" style="margin-left: 50px;margin-bottom: 20px;">
        <select name="input_page" class="inputPilihPage">
            <option value=""></option>
            <option value="5">5</option>
            <option value="25">25</option>
            <option value="50">50</option>
            <option value="100">100</option>
        </select>
        <input type="submit" name="tampilkan" value="Tampilkan" class="btnPilihPage">
        
    </form>
    <table class="table2" align="center" onclick="tbl_click()">
        <?php 
        if ($sort == "1") {
            $sort_type = "asc";
        }else{
            $sort_type = "desc";
        }
        ?>
        <tr>
            <?php 
            if (empty($page)) {
                $page = 25;
            }
            ?>
            <th class="th"a></th>
            <th class="th" style="text-align: center;"><a href="/departement/id_departement/">ID departement</a></th>
            <th class="th" style="text-align: center;"><a href="/departement/nama_departement/">Nama departement</a></th>
        </tr>
        <?php 
        $warna = "white";
        ?>
        @foreach ($departements as $data)
        <tr>
            <td align="center"  style="background-color: <?php echo $warna; ?>">
                <form action="/departement/" method="post">
                    <input type="submit" name="delete_min" style="background-image: url('../../../../assets/gambar/delete.png');" class="btn_table" value="" onclick="return confirm('Anda yakin ingin menghapus data ini?')">
                    
                    <input type="hidden" name="_method" value="DELETE">
                </form>
                <form action="/departement//edit" method="post">
                    <input type="submit" name="edit_min" style="background-image: url('../../../../assets/gambar/edit.png');" class="btn_table" value="">
                    
                </form>
            </td>
            <td align="center" style="background-color: <?php echo $warna; ?>"></td>
            <td align="center"  style="background-color: <?php echo $warna; ?>"></td>
        </tr>
        @endforeach
    </table>
</div>
<div class="sidebar" id="sidebar">
    <button onclick="opennav()" class="btn_slide" id="btn_slide" style="height:100%; bottom: 0px; width: 20px;background-color: grey;float: left;border:0px;color: white; position: fixed;">
        >
    </button>
    <?php if ($edits == '') {?>
        <form method="post" action="/departement">
            <table class="table_input" align="center" id="table_input">
                <tr>
                    <td colspan="2">ID Departement</td>
                </tr>
                <tr>
                    <td colspan="2"><input type="text" name="input_id_departement" class="input_admin" value=""></td>
                </tr>
                <tr>
                    <td colspan="2">Nama Departement</td>
                </tr>
                <tr>
                    <td colspan="2"><input type="text" name="input_nama_departement" class="input_admin" required="" value=""></td>
                </tr>
                <tr>
                    <td colspan="2"><input type="submit" name="input" value="input" class="btn_admin"></td>
                    
                </tr>
            </table>
        </form>
    <?php }else{?>
        <form method="post" action="update">
            <table class="table_input" align="center" id="table_input">
                <tr>
                    <td colspan="2">ID Departement</td>
                </tr>
                <tr>
                    <td colspan="2"><input type="text" name="input_id_departement" class="input_admin" value=""></td>
                </tr>
                <tr>
                    <td colspan="2">Nama Departement</td>
                </tr>
                <tr>
                    <td colspan="2"><input type="text" name="input_nama_departement" class="input_admin" required="" value=""></td>
                </tr>
                <tr>
                    <td><input type="submit" name="update" value="update" class="btn_admin"></td>
                    <input type="hidden" name="_method" value="PUT">
                    
                </form>
                <form action="/departement/batal">
                    <td><input type="submit" name="batal" value="batal" class="btn_admin"></td>
                </form>
            </tr>
        </table>
    <?php } ?>
</div>
@endsection

please help me, thank you



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire