MySQLdb insert HTML code error

Discussion in 'Python' started by Anatoli Hristov, Dec 11, 2012.

  1. 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

    Thanks
     
    Anatoli Hristov, 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. Mark Lawrence

    Re: MySQLdb insert HTML code error

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

    Re: MySQLdb insert HTML code error

    Anatoli Hristov, Dec 11, 2012, in forum: Python
    Replies:
    0
    Views:
    205
    Anatoli Hristov
    Dec 11, 2012
  3. Anatoli Hristov

    Re: MySQLdb insert HTML code error

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

    Re: MySQLdb insert HTML code error

    Mark Lawrence, Dec 11, 2012, in forum: Python
    Replies:
    0
    Views:
    177
    Mark Lawrence
    Dec 11, 2012
  5. MRAB
    Replies:
    0
    Views:
    158
Loading...

Share This Page