I'm searching good resource for learning more about stored procedures in SQL. Know any?

Stanford has a course on youtube back from 2013 or 2014, which is quite good. If I find the link, I'll post it here. I don't recall exactly if it includes store procedure, but I think it does.

@Wack that would be awesome, sir. Please let me know. 😊

Do you know how to write normal queries?

It's almost the same, but in stored procedures you can use variables, and functions if you want.

Also, there is a difference if you are using it in Mysql or Microsoft SQL Server

This playlist explain it good for Microsoft SQL Server:

https://youtube.com/playlist/...

Good luck in your search

@FahadAlt thanks. But I use MySQL only. 😅

@Divisionbyzero no problem, do you want to write sp inside phpmyadmin? Or do you have mysql application?

@FahadAlt I have no clue what can be done with it. I will take a glance at it first and then decide what to do with it.

@Divisionbyzero ok, its really good!

You won’t need to write queries in your php code anymore if you use it. You just call the sp.

@FahadAlt that sounds really awesome. 😦

This was the playlist: https://youtube.com/playlist/... unfortunately there is no lesson labled as stored procedures. I thought, I remembered that in there somewhere she talked about it. But I'm not sure anymore.

@Divisionbyzero yeah, but there is a small trick .. you need an OOP class that help you make the db connection and called the SP and passing the variables.

Classes like this can be found here:
https://www.phpclasses.org/

The want I used to use was made for SQL server.

@FahadAlt @Wack thank you. 😉