mercredi 9 octobre 2019

insert static valus from select box laravel

im new to laravel when i try to insert data from static select option to database i get "Field 'city' doesn't have a default value" i did try previous solutions on stack overflow but nothing works thanq you in advance // model class Job_Seeker extends Model { protected $guard='job_seeker'; protected $fillable = [ 'username', 'email', 'password','city','categories' ];

    protected $hidden = [
        'password', 'remember_token',
    ];

    protected $casts = [
        'email_verified_at' => 'datetime',
    ];

    public $table = "job_seekers";
}

// register_controller

 public function store(Request $request)
        {
            $validatedData = $request->validate([
                'name' => 'required|max:255',
                'email' => 'required|unique:job_seekers', 
                'password'=>'min:5|required',
            ]);    
            $job_seeker = new Job_seeker;
            $job_seeker ->name = $request->name;
            $job_seeker ->email = $request->email;
            $job_seeker ->city = $request->city;
            $job_seeker ->categories = $request->categories;
            $job_seeker ->password = Hash::make($request->password);

            $job_seeker ->save();
        }


// form 
<form method="POST" action="">
        @csrf
    <div class="wrap">
        <input type="text" placeholder="Username" class="login-input" name="username">
        <input type="email"placeholder="email" class="login-input" name="email">
        <input type="password"placeholder="Password" class="login-input" name="password">
        <input type="password"placeholder="confirm Password" class="login-input" name="password_confirmation">
        <select name="city"  id="city" class="grid" required="required">
            <option value="" disabled selected> city</option>
            <option value="chicago">Chicago</option>
            <option value="losangeles">Los Angeles</option>
            <option value="seattle">Seattle</option>
            <option value="dallas">Dallas</option>
            <option value="boston">Boston</option>
            <option value="sanfran">San Francisco</option>
          </select>
          <select name="categories"  id="categories" class="grid">
            <option value="" disabled selected> catégories</option>
            <option value="web design">web design</option>
            <option value="infor">inforgraphie</option>
            <option value="tele">télecomunication</option>
            <option value="inf">infirmiére</option>
            <option value="cpmta">comptabilité</option>
            <option value="agri">agriculture</option>
          </select>
        <input type="submit" value="Sign Up" class="login-input" >

        <div class="separator">
            <span class="divider">or</span>
            <span class="sep"></span>  
        </div>
        <div class="social-login">
            <p class="social-button">
                <a class="facebook-before"><span class="fontawesome-facebook"></span></a>
                <button class="facebook">login Using Facbook</button>
            </p>
            <p class="social-button">
                <a class="twitter-before"><span class="fontawesome-twitter"></span></a>
                <button class="twitter">login Using Twitter</button>
            </p>
    </div> 
    </div>
</form>


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire