Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- def vypis_zaky(mydb, razeni):
- mycursor = mydb.cursor()
- mycursor.execute("SELECT * FROM zaci ORDER BY " + razeni +";")
- myresult = mycursor.fetchall()
- for x in myresult:
- print(x[1], x[2])
- def prihlas(uzivatel, heslo):
- global mydb
- mycursor = mydb.cursor()
- mycursor.execute("SELECT id FROM zaci WHERE jmeno ='%s' and heslo = '%s';"
- % (uzivatel, heslo))
- myresult = mycursor.fetchone()
- if myresult is not None:
- print("ok")
- else:
- print("chyba")
- try:
- mydb = mysql.connector.connect(
- host = "studenti.odbornaskola.cz",
- user = "u319",
- password = "22a44e",
- database = "u319",
- port = "3306"
- )
- except mysql.connector.Error:
- print("Připojení se nepodařilo")
- vypis_zaky(mydb,"jmeno")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement