En Thu, 17 Apr 2008 15:51:43 -0300, Victor Subervi <[EMAIL PROTECTED]> escribió:
> On Thu, Apr 17, 2008 at 1:07 PM, Steve Holden <[EMAIL PROTECTED]> wrote: >> Victor Subervi wrote: >> >> > Gabriel provided a lovely script for showing images which I am modifying >> > for my needs. I have the following line: >> > print '<img src="getpic.py?id=%d&x=%d"><br /><br /></td>\n' % (d, y) >> > where the correct values are entered for the variables, and those values >> > increment (already tested). Here is the slightly modified script it calls: >> > #!/usr/local/bin/python >> > import cgitb; cgitb.enable() >> > import MySQLdb >> > import cgi >> > form = cgi.FieldStorage() >> > picid = int(form["id"].value) >> > x = int(form["x"].value) >> > pic = str(x) >> > print 'Content-Type: text/html' >> > db = MySQLdb.connect(host=host, user=user, passwd=passwd, db=db) >> > cursor= db.cursor() >> > sql = "select " + pic + " from products where id='" + str(picid) + "';" >> > cursor.execute(sql) >> > content = cursor.fetchall()[0][0].tostring() >> > cursor.close() >> > print 'Content-Type: image/jpeg\r\nContent-Length: %s\n' % len(content) >> > print content >> > I need to make it so that it will show all my images, not just the last >> > one. Suggestions, please. That 'Content-Type: text/html' is wrong, you're returning an image here. Are you sure that *different* pictures are stored in the database? Perhaps there was an error and all columns have the same picture. Also make sure you're not seeing a cached image in your browser. >> > In your "page generator" page, replace >> >> print '<img src="getpic.py?id=%d&x=%d"><br /><br /></td>\n' % (d, y) >> >> by >> >> for d, y in (results of some DB query to get d and y for each image): >> print '<img src="getpic.py?id=%d&x=%d"><br /><br /></td>\n' % (d, y) > > Well, I just tried this: > > #! /usr/bin/python > print """Content-type: text/html > <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> > <html> > <head> > <title></title> > </head> > <body> > <input type='hidden' name='db' value='benobeno_bre' /> > """ > y = 1 > for d in 2, 12: > while y < 12: > print '<img src="getpic.py?id=%d&x=%d"><br /><br /></td>\n' % (d, y) > y += 1 > print""" > </body> > </html>""" > and it printed the same image over and over again :( An empty line is missing after Content-Type and before the actual content. Look at the source and be sure the src= attribute is generated correctly. -- Gabriel Genellina -- http://mail.python.org/mailman/listinfo/python-list
