SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘image’ (SQL: create table products (id bigint unsigned not null auto_increment primary key, name varchar(255) not null, slug varchar(255) not null, short_description varchar(255) null, description text not null, regular_price decimal(8, 2) not null, sale_price decimal(8, 2) null, SKU varchar(255) not null, stock_status enum(‘instock’, ‘outofstock’) not null, feature ..
Category : database
enter image description here im using xampp server on localhost and when try to install the database for laravel script get this error on file permission im trying to change the permission to full control but still error appear how can i solve it ?! Sourc..
Hej guys, currently I am developing a Laravel web app with a kind of hard to solve through-relationship. My relationship looks like this: The problem is: I want to have a courses relationship on my module model. I tried to solve it with a custom has-many relationship that works … kind of. Well, yes, it ..
I would like to insert data into a database, but in controller is $request->ajax() false. Can anybody help me? I spent a whole day on Google, but nothing helped me. I am using laravel 8. I used ajax for filter books. It works fine. But here I don’t know where the error is. When I ..
Is there any to in laravel? I want to check if current_time<2PM , i want to update the datatabase time with : current_date and 8PM, If current_time>2PM: update the db with tomorrows date , 2pm, if TODAYS DAY is saturday and I want to update to MONDAY 2PM $check_time = Carbon::createFromFormat(‘H:i a’, ’01:00 PM’); $date ..
This is my code $data = DB::table(‘constructor_standings’) ->join(‘constructors’, ‘constructors.constructorId’, ‘=’, ‘constructor_standings.constructorId’) ->select(‘constructor_standings.*’, ‘constructors.*’) ->where([‘constructor_standings.raceId’ => $res2]) ->orderBy(‘position’, ‘asc’) ->get(); return $data; In constructor_standings there is a column "points". The column’s type is float. Although only few values are demical so i want the rest of them to be returned as integer and not as a ..
I have this line in a migration table Schema::create(‘xyzTableName’, function (Blueprint $table) { $table->id(); $table->unsignedBigInteger(‘userId’); $table->foreign(‘userId’)->references(‘id’)->on(‘userId’); $table->timestamps(); }); where I did write on(‘userId’) by mistake what I want is on(‘users’) now I did this, (in a new migration, as I can’t run migrate:fresh) Schema::create(‘xyzTableName’, function (Blueprint $table) { $table->foreign(‘userId’)->references(‘id’)->on(‘users’)->->change(); }); but I don’t why it ..
I have this line in a migration table Schema::create(‘xyzTableName’, function (Blueprint $table) { $table->id(); $table->unsignedBigInteger(‘userId’); $table->foreign(‘userId’)->references(‘id’)->on(‘userId’); $table->timestamps(); }); where I did write on(‘userId’) by mistake what I want is on(‘users’) now I did this, (in a new migration, as I can’t run migrate:fresh) Schema::create(‘xyzTableName’, function (Blueprint $table) { $table->foreign(‘userId’)->references(‘id’)->on(‘users’)->change(); }); but I don’t why it ..
I’m having doubts determinig the name for some tables of my project. Basically, I want to link a property (real estate) to it’s improvements. For example, a house that have a pool. The pool is an improvement. A property may have many improvements and an improvement may be linked to many properties. So I need ..
i am making a search for the website so the user can search for results from database everything is working fine but how can i hide results until the user complete the search? this is the controller: class SearchController extends Controller { public function search(Request $request){ // Get the search value from the request $search ..
please help me! how to read file uploaded from database of moodle by laravel framework moodle code: $fs = get_file_storage(); $files = $fs->get_area_files($context->id, ‘local_lmsdata’, ‘banner’, $banner->itemid, "", false); Sourc..
Here not able to extract JSON values because new row(data) will come with different set of key’s…? so how to fetch random keys from JSON in database ?? Sourc..
before i got this problem, i was try to connect the database from laravel to phpmyadmin and i think it’s solved i don’t know if it solved or not yet cause the error said different before it says "SQLSTATE[HY000] [1045] Access denied for user ‘homestead’@’localhost’ (using password: YES)" something like that and after i change ..
i make code to when user click on button make count how much count do downloaded look here : https://i.ibb.co/1GMfrvr/3s.png $downloads = new Download(); $downloads = Download::where(‘trx’,$downloads->trx)->whereHas(‘user’, function ($query) { $query->where(‘download_count’,0); })->latest()->with([‘product_id’])->first(); $downloads->increment(‘download_count’); I need to read it differently for each transaction id and id – one by one Sourc..
Hi I am trying to get the current count of my statement below , but Iam get another product count: i adding New Count System Like When User Click Button get +=1 in DB public function productDownload($id) { $counts_download = Download::where(‘download_count’,0,’product_id’,$product->id->paginate(getPaginate())); $counts_download->increment(‘download_count’); } This Working Adding Count but on another Product so how to edit ..
I am create an laravel app it’s similar classroom app. Now I’m going to make button to make unit of lesson, it will loop to create column when click button, then I want to make button in blade for add column in database. Is it possible? Sourc..
I have 2 different TEAM BASED web sites setup that must share the same USER database however hold TEAMS info and manage them in their respective database. So for example… I have a database connection setup for DATABASE_USERS. It works fine, people can log in and out edit their member profile, etc… Then I have ..
I have one database table which contains multiple columns are there with different data types,one of the column is currency which is stored inside a database as an integer. i have one API which is used for retrieving all the values from the database and displayed in UI,in my UI level they are accepting currency ..
I have a users table where the clients can either register themselves or call the company to register them in case the process is complicated for them, i wanted to organize the clients list in order to have: the self registered clients in one page ,and the clients registered by an employee in another page, ..
I have recently joined a project that uses AWS EC2 to deploy a frontend in NodeJS and a backend in Laravel linked to a phpMyAdmin database. My question is simple but I have not found the way to do it despite litteral hours of research. How can I launch the backend locally and use the ..
Here is my products table schema Schema::create(‘products’, function (Blueprint $table) { $table->id(); $table->string(‘product_name’); $table->string(‘product_slug’); $table->text(‘product_description’); $table->unsignedBigInteger(‘quantity’); $table->foreignId(‘category_id’)->constrained()->onDelete(‘cascade’); $table->timestamps(); }); Here is my categories table schema Schema::create(‘categories’, function (Blueprint $table) { $table->id(); $table->string(‘name’); $table->timestamps(); }); After that when i try to migrate the database it show this kind of errors.please tell me why it’s causing this ..
public function scopeSearch($query, $value) { $searchValues = explode(‘ ‘, $value); if (!$value) return $query; return $query->where(function ($q) use ($searchValues) { foreach ($searchValues as $token) { $q->orWhere(‘name’, ‘like’, "%{$token}%"); $q->orWhere(‘street’, ‘like’, "%{$token}%"); } }); } I want to search the data. This model also has public function brands() { return $this->belongsToMany(Brand::class, ‘dealer_brands’); } public function province() ..
in case I make a request for filtered results on laravel 8 which contains over 2k rows in results I don’t get any results in response if I use order by in a controller. If I don’t use order by I recieve all the results correctly. Laravel 8, Linux, VueJS 2 Sourc..
Schema::create(‘signups’, function (Blueprint $table) { $table->id(); $table->string(‘first name’); $table->string(‘last name’); $table->??(’email’); $table->timestamps(); }); Sourc..
I am working on a delivery tracking system in Laravel and I want to implement automation in such a way that if the current status is SCHEDULED then on the time specified in the same DB table as SCHEDULED_TIME, its status should change to OUT_FOR_DELIVERY unless it is changed manually. I have searched a lot ..
Web Development Company
Free Hosting Company
