aboutsummaryrefslogtreecommitdiff
path: root/www/html/affiche-tas.py
diff options
context:
space:
mode:
Diffstat (limited to 'www/html/affiche-tas.py')
-rw-r--r--www/html/affiche-tas.py38
1 files changed, 38 insertions, 0 deletions
diff --git a/www/html/affiche-tas.py b/www/html/affiche-tas.py
new file mode 100644
index 0000000..726bed4
--- /dev/null
+++ b/www/html/affiche-tas.py
@@ -0,0 +1,38 @@
+#!/usr/bin/python3
+# -*- coding: utf-8 -*-
+
+import mod_python
+from fonctions import baseHTML, connexionBD, lien
+
+def index(req):
+ req.content_type="text/html"
+ content=str()
+
+ conn=connexionBD()
+ cur=conn.cursor()
+
+ sql="SELECT * FROM paquet ORDER BY heure DESC;"
+
+ cur.execute(sql)
+ conn.commit()
+ data=cur.fetchall()
+
+ conn.close()
+
+ for i in data:
+ content+=("""<tr>""" +
+"""<td>""" + str(i[1]) + """</td>""" +
+"""<td>""" + str(i[2]) + """</td>""" +
+"""<td>""" + str(i[3]) + """</td>""" +
+"""<td>""" + lien('destination.py?ip=' + str(i[4]), str(i[4])) + """</td>""" +
+"""<td>""" + str(i[5]) + """</td>""" +
+"""<td>""" + str(i[6]) + """</td>""" +
+"""</tr>""")
+
+ req.write("""
+<table class="data_tab">
+<tr><th>Heure</th><th>Protocole</th><th>IP Source</th><th>IP Destination</th><th>Port Source</th><th>Port Destination</th></tr>
+"""
++ content +
+"""
+</table>""")