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" |
Partager