Guys i need help I converted my php pure code to laravel but it seems a problem

Question

This is pure code :

1. public function getComments() {

2.         $query = $this->con->prepare("SELECT * FROM comments WHERE videoId=:videoId AND responseTo=0 ORDER BY datePosted DESC");

3.         $query->bindParam(":videoId", $id);

5.         $id = $this->getId();

7.         $query->execute();

9.         $comments = array();

10.         while($row = $query->fetch(PDO::FETCH_ASSOC)) {

11.             $comment = new Comment($this->con, $row, $this->userLoggedInObj, $id);

12.             array_push($comments, $comment);

13.         }

15.         return $comments;

17.     }

This is laravel code:

1. public function getComments() {

3.         $id = $this->getId();

4.          $query= DB::table('comments' )->where(['videoId' => $id ,'responseTo' =>0])->get();

5.         $comments = array();

6.         while( $row = $query) {

7.             $comment = new Comment($row, $this->userLoggedInObj, $id);

8.             array_push($comments, $comment);

9.         }

10.         return $comments ;

11.     }

Probably the problem withe
 FETCH_ASSOC
How can i use FETCH_ASSOC in laravel ? I think get() it use it manually

Comments

Hello @Hawati ,

I think First() is fetch assoc. Try using that first

Hope it helps!

---

Thank you so much buddy.....I fix that...but now I got an error... FatalErrorException in ProviderRepository.php line 146: Class 'Artisaninweb\SoapWrapper\ServiceProvider' not found

Help me to fix this...

---

The error is telling you the class can't be found, so perhaps your setup is lacking something or the package didn't install properly. You could try composer dump-autoload and double checking the Soap package is installed properly by checking your composer files  it should be in composer.json and autoload_classmap.php and if that fails double check the steps for installation.

---

Thank you so much.it helps