What are database escape() and quote() used for?

Question

I looked at some joomla components and there are functions like

$db->escape()
$db->quote()

What are they used for ?

Thanks

Answer 1

Thes escape function is used to escape bad characters in order to protect against SQL injection.

The quote* functions are used to quote strings, because different database dialects have different quoting characters.

So depending on the database system you use, Joomla will choose the appropriate quoting characters.