1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
import socket # Import socket module
import time
import MySQLdb
print 'On commence:'
conn = MySQLdb.Connect(host="127.0.0.1",user="gps",passwd="mdp",db="gps")
cursor = conn.cursor()
s = socket.socket()
host = socket.gethostname()
port = 13242
s.bind((host, port))
s.listen(5)
while True:
c, addr = s.accept()
RequeteDuClient = c.recv(1000)
timetrame = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
print 'Date: ', timetrame, '\nIP: ', addr, '\nTrame: ', RequeteDuClient
ip_port = str(addr)
trame = str(RequeteDuClient)
# client=(ip_port, timetrame, trame)
# print client, "\n"
sqlvar = 'Insert into gps Values(?, ?, ?)'
# sqlvar = ('Insert into gps(info, datetime, texte) Values(%s, %s, %s)')
cursor.execute(sqlvar, (ip_port, timetrame, trame))
c.close() |
Partager