Guest User

Untitled

a guest
Oct 31st, 2017
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. def check_user_db(self, getFrom):
  2. #mysql
  3. check_cnx = mysql.connector.connect(user='root', password='root',
  4. host='127.0.0.1', port='8889',
  5. database='test')
  6. check_cursor = check_cnx.cursor()
  7. check_chat =("SELECT number, lang FROM user WHERE number = %s")
  8. #("SELECT number, lang from user where "
  9. #"number ='(%s)'")
  10.  
  11. check_cursor.execute(check_chat, (getFrom))
  12.  
  13. for (number) in check_cursor:
  14. file = open("logFile.txt","a")
  15. file.write("\n" + number)
  16. file.close()
  17. # Make sure data is committed to the database
  18. check_cnx.commit()
  19. check_cursor.close()
  20. check_cnx.close()
Add Comment
Please, Sign In to add comment