Re: MySQLdb insert HTML code error

Discussion in 'Python' started by MRAB, Dec 11, 2012.

  1. MRAB

    MRAB Guest

    On 2012-12-11 00:04, Anatoli Hristov wrote:
    > Hi all,
    >
    > I'm facing an issue inserting an html code into the DB, it comes out
    > with a syntax error but I face it only when I have html code. Could
    > help me escape the error somehow ?
    >
    > Here is my code
    >
    > def InsertSpecsDB(product_id, spec, lang, name):
    > db = MySQLdb.connect("localhost","getit","opencart")
    > cursor = db.cursor()
    > sql = ("INSERT INTO product_description (product_id, language_id,
    > name, description) VALUES ('%s','%s','%s','%s')")
    > params = (product_id, lang, name, spec)
    > cursor.execute(sql, params)
    > id = cursor.lastrowid
    > print"Updated ID %s description %s" %(int(id), lang)
    > return id
    >

    You're using a parametrised query (which is good :)), but you've included
    quotes around the placeholders. There's no need to do that. They'll be
    quoted automatically when necessary:

    sql = "INSERT INTO product_description (product_id, language_id, name,
    description) VALUES (%s,%s,%s,%s)"
     
    MRAB, Dec 11, 2012
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Anatoli Hristov

    MySQLdb insert HTML code error

    Anatoli Hristov, Dec 11, 2012, in forum: Python
    Replies:
    0
    Views:
    146
    Anatoli Hristov
    Dec 11, 2012
  2. Mark Lawrence

    Re: MySQLdb insert HTML code error

    Mark Lawrence, Dec 11, 2012, in forum: Python
    Replies:
    0
    Views:
    163
    Mark Lawrence
    Dec 11, 2012
  3. Anatoli Hristov

    Re: MySQLdb insert HTML code error

    Anatoli Hristov, Dec 11, 2012, in forum: Python
    Replies:
    0
    Views:
    192
    Anatoli Hristov
    Dec 11, 2012
  4. Anatoli Hristov

    Re: MySQLdb insert HTML code error

    Anatoli Hristov, Dec 11, 2012, in forum: Python
    Replies:
    0
    Views:
    179
    Anatoli Hristov
    Dec 11, 2012
  5. Mark Lawrence

    Re: MySQLdb insert HTML code error

    Mark Lawrence, Dec 11, 2012, in forum: Python
    Replies:
    0
    Views:
    173
    Mark Lawrence
    Dec 11, 2012
Loading...

Share This Page