Adding title to HTML table using python

Question

I have the following code;

#!/usr/bin/python3
# Connect to the database.
import pymysql
conn = pymysql.connect(
db='srt_test2',
user='root',
passwd='',
host='localhost')
c = conn.cursor()

# Print the contents of the database.
c.execute("SELECT * FROM users")
all_data = c.fetchall()
my_list = []
for item in all_data :
   my_list.append([item[1],item[4]])

my_page = """

<!DOCTYPE html>
   <html>
      <head>
         <title>HTML Tables</title>
   </head>
   <body>
     <table border="1">
{MY_TABLE}
      </table>
   </body>
</html>
"""
my_string = ""

for item in my_list :
   my_string += "      <tr>\n"
   for element in item :
       my_string += "         <td>" + str(element) + "</td>\n"
   my_string += "      </tr>\n"
# Print necessary headers.
print("Content-Type: text/html")
print()

print(my_page.format(MY_TABLE=my_string))

When I print element 1 how can I get it to have a title of "username" and when I print element 4 how can I get it to have a title of "grade" ? Thanks

where do you want "username" and "grade" ? In table header or in the same <td> or in another column ? — furas
– furas, Commented Dec 1, 2016 at 19:36

Robᵩ · Accepted Answer · 2016-12-01 19:34:26Z

2

You can use the th element, like so:

 <table border="1">
 <tr><th>username</th><th>grade</th></tr>
 {MY_TABLE}
  </table>

answered Dec 1, 2016 at 19:34

Robᵩ

170k20 gold badges251 silver badges323 bronze badges

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

Comments

ettanany · Accepted Answer · 2016-12-01 19:37:49Z

0

If what you want is just to add title for your table's columns, you can initialize your my_string variable like this:

my_string = '<tr><th>username</th><th>grade</th></tr>'

answered Dec 1, 2016 at 19:37

ettanany

20k9 gold badges49 silver badges64 bronze badges

Comments

Christoph Bluoss · Accepted Answer · 2016-12-01 19:41:48Z

0

Options:

1. ~~String concatenation~~

~~Template Strings~~
A fully featured template system like jinja2

I would also recommend to use some kind of web framework.

Edit: I think I misunderstand your Question. #3 is still a valid option, and you can count your loop as shown here

edited Dec 1, 2016 at 19:41

answered Dec 1, 2016 at 19:36

Christoph Bluoss

3591 silver badge9 bronze badges

Collectives™ on Stack Overflow

Adding title to HTML table using python

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related