Help with CGI functions on python.

Hi all....

i'm very new to this programming language. i'm required to fulfill this task in the company i'm doing my practical. i hope i can get guide for my problem...
Here is the script i already wrote but i'm having problem to move forward.

#!C:\python24\python.exe

####Code for viewing database....or search function#######

print 'Content-type: text/html\n\n'

import cgi # importing cgi module

import MySQLdb #importing MySQLdb module

form = cgi.FieldStorage() #assigning form to the cgi.FieldStorage

attribute = form.getvalue("attribute") #assigning attribute to get value from the function called attribute(drop down box) in the form

search = form.getvalue("search") #assigning search to get value from the function called search(textbox) in the form

conn =MySQLdb.connect(host = 'localhost', db='LESS', user ='root', passwd='') #creating conn to connect to MySQL

curs = conn.cursor() #creating a cursor called curs

curs.execute("use LESS") # exucuting the database

table = "download_file" #assignin table to download_file which is retrieved from MySql "less" under tables
#(download_file is a table name in less)

query = "select * from %s where %s like '%s'" %(table, attribute, search) #assigin query to MySQL command of select

#print query
curs.execute(query) #executing command set in the query function

count = curs.rowcount #indicating the cursor to count the rows
######## start of HTML code ##########
page= '''<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml
<head><title>View Database</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="http://localhost/Pictures/mm_travel2.css" type="text/css" />

<style type="text/css">

</style>

<script language="JavaScript" type="text/javascript">

var d=new Date();
var monthname=new Array("January","February","March","April","May"," June","July","August","September","October","Novem ber","December");
var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();
</script>
</head>
<body bgcolor="#C0DFFD">
<span class="style15"><img src="http://localhost/Pictures/f-secure.JPG" alt="Header image" width="153" height="144" border="0" /></span>
<h1 align="center">
<script language="JavaScript1.2">
var message="LESS File Collection!"
var neonbasecolor="#99FF66"
var neontextcolor="#CC3399"
var flashspeed=100 //in milliseconds
var n=0
if (document.all||document.getElementById){
document.write('<font color="'+neonbasecolor+'">')
for (m=0;m<message.length;m++)
document.write('<span id="neonlight'+m+'">'+message.charAt(m)+'</span>')
document.write('</font>')
}
else
document.write(message)
function crossref(number){
var crossobj=document.all? eval("document.all.neonlight"+number) : document.getElementById("neonlight"+number)
return crossobj
}
function neon(){
if (n==0){
for (m=0;m<message.length;m++)
crossref(m).style.color=neonbasecolor
}
crossref(n).style.color=neontextcolor
if (n<message.length-1)
n++
else{
n=0
clearInterval(flashing)
setTimeout("beginneon()",1500)
return
}
}
function beginneon(){
if (document.all||document.getElementById)
flashing=setInterval("neon()",flashspeed)
}
beginneon()
</script>

<table width="104%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="4" bgcolor="#003366"><img src="http://localhost/Pictures/spacer.gif" alt="" width="1" height="1" border="0" /></td>
</tr>

<tr bgcolor="#CCFF99">
<td> </td>
<td colspan="3" id="dateformat" height="25"><a href="LESS.html">HOME</a> ::<a href="Collection.html">Collection</a> ::<a href="Info.html">Info</a> ::<a href="Sources.html">Sources</a> :: <script language="JavaScript" type="text/javascript">
document.write(TODAY); </script> </td>
</tr>
<tr>
<td colspan="4" bgcolor="#003366"><img src="http://localhost/Pictures/spacer.gif" alt="" width="1" height="1" border="0" /></td>
</tr>
<tr>
<td width="4"> </td>
<td colspan="2" valign="top"><p> </p>
<p> </p></td>
<td width="590">  </td>
</tr>
</table>
'''
print page
print "<p><div align=\"center\"><h1>Search with %s Results</h1>" %count
print "<i>Searching for %s with %s</i> </div></p>" %(attribute, search)
print "<form method=post action=http://localhost/cgi-bin/Raulf/next.py>"
print "<table border = 1 cellpadding =0 cellspacing = 0>"
##### End of HTML code ######

###### start of Html and python code for the header of the search table #######
print "<tr bgcolor=\"#cccccc\">"
print "<td></td>"

h = 0 #setting the values of the attribute as zero

while h < 9: # total attribute is 0-8 so while h is less than 9
desc = curs.description[h]
print "<th>%s</th>" %desc[0]
h += 1 #increase the h value.
print "</tr>"
print "<p align=right><input type=submit value=Download>  <input type=submit value=Delete></p>"

###### End of code #####

###### start of Html and python code for the result of the search table #######

no_of_rows = 0 #setting the number of rows as zero

while True: #using while for true

row = curs.fetchone() #asking cursor to fetch one data at a time for a row
if not row: break #saying if its not a row the break it.

if (no_of_rows % 2): # for even no of row
print "<tr bgcolor=\"#dfdfdf\">" # if code is even, use such color for the cell
print "<td><input type=checkbox name=tick value=",form["attribute"].value=='d_id', "></td>"
i = 0
while i < 9:
print "<td>%s</td>" %row[i]
i += 1
else:
print "<td><input type=checkbox name=tick value=", form["attribute"].value=='d_id', "></td>"
i = 0
while i < 9:
print "<td>%s</td>" %row[i]
i += 1
no_of_rows += 1
print "</tr>"
print "</table>"

print "<div align = \"center\"><a href=\"http://localhost/Raulf/show_all.html\">Back</a>"
print "<input type=submit value=Submit>"
print "</form></body></html>"

my problem is :

1. how do i assign each checkbox to have equal value with the value of the d_id?

2. when the checkbox is clicked or check and when the submit button is pressed, how can i produce a new page showin me all the d_id of the check box that is clicked?

3. this is somethin like email function. when the checkbox is checked and delete button is pressed, how do i remove the checked files from my database?

4. finally if the checked box is checked and the download button is pressed, how do i download that particular file into the assignned folder, in this case assignned folder is C:\temp. If multiple box are checked, the file should be zipped and download in the assignned folder. how could i reach to this?

please assist me to this. i also will attach a snapshot.

Actually the codes above is a cgi for this codes:

<html>
<head>
<title>Source Downloader for LESS
</title>
<body>
<div align="left"><h1>Find record in LESS</h1></div>
<form method="POST" action="http://localhost/cgi-bin/Raulf/show_all.py">
<p>Select:
<select name ="attribute">
<option value="d_id">File ID</option>
<option value="filename">Filename</option>
<option value="extension">Extension</option>
<option value="size">Size(Bytes)</option>
<option value="url">Downloaded from</option>
<option value="location">Location in LESS</option>
<option value="md5">MD5</option>
<option value="SHA1">SHA1</option>
<option value="time_add">Date Entered</option>
</select>
<input type= text name="search">
<br>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</body>
</html>

very sorry. i'm extremely new to this and i have to complete this asap. can pls help me with the codes? thanks

Jan 15 '07 #1

Subscribe Post Reply

2988

ghostdog74

511

Expert 256MB

hi

can you put your code in "code" tags, not "quote" tags.
thanks

Jan 15 '07 #2

cuties

sorry abt tat error....

Expand|Select|Wrap|Line Numbers

 <html>

<head>

<title>Source Downloader for LESS

</title>

<body>

<div align="left"><h1>Find record in LESS</h1></div>

<form method="POST" action="http://localhost/cgi-bin/Raulf/show_all.py">

<p>Select:

<select name ="attribute">

<option value="d_id">File ID</option>

<option value="filename">Filename</option>

<option value="extension">Extension</option>

<option value="size">Size(Bytes)</option>

<option value="url">Downloaded from</option>

<option value="location">Location in LESS</option>

<option value="md5">MD5</option>

<option value="SHA1">SHA1</option>

<option value="time_add">Date Entered</option>

</select>

<input type= text name="search">

<br>

<input type="submit" value="Submit">

<input type="reset" value="Reset">

</body>

</html>

Expand|Select|Wrap|Line Numbers

 #!C:\python24\python.exe
 
####Code for viewing database....or search function#######
 
print 'Content-type: text/html\n\n'
 
import cgi # importing cgi module
 
import MySQLdb #importing MySQLdb module
 
form = cgi.FieldStorage() #assigning form to the cgi.FieldStorage
 
attribute = form.getvalue("attribute") #assigning attribute to get value from the function called attribute(drop down box) in the form
 
search = form.getvalue("search") #assigning search to get value from the function called search(textbox) in the form
 
conn =MySQLdb.connect(host = 'localhost', db='LESS', user ='root', passwd='') #creating conn to connect to MySQL
 
curs = conn.cursor() #creating a cursor called curs
 
curs.execute("use LESS") # exucuting the database
 
table = "download_file" #assignin table to download_file which is retrieved from MySql "less" under tables

#(download_file is a table name in less)
 
query = "select * from %s where %s like '%s'" %(table, attribute, search) #assigin query to MySQL command of select
 
#print query

curs.execute(query) #executing command set in the query function
 
count = curs.rowcount #indicating the cursor to count the rows

######## start of HTML code ##########

page= '''<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml

<head><title>View Database</title>
 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<link rel="stylesheet" href="http://localhost/Pictures/mm_travel2.css" type="text/css" />
 
<style type="text/css">

<!--

.style1 {font-family: Georgia}

.style2 {font-family: "Franklin Gothic Medium"}

.style3 {

font-family: "Franklin Gothic Medium";

font-weight: bold;

font-size: x-small;

font-style: italic;

}

.style4 {font-family: Georgia; font-size: 12px; }

.style5 {font-family: "Comic Sans MS"; font-weight: bold; font-size: large; color: #3300FF; }

.style6 {

font-size: large;

font-family: "Comic Sans MS";

font-style: italic;

font-weight: bold;

}

.style7 {font-size: large; font-family: "Comic Sans MS"; font-style: italic; color: #CC66CC; }

.style8 {font-family: "Times New Roman"; color: #000000; }

.style9 {

font-family: Arial;

font-weight: bold;

}

.style10 {

font-family: Roman;

font-size: 18px;

}

.style11 {color: #000000}

.style12 {

font-family: "Times New Roman";

font-style: italic;

}

.style13 {color: #000000; font-family: "Courier New"; }

.style14 {font-size: large; font-weight: bold; color: #006600; font-family: Verdana; }

.style15 {color: #006699;

font-weight: bold;

}

.style16 {color: #006699; font-weight: bold; font-size: 16px; }

-->

</style>
 
<script language="JavaScript" type="text/javascript">
 
var d=new Date();

var monthname=new Array("January","February","March","April","May","June","July","August","September","October","November","December");

var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();

</script>

</head>

<body bgcolor="#C0DFFD">

<span class="style15"><img src="http://localhost/Pictures/f-secure.JPG" alt="Header image" width="153" height="144" border="0" /></span>

<h1 align="center">

<script language="JavaScript1.2">

var message="LESS File Collection!"

var neonbasecolor="#99FF66"

var neontextcolor="#CC3399"

var flashspeed=100 //in milliseconds

var n=0

if (document.all||document.getElementById){

document.write('<font color="'+neonbasecolor+'">')

for (m=0;m<message.length;m++)

document.write('<span id="neonlight'+m+'">'+message.charAt(m)+'</span>')

document.write('</font>')

}

else

document.write(message)

function crossref(number){

var crossobj=document.all? eval("document.all.neonlight"+number) : document.getElementById("neonlight"+number)

return crossobj

}

function neon(){

if (n==0){

for (m=0;m<message.length;m++)

crossref(m).style.color=neonbasecolor

}

crossref(n).style.color=neontextcolor

if (n<message.length-1)

n++

else{

n=0

clearInterval(flashing)

setTimeout("beginneon()",1500)

return

}

}

function beginneon(){

if (document.all||document.getElementById)

flashing=setInterval("neon()",flashspeed)

}

beginneon()

</script>
 
<table width="104%" border="0" cellspacing="0" cellpadding="0">

<tr>

<td colspan="4" bgcolor="#003366"><img src="http://localhost/Pictures/spacer.gif" alt="" width="1" height="1" border="0" /></td>

</tr>
 
<tr bgcolor="#CCFF99">

<td>&nbsp;</td>

<td colspan="3" id="dateformat" height="25"><a href="LESS.html">HOME</a> ::<a href="Collection.html">Collection</a> ::<a href="Info.html">Info</a> ::<a href="Sources.html">Sources</a> :: <script language="JavaScript" type="text/javascript">

document.write(TODAY); </script> </td>

</tr>

<tr>

<td colspan="4" bgcolor="#003366"><img src="http://localhost/Pictures/spacer.gif" alt="" width="1" height="1" border="0" /></td>

</tr>

<tr>

<td width="4">&nbsp;</td>

<td colspan="2" valign="top"><p>&nbsp;</p>

<p>&nbsp;</p></td>

<td width="590">&nbsp; </td>

</tr>

</table>

'''

print page

print "<p><div align=\"center\"><h1>Search with %s Results</h1>" %count

print "<i>Searching for %s with %s</i> </div></p>" %(attribute, search)

print "<form method=post action=http://localhost/cgi-bin/Raulf/next.py>"

print "<table border = 1 cellpadding =0 cellspacing = 0>"

##### End of HTML code ######
 
###### start of Html and python code for the header of the search table #######

print "<tr bgcolor=\"#cccccc\">"

print "<td></td>"
 
h = 0 #setting the values of the attribute as zero
 
while h < 9: # total attribute is 0-8 so while h is less than 9

desc = curs.description[h]

print "<th>%s</th>" %desc[0]

h += 1 #increase the h value.

print "</tr>"

print "<p align=right><input type=submit value=Download>&nbsp; <input type=submit value=Delete></p>"
 
###### End of code #####
 
###### start of Html and python code for the result of the search table #######
 
no_of_rows = 0 #setting the number of rows as zero
 
while True: #using while for true
 
row = curs.fetchone() #asking cursor to fetch one data at a time for a row

if not row: break #saying if its not a row the break it.
 
if (no_of_rows % 2): # for even no of row

print "<tr bgcolor=\"#dfdfdf\">" # if code is even, use such color for the cell

print "<td><input type=checkbox name=tick value=",form["attribute"].value=='d_id', "></td>"

i = 0

while i < 9:

print "<td>%s</td>" %row[i]

i += 1

else:

print "<td><input type=checkbox name=tick value=", form["attribute"].value=='d_id', "></td>"

i = 0

while i < 9:

print "<td>%s</td>" %row[i]

i += 1

no_of_rows += 1

print "</tr>"

print "</table>"
 
print "<div align = \"center\"><a href=\"http://localhost/Raulf/show_all.html\">Back</a>"

print "<input type=submit value=Submit>"

print "</form></body></html>"

Jan 15 '07 #3

cuties

sorry for the error i caused. earlier i also said that i'll attach a snapshot but i'm not available to do it. anyway my question is something like how our email system works. Only extra tasks is der such as user can view results of all the checked output. for question no2 i did try writing a script but i jst don't get the results that i desire. here is the codes

Expand|Select|Wrap|Line Numbers

 
#!C:\python24\python.exe
 
print 'Content-type: text/html\n\n'
 
import cgi
 
import MySQLdb  
 
form = cgi.FieldStorage() 
 
tick = form.getvalue("tick")
 
attribute = form.getvalue("attribute") 
 
search = form.getvalue("search") 
 
conn =MySQLdb.connect(host = 'localhost', db='LESS', user ='root', passwd='') 
 
curs = conn.cursor() 
 
curs.execute("use LESS")  
 
page= '''<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml

<head><title>Results of Checked Output</title>
 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<link rel="stylesheet" href="http://localhost/Pictures/mm_travel2.css" type="text/css" />
 
<style type="text/css">

<!--

.style1 {font-family: Georgia}

.style2 {font-family: "Franklin Gothic Medium"}

.style3 {

    font-family: "Franklin Gothic Medium";

    font-weight: bold;

    font-size: x-small;

    font-style: italic;

}

.style4 {font-family: Georgia; font-size: 12px; }

.style5 {font-family: "Comic Sans MS"; font-weight: bold; font-size: large; color: #3300FF; }

.style6 {

    font-size: large;

    font-family: "Comic Sans MS";

    font-style: italic;

    font-weight: bold;

}

.style7 {font-size: large; font-family: "Comic Sans MS"; font-style: italic; color: #CC66CC; }

.style8 {font-family: "Times New Roman"; color: #000000; }

.style9 {

    font-family: Arial;

    font-weight: bold;

}

.style10 {

    font-family: Roman;

    font-size: 18px;

}

.style11 {color: #000000}

.style12 {

    font-family: "Times New Roman";

    font-style: italic;

}

.style13 {color: #000000; font-family: "Courier New"; }

.style14 {font-size: large; font-weight: bold; color: #006600; font-family: Verdana; }

.style15 {color: #006699;

    font-weight: bold;

}

.style16 {color: #006699; font-weight: bold; font-size: 16px; }

-->

</style>
 
<script language="JavaScript" type="text/javascript">
 
var d=new Date();

var monthname=new Array("January","February","March","April","May","June","July","August","September","October","November","December");

var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();

</script>

</head>

<body bgcolor="#C0DFFD">

<span class="style15"><img src="http://localhost/Pictures/f-secure.JPG" alt="Header image" width="153" height="144" border="0" /></span>

<h1 align="center">

<script language="JavaScript1.2">

var message="LESS File Collection!"

var neonbasecolor="#99FF66"

var neontextcolor="#CC3399"

var flashspeed=100  //in milliseconds

var n=0

if (document.all||document.getElementById){

document.write('<font color="'+neonbasecolor+'">')

for (m=0;m<message.length;m++)

document.write('<span id="neonlight'+m+'">'+message.charAt(m)+'</span>')

document.write('</font>')

}

else

document.write(message)

function crossref(number){

var crossobj=document.all? eval("document.all.neonlight"+number) : document.getElementById("neonlight"+number)

return crossobj

}

function neon(){

if (n==0){

for (m=0;m<message.length;m++)

crossref(m).style.color=neonbasecolor

}

crossref(n).style.color=neontextcolor

if (n<message.length-1)

n++

else{

n=0

clearInterval(flashing)

setTimeout("beginneon()",1500)

return

}

}

function beginneon(){

if (document.all||document.getElementById)

flashing=setInterval("neon()",flashspeed)

}

beginneon()

</script>
 
<table width="104%" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td colspan="4" bgcolor="#003366"><img src="http://localhost/Pictures/spacer.gif" alt="" width="1" height="1" border="0" /></td>

  </tr>
 
  <tr bgcolor="#CCFF99">

      <td>&nbsp;</td>

      <td colspan="3" id="dateformat" height="25"><a href="LESS.html">HOME</a> ::<a href="Collection.html">Collection</a> ::<a href="Info.html">Info</a> ::<a href="Sources.html">Sources</a> :: <script language="JavaScript" type="text/javascript">

      document.write(TODAY);    </script>    </td>

  </tr>

 <tr>

    <td colspan="4" bgcolor="#003366"><img src="http://localhost/Pictures/spacer.gif" alt="" width="1" height="1" border="0" /></td>

  </tr>

 <tr>

    <td width="4">&nbsp;</td>

    <td colspan="2" valign="top"><p>&nbsp;</p>

    <p>&nbsp;</p></td>

      <td width="590">&nbsp; </td>

  </tr>

</table>

'''

print page
 
if tick == True:

    print "The d_id", form["tick"].value, "is checked" 

else: 

    print "Nothing is ticked"
 
print "</body></html>"

Jan 15 '07 #4

Help with CGI functions on python.

Similar topics