Timeline for pset7 finance register where and how to write sql
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 2, 2018 at 22:54 | vote | accept | Joel Banks | ||
| Jan 31, 2018 at 8:34 | comment | added | Blauelf |
Forgot that we are doing the password check ourselves. Just take that SELECT statement from the login function, and if len(rows) != 0: return apology("Name already taken")
|
|
| Jan 30, 2018 at 20:45 | comment | added | Joel Banks | So I guess my question is, where do I write the SQL code so that when I click register, it runs my SQL. I see the sql in the database but it doesn't look like it would run on a button press like register, which is what I need help with | |
| Jan 30, 2018 at 5:52 | comment | added | Blauelf | For the first select statement, copy the select from login and remove the password/hash part, keeping the name comparison. If the result is non-empty, the name is in use. | |
| Jan 29, 2018 at 22:35 | comment | added | Joel Banks | I have the code that checks to make sure they aren't blank and that they match. I do not have any sql yet because I do not understand where I need to write it. That is the part I am stuck on, I do not understand where to write sql. Thanks | |
| Jan 29, 2018 at 8:47 | comment | added | Blauelf |
What do you have? Checked the POST variables username, password, and confirmation? Do you have the SQL statement to check for an existing account with same username? Your question gives little context. Also, make sure you're familiar with your table layout, with the names and types of the fields.
|
|
| Jan 29, 2018 at 1:25 | comment | added | Joel Banks | This is very helpful, but the part I'm really stuck on is where I need to write the sql so it adds/checks for a user after registering. Thanks | |
| Jan 28, 2018 at 18:44 | history | answered | Blauelf | CC BY-SA 3.0 |