====== Templates ====== **base.html** template:-





  
    
      {% block header %}
      {% endblock %}
      
    
  

  
    
    {% block content %}
    {% endblock %}

===== Passing a dictionary into a template ===== ==== Python ==== Flask needs to return a template and the name of any dictionaries used.


from flask import make_response, render_template, request

    headers = {'title': 'Login Page'}
    result = {'username': username}
    return render_template('output.html', headers=headers, result=result)

==== output.html ====


{% extends "base.html" %}

{% block header %}
{{ headers['title'] }}
{% endblock %}


{% block content %}
    Data Result

    
     Data returned
     
       Username {{ result['username'] }}
     
    
{% endblock %}

===== Setting Cookies ===== See 'status':-


        loginresult = {'username': username, 'known_as': known_as, 'expiry': cookie_expiry}
        response = make_response(render_template(
            'loginoutput.html', loginresult=loginresult, headers=headers)
        )

        response.set_cookie('status', 'not_known')
        return response

===== MySQL connector ===== Also works with MariaDB ==== Boolean ==== Get boolean true/false back, db stores 1 or 0


statement = "SELECT IF(login_status, 'true', 'false') from user_model WHERE user_id = %s;"

session_name = session["username"]
mycursor.execute(statement, (session_name,))