Laravel 2019-08-07 21:39

$.ajaxSetup({
headers: {
‘X-CSRF-TOKEN’: $(‘meta[name=”csrf-token”]’).attr(‘content’)
}
});

hie

can i check route parameter and ther route to controller accordingly

Route::get(‘builder/{template}’, ‘TemplatesController@show’);
Route::get(‘builder/{savedtemplates}’, ‘SavedTemplatesController@show’);

Can any one help to find this error
I didn’t use auth service provider in this project

Trying adding ‘driver’ => ‘eloquent’ into the auth.php

Is this correct

Yeah

But the issue is not solved

Which version are U using

5.4

Ok

Let check thru first then get back

Sorry that is 5.5

Try this
After adding ‘driver’=>’eloquent’
2. Add ArtisanServiceProvider
IllluminateFoundationProvidersArtisanServiceProvider

Under ‘providers’

3. Then perform composer update

Done these steps but no change

Did U add the “::class” at the end of no.2

Yes

Then try and comment out the lines you just added before the updates then see what happens

Yap sure

How to find parent_id count?

Users table

public function up()
{
Schema::create(‘users’, function (Blueprint $table) {
$table->bigIncrements(‘id’);
$table->string(‘first_name’);
$table->string(‘last_name’);
$table->string(‘referral_code’)->nullable();
$table->integer(‘parent_id’)->unsigned()->nullable();
$table->string(‘mobile’)->unique();
$table->string(’email’)->unique();
$table->string(‘password’);
$table->rememberToken();
$table->timestamps();
});
}

Order table

public function up()
{
Schema::create(‘oreders’, function (Blueprint $table) {
$table->bigIncrements(‘id’);
$table->bigInteger(‘user_id’)->unsigned();
$table->foreign(‘user_id’)->references(‘id’)->on(‘users’)->onDelete(‘cascade’);
$table->bigInteger(‘product_id’)->unsigned();
$table->foreign(‘product_id’)->references(‘id’)->on(‘products’)->onDelete(‘cascade’);
$table->timestamps();
});
}

My Controller.php

public function index()
{
$orders = Order::with(‘user’)->where(”parent_id)->count();
return $orders;
}

I get this error.

> SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘parent_id’ in ‘where clause’ (SQL: select count(*) as aggregate from orders where exists (select * from users where orders.user_id = users.id`) and `parent_id is null)

Try this .. where(“users.parent_id”)

*user.parent_id

Hello, I have a windows server for testing, running SQL Server 14, Apache and PHP 7.3.

I’m hosting an API laravel project in it, and I’ve configured php/laravel to use SQL Server, so far, the migrations are running, creating objects with tinker works and saves in the DB, but when the VueJS SPA (in the same laravel project) queries the API, the driver throws the following exception:

SQLSTATE[08001]: [Microsoft][ODBC Driver 13 for SQL Server]Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server.

I’ve tried with SQLite and everything runs well, but no luck with MSSQL.

I’ve tried some solutions suggested in google like restarting the MSSQL server, or adding the domain name to the hosts file, but with no luck.

Hi guys
Please suggest me good tutorial for VCS and git

Did any body work on rental system in laravel

“rental system”?

what are you renting

Hello Every One I encounterd the problem please tell me how to do it.
here is my code style

and it show me with errors shown in below pic

your case isnt right for your backendapi main controller

it should be BackendApi not backendApi

seems pretty self explanatory to me

…did you just… facepalm your own message?

Hi guys .I am running php artisan migrate:fresh —seed . But i get the following error message .

IlluminateDatabaseQueryException : SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table product_categories add constraint `
product_categories_category_id_foreign` foreign key (category_id) references categories (id))

is it because of laravel 5.8

try making them bigintegers maybe

it looks like the types (whatever they may be) don’t match between the columns

i’d say because you’re using bigIncrements for the ids they should be bigintegers for the foreign keys

Let me try

This is what i get

Base table or view already exists: 1050 Table ‘product_categories’ already exists (SQL: create table `product
_categories` (id bigint unsigned not null auto_increment primary key, category_id bigint unsigned not null, product_id bigint unsigned not null) default characte
r set utf8mb4 collate ‘utf8mb4_unicode_ci’)

did you just seed, or migrate:fresh —seed?

migrate:fresh —seed

php artisan migrate:fresh —seed