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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
#! /usr/bin/python
# -*- coding: latin1 -*-
import MySQLdb, cgi, urllib
from user import User
from online import Online
class Connexion:
bdd = MySQLdb.connect(host='localhost', user='root', passwd='', db='amazon') # Connexion à la base de données amazon
cursor = bdd.cursor()
def addUser(pseudo, password, age, genre, occupation, zip_code):
""
cursor.execute("select * from user")
valeurs = cursor.fetchall()
test = 1
for v in valeurs:
if(pseudo == v[1]):
test = 0
user_id = v[0]
if(test):
cursor.execute("insert into people values('', %s, %s, %s, %s)", (age, genre, occupation, zip_code))
cursor.execute("select max(user_id) from people")
valeurs = cursor.fetchone()
user_id = valeurs[0]
user = User(pseudo, password, user_id, age, genre, occupation, zip_code)
cursor.execute("insert into user values(%s, %s, %s)", (user_id, pseudo, password))
else:
print "Erreur, Votre pseudo est déjà utilisé, veuillez en utiliser un autre"
def connexion(pseudo, password):
""
cursor.execute("select * from user")
valeurs = cursor.fetchall()
test = 0
for v in valeurs:
if(pseudo == v[1] and password == v[2]):
user_id = v[0]
cursor.execute("select * from people where user_id = %s",(user_id))
val= cursor.fetchone()
user = User(pseudo, password, val[0], val[1], val[2], val[3], val[4])
online = Online(user)
test = 1
if(test):
print "Bienvenue", pseudo
else:
print "Pseudo et/ou mot de passe incorrect"
def disConnexion(self):
""
print "Content-Type: text/html \n"
form = cgi.FieldStorage()
if(form.has_key("connexion")):
if(form.has_key("user_name") and form.has_key("user_password")):
pseudo = form["user_name"].value
password = form["user_password"].value
connexion(pseudo, password)
else:
print "Tous les champs n'ont pas été remplis"
if(form.has_key("inscription")):
if(form.has_key("user_name") and form.has_key("user_password") and form.has_key("user_password_bis") and form.has_key("age") and form.has_key("genre") and form.has_key("occupation") and form.has_key("zip_code")):
if(form["user_password"].value == form["user_password_bis"].value):
addUser(form["user_name"].value, form["user_password"].value, form["age"].value, form["genre"].value, form["occupation"].value, form["zip_code"].value)
else:
print "Vos mots de passe ne sont pas identiques!"
else:
print "Tous les champs n'ont pas été remplis" |
