首页 文章

SQLSTATE [42S22]：未找到列：1054未知列'1'在'field list'（SQL：从`phonebooks`中选择`1`）

提问于
浏览 次
0

当我试图将数据传递到编辑页面时，我得到了这个错误 . 请帮助我

QueryException in Connection.php line 729: SQLSTATE[42S22]: Column not found: 1054 Unknown column '1' in 'field list' (SQL: select 1 from phonebooks)

PhonebookController.php

public function edit($id)
    {
        $data = Phonebooks::all($id);
        echo"$data";
        return view('phonebook.edit', compact('$data'));
    }

edit.blade.php

<html>
    <body>
        <form method="POST" action="{{ URL::to('phonebook') }}" >
            <input type="text" name="id" value="{{$id}}"/>
            <input type="text" name="phoneNo" value="{{old('phoneNo')}}"/>
            <input type="text" name="email" value="{{old('email')}}" />
            <input type="submit" value="Save"/>
            <input type="hidden" name="_token" value="{{ csrf_token() }}">
        </form>

    </body>
</html>
mysql laravel

2 回答

  • 2

    你应该试试这个：

    public function edit($id)
        {
            $data = Phonebooks::find($id);

            return view('phonebook.edit', compact('data'));
        }

<html>
    <body>
        <form method="POST" action="{{ URL::to('phonebook') }}" >
            <input type="text" name="id" value="{{$data->id}}"/>
            <input type="text" name="phoneNo" value="{{old('phoneNo')}}"/>
            <input type="text" name="email" value="{{old('email')}}" />
            <input type="submit" value="Save"/>
            <input type="hidden" name="_token" value="{{ csrf_token() }}">
        </form>

    </body>
</html>
    回复于
  • 0
    public function edit($id)
        {
            $data = Phonebooks::find($id);
            return view('phonebook.edit', compact('data'));
        }

If you use Laravel Form Model then not required to pass any hidden data and assign individual values. Below is link how you can use Form model. Even not require passing CSRF token on hidden.

    https://selftaughtcoders.com/from-idea-to-launch/lesson-23/laravel-5-application-form-model-binding-laravelcollective-forms-html-library-bootstrap-framework/

    {!! Form::model($post, ['method' => 'PATCH','url' => ['/admin/posts',$post->id], ]) !!}

{!! Form::text('phoneNo', null, ['class' => 'form-control']) !!}

{!! Form::email('email', null, ['class' => 'form-control']) !!}
{!! Form::submit('Save', ['class' => 'btn btn-primary form-control']) !!}

    希望这对你有所帮助！

    回复于

相关问题