tags:

views:

185

answers:

1
Q: 

Adodb, escaping quotes?

I am using adodb with php. I need to insert html into my database, and need to know the best method to escape the quotes before inserting it into the database? I tried using pg_escape_string() but it still does not seem to insert.

What is the best method to do this?

+1  A: 

The best method is to use a parameterized query. See here to get started:

Tomalak  2010-02-28 07:47:37
I am not sure I understand how this will help in escaping.
Nic Hubbard  2010-02-28 08:00:28
@Nic: But that is the whole *point* of parameterized queries. You don't need any escaping. You pass the raw string into the parameter, and that's it.
Tomalak  2010-02-28 09:53:07
Ok, I guess even after looking at those posts I am still every confused how to use parameterized queries.
Nic Hubbard  2010-02-28 19:54:25
$sql = "INSERT tbl (id, html) VALUES (?, ?)"; $results = $this->db->Execute($sql, array($id_val, $html_string));
Tomalak  2010-03-01 00:22:59
@Nic: Why ask me a question that is best suited for Google? Common sense applied, there must be tons of tutorials across the web, since there are tons of tutorials for almost *any* topic. It seems to me that you have not bothered looking into the topic of parameterized queries *at all*, so far. It's not that hard, really. All you got to do is do some basic reading, so I'm unsure where the actual problem is right now.
Tomalak  2010-03-02 12:35:20

related questions

IDE suggestions: Eclipse IDE vs. Zend Studio ( confused )
MySQL/Apache Error in PHP MySQL query
Lightweight IDE for Linux
What PHP framework would you choose for a new application and why?
Why is my ternary expression not working?
How can I get at the matches when using preg_replace in PHP?
Mechanisms for tracking DB schema changes
Wordpress theme development offline tools
Using object property as default for method property
How can I get the authenticated user name under Apache using plain HTTP authentication and PHP?
Make XAMPP/Apache serve file outside of htdocs
How do you debug PHP scripts?
PHP Variables passed by value or by reference?
Best way to implement unit testing in PHP
Connect PHP to an AS/400
Best way to access Exchange using PHP?
PHP Session Security
How do I access a remote form in php?
What's the best way to generate a tag cloud from an array? (using h1 through h6 for sizing)
Apache/PHP: error_log per Virtual Host?
How do I track file downloads with apache/PHP
How would you access Object properties from within an object method?
Flat File Databases in PHP
Best way to allow plugins for a PHP application
Latest information on PHP upcoming releases