I want to know about Stored Procedures.
are they created in my db software - heidisql or PhpMyAdmin? I mean, where is the procedure stored.
having set up such a thing, (technical expression, I know), is the manner in which a script would interact with it, such that a set of params would be passed to the SP and it then process the query with those params?
how does that offer any more security than just having a query in my script, where the params are cleaned and cleaned and checked before the query can be run?
If this sounds like a, 'please work all this out for me' type question, it isn't meant to be. Links to easily explained tutorials would suffice. I have read the docs but can't seem to find the answers to these questions.