Javascript – Remove immediate duplicate items
I need to remove immediately-subsequent duplicate items from a given array items. For example, if I have this array: [1, 2, 2, 3, 3, 1, 1, 4, 5, 5, 4, 4, 4, 6, 2] … this is what the result…
PHP – Count Unique Word and Add Counted Prefix
I tried this $data = "air;air;air;bus;air;air;bus;air;air"; $a = substr_count($data,"air"); $b = substr_count($data,"bus"); $data = implode($a . ' x ', array_unique(explode('air;', $data))); echo $data; And I get 7 x bus;7 x air What I actually want to get is 7 x…
Javascript – How to get unique objects without key-value from an array of objects with numbers in js?
I'm sorry for posting such a question, but I really want to know about this, I have used Set, Map, or array filter methods to do the same but it works when I have the first set of arrays with…
Get all possible combinations from an array in PHP
I have an array. This an example: $array = ['A', 'B', 'C', 'D'] I would like all possible combination to get the following result: $new_array = [ ['A', 'B'], ['A', 'C'], ['A', 'D'], ['A', 'B', 'C'], ['A', 'B', 'D'], ['A',…
Unique validation for Phone No column in Laravel Controller not working properly
I want to validate Email column and Phone No column as Unique. Phone no is submitted to the Database as a concatenation of calling code and phone no. Here is my code. public function customRegistration(Request $request) { $request->validate([ 'name' =>…
MySQL multi UPDATE possible unique key performance issue
I have a MySQL database table with 15 columns. It has 2 indexes; a primary which is an int (auto increment), and a compound unique index across 4 columns, int, int, int and datetime. The table currently has 5.5M entries,…
optimal way to create a 12 digit unique random number for users – PHP
Issue I am trying to add a 12 digit long (numeric values only!), unique identifier to a user table that will be given to the users to find each other. Since it will be handed to the users it needs…
CONSTRAINT to restrict DUPLICATE values among 2 Columns – Mysql
I need to put a constraint which will restrict DUPLICATE entries in combination of 2 columns. So I have a customers table, with the below mentioned columns id, first_name, last_name, date_of_birth, gender, email_address, primary_number, secondary_number. What I am expecting is…
Is unique composite index as effective as non-composite for queries on first column? – Postgresql
I have a table with b-tree index on column A (non-unique). Now I want to add a check for uniqueness of column A and column B combination when inserting, so I want to add a unique composite index (A, B).…
Jquery inside PHP loop with PHP values as ID
I'm using a Bootstrap multiselect plugin (https://davidstutz.github.io/bootstrap-multiselect/). The documentation says to call the plugin to the forms select id by the following: $('#example').multiselect(); However my page is a timetable with multiple cells that are actually generated by a loop statement.…