CAS Community   >   Resources   >  

Python SQL login/ Signup system

Using a SQL select query in python to identify users

Chris Hall

Created by Chris Hall
last edited Feb 07 2018 by Chris Hall

The point of this resource was to show students how the syntax of an SQL SELECT query varies from the other SQL queries in python when you want to use the WHERE condition (without the annoying ‘must be string’ error). This resource should be used in conjunction with my earlier SQL python resources - but will work as a standalone.

If you do use it with the menu system, you will want to make sure you include the following lines when either login or signup is successful:

global loop
loop = True
Downloaded 2987 times.


This resource has attached files: to access these files, please tick the box below to assent to the license terms
License: The resources on CAS website are under Creative Commons Attribution-Share Alike 3.0 licence unless otherwise specified by the resource creators.

You must confirm that you have read and agree the licence's ToS before you can download the attachments of this resource.

I have read the licence agreement of this resource and agree to abide by its terms and conditions.

Feedback and Comments

Available when logged in (join via the front page, for free):
  • View 0 comments on this resource.
  • View resource history, links to related resources.
  • Leave feedback for the author(s), or help by editing the resource.