Prob. w/ Script Posting Last Value

Thu Apr 17 14:51:43 EDT 2008

On Thu, Apr 17, 2008 at 1:07 PM, Steve Holden <steve at holdenweb.com> wrote:

>  Victor Subervi wrote:
>
> > Hi;
> > 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.
> > TIA,
> > Victor
> >
> > 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 :(
Now, I could write a generator function that writes and then executes a new
program for each image "getpic" + i + "py?... but that is ugly.
Victor
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20080417/727da864/attachment-0001.html>