How to execute multiple query in laravel ? (create myslq event, insert and update at one query)

before anyone answers your question, you should know that you should NEVER use string and variable concatenation in Sql queries. You are leaving yourself open to SQL injection attack.

We are trying to leave behind the perception of php being for hacky sites that are insecure... and the query appears very insecure

Thanks @Snapey .. I will prepare my code later to improve the security ? but the main problem for me, I have execute the code at mysql and it's work perfectly. I just dont know how to excecute it with DB::raw. anybody can help me to using another method to excecute that query ?? Thanks ?

You have to ->get() to run the query, but you should use prepared statements

Thanks @Snapey I have solved my problem. Altough I have to separate my query into 3 statement, but it's work