I am trying to create procedure migration in laravel but I am getting syntex error every time I tried so but didn’t make it work Below is the code $this->addSql("CREATE PROCEDURE Type_Store_Sync(IN name_it VARCHAR(255), IN guid VARCHAR(32), IN type VARCHAR(10), IN orgid INT(11), IN scheme VARCHAR(6)) LANGUAGE SQL BEGIN CALL mysql.lambda_async( ‘arn:aws:lambda:eu-west-2::function:triggersync’, CONCAT(‘{ "name" : ..
Category : database
I’m having trouble with the foreign key. I have two tables. users table and user_address table. I’ll show you the migration. users table: public function up() { Schema::create(‘users’, function (Blueprint $table) { $table->id(); $table->string(‘name’); $table->string(‘username’)->unique()->nullable(); $table->string(’email’)->unique(); $table->timestamp(’email_verified_at’)->nullable(); $table->string(‘password’); $table->rememberToken(); $table->timestamps(); }); } and this is the user_address table: public function up() { Schema::create(‘user_address’, function (Blueprint ..
I am trying to fetch a grouped By list of all my Summaries with the according Sum of the total field. To visualise it it would look something like this ID. Code. Total. Created_at. Updated_at 1 61B5A4C5 1437.64 2021-06-22 11:18:09 2021-06-22 11:18:09 2 A9B5311C 711.44 2021-06-22 11:19:10 2021-06-22 11:19:10 3 1426CDC5 711.44 2021-06-22 11:19:27 2021-06-22 ..
I have a SAAS application in which users creates school, now, once that school was approved, I need to automate the creation of that school’s database. So far, I can manually do it by adding new connection to database.php config. My question is, how can I dynamically add new connection to database.php? … ‘connections’ => ..
->editColumn(‘milestitle’, function ($row) { return DATEDIFF($row->start, $row->due) ; }) Error Call to a member function diffInDays() on null Sourc..
I am trying to fetch the most popular product of all my summaries. Preverable the name of the product that is the most common among all the summaries. I have a Summaries table and a products table with a pivot table in between. The relation is as follows: Product model public function summaries() { return ..
I am very new to Laravel. I am currently doing a Laravel project where a person can submit a proposal. The Laravel version im using is Laravel Framework 8. I divided the proposal form into 7 pages. I also have 7 tables in the database. So the data of each page will be saved into ..
I’m trying to add an user to data base in latavel. following is my User Model. <?php namespace AppModels; use IlluminateContractsAuthMustVerifyEmail; use IlluminateDatabaseEloquentFactoriesHasFactory; use IlluminateFoundationAuthUser as Authenticatable; use IlluminateNotificationsNotifiable; use SpatiePermissionTraitsHasRoles; class User extends Authenticatable implements MustVerifyEmail { use HasFactory, Notifiable, HasRoles; /** * The attributes that are mass assignable. * * @var array */ ..
How Are You? I am new to app development. I have a project to develop an app of already existing website, which is develop in Laravel 8. This website is online food ordering system which contains it’s data of food items and other in mysql database. Plz Guide me about the best way to develop ..
I have an enum column in my migration $table->enum(‘service_dmo’, [‘DCO’, ‘SEP’, ‘SEM’])->nullable(); I want to use a multiple select in a form in my blade view, am trying this but it didn’t work: <select class="form-control @if($errors->has(‘service_dmo’)) is-invalid @endif" name="service_dmo" multiple=""> <option></option> @foreach($courrier->service_dmo AS dmo) <option value="{{ $dmo }}">{{ $dmo }}</option> @endforeach </select> Sourc..
I need to make a composite constraint in Laravel, which only consider non soft-deleted rows. So if the entity was deleted, the deleted_at is not null and data_1, data_2, data_3, data_4, data_5 can be inserted again. Best I could come up with is this (table and column names were defined in previous migrations): public function ..
I’m using Laravel 7.. how want to regenerate the deleted primary key ID for example… Database ids are.. ================ id | username| ================ 1 | john | 2 | abc | 3 | xyz | if any user delete account like ID 2… my database look like follows… ================ id | username| ================ 1 | ..
I’m using Laravel 7.. I want to regenerate the deleted primary key ID for example… My database ids are.. ================ id | username| ================ 1 | john | 2 | abc | 3 | xyz | if any user delete account like ID 2… my database look like follows… ================ id | username| ================ 1 ..
Hye everyone! I have 2 issues:- I want to update my form but the data inside the database is not update, there is no error. Where and how to check other errors if possible? On the update popup, my dynamic dropdown did not work. Controller:- public function update(Request $req) { $usp_var = UserShiftPattern::find($req->inputUserID); $usp_var->shift_pattern_id = ..
I need to know what is the best way to store website settings (global configuration) as per performance and security wise? I want to store the following kind of data: Key Value Setting1 Value1 Setting2 Value2 I’m thinking about 2 ways. DB (This is somewhat hard to manage, because of the key-value pairs) Config file ..
So I was fetching data from my database to print in a table however, it says that Class "AppHttpControllersUser" not found. Here is the controller and here is how I will print the data public function directory() { $dashboardTitle = "Directory"; $isCurrent = "Directory"; $users = User::all(); return view(‘dashboard.directory’, [ ‘dashboardTitle’ => $dashboardTitle, ‘isCurrent’ => ..
I have written this code, yet I don’t know how to update the database after I perform a transaction, based on the product I purchase. Here is the MySQLi, where I think the problem is: <?php $total = $total + ($product[‘quantity’] * $product[‘price’]); mysqli_query($db, "UPDATE product set quantity = quantity-".$product[‘quantity’]." WHERE PRODUCT_ID = ‘".$product[‘id’]."’"); //$db::table(‘product’)->decrement(‘quantity’); ..
I have deployed my Laravel project on production but it seems that I am unable to establish a connection with the database I created in CPanel. I need this in order to execute some migrations and make some inserts through the platform. I have checked that the database name, username and password are correct multiple ..
How can I get the category names for a given subject whose my case is chemistry? This is the subject.blade.php code subject.blade.php code This is my subject table subjects table This is my category table categories table This is the web view of the result Subject.blade.php web view Sourc..
How does Laravel work in fetching database connections from database.php file and persist across the app? Sourc..
i’m trying get data from a table which is called item and i want to bring the items that contains the search string that the user searches for example the user searches "active" so it will go the the table pick up any data that’s field contain the word "active". i tried to do it ..
I have like this query to sum user stuffs volume: $users = User::query() ->select(‘users.id’, ‘users.name’) ->selectRaw(‘SUM(user_stuffs.volume) AS total_volume’) ->join(‘user_stuffs’, ‘user_stuffs.user_id’, ‘=’, ‘users.id’) ->get(); In this case my query return only there users which total_volume greater than zero. But I need all users in my case. For example if user doesn’t has volumes then there users ..
I have an issue with my project. I am passing the data through reactjs in the front end, but the value is not getting in the backend. Can anyone say what is the problem. $cert = new certificate; $val = Validator::make($req->all(), $cert->createRules); if ($val->fails()) { return response()->json($val->errors(), 422); } $cert->prize = $req->prize; $cert->name = $req->name; ..
I’m trying to store data into a database and I encountered a situation where I don’t know is it feasible or not to do that. so I have two following tables in the database public function up() { Schema::create(‘castings’, function (Blueprint $table) { $table->increments(‘id_casting’); $table->string(‘nom’); $table->string(‘prenom’); $table->string(‘cine’); $table->string(‘date_naissance’); $table->integer(‘lieu_naissance’); $table->string(‘mineur’); $table->integer(‘id_representant’)->unsigned(); $table->timestamps(); $table->foreign(‘id_representant’)->references(‘id_representant’)->on(‘representants’); }); } ..
This is the current code that loads all the users in the database. In the role 1 is admin and 2 are the normal users. So how can I return only the admin whit a role of 1? @foreach ($users as $key => $user) <tr> <td class="bs-checkbox "><input data-index="0" name="btSelectItem" type="checkbox"></td> <td>{{ $key + 1 ..
Web Development Company
Free Hosting Company
