python CGI 和 JQUERY 问题

发布于 2024-08-17 05:49:58 字数 1438 浏览 1 评论 0原文

我有一个简单的 python CGI 脚本,我在其中查询 MySQL 数据库,然后将结果打印到屏幕/网页。 我的问题是“cursor.execute()”函数返回元组列表。我使用一个简单的 for 循环来迭代该列表并提取每个元组。这一直很有效,直到......我有了一个好主意,使用 jquery 为用户制作一些引人注目的东西。我的整个脚本仍然有效......除了 for 循环。

我已经尝试过(在我看来)一切,但由于某种原因,当我做循环时它会破坏一切。有人可以启发我吗?我还注意到,如果我尝试使用函数调用来分离 HTML 格式和 python 代码,这也会破坏整个事情。我所说的破坏是指我收到服务器错误(apache)

以下是通过 /var/log/httpd/error.log 的错误:

[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32]  , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32]  , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32]  , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32]  , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] ^, referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] SyntaxError, referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] : , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] invalid syntax, referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] Premature end of script headers: userdata_submit.py, referer: http://test/index-test.html

I have a simple python CGI script where I query a MySQL database and then prints the result to the screen/webpage.
My problem is that the "cursor.execute()" function returns a list of tuples. I use a simple for loop to iterate through this list and extract each tuple. This was working great until.....I got the bright idea to use jquery to make some eyecandy for the user. My whole script still work....except the for loop.

I have tried to (to my mind) everything, but for some reason when I do a loop it breaks everything. Could someone enlighten me please. I have also noticed that if I try and seperate my HTML formatting and python code by using function calls this also breaks the whole thing. By breaking I mean I get a server error(apache)

Below is the error via /var/log/httpd/error.log:

[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32]  , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32]  , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32]  , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32]  , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] ^, referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] SyntaxError, referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] : , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] invalid syntax, referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] , referer: http://test/index-test.html
[Tue Jan 12 14:56:25 2010] [error] [client 192.168.7.32] Premature end of script headers: userdata_submit.py, referer: http://test/index-test.html

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

離人涙 2024-08-24 05:49:58

您似乎有语法错误。在 Python 和 Javascript 中,代码:

{referer: http://test/index-test.html}

无效。在 Javascript 中,你必须这样写:

{referer: "http://test/index-test.html"}

在 Python 中(假设“referer”是键而不是变量)为:

{"referer": "http://test/index-test.html"}

很难从你的日志中看出,但你可能会遇到类似的问题引用者密钥之前的相同哈希/字典。

It looks like you have a syntax error. In Python and Javascript, the code:

{referer: http://test/index-test.html}

is invalid. In Javascript, you'd have to write it like:

{referer: "http://test/index-test.html"}

and in Python (assuming "referer" is a key and not a variable) as:

{"referer": "http://test/index-test.html"}

It's hard to tell from your log, but you may have a similar problem with other keys in the same hash/dictionary prior to the referer key.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文