This is validate.py
import cgi
import yate
import sqlite3
connection = sqlite3.connect('users.sqlite')
cursor = connection.cursor()
print(yate.start_response('text/plain'))
form=cgi.FieldStorage()
for each_form_item in form.keys():
if (each_form_item=='username'):
username=form[each_form_item].value
if (each_form_item=='password'):
password=form[each_form_item].value
result=cursor.execute('SELECT USERNAME from validate')
usernames=[row[0] for row in result.fetchall()]
for each_username in usernames:
if (username==each_username):
pass_result=cursor.execute('SELECT PASSWORD from validate where username=?',(each_username,))
password1=[row[0] for row in pass_result.fetchall()]
for each_password in password1:
if (each_password==password):
print('Login Success')
#Here want to run another python program eg welcome.py
else:
print('Login Failure')
Web服务器在后台运行。如果以上代码中的条件为真，我想网页重定向到另一个python程序。我怎么做？
编辑：
Index.html
<html>
<head>
<title>Login Page</title>
<link type="text/css" rel="stylesheet" href="coach.css" />
</head>
<body>
<img src="images/logo-cel-transparent_0.png" width="74" height="64"> <strong><img src="images/logo-cel-transparent_0.png" alt="Cel logo" width="74" height="64" align="right">
</strong>
<h1 align="center"><strong>Central Electronics Limited</strong></h1>
<p> </p>
<h2 align="center">Storage Management System</h2>
<p> </p>
<p align="center">Login to System</p>
<p align="center"> </p>
<form action="/cgi-bin/validate.py" method="post">
<div align="center">User name :
<input type="text" name="username" value=""> <br>
Password : <input type="text" name="password" value=""> <br>
<input name="Submit" type="submit" value="Submit">
</div>
</form>
</body>
</html>
当我单击提交按钮validate.py运行。现在，如果用户名和密码匹配，我希望Web浏览器将浏览器自动重定向到另一个py文件或html页面，而无需用户执行任何操作。
编辑2：
我正在使用代码为：
from http.server import HTTPServer, CGIHTTPRequestHandler
port = 8080
httpd = HTTPServer(('', port), CGIHTTPRequestHandler)
print("Starting simple_httpd on port: " + str(httpd.server_port))
httpd.serve_forever()
这是使用命令提示符运行的。然后，我使用“ localhost：8080”在Web浏览器中打开索引页。
最佳答案
通过以下方式使用execfile命令：
for each_username in usernames:
if (username==each_username):
pass_result=cursor.execute('SELECT PASSWORD from validate where username=?',(each_username,))
password1=[row[0] for row in pass_result.fetchall()]
for each_password in password1:
if (each_password==password):
print('Login Success')
execfile(PATH_TO_THE_FILE+"./welcome.py")
else:
print('Login Failure')
注意：
PATH_TO_THE_FILE是磁盘中的路径，应为字符串编辑
当您使用python 3x时，这是
execfile命令的替代方法：with open("welcome.py") as f:
code = compile(f.read(), "welcome.py", 'exec')
exec(code)