Attributes Not Added To Product After Successful Save

@vincent15000 Thanks for your answer l replaced if(is_array($this->attribute_values)) but nothing changes, ATTRIBUTE_VALUES table remain blank after saving.

@cotations88 Add this before the condition to check what is value is in the variable.

dd($this->attribute_values);

@vincent15000 null // app\Livewire\Admin\AdminAddProductComponent.php:117

@cotations88 Now you have the answer, the variable is empty, so you know why it doesn't save anything in the database.

You need to search why the variable is empty.

@vincent15000 l use this input to save it

@foreach($inputs as $key => $value)
    <div class="form-group">
        <label class="col-md-4 control-label">{{$pattributes->where('id',$attribute_arr[$key])->first()->name}}</label>
        <div class="col-md-12">
            <input type="text" placeholder="{{$pattributes->where('id',$attribute_arr[$key])->first()->name}}" class="form-control input-md" wire:model="attribute_values.{{$value}}" />                                        
        </div>
        <div class="col-md-12">
            <button type="button" class="btn btn-danger btn-sm" wire:click.prevent="remove({{$key}})">Remove</button>
        </div>
    </div>
@endforeach           

@cotations88 This can't work. You have to declare the value as an array.

wire:model="attribute_values[]"

@vincent15000 No result. l thing l must look for another way. Thanks for your help.

@cotations88 I would check what is now in the variable with a dd().

@vincent15000 Blank !

@cotations88 dd($this->attribute_values); ?

@vincent15000 null // app\Livewire\Admin\AdminAddProductComponent.php:117

@tangtang Thanks for answer me.

class AttributeValue extends Model
{
    use HasFactory;

    
    protected $fillable = [
       'value',
       'product_id',
       'product_attribute_id',
    ];

If product attribute is COLOR : attribute_value = Red,Green,Black,Blue...

If product attribute is SIZE : attribute_value = S,M,L,XL,XXL,XXXL

If product attribute is wEIGHT : attribute_value = 1.50CM,1.70CM,1.90CM

Hope you see what l'am taking about.

@cotations88

let's breakdown this issue, seems like this issue is lack of database structure or maybe you just confused how to ask what you really need.

is this input in your blade works ?

and the input displayed the data you need ?

can the user type the value of this input ?

or this input is added with another button from the blade ?

when user click this add button, the input is added to the form wih static value ?

and you have the controller to check, if this product attribute is COLOR, the add button will just add the COLOR value ?

can you tell the user story for this product (from the first time how to add product and select this attribute and then save the product) ? so we can figure out how exacly to execute this laravel code for this product controller.

@tangtang I have impression that the database no longer works, the old databases created at the beginning (product category users) of the project work, but the new databases product_attribute ,orders and shipping address do not work. All my routes were undefined until I found a way to update them. How to update inputs and database in laravel/livewire ?

@cotations88 Do you respect the naming convention for the tables and the models ? If not you need to set the name of the table directly in the model like this.

protected $table = 'my_table_name';

@cotations88 You should follow the Laravel from scratch tutorial.

https://laracasts.com/series/laravel-8-from-scratch

And then the livewire series.

https://laracasts.com/series/livewire-basics

@tangtang

                       <div class="mb-3 mt-3"> 
                       <label for="name" class="form-label">Name</label>
                       <input type="text" name="name" class="form-control" placeholder="Enter Product Name" wire:model="name" wire:keyup="generate">
                       @error('name')
                       <p class="text-danger">{{$message}}</p>
                       @enderror
                       </div>
                       <div class="mb-3 mt-3"> 
                       <label for="slug"  class="form-label">Slug</label>
                       <input type="text" name="slug" class="form-control" placeholder="Enter Product Slug" wire:model="slug">
                        @error('slug')
                       <p class="text-danger">{{$message}}</p>
                       @enderror
                       </div>
                 
                       </div>   
                       <div class="mb-3 mt-3"> 
                       <label for="images"  class="form-label">Images</label>
                       <input type="file" name="images" class="form-control"  wire:model="images" multiple>
                       @if($images)
                         @foreach($images as $image)
                       <img src="{{$image->temporaryUrl()}}" width="120px">
                         @endforeach
                       @endif
                        @error('images')
                       <p class="text-danger">{{$message}}</p>
                       @enderror
                       </div> 
                         <div class="mb-3 mt-3"> 
                       <label for="category"  class="form-label">Category</label>
                       <select  name="category_id" class="form-control"  wire:model="category_id">
                            <option value="">Select Categories</option>
                        @foreach($categories as $category)
                           <option value="{{$category->id}}">{{$category->name}}</option> 
                        @endforeach                      
                       </select>
                        @error('category_id')
                       <p class="text-danger">{{$message}}</p>
                       @enderror
                       </div> 
                        <div class="mb-3 mt-3" style="display:flex;"> 
                       <label for="attr"  class="form-label" style="font-weight: bold;">Product Attribute</label>
                       <select  class="form-control"  wire:model="attr" required> 
                            <option value="0">Select Attribute</option>
                        @foreach($pattributes as $pattribute)
                           <option value="{{$pattribute->id}}">{{$pattribute->name}}</option> 
                        @endforeach                      
                       </select>
                       <div class="col-md-1">
                           <button type="button" class="btn btn-info" wire:click.prevent="add" >Add</button>
                       </div>
                        @error('attr')
                       <p class="text-danger">{{$message}}</p>
                       @enderror
                       </div> 
@foreach($inputs as $key => $value)
    <div class="mb-3 mt-3">
        <label class="mb-3 mt-3">{{$pattributes->where('id',$attribute_arr[$key])->first()->name}}</label>
   
            <input type="text" placeholder="{{$pattributes->where('id',$attribute_arr[$key])->first()->name}}" class="mb-3 mt-3" wire:model="attribute_values.{{$value}}" />                                        
        </div>
        <div class="col-md-1">
            <button type="button" class="btn btn-danger btn-sm" wire:click.prevent="remove({{$key}})">Remove</button>
        </div>
    </div>
@endforeach            
                      <button type="submit" class="btn btn-primary float-end">Submit  </button>

                     </form>
                     </div>
                     </div>
                    </div>
                </div>
            </div>
        </section>
    </main>
</div>    

LivewireComponent

<?php

namespace App\Livewire\Admin;

use Livewire\Component;
use Illuminate\Support\Str;
use App\Models\Category;
use Livewire\WithPagination;
use Livewire\WithFileUploads;
use App\Models\Product;
use App\Models\AttributeValue;
use App\Models\ProductAttribute;
use Carbon\Carbon;

class AdminAddProductComponent extends Component
{
    use WithFileUploads;

    
    

    public $inputs = [];
    public $attribute_arr = [];
    public $attribute_values = [];
    public $product_attribute_id;


       public function generateSlug()
    {
        $this->slug = Str::slug($this->name);
    }

    public function add()
    {
        if(!in_array($this->attr,$this->attribute_arr))
        {
            array_push($this->inputs,$this->attr);
            array_push($this->attribute_arr,$this->attr);
        }
    }

   public function remove($attr)
{
    unset($this->inputs[$attr]);
}

    public function addProduct()
    {
       
            'featured'=> 'required',
            'quantity'=> 'required',
             'image'=> 'required',
         //   'images'=> 'required',
            'category_id'=> 'required',
        ]);
        $product = new Product();
        $product->name = $this->name;
       
}
        $product->category_id = $this->category_id;
  if(is_array($this->attribute_values)){
         foreach($this->attribute_values as $key=>$attribute_value)
         {
            $avalues = explode(",",$attribute_value);
           foreach($avalues as $avalue)
          {
           $attr_value = new AttributeValue();
           $attr_value->product_attribute_id = $key;
           $attr_value->value = $avalue;
           $attr_value->product_id = $product->id;
           $attr_value->save();
           }
          }
          }
          dd($this->attribute_values); 
      
        //  $product->sync(AttributeValue::where('product_attribute_id',$this->product_attribute_id));
     $product->save();
    
         

@cotations88

you haven't provided the print screen results from your form yet. but it's okay. you give the form instead.

base on your form seems like there a little miss in your foreach task in controller.

update the code base this reference and remember the $product->save(); is added before the foreach task.

// your other code . . . .

$product->save();

foreach ($this->attribute_values as $key => $attribute_value) {
	$attr_value = new AttributeValue();
	$attr_value->product_attribute_id = $this->attribute_arr[$key]; // this is the new code
	// this will added the index base on the attribute ids
	$attr_value->value = $attribute_value;
	$attr_value->product_id = $product->id; // if the produc isn't saved first, this code line will not work
	$attr_value->save();
}

// your other code . . . .

and did you try to read and analyze all the response ? seems like you just try to copy paste the code without know what or why the reason the code work or not.

so instead you understanding the code, you just give the code here, you did not even answer the related question from the respond response.

I doubt if you even read the reply. you just wait for the full code answer right ? 🤣

@tangtang It will give

foreach() argument must be of type array|object, bool```  

This is why l try (is_integer ) or ( is_array) to  fix it 

l am tired of this error, and l am looking for another way or restart project.

@cotations88

even using is_array or is_integer the result is always false and the foreach task will never be executed, thats why the we needs to know what the dd result of this $this->attribute_values ?

do the dd before the foreach task

it the dd is null, thats means $this->attribute_values doesn't even read on the controller.

@tangtang Yes dd is null it is why l pasted all code here ,maybe it miss something. Product database is saving data but but attribute value table remain blank. l don't know why inputs can be add and can't save data. l'am using node 20.9 ,php 8.1.12 and laravel 10.30.0

@cotations88

you needs to refactor the code in your form.

each time user click add attr build two inputs inside @foreach($inputs as $key => $value)

one for input type hidden, the value for this hidden inputs is attr id

and second input is for the value

with this technique you will have the array data you needs.

and for the controller the foreach task is more like this foreach ($this->inputs as $input)

@tangtang Many Many Many........................Thanks For Your Help!!!!!!!!!!!!!!!!!!!!

@tangtang Please l have another problem here on update $this->inputs = $product->attributeValues->where('product_id',$product->id)->unique('product_attribute_id')->pluck('product_attribute_id'); Call to a member function where() on null

@cotations88

do the if logic before execute this where() query

if ($product->attributeValues) {
    $this->inputs = $product->attributeValues
        ->where('product_id', $product->id)
        ->unique('product_attribute_id')
        ->pluck('product_attribute_id');
} else {
    // do another code here if the  $product->attributeValues is not available
}