Using Python to write to HTML file with MySQL data as source?

Question

I am trying to generate some simple html pages that contain data stored in a MySQL database. I have searched and searched for an answer to this and while I can successfully generate html pages from txt or user input I can't get it working with SQL. I am not worried about formatting the data in html or anything, that I can work out. All I would like to do is something like the following but I can't work out how to actually get the data printing to the file. Any help would be greatly appreciated.

import MySQLdb 

def data():    
    db_connection = MySQLdb.connect(host='localhost', user='root', passwd='') 
    cursor = db_connection.cursor()
    cursor.execute('USE inb104')
    cursor.execute("SELECT Value FROM popularity WHERE Category = 'movies'")
    result = cursor.fetchall()

    return result

htmlFilename = 'test.html'
htmlFile = open(htmlFilename, 'w')
htmlFile.write = data
htmlFile.close()

ghostdog74 · Accepted Answer · 2010-10-17 02:40:52Z

2

def data():    
    db_connection = MySQLdb.connect(host='localhost', user='root', passwd='') 
    cursor = db_connection.cursor()
    cursor.execute('USE inb104')
    cursor.execute("SELECT Value FROM popularity WHERE Category = 'movies'")
    result = cursor.fetchall()

    return ' '.join(result)

If your data() returns a tuple, you may want to use join to make it into a string.

answered Oct 17, 2010 at 2:40

ghostdog74

346k62 gold badges264 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ned Batchelder · Accepted Answer · 2010-10-17 02:47:19Z

2

Change this:

htmlFile.write = data

to:

def formatDataAsHtml(data):
    return "<br>".join(data)

htmlFile.write(formatDataAsHtml(data()))

edited Oct 17, 2010 at 2:47

answered Oct 17, 2010 at 2:27

Ned Batchelder

378k77 gold badges583 silver badges675 bronze badges

1 Comment

Mischa Colley Over a year ago

Thanks but I get an error saying: TypeError: must be string or read-only character buffer, not tuple

Machavity · Accepted Answer · 2020-12-25 19:14:13Z

-1

Make sure to replace

return ' '.join(result)

with

list_of_strings = ["(%s)" % c for c in result]
return ' '.join(list_of_strings)

edited Dec 25, 2020 at 19:14

Machavity♦

31.8k27 gold badges97 silver badges108 bronze badges

answered May 2, 2012 at 6:48

user1357154

391 silver badge9 bronze badges

Collectives™ on Stack Overflow

Using Python to write to HTML file with MySQL data as source?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related