dongyipa0028 2016-10-23 14:46
浏览 91
已采纳

向DB添加数据失败,没有错误 - Laravel

I am having problems adding information to the database. I am not getting any errors, but every time I either try to validate or add information to the table Kids I get redirected to the main page "/" and nothing gets add. I really hope you can help me:

PagesController:

    <?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Kids;
use App\Guardians;
use App\Donations;
use App\Expenses;
use App\Food;
use App\Medicines;
use App\Inventory;
use App\User;
use App\Http\Requests;
use App\Http\Controllers\Controller;


class PagesController extends Controller
{

     public function viewAddPage(){

        return view('add');
    }

    public function storeKids(Request $request)
    {
    $validation= array(
                      'KidID'=>'required',
                      'fname'=>'required',
                      'lName'=>'required',
                      'DateOfBirth'=>'required',
                      'Sex'=>'required',
                      'Age'=>'required',
                      'SchoolName'=>'required',
                      'SchoolGrade'=>'required',
                      'SchoolGroup'=>'required',
                      'BloodType'=>'required',
                      'Allergies'=>'required',
                      'enroll_date'=>'required',
                      'exit_date'=>'required',
                      'created_by'=>'required',
                      'updated_by'=>'required'

                          );
        $v1= Validator::make(Input::all(),$validation);

        if( $v1->fails())
        {
        return Redirect::to('add/list/')->withErrors($v1);
        }
        else
        { $poststudent=$request->all();
          $data = array('KidID'=>$poststudent['KidID'],
                         'fname'=>$poststudent['fname'],
                         'mName'=>    $poststudent['mName'],
                    'lName'=>    $poststudent['lName'], 
                         'DateOfBirth'=>   $poststudent['DateOfBirth'],
                         'Sex'=>   $poststudent['Sex'],
                         'Age'=>   $poststudent['Age'],
                         'SchoolName'=>   $poststudent['SchoolName'],
                         'SchoolGrade'=>   $poststudent['SchoolGrade'],
                         'SchoolGroup'=>   $poststudent['SchoolGroup'],
                         'BloodType'=>   $poststudent['BloodType'],
                         'Allergies'=>   $poststudent['Allergies'],
                         'enroll_date'=>   $poststudent['enroll_date'],
                         'exit_date'=>   $poststudent['exit_date'],
                         'created_by'=>   $poststudent['created_by'],
                         'updated_by'=>   $poststudent['updated_by']

                         );

        $check=0;
        $check=DB::table('kids')->insert($data);

        if($check > 0)
        {
        return Redirect::to('kids/list/');
        }
        else
        {
        return Redirect::to('add/list/');
        }

        }
    }
}

web.php (Routes):

<?php
Route::get('/', function(){
return view('welcome');
});

Route::post('/signin',[
'uses'=>'UserController@postSignIn',
'as'=>'signin'
]);

Route::get('user/logout',function(){
Auth::logout();
return redirect('/');
});

Route::get('/home', [
'uses'=> 'UserController@getDashboard',
'as'=> 'home'
]);

Route::get('kids/list', 'PagesController@viewKidsList');
Route::get('guardians/list', 'PagesController@viewGuardiansList');
Route::get('donations/list', 'PagesController@viewDonationsList');
Route::get('expenses/list', 'PagesController@viewExpensesList');
Route::get('food/list', 'PagesController@viewFoodList');
Route::get('medicines/list', 'PagesController@viewMedicinesList');
Route::get('inventory/list', 'PagesController@viewInventoryList');
Route::get('users/list', 'PagesController@viewUsersList');
Route::get('add/list','PagesController@viewAddPage');
Route::post('/save', array('uses'=>'PagesController@storeKids'));

View (add.blade.php):

@extends('menu')

@section ('add')

<style>

.imagen{
width:400px;
height:auto;
margin-top: 10px;
margin-left: 40px;
margin-bottom: 10px;
}

.user{
position:absolute;
margin-top: -70px;
right:20px;
font-size:14px;
font-family:"courier";
}

</style>

        <form class ="form" action="<?=URL::to('/save')?>" method="POST">
        <h3><center>New kid Information</center></h3>

             <input type="hidden" name="_token" value="{{ csrf_token() }}">
             <div class="form-group">
                <input type="text" name="KidID" id="KidID" placeholder="Kid ID" class = "form-control">

                <br>

                <input class="form-control" type="text" name="fname" id="fname" placeholder="First Name">
                <br>

                <input class="form-control" type="text" name="mName" id="mName" placeholder="Middle Name">
                <br>

                <input class="form-control" type="text" name="lName" id="lName" placeholder="Last Name">
                <br>

                <input class="form-control" type="text" name="DateOfBirth" id="DateOfBirth" placeholder="Date Of Birth">
                <br>

                <input class="form-control" type="text" name="Sex" id="Sex" placeholder="Sex">
                <br>

                <input class="form-control" type="text" name="Age" id="Age" placeholder="Age">
                <br>

                <input class="form-control" type="text" name="SchoolName" id="SchoolName" placeholder="School Name">
                <br>

                <input class="form-control" type="text" name="SchoolGrade" id="SchoolGrade" placeholder="School Grade">
                <br>

                <input class="form-control" type="text" name="SchoolGroup" id="SchoolGroup" placeholder="School Group">
                <br>

                <input class="form-control" type="text" name="BloodType" id="BloodType" placeholder="Blood Type">
                <br>

                <input class="form-control" type="text" name="Allergies" id="Allergies" placeholder="Allergies">
                <br>

                <input class="form-control" type="text" name="enroll_date" id="enroll_date" placeholder="Enroll Date">
                <br>
                 <input class="form-control" type="text" name="exit_date" id="exit_date" placeholder="Enroll Date">
                <br>

                <input class="form-control" type="text" name="created_by" id="created_by" placeholder="Created By">
                <br>
                 <input class="form-control" type="text" name="updated_at" id="updated_at" placeholder="Enroll Date">
                <br>
           <input type="submit" value="Submit" name="save" class="text" />

        </form>
@endsection

Kids Table:

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateKidsTable extends Migration
{

public function up()
{
    Schema::create('kids', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('KidID')->unique();
        $table->string('fname');
        $table->string('mName');
        $table->string('lName');
        $table->date('DateOfBirth');
        $table->string('Sex');
        $table->tinyInteger('Age');
        $table->string('SchoolName');
        $table->tinyInteger('SchoolGrade');
        $table->char('SchoolGroup');
        $table->string('BloodType');
        $table->longText('Allergies');
        $table->date('enroll_date');
        $table->date('exit_date');
        $table->string('created_by');
        $table->timestamps();
    });
}

 public function down()
{
    Schema::drop('kids');
}

}

Kids

namespace App;

use Illuminate\Database\Eloquent\Model;

class Kids extends Model
{

protected $table = 'kids';

}

I have been looking to this problem for days, and I really don't know why it isn't storing nothing, and it keeps sending me to the "/" webpage.

  • 写回答

3条回答 默认 最新

  • doutuo1908 2016-10-23 14:53
    关注

    If you add the fillable array to you Kids model

    protected $fillable = ['fName', 'mName','lName'...];
    

    You can then insert the record with eloquent, which is much simpler than the query builder:

    $kids = Kids::create($request->all());
    

    Your validator is quite involved, so move that to a FormRequest:

    php artisan make:request KidsRequest

    The add your validation array to the rules() method in Requests\KidsRequest and make sure you set the authorize() method to return true.

    You can now type hint that in your store method:

    public function storeKids(KidsRequest $request)

    You validation will then be automatically applied.

    So now we have the following method:

    public function storeKids(KidsRequest $request)
    {
            $kids = Kids::create($request->all());
    
            return Redirect::to('add/list/');      
    }
    

    Which I think you'll agree is a lot neater!

    Your code is a little unorthodox, if you stick to naming conventions: index(), show(), store(), edit() etc' you can use resource routes instead which prevents you having to list each route individually, and try to keep your field names on you db format consistent, snake case (e.g. last_name) is preferred in laravel for db fields.

    If you are struggling to understand some of this then there are some excellent tutorials on laracasts

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗
  • ¥15 钢筋实图交点识别,机器视觉代码
  • ¥15 如何在Linux系统中,但是在window系统上idea里面可以正常运行?(相关搜索:jar包)
  • ¥50 400g qsfp 光模块iphy方案
  • ¥15 两块ADC0804用proteus仿真时,出现异常
  • ¥15 关于风控系统,如何去选择