Python Return value from HTML select to python app

[Ramone]

Hi
I need some help with getting the chosenclass value from my HTML select into my python flask SQLAlchemy data query. I'm not sure what to put in the form action to make it return the chosenclass value to app.py.
Your expertise would be appreciated. Thanks!

<form action="." method="POST">
    <select name="chosenclass" id="chosenclass">
        <option value="107i am">107i am</option>
        <option value="107i pm">107i pm</option>
        </select><br>
        <input type="submit" value="Submit">
</form>

@app.route('/', methods = ["GET", "POST"])

def Index():
    all_data = Data.query.filter_by(classroom=chosenclass).all()
    return render_template("index.html", students = all_data)

 

[Malcolm]

Hi there, Welcome to Code Forum!

I'm not really familiar with this, however, I believe @Ghost or @Krusty the Senile might be of help.

Try changing the form action value to point towards your python file (app.py). So once the form is submitted it will send the data to that file.

 

[Ramone]

Thanks for your response. I tried redirecting it to app.py but no luck yet.

 

[Malcolm]

Thanks for your response. I tried redirecting it to app.py but no luck yet.

dang. I’ll keep looking for an answer!

 

[Ramone]

dang. I’ll keep looking for an answer!

Thanks Malcolm

 

[Ramone]

I did it! Yeah, it's beer O'clock! Thanks for your help Malcolm! I might be back for more help later. I hope this snippet helps others.

[CODE lang="python" title="app.py"]@app.route('/' , methods = ["GET", "POST"])
def Index():
chosenclass = request.form.get('chosenclass')
all_data = Data.query.filter_by(classroom=chosenclass).all()
return render_template("index.html", students = all_data)
[/CODE]
[CODE lang="html" title="Index.html"]<form action="." method="POST">
<select name="chosenclass" id="chosenclass">
<option value="107i am">107i am</option>
<option value="107i pm">107i pm</option>
</select><br>
<input type="submit" value="Submit">
</form>[/CODE]

 

[Malcolm]

Hi there!

I’m glad you found a solution to this! Could you explain how you fixed it?

 

[Ramone]

Hi Malcolm. Sure, no problem. I dug deeper on https://docs.sqlalchemy.org/ and stackoverflow and found that to gain access to the chosenclass variable in the html file, I just needed to add the line
chosenclass = request.form.get('chosenclass') to the python def Index():

Someone on stackoverflow had posted...

If you want to retrieve POST data:
first_name = request.form.get("firstname")

If you want to retrieve GET (query string) data:
first_name = request.args.get("firstname")

Or if you don't care/know whether the value is in the query string or in the post data:
first_name = request.values.get("firstname")

I don't like to post on stackoverflow as I have found them to be unfriendly to a noob like me.
I also need to add a checkbox to the index.html with the am pm values that I'll call chooseampm. I expect that'll work something like

@app.route('/' , methods = ["GET", "POST"])
def Index():
chosenclass = request.form.get('chosenclass')
chooseampm = request.form.get('chooseampm')
all_data = Data.query.filter_by(classroom=chosenclass, chooseampm).all()
return render_template("index.html", students = all_data)

I'm not sure yet as it's early morning here in Cambodia.

I'm not quite finished yet as after the comment is added in a separate form, it returns an empty class. I'll try to fix that or keep things on one form and add a select option to every row. If I get stuck, which I probably will. I'll create another thread for that.

Thanks again and I hope my explanation benefits someone.
Ramone

 

[Malcolm]

Awesome! Thank you so much! I have marked it as solution for you 🙂