How to convert this into Query builder or eloquent?

Question

Here is the part of code. As I am new to Laravel, I have no idea how to convert my query into Laravel Eloquent Query Builder, please let me know how to convert this into eloquent or query builder for LARAVEL?

for ($i = 0; $i < count($links); $i++) {
        $con = mysqli_connect("localhost", "root", "", "pacra-daily-2021");
        $sql = "SELECT keywords FROM `sectors` WHERE  id BETWEEN  0 AND 59";
        $result = mysqli_query($con, $sql);
        while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
            $keywords = $row["keywords"];
            if (preg_match($keywords, $links[$i])) {
                if (filter_var($links[$i], FILTER_VALIDATE_URL) !== false) {
                    array_push($mainNewsLinks, $links[$i]);
                }
            }
        }
    }
    return $mainNewsLinks;
}

[Here](https://laravel.com/docs/8.x/database) is how you can connect to the database using Laravel and the [query builder documentation](https://laravel.com/docs/8.x/queries) is how you can write queries. Can you make an attempt in getting it to work yourself and only open a question if you're having difficulty? This site isn't intended to provide tutorials — apokryfos, Jul 29 '21 at 05:47

score 0 · Accepted Answer · edited Jul 30 '21 at 00:48

0

ModalName::select('keywords')->whereBetween('id', [0, 59])->get();

Here ModalName will go to be replaced with your Respective ModalName

edited Jul 30 '21 at 00:48

Dharman

30,962
25
85
135

answered Jul 29 '21 at 05:55

Prince Patel

16
5

score 0 · Answer 2 · answered Jul 29 '21 at 07:56

0

ModalKeywords::where('id', '>',0)->where('id','<',59)->get();

You should create a Keywords Modal

answered Jul 29 '21 at 07:56

How to convert this into Query builder or eloquent?

2 Answers2