Btukfyl

Hello I would like to insert a null value to my database but i have no clue how to do it is giving an error

How to insert an empty value to input text and set it to null to database, as I do this Im having an error because the rows of the database does not have a value. how can I do this without an error.

here is my error

As you can see I have a foreach loop so inserting 1 input text value returns nothing on the database.

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'title'
cannot be null (SQL: insert into awards (title, description,
awards_image, updated_at, created_at) values (, , a:0:{},
2018-11-28 10:29:35, 2018-11-28 10:29:35))

my Controller

public function store(Request $request)

{

    $this->validate($request, [

        'title' => 'nullable',

        'description' => 'nullable',

        'awards_image.*' =>  'image|nullable|max:1999'

    ]);

    $awards = ;

    if ($request->has('awards_image'))

    {   

        //Handle File Upload





        foreach ($request->file('awards_image') as $key => $file)

        {

            // Get FileName

            $filenameWithExt = $file->getClientOriginalName();

            //Get just filename

            $filename = pathinfo( $filenameWithExt, PATHINFO_FILENAME);

            //Get just extension

            $extension = $file->getClientOriginalExtension();

            //Filename to Store

            $fileNameToStore = $filename.'_'.time().'.'.$extension;

            //Upload Image

            $path = $file->storeAs('public/awards_images',$fileNameToStore);

            array_push($awards, $fileNameToStore);

        }



        $fileNameToStore = serialize($awards);

    }

    else

    {

        $fileNameToStore='noimage.jpg';

    }





foreach ($awards as $key => $values) {

            $awardsContent = new Award;

            $awardsContent->title = $request->title[$key];

            $awardsContent->description = $request->description[$key];

            $awardsContent->awards_image = $values;

            $awardsContent->save();

            }



}

If you do not want to change the table then try this:

foreach ($awards as $key => $values) {

        $awardsContent = new Award;

        $awardsContent->title = !empty($request->title[$key]) ? $request->title[$key] : '';

        $awardsContent->description = $request->description[$key];

        $awardsContent->awards_image = $values;

        $awardsContent->save();

        }



}

Some more info in empty():

http://php.net/manual/en/function.empty.php

If you are happy to change the table the create a migration where this is in up

Schema::table('awards', function(Blueprint $table) {



    $table->string('title')->nullable()->change();



});

of course you will have to change this to what you have already but the important part is ->nullable()->change(); the rest of the line should be the same as your initial migration.

Some more info on migration changes:

https://laravel.com/docs/5.7/migrations#modifying-columns

I hope this helps

Make a new migration

php artisan make:migration fix_title_in_table_awards --table=awards

Then in the migration created first drop the column, and then recreate the column making it nullable..

Schema::table('awards', function (Blueprint $table) {

    $table->dropColum('title');

});



Schema::table('awards', function (Blueprint $table) {

    $table->string('title')->nullable();

});

Take care of this action because you will lost all the data in that column...maybe you can copy the actual values of title to another column untill you make the change...