How do I get a count of how many columns are (or aren't) null in a query?

$query->whereNull('column_name')->count();

@DRFRAKER - I want to count the empty columns in the returned row. My query will always return one row.

@DRFRAKER - For example: How many profile questions has the user not filled out.

I'm looking for something like: {{ $user->profile->count(empty columns) }}

I can help you live on https://devallies.com . I'm drfraker on there too. Might be easier.

@DRFRAKER - I'm using Linux. So installing microsoft assets might be a problem. Thanks though.

No problem.

$entity =  Model::find(1); 

if ( count($entity->attributes) !==  array_filter($entity->attributes)) {
   echo 'profile incomplete'
}

you could also use array_unique... and there might be a collection method for doing the same..

Since you're wanting the count on the model of unanswered questions, you could just create an accessor on the model which returns the filtered count. Then you could easily just show them how many questions, or percentage of questions, they haven't answered yet (like a progress bar).

https://laravel.com/docs/5.7/eloquent-mutators#accessors-and-mutators

Haven't tested it, but something like

public function getUnansweredQuestionCountAttribute() {
    return count(array_filter($this->attributes));
}

$questions = QuestionModel::someQuery();

echo $questions->unanswered_question_count

@CRONIX - Wow, that is exactly where I was going with it. Thanks!!!

@cronix

I am doing the same thing.

I add this below method in my question model.

public function getUnansweredQuestionCountAttribute() {
    return count(array_filter($this->attributes));
}

and I access it like below.

 $qs = Question::where('user_id', Auth::user()->id)->count();
            dd($qs->getUnansweredQuestionCountAttribute);

I got App\Question::getUnansweredQuestionCountAttribute must return a relationship instance.

Any idea?