I am trying to insert hard coded data with QueryBuilder insertGetId() method. my code is- <?php namespace AppHttpControllers; use IlluminateHttpRequest; use IlluminateSupportFacadesDB; class StudentController extends Controller { public function addStudent() { $foreign_key = DB::table('students')->insertGetId([ 'id' => 'stu-000002', 'name' => 'Ahsan',…
I am trying to send simple email through mailgun and laravel, but getting a weird error. I am not using queue just sending a simple welcome email on run time. following is error: Serialization of 'Closure' is not allowed Following…
i have query like this, but displays wrong last_message. $users = Message::join('users', function ($join) { $join->on('messages.from_id', '=', 'users.id') ->orOn('messages.to_id', '=', 'users.id'); }) ->where(function ($q) { $q->where('messages.from_id', auth()->user()->id) ->orWhere('messages.to_id', auth()->user()->id); }) ->where('users.id','!=',auth()->user()->id) ->select([ 'users.id', 'users.name', 'users.avatar', DB::raw('MAX(messages.created_at) max_created_at'), DB::raw('MAX(messages.body) last_message'), DB::raw('CASE…
I have php 7.4 by default in my xampp (in the path c:xamppphp) and my most projects are running on it.Now, I've a php 8 project & so need to run xampp with php 8.1 on a different port(8056).I tried…
I have been trying to implement a search filter query for my table of vfis using React and Laravel with an API. The below code is where the search form resides. Navbar.js import React, {useState} from 'react'; import {Link, useHistory}…
i'm using flickity as the instructions, but got this error warning in the console anybody know how to solve this? Here is the current bundle package <script src="https://unpkg.com/flickity-as-nav-for@3/as-nav-for.js"></script> <script src="https://unpkg.com/flickity@2/dist/flickity.pkgd.min.js"></script> <link rel="stylesheet" href="https://unpkg.com/flickity@2/dist/flickity.min.css"> i'm using flickity AsNavFor but it shown…
I need to validate a string whose length is exactly 6 OR 8. How could I make the rule for this validation? The number must be 6 OR 8, it cannot be between 6 and 8.
After upload, this code gets the error on ip2proxy not found on the server. I have already installed ip2proxy extension. use IlluminateHttpRequest; use IlluminateRoutingController as BaseController; use IP2ProxyLaravel; class Controller extends BaseController { public function lookup(Request $request) { $get_ip =…
I'm new in php/laravel. I'm trying to get one user with the userName of the user connected except if it's "Chuck NORRIS" This, is working. I'm getting the user connected information $oneUser= User::where('name', $userName)->get(); This, is not working. I'm getting…
I want to use sync() for table client_package except some values/fields. It's because I'm displaying checkboxes with client names, that I want to add to a package. So if User has specific permission, he could see specific clients, and it's…