mvd

@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

Hi @trifek,

You can use deleteFileAfterSend

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

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

Hi @kundefine

Sorry forget my previous post, I can't see at the moment why it is not working.

What is the output if you log, response.data

console.log(response.data);

Created a quick example and this does work, https://jsfiddle.net/mvd81/z7mafx92/4/

Hi @joaquinvilchez,

That is an option, also you have a price history for your product. You can copy the id from the current price table to your order_product table.

Example: id | order_id | product_id | id_from_price_table

Other option (if you don't care about the price history) is to copy the price to an 'order_products' table when someone place an order.

Example: id | order_id | products_id | price |

Hi @doctolly,

I never used presenters but does this work?

$staff = $duties->staff->present(StafPresenter::class);

Hi @adgower,

Does this works?

 $event = Carbon\Carbon::parse($events->first()->start_date);
 $diffInHours = $event->diffInHours(Carbon\Carbon::now());
 dd($diffInHours);

If you run

phpinfo();

in a php script and call this php file in your browser, search for 'php.ini' you can see which is in use.

Hi @jeroenvanrensen

You have to make sure SSL / HTTPS is enabled. Search for 'wampserver enable ssl error 60' on Google