API tools faq
paste
View difference between Paste ID: FcgP7fQB and YUapAfaU
SHOW: | | - or go back to the newest paste.
1-
[Mon Dec 05 19:43:27.906232 2016] [cgi:error] [pid 1643] [client 10.0.1.10:63665] AH01215:   File "/var/www/html/8279/scripts/Form.py", line 52, referer: http://10.0.1.13/html/8279/HTML%20Form.html
1+
#!/usr/bin/python
2-
[Mon Dec 05 19:43:27.906517 2016] [cgi:error] [pid 1643] [client 10.0.1.10:63665] AH01215:     int(xGrade) = Graderow[2], referer: http://10.0.1.13/html/8279/HTML%20Form.html
2+
# Import modules for CGI handling
3-
[Mon Dec 05 19:43:27.906632 2016] [cgi:error] [pid 1643] [client 10.0.1.10:63665] AH01215: SyntaxError: can't assign to function call, referer: http://10.0.1.13/html/8279/HTML%20Form.html
3+
4-
[Mon Dec 05 19:43:27.913281 2016] [cgi:error] [pid 1643] [client 10.0.1.10:63665] End of script output before headers: Form.py, referer: http://10.0.1.13/html/8279/HTML%20Form.html

4+
import cgi, cgitb

5-
[Mon Dec 05 19:43:30.426618 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215:   File ", referer: http://10.0.1.13/html/8279/HTML%20Form.html

5+
import sqlite3

6-
[Mon Dec 05 19:43:30.427011 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215: /var/www/html/8279/scripts/Form.py, referer: http://10.0.1.13/html/8279/HTML%20Form.html

6+
conn = sqlite3.connect('../databases/StudentForms.db')

7-
[Mon Dec 05 19:43:30.427184 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215: ", line , referer: http://10.0.1.13/html/8279/HTML%20Form.html

7+
c = conn.cursor()

8-
[Mon Dec 05 19:43:30.427339 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215: 52, referer: http://10.0.1.13/html/8279/HTML%20Form.html

8+
9-
[Mon Dec 05 19:43:30.427474 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215: , referer: http://10.0.1.13/html/8279/HTML%20Form.html

9+
# Create instance of FieldStorage

10-
[Mon Dec 05 19:43:30.427615 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215:     , referer: http://10.0.1.13/html/8279/HTML%20Form.html

10+
form = cgi.FieldStorage()

11-
[Mon Dec 05 19:43:30.427801 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215: int(xGrade) = Graderow[2], referer: http://10.0.1.13/html/8279/HTML%20Form.html

11+
12-
[Mon Dec 05 19:43:30.427978 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215: SyntaxError, referer: http://10.0.1.13/html/8279/HTML%20Form.html

12+
# Get data from fields

13-
[Mon Dec 05 19:43:30.428119 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215: : , referer: http://10.0.1.13/html/8279/HTML%20Form.html

13+
first_name = form.getvalue("firstName")

14-
[Mon Dec 05 19:43:30.428399 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215: can't assign to function call, referer: http://10.0.1.13/html/8279/HTML%20Form.html

14+
last_name  = form.getvalue("lastName")

15-
[Mon Dec 05 19:43:30.428536 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] AH01215: , referer: http://10.0.1.13/html/8279/HTML%20Form.html

15+
courses = form.getvalue("courses")

16-
[Mon Dec 05 19:43:30.440609 2016] [cgi:error] [pid 1220] [client 10.0.1.10:63666] End of script output before headers: Form.py, referer: http://10.0.1.13/html/8279/HTML%20Form.html
16+
work_type = form.getvalue("worktype")

17
grade = form.getvalue("grade")

18
19
fullName = first_name + ' ' + last_name

20
21
# Insert user 1

22
c.execute ('INSERT INTO Work(WorkType, Grade) VALUES(?,?)', (work_type , grade))

23
workTypeID = c.lastrowid

24
c.execute ('INSERT INTO Course(Name) VALUES(?)', [courses])

25
courseID = c.lastrowid

26
c.execute ('INSERT INTO Students(Name, Work_WorkID, Course_CourseID) VALUES(?, ?, ?)', (fullName, workTypeID, courseID))

27
28
# Save (commit) the changes

29
conn.commit()

30
31
print "Content-type:text/html\r\n\r\n"%>

32
<html>

33
<head>

34
<title>Student Database</title>

35
<link rel='Stylesheet' href='css/style.css'>

36
</head>

37
<body><%

38
print "<h1>Student Database</h1>"

39
c.execute("SELECT * FROM Students")

40
rows = c.fetchall()

41
for row in rows:

42
	print row[1]

43
	CourseID = row[2]

44
	WorkID = row[3]

45
	studentName = row[1]

46
	c.execute("select Name FROM Course where CourseID = " + str(CourseID))

47
	courseName = c.fetchall()

48
	print "%s" % (courseName[0])

49
	

50
	c.execute("select * FROM Work where WorkID = " + str(WorkID))

51
	Graderow = c.fetchone()

52
	int(xGrade) = Graderow[2]

53
	nGrade = lettGrade(xGrade)

54
	print str(Graderow[1]) + " , " + str(Graderow[2]) 

55
	print nGrade

56
	print "</br>"

57
print "<body>"%>

58
</br> <%

59
print "<a href='HTML Form.html'> <input type='Submit' value='Add Another Student' name='submitBtn'> </a>"

60
61
# We can also close the connection if we are done with it.

62
# Just be sure any changes have been committed or they will be lost.

63
conn.close()
        

    


            


                                


        

            



                
    

        Public Pastes
    

    
            

    

                    

        

    





    


    
    
    
    
    
    
    
    




    


    



                

            We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.             OK, I Understand
        

    
                

            

                
                    
                
            

            

                Not a member of Pastebin yet?

                Sign Up, it unlocks many cool features!