CODEWITHSUNDEEP
phplaravellaravel-8
user7424490
user7424490

Reputation:

Laravel 8: How to insert unique data from the DB

I need to insert some unique content into the DB using Laravel 8. Here is my code:

foreach($trigger as $e)
{
    if(is_array($e))
    {
        foreach($e as $t)
        $query = DB::table('tickets')->insert([
            'userId' => '',
            'types' => '',
            'startRound' => '',
            'endRound' => '',
            'numbers' => '0x'.$t->toHex() // MUST BE UNIQUE
        ]);
    }
}

As you can see the field numbers should stored unique numbers but I have some duplicated Hex values and I don't want to store them at the DB.

So how can I insert UNIQUE values into the DB.

Note that I have already added unique() to the Migration like this:

$table->string('numbers')->unique();

But this does not solve my problem, I need some codes to be added to the Controller for making this field unique.

So I would really appreciate any idea or solution from you guys...

Thanks in advance.

UPDATE #1:

enter image description here

UPDATE #2:

enter image description here

UPDATE #3:

enter image description here

Upvotes: 1

Views: 2333

Answers (3)

dılo sürücü
dılo sürücü

Reputation: 4211

you should unique method in migration or in mysql

$table->string('field_name')->unique();

that will avoid duplicate records

Upvotes: 0

Mehravish Temkar
Mehravish Temkar

Reputation: 4365

First you need to get details of existing data and then before inserting you need to check if the data already exists else insert.

$existing_data = DB::table('tickets')->pluck('numbers', 'numbers');

foreach($trigger as $e)
{
    if(is_array($e))
    {
        foreach($e as $t) {
            if(!isset($existing_data['0x'.$t->toHex()])) {
                $query = DB::table('tickets')->insert([
                        'userId' => '',
                        'types' => '',
                        'startRound' => '',
                        'endRound' => '',
                        'numbers' => '0x'.$t->toHex() // MUST BE UNIQUE
                ]);
                $existing_data['0x'.$t->toHex()] = '0x'.$t->toHex();
            }
        }
    }
}

To reduce the number of rows in $existing_data, you can pass all the values of $t in your $trigger by fetching them through some built-in function and then passing them to the query like this

$existing_data = DB::table('tickets')->whereIn('numbers', $all_values_of_t)->pluck('numbers', 'numbers');

Upvotes: 4

Peppermintology
Peppermintology

Reputation: 10220

If you just want to skip over the insertion, you could make use of the unique rule available in the Laravel validator.

foreach($trigger as $e) {
    if(is_array($e)) {
        foreach($e as $t) {
            $validator = Validator::make(['number' => '0x'.$t->toHex()], [
                'numbers' => ['unique:tickets'],
            ]);

            if ($validator->fails()) {
                continue;
            }

            $query = DB::table('tickets')->insert([
                'userId' => '',
                'types' => '',
                'startRound' => '',
                'endRound' => '',
                'numbers' => '0x'.$t->toHex() // MUST BE UNIQUE
            ]);
        }
    }
}

Upvotes: 0

Related Questions