Converting mysql to laravel query

Why would you not want to execute something that detailed as a stored procedure?

Example:

DB::select('exec my_stored_procedure(?,?,..)',array($Param1,$param2));

I finally found some searches that lead me in the right direction.

$Registrations = DB::table('somascourseregistrations')
                ->select('somascourseregistrations.id', 'CourseID', 'TuitionType', 'FirstName', 'LastName',
                    DB::raw("(SELECT (ClassFee + HomeOfficeFee + MaterialsFee)                                
                                GROUP BY somascourseregistrations.id) as TotalTuition"),
                    DB::raw("(SELECT SUM(PaymentAmount) FROM somasstudentclasspayments
                                WHERE somasstudentclasspayments.RegistrationID = somascourseregistrations.id
                                GROUP BY somascourseregistrations.id) as TotalPayments"))
                ->join('students', 'students.id', '=', 'somascourseregistrations.StudentID')                
                ->where('CourseID', $courseid)
                ->orderby('LastName')
                ->get();

I'm still really new... But I will look at the stored procedures you are referring too. Can you give me some links to check out?

Do you maintain your own database? I assume so if you wrote a query like that :-)

Generically, stored procedures are objects inside your database that allow you to name and run queries over and over without having to type them each time.

Here is a good generic page to get you started with what you should look into for learning how to write them:

https://www.w3schools.com/sql/sql_stored_procedures.asp

Note that each database engine has its own syntax for creating a stored proc so you will have to look at the documentation for your specific instance.

Database management tools like HeidiSQL have a sort of wizard that keeps you from having to create procs by typing the whole thing.

Perfect.. Thanks cemcminn... Yes.. I'm maintaining the database. I'm new to mysql.. so this is exactly what I needed.