separating sql from html

[drooh]

I was reading up and Ive heard this before about not having your SQL queries mixed in with your PHP/HTML.

So my question is, what is the best way to do this and what are some ways of doing this? Why is it helpful? What is the benefit?

[LifeinAsia]

You can put your SQL in stored procedures.

It's another layer of security. If you have separate servers for web/application and database, it can also mean fewer calls to the database. Depending on the database and specific queries, they may run faster through a stored procedure than calling them from PHP.

[drooh]

hmmmm, what is a "stored procedure" ?

Can you give some examples and explain better.

[LifeinAsia]

A stored procedure is basically a block of SQL code that is run on the database server. This sounds like a good tutorial- [dev.mysql.com...]

[drooh]

yeah, thats flyin over the old noggin. if they could explain things in plain english then maybe more of us amateur coders could get better, until then