[Flask] Passing MySQL values to different webpages

[Anthony Ford]

Hey Stephen,

You would use the `request.args` MultiDict. It works in the same manner as
`request.form`, but accesses the values in the query string.

In your example, you could access the value of your argument via
`request.args.get('myVar1')`. It is also a MultiDict
<http://werkzeug.pocoo.org/docs/0.11/datastructures/#werkzeug.datastructures.MultiDict>,
so you can do things like fetch all the keys with `.keys()`, or use
`.getlist('foo')`.

For more info, see the Quickstart (Request Object
<http://flask.pocoo.org/docs/0.10/quickstart/#the-request-object>). A short
example is seen in the last 1/3 of that section.

Anthony Ford,
KF5IBN,
ford.anthonyj at gmail.com

On Fri, Mar 11, 2016 at 3:23 PM, Mazzei, Stephen Andrew <
Stephen.Mazzei at asrcfederal.com> wrote:

> Maybe you can answer this, (being completely new to flask/html/etc) the
> session helped pass variables through the flask program inside the python
> scripts. How can I pass variables from the html template? Would that be
> more the method you originally sent?
>
>
>
> I am trying to build a basic template that can be reused depending on what
> http link was clicked from the previous page.
>
>
>
> Example:
>
>
>
> Page 1
>
> “link to apple”
>
> “link to orange”
>
>
>
> Page 2
>
>                 You chose (VARIABLE)
>
>
>
> Looking online it looks like I could do
>
>
>
> Page 1
>
> <a href='template.html?myVar1=apple'>Apple</a>
>
> <a href='template.html?myVar1=apple'>Orange</a>
>
>
>
> Page 2
>
>                 You chose (myVar1) è You chose Apple
>
>
>
> Not sure on the python/flask side how to capture the ?myVar1?
>
>
>
>
>
> ---
>
> Stephen A. Mazzei
>
> Systems Administrator | AFDS, ASRC Federal Data Solutions - P&G HPC
> Account | 513-634-9965
>
>
>
> *From:* Brian Kim [mailto:bk at breadtech.com]
> *Sent:* Friday, March 11, 2016 2:16 PM
>
> *To:* Mazzei, Stephen Andrew <Stephen.Mazzei at asrcfederal.com>
> *Cc:* flask at python.org
> *Subject:* Re: [Flask] Passing MySQL values to different webpages
>
>
>
> Nice! Using a session variable is definitely a better solution than what I
> was suggesting.
>
>
> On Mar 11, 2016, at 1:52 PM, Mazzei, Stephen Andrew <
> Stephen.Mazzei at asrcfederal.com> wrote:
>
> Thanks Brian, but I was able to do this using Flask/session.
>
>
>
> @app.route(‘/page1’)
>
> def page1():
>
>     session[‘var1’] = “Some value”
>
>     return redirect(url_for(app.page2))
>
>
>
> @app.route(‘/page2’)
>
> def page2():
>
>     return render_template(“template.html”, value2=session.get('val1',
> None))
>
>
>
>
>
> ---
>
> Stephen A. Mazzei
>
> Systems Administrator | AFDS, ASRC Federal Data Solutions - P&G HPC
> Account | 513-634-9965
>
>
>
> *From:* Brian Kim [mailto:bk at breadtech.com <bk at breadtech.com>]
> *Sent:* Friday, March 11, 2016 11:36 AM
> *To:* Mazzei, Stephen Andrew <Stephen.Mazzei at asrcfederal.com>
> *Cc:* flask at python.org
> *Subject:* Re: [Flask] Passing MySQL values to different webpages
>
>
>
> Hi Stephen,
>
>
>
> I believe that the best way to solve your problem will be to pass the data
> from page1 into page2 through the URI via GET request. In order to
> dynamically set the values, you will probably need to use Javascript. For
> example (with JQuery for syntactic convenience...)
>
>
>
> mypage1.html:
>
> <button id="go">Go to Page 2</button>
>
> <script>
>
>   $("#go").click( function() {
>
>      target = "/mypage2?" + "key1=" + mydata[0] + "&key2=" + mydata[1]; //
> build the URI
>
>      location.href = target; // redirect the page to that URL
>
>    }
>
> </script>
>
>
>
> myapp.py:
>
> @app.route("/mypage2")
>
> def mypage2():
>
>   data1 = request.args.get("key1")
>
>   data2 = request.args.get("key2")
>
>   return render_template("mypage2.html", key1=data1, key2=data2)
>
>
>
> This isn't a complete by any means but hopefully gives enough to get you
> started... Let me know if you would like a better example and I'll try to
> put something up on github for you.
>
>
>
> BK
>
>
>
> On Fri, Mar 11, 2016 at 10:30 AM, Mazzei, Stephen Andrew <
> Stephen.Mazzei at asrcfederal.com> wrote:
>
> Good morning,
>
>
>
> I am looking for help on a MySQL issue. I am currently running an query
> over a database and populating a table. The table contains items group
> units and then their values. I currently have the group unit as a link to
> that units own webpage.
>
>
>
> On this webpage I would like to repost the same table information, per the
> unit, and then some additional information. How can I pass the query from
> the previous webpage to the next page without having to re-run the same
> query over and over again.
>
>
>
> Thank you
>
>
>
>
>
> ---
>
> Stephen A. Mazzei
>
> Systems Administrator | AFDS, ASRC Federal Data Solutions - P&G HPC
> Account | 513-634-9965
>
>
>
>
> ------------------------------
>
>
> The preceding message (including attachments) is covered by the Electronic
> Communication Privacy Act, 18 U.S.C. sections 2510-2512, is intended only
> for the person or entity to which it is addressed, and may contain
> information that is confidential, protected by attorney-client or other
> privilege, or otherwise protected from disclosure by law. If you are not
> the intended recipient, you are hereby notified that any retention,
> dissemination, distribution, or copying of this communication is strictly
> prohibited. Please reply to the sender that you have received the message
> in error and destroy the original message and all copies.
>
>
> _______________________________________________
> Flask mailing list
> Flask at python.org
> https://mail.python.org/mailman/listinfo/flask
>
>
>
>
> ------------------------------
>
>
> The preceding message (including attachments) is covered by the Electronic
> Communication Privacy Act, 18 U.S.C. sections 2510-2512, is intended only
> for the person or entity to which it is addressed, and may contain
> information that is confidential, protected by attorney-client or other
> privilege, or otherwise protected from disclosure by law. If you are not
> the intended recipient, you are hereby notified that any retention,
> dissemination, distribution, or copying of this communication is strictly
> prohibited. Please reply to the sender that you have received the message
> in error and destroy the original message and all copies.
>
>
> ------------------------------
>
> The preceding message (including attachments) is covered by the Electronic
> Communication Privacy Act, 18 U.S.C. sections 2510-2512, is intended only
> for the person or entity to which it is addressed, and may contain
> information that is confidential, protected by attorney-client or other
> privilege, or otherwise protected from disclosure by law. If you are not
> the intended recipient, you are hereby notified that any retention,
> dissemination, distribution, or copying of this communication is strictly
> prohibited. Please reply to the sender that you have received the message
> in error and destroy the original message and all copies.
>
> _______________________________________________
> Flask mailing list
> Flask at python.org
> https://mail.python.org/mailman/listinfo/flask
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/flask/attachments/20160311/f22e836c/attachment-0001.html>