Are you trying to add a column to an already existing table?

I found solution that worked for me , I edited database.php file in config folder. Just edit

‘charset’ => ‘utf8mb4’,
‘collation’ => ‘utf8mb4_unicode_ci’,
to

‘charset’ => ‘utf8’,
‘collation’ => ‘utf8_unicode_ci’,

And it worked

Good job 👍

Hi Guys , Iam add information to the database via the form but i get a weired error message

Unprocessable Entity` response: {“error”:{“title”:[“The title field is required.”],”details”:[“The details field is required.”],”stock”:[“The stock fiel (truncated…)

Are you trying to add a column to an already existing table?, if not type on your terminal php artisan migrate:fresh

Print out the request

array:5 [▼
“title” => “Testing”
“details” => “testing”
“stock” => “8”
“picture” => UploadedFile {#243 ▶️}
“category” => “1”
]

Can any one help me to how can pass Berear token in header in swagger UI?

Left side of headers, there is a authorization tab

Sorry I didn’t under stand plz can you explain about it?

You should correct write word ‘bearer’

I am getting an error in Swagger UI can help me?

Did it work?

422 Unprocessable Entity` response: ?

ajax or axios?

normal laravel

I know

insert into database

what are you using in your javascript? axios or ajax?

no

.fail(function(err){
if (err.responseJSON) {
for (const error in err.responseJSON.errors) {
if (err.responseJSON.errors.hasOwnProperty(error)) {
const element = err.responseJSON.errors[error];
$this.prepend(`<div class=”alert alert-warning”> ${element}</div>`);
}
} this is for ajax(example)

public function PublishProduct(Request $request)
{
$rules = [
‘title’ => ‘required’,
‘details’ => ‘required’,
‘stock’ => ‘required|min:1’,
‘picture’ => ‘required|image’,
‘category’ => ‘required’,
];

//validate
$productData = $this->validate($request, $rules);

//Add the content the pic
$productData[‘picture’] = fopen($request->picture->path(), ‘r’);

//create a product

$productData = $this->marketServices->publishProduct($request->user()->service_id, $productData);

dd($productData);
return redirect()->route(‘products.show’,
[
‘title’ =>$productData->title,
‘id’ =>$productData->identifier,
])
->with(‘success’,[‘Product created successfull’]);
}

this is an api

consume an API

I want your javascript

I don’t use javascript

Then how are you getting 422 error?

422 means the data is invalid

The error comes from herer

it contains the validation meassge. an object with errors. good luck

$productData = $this->marketServices->publishProduct($request->user()->service_id, $productData);

dd($productData);

where have you seen that error?

when i am inserting data from the UI

OR Form

/*
* Publish a product on the API
* @return stdClass
* */
public function publishProduct($sellerId , $productData)
{
return $this->makeRequest(
‘POST’,
“sellers/{$sellerId}/products”,
[],
$productData,
[],
$hasFile = true
);
}

this method is not complete what happens if validation fails?

public function PublishProduct(Request $request)
{
$rules = [
‘title’ => ‘required’,
‘details’ => ‘required’,
‘stock’ => ‘required|min:1’,
‘picture’ => ‘required|image’,
‘category’ => ‘required’,
];

//validate
$productData = $this->validate($request, $rules);

//Add the content the pic
$productData[‘picture’] = fopen($request->picture->path(), ‘r’);

//create a product

$productData = $this->marketServices->publishProduct($request->user()->service_id, $productData);

dd($productData);
return redirect()->route(‘products.show’,
[
‘title’ =>$productData->title,
‘id’ =>$productData->identifier,
])
->with(‘success’,[‘Product created successfull’]);
}
}

if ($validator->fails()) {
return redirect(‘post/create’)
->withErrors($validator)
->withInput();
}

i prefer this one from the request object

`$request->validate([
‘title’ => ‘required|unique:posts|max:255’,
‘author.name’ => ‘required’,
‘author.description’ => ‘required’,
]);`

SQLSTATE[28000] [1045] Access denied for user ‘DB_USER’@’localhost’ (using password: YES) (SQL: select SUM(amount) as total from `tp_transactions` where `create ▶

Please How do I fix this error?

you set a user, in your data base, on this case localhost

Ok

Guys a little help

I’m trying an ajax file upload with laravel 5.7 but the file object isn’t found in the request

Any ideas why?

I’m using blueimp jquery upload library

It’s hard to help you without looking at the code

Something weird about my grammar, can someone fix it? Haha

use Vue.js or react js

It’s a jquery library that does multiple uploads