mvd

@ignium thanks!

Already tried to recreate input.blade.php step by step?

I don't have Livewire installed on this machine but tried to reproduce your code without Livewire. This is working.

input.blade.php

@props([
'prepend' => null,
'append' => null,
'type' => 'text'
])

<div class="{{ $attributes->get('class') }}">
    <label for="test-input" class="block text-sm font-medium leading-5 text-gray-700">{{ $slot }}</label>
        <input
            {{ $attributes->except('class') }}
            id="test-input"
            type="{{ $type }}"
            data-lpignore="true"
            class="form-input block w-full sm:text-sm sm:leading-5 {{ $prepend ? 'pl-7' : '' }} {{ $append ? 'pr-12' : '' }} disabled:bg-gray-100"
        />
        @if($append)
            <div class="absolute inset-y-0 right-0 pr-3 flex items-center pointer-events-none">
                <span class="text-gray-500 sm:text-sm sm:leading-5" id="price-currency">
                {{ $append }}
                </span>
            </div>
        @endif

</div>

and

<x-input
                            wire:model.lazy="initial_payment"
                            min="0"
                            step="0.01"
                            type="number"
                        prepend="$"
                        placeholder="placeholder....."
                        class="col-span-6 sm:col-span-3"
                        >field name</x-input>

And removing the space?

'user.badge' => 'required|unique:users, badge',

to

'user.badge' => 'required|unique:users,badge',

?

And removing the space?

'user.badge' => 'required|unique:users, badge',

to

'user.badge' => 'required|unique:users,badge',

?

Hi @ignium

Can you post the full input.blade.php file?

hi @jgravois

You can also add the column name in the validation

'user.badge' => 'required|unique:users, badge',

Thanks Andre! Usefull course.

@randy_johnson

Error in your code?

<input type="password" class="form-control" wire:model=" name"wire:model="password" required>

@araw I think this is the case

• If you run php artisan migrate (for the first time to create the table) and create the table temp_data, the table exists.
• If you run temporary_check for the first time everything is still working
• But by running temporary_check you also drop the table temp_data so the next time you run temporary_check the table does not exist and you will get this error.

So you need somewhere recreate the temp_data table.

Another option is to don't drop the table (Schema::drop('temp_data');) but remove all the data inside this table (DB::table('temp_data')->truncate();) so the table keeps existing.

@araw I think this is the case

• If you run php artisan migrate (for the first time to create the table) and create the table temp_data, the table exists.
• If you run temporary_check for the first time everything is still working
• But by running temporary_check you also drop the table temp_data so the next time you run temporary_check the table does not exist and you will get this error.

So you need somewhere recreate the temp_data table.

Another option is to don't drop the table (Schema::drop('temp_data');) but remove all the data inside this table (DB::table('temp_data')->truncate();) so the table keeps existing.

@araw

Can you show us your (whole) migration file for this table?

@araw

Do you have a GUI tool voor your database? Like PHPmyadmin for example and can you see the table temp_data?

@araw

And you also fired php artisan migrate?

You drop table in the code Schema::drop('temp_data');. Do you run the check temporary_checkmultiple times? Can you give us the output of

...
public function temporary_check()
{
    
    

    DB::table('temp_data')->insert(['sender_id'=>2,'receiver_id'=>3,'message'=>'message temp check']);

    $data = DB::table('temp_data')->get();
dd($data);	
    Schema::drop('temp_data');

    return $data;
}

Still the same error

Hi @araw

But in this piece of code you don't create the table. Did you create the temp table somewhere?

https://laravel.com/docs/8.x/migrations#creating-tables

Hi @majedabdullah

Not tested but something like this?

if($request->hasFile('files')){
    $counter = 0;
    
    $project = [
        'project_name' => $addProjectName,
        'project_des' => $addProjectDes,
        'project_link' => $addProjectLink
    ];
    
    $host = $_SERVER['HTTP_HOST'];
    foreach ($request->file('files') as $file) {
        $files =  $file->store('public');
        $fileName =  (explode('/',$files))[1];        
        $projectImage = 'http://'.$host.'/storage/'.$fileName;
        
        if (!$counter) {
            $project['project_image'] = $projectImage;
        }
        else {
            $project['project_image' . $counter] = $projectImage
        }
        $counter++;
        
    }

    DB::table('projects')->insert($project);
}

hi @davy_yg

Did you upload the file wp-config.php?

Hi @niyazvpp

Did you try to clear the cache?

php artisan config:cache or composer dump-autoload?

Hi @niyazvpp

Did you try to clear the cache?

php artisan config:cache or composer dump-autoload?

Hi @ravish

Can you show us the whole C:/xampp/apache/conf/extra/httpd-vhosts and C:\Windows\System32\drivers\etc\hosts file?

Can you also give us a link to the Youtube video?

@msslgomez you already have solved this(I see your answer as solved in your other topic) ?

Hi @msslgomez

I never used this package but based on the documentation you need to pass the total items (you already do this), current-page number and page-size, based on those variables the pagination can create the pager.

Example, you have 45 items, you want to show 10 items on a page. So you pass

Total: 45

Page-size: 10

current-page: 1

You will see something like 1 | 2 | 3 | 4 | 5

If you click on another page item, event handleCurrentChange will triggered.

handleCurrentChange(val) {
    console.log(`current page: ${val}`);      
},

Based on the new current page you can do an axios request for example and getting the next/previous 10 items for in you table. I assume :data="displayData" is the data for in el-table?

Something like:

handleCurrentChange(val) {

 axios.get("your-url-to-get-new-data?page=" + ${val})
        .then(response => {
            // update displayData
        })     
},

@neeraj1005 did you already create an Blade file with only HTML / CSS / JS for datatables?

Hi @equimper

Now you are doing a query for each player, so yes a lot of queries. Bulk is a good idea but Eloqent does not support bulk for updateOrCreate

Maybe you can use something like this for bulk insert https://gist.github.com/RuGa/5354e44883c7651fd15c ?

Hi @neeraj1005

Are there errors in your browser console?

@automica it seems like that, if I remove the unlink then I will (of course) see the file if I cancel it

@automica

The download popups if the zip is ready so you can't cancel the download if it is not ready. If I cancel the download when it is ready, there is no file on the server.

Hi @daenufrey

I make use of ZipArchive and this is doing what you want to do. https://www.php.net/manual/en/class.ziparchive.php

Here is an example

   $zip = new ZipArchive();
   
    //create the file and throw the error if unsuccessful
    if ($zip->open($archive_file_name, ZIPARCHIVE::CREATE )!==TRUE) {
        exit("cannot open <$archive_file_name>\n");
    }
    
    //Add image
    foreach($images as $files)    {
        $zip->addFile($file_path.$files,$files);

    }
    $zip->close();
    //then send the headers to force download the zip file
    header("Content-type: application/zip");
    header("Content-Disposition: attachment; filename=$archive_file_name");
    header("Pragma: no-cache");
    header("Expires: 0");
    readfile("$archive_file_name");

    // remove zip
    unlink($archive_file_name);
    exit;

I did not use Laravel for this code above, so maybe you can look to streamDownload in Laravel https://laravel.com/docs/7.x/responses#file-downloads

Sometimes you may wish to turn the string response of a given operation into a downloadable response without having to write the contents of the operation to disk. You may use the streamDownload method in this scenario. This method accepts a callback, file name, and an optional array of headers as its arguments

Hi @naysoewin,

You can disable the timestamps and do a save?

 $post->timestamps = false;
 $post->increment('view_count');
 $post->save();

And you can create a kind of increment in your $post model

public function incrementViewCount() {
        $this->timestamps = false;
        $this->increment('view_count');
        $this->save();
    }

So you can call

$post->incrementViewCount();

Hi @naysoewin,

You can disable the timestamps and do a save?

 $post->timestamps = false;
 $post->increment('view_count');
 $post->save();

And you can create a kind of increment in your $post model

public function incrementViewCount() {
        $this->timestamps = false;
        $this->increment('view_count');
        $this->save();
    }

So you can call

$post->incrementViewCount();

@afoysal

The 2.2.7 version uses Jquery

https://embed.plnkr.co/plunk/wx1lC8 (see script.js how to setup with Jquery)

And some more demo, https://github.com/fullcalendar/fullcalendar/tree/v2.2.7/demos

@afoysal

The JS/HMLT code from

{!! $calendar->calendar() !!}

{!! $calendar->script() !!}

@jlrdw

I don't think @tarang19 want do this at the same time but more do a post and return the create record (maybe @tarang19 needs some relationschip or there are some accessors / mutators for this created item). But this is just a assumption because it is a Vue question and not a Laravel / Eloquent question.

Hi @tarang19

You can use axio to do a post and return some data.

This article will help you, https://www.itsolutionstuff.com/post/laravel-vue-js-axios-post-request-example-and-demoexample.html to do this.

Hi @afoysal

What is the js output and source from

{!! $calendar->calendar() !!}

{!! $calendar->script() !!}

?

@hekmatyar it means there are no records in your database with status = 'published' and slug = '$slug'

If there are records, can you show us a screenshot from those records?

@hekmatyar

Replace

$offer = Offer::where('slug', '=', $slug)
        ->where('status', 'published')
        ->firstOrFail();
dd($offer);

with

$offer = Offer::where('slug', '=', $slug)
        ->where('status', 'published')
        ->get();
dd($offer);

To see if you have results from the query.

Hi @hekmatyar

Are you sure you set {{ $offer->title }} in view offers.show?

What is the output from this dump?

$offer = Offer::where('slug', '=', $slug)
        ->where('status', 'published')
        ->firstOrFail();
dd($offer);

@amit028 I am not familiar with the CoreRequest class.

Does the CoreRequest class make use of the formrequest class? Maybe you can implement the failedValidation method?

class RegisterCompany extends CoreRequest {

protected function failedValidation(Validator $validator)
    {
        throw (new ValidationException($validator))
                    ->errorBag($this->errorBag)
                    ->redirectTo($this->getRedirectUrl());
    }

public function rules()
{
...
}

}

Hi @amit028

Can you show us your controller code where you do the validation?

Hi @amit028

This is not a validation error but a sql error. If you want a validation for a unique e-mail you need this

'email' => 'required|email|unique:company_table_name,email'

And change 'company_table_name'to your sql table name for companies.

https://laravel.com/docs/7.x/validation#rule-unique

@davidsprauel

With the 'function'

'contact_id'      => function() {
            return factory(Contact::class)->create()->id;
        },

you can pass a variable and use it for the 'contact_id'. If you don't pass this variable it will use the return factory(Cont.... code.

With

'contact_id' => factory(Contact::class)

You are generating a new contact and you can not override the 'contact_id'

Hi @davidsprauel

Yes there is a problem a contact factory creates a company but the company factory creates again a contact ...you are in a loop. I am not sure if this is the best way but this will not loop.

Change the company factory to this

$factory->define(Company::class, function (Faker $faker) {
    return [
        'name'            => $faker->company,
        'contact_id'      => function() {
            return factory(Contact::class)->create()->id;
        },
        'location_id'     => factory(Location::class),
        'company_type_id' => rand(1, 3),
    ];
});

Create a company but you don't have a contact yet, so set this to 0

$company = factory(Company::class)->create(['contact_id' => 0]);

Update contact factory

$factory->define(Contact::class, function (Faker $faker) {
    return [
        'company_id'       => function() {
            return factory(Company::class)->create()->id;
}       ,
        'user_category_id' => rand(1, 3),
        'entry_date'       => now(),
        'key'              => Str::random(16),
        'email'            => $faker->safeEmail
    ];
});

Create the contact

$contact = factory(Contact::class)->create(['company_id' => $company->id]);

Now we have also a contact so we can update company with this contact id.

$company->contact_id = $contact->id;
$company->save();

Change the user factory

$factory->define(User::class, function (Faker $faker) {
    return [
        'contact_id'     => function() {
            return factory(Contact::class)->create()->id;
        },
        'firstname'      => $faker->firstName,
        'lastname'       => $faker->lastName,
        'email'          => $faker->unique()->safeEmail,
        'password'       => 'yIXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', // password,
        'key'            => Str::random(16),
        'remember_token' => Str::random(10),
    ];
});

Last step, create the user

$user= factory(User::class)->create(['contact_id' => $contact->id]);

Hi @nickywan123

Can you show us some Postman screenshots with you settings and response?

Hi @prachee

I think you need uses and not users

Route::post('/signup', [
	'uses' => '[email protected]',
	'as' => 'signup'
]);
....

Hi @prachee

I think you need uses and not users

Route::post('/signup', [
	'uses' => '[email protected]',
	'as' => 'signup'
]);
....

Hi @sumeshvasu

If you add this (test) code to your route/web.php

Route::get('test', function () {

// Don't know your model path/name, just a guess	
    \App\freelancerVehicleModel::create([
        'user_id' => 1,
        'vehicle_type' => 'bike',
        'vehicle_brand' => 'sample brand',// hardcoded
        'vehicle_model' => 'sample model',// hardcoded
        'vehicle_color' => 'red',
        'vehicle_number' => 123,
        'status' => true,
    ]);
});

And run 'yoursite/test' in your browser? Is there a new record in your database?

Hi @bhhussain,

Something like this?

->groupBy(DB::raw("DATE_FORMAT(job_invoice_date, '%Y-%m-%d')")

?

Hi @sumeshvasu ,

Can you show us the controller code where you hardcoded this and where do the create?

Hi @sumeshvasu

You are not passing a ‘vehicle_brand’ from the postman request I guess. And the database field has no default value.

@boubou

How do you bind the response in your Axios request.

Code looks fine, example: https://jsfiddle.net/mvd81/a1nsvqL4/16/

Hi @trifek,

You can use deleteFileAfterSend

return response()->download(storage_path($fileNameServer), $fileName)->deleteFileAfterSend(true);

https://laravel.com/docs/5.0/responses#other-responses