SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mysql, SQL: alter table personal_a ccess_tokens add index personal_access_tokens_tokenable_type_tokenable_id_index(`tokenable_ I tried to add index with the specified key length $table->index(['tokenable_type', 'tokenable_id'],…
is there any way to make select2 auto select an item on ajax request when an specific condition matches? The below is my current code: const optionFormatSelect = (item) => { if (!item.id) { return item.text; } var span =…
I got this data from an external API call. $countries = @file_get_contents('https://external../api/countries'); $countriesArray = json_decode($countries, true); print_r($countriesArray); //dd($countriesArray); Array ( [success] => 1 [message] => countries [data] => Array ( [0] => Array ( [id] => 1 [name] => Afghanistan…
I have a Laravel rule for validation which is like this:- $ruleCondition = array( 'home_address' => 'required_if:delivery,y', 'office_address' => 'required_if:delivery,y', 'farm_house_address' => 'required_if:delivery,y', ); If delivery is y, then home_address, office_address and farm_house_address are required. However, I want to modify…
public function login(Request $request) { // Validate the request $request->validate([ 'username' => 'required|string', 'password' => 'required|string', ]); // Attempt to find the user by username $user = User::where('username', $request->username)->first(); // Check if the user exists if (!$user) { return response()->json(['error'…
I have a Laravel 10 project and I'm trying to validate a string that can include any character (max 11 chars), except the # char In my controller I tried this code, using regex $request->validate([ 'code' => 'required|max:11|regex:/[^#]*/', ]); but…
I'm having an issue when trying to register a new user in my Laravel application that uses Passport for API authentication. Here's the scenario and the error I'm facing: Scenario: I'm developing a RESTful API with Laravel and using Passport…
I've been scratching my head for maybe the last hour trying to figure out what's going on. I deleted my database.sql file since I wanted a new one from scratch. I've done this dozens of times, but upon running php…
My docker cmds: docker volume create SQL-DB docker run --name MySQL -p 3306:3306 -v SQL-DB:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=password -d mysql:latest Able to connect via TablePLUS & other MySQL Clients. But Failed to connect using .env file of Laravel. .env file: DB_CONNECTION=mysql…
I have two table: Clients, Employees Clients structure: id company_name address email phone created_by_employee Employees structure: id name position department_id I want to get all clients who were added by employees of the same department as the logged user. So…