471,119 Members | 1,109 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,119 software developers and data experts.

Re: Prob. w/ Script Posting Last Value

En Thu, 17 Apr 2008 15:51:43 -0300, Victor Subervi <vi***********@gmail.comescribió:
On Thu, Apr 17, 2008 at 1:07 PM, Steve Holden <st***@holdenweb.comwrote:
> 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

Jun 27 '08 #1
0 617

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Jonathan M. Rose | last post: by
5 posts views Thread by Steve | last post: by
6 posts views Thread by oeyvind toft | last post: by
1 post views Thread by mahajanrahuld | last post: by
reply views Thread by Steve Holden | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.