I can not bring mysql information in form with flask

0

Hello everyone my question is because I can not bring information from the mysql database .. I have a form in html I am using flask and I put a value in the input and by pressing "enter"  I need you to fill in the other controls with the related data

this is the code in html

 <div class="body">
                        <form  method="post" action="/consultamovil">
                            <div class="row clearfix">

                                 <div class="col-md-6">
                                            <div class="form-horizontal">
                                                <label class="control-label">Patente</label>
                                                <input  type="text" class="form-control" placeholder="Ingrese Patente del móvil" name = "patente">
                                                </div>
                                        </div>
                                        <!--/span-->
                                        <div class="col-md-6">
                                            <div class="form-horizontal">
                                                <label class="control-label">Area</label>
                                                <input  type="text"  class="form-control form-control-danger" placeholder="Area Responsable" name= "area" >
                                                </small> </div>
                                        </div>
                                        <!--/span-->

                                         <!--/span-->
                                        <div class="col-md-6">
                                            <div class="form-horizontal">
                                                <label class="control-label">Interno</label>
                                                <input  type="text"  class="form-control form-control-danger" placeholder="Interno" name="interno" >
                                                </small> </div>
                                        </div>
                                        <!--/span-->

                                         <!--/span-->
                                        <div class="col-md-6">
                                            <div class="form-horizontal">
                                                <label class="control-label">Marca</label>
                                                <input  type="text" id="Marca" class="form-control form-control-danger" placeholder="Marca movil" name="marca" >
                                                </small> </div>
                                        </div>
                                        <!--/span-->


                                        <div class="col-md-6">
                                            <div class="form horizontal">
                                                <label class="control-label">Fecha desde:</label>

                                                    <input name= "Fechadesde" type="date" id="Fecha1" class="form-control" placeholder="dd/mm/yyyy">
                                                    </small> </div>


                                        </div>

                                         <div class="col-md-6">
                                            <div class="form horizontal">
                                                <label class="control-label">Fecha hasta:</label>

                                                    <input name= "Fechahasta "type="date" id="Fecha2" class="form-control" placeholder="dd/mm/yyyy">
                                                    </small> </div>


                                        </div>  

this is the code in python

from flask import Flask, render_template, request
from flask_bootstrap import Bootstrap
from flaskext.mysql import MySQL
from flask_admin import Admin
from flask_admin.contrib.sqla import ModelView
import MySQLdb



app = Flask(__name__)
mysql = MySQL()

# MySQL configurations
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = ''
app.config['MYSQL_DATABASE_DB'] = 'movedb'
app.config['MYSQL_DATABASE_HOST'] = 'localhost'
mysql.init_app(app)
Bootstrap(app)
conn = mysql.connect()

    @app.route('/consultamovil.html', methods=["GET","POST"])
def consultamovil():
    db = mysql.connect(host="localhost",user="root",passwd="",db="movedb")


    cursor = db.cursor()
    varpatente= request.form["patente"]
    varinterno= request.form["interno"]
    varmarca= request.form["marca"]
    vararea= request.form["area"]

    query = "SELECT  moviles.Marca,  moviles.Interno, areas.Area_Responsable FROM moviles, areas where moviles.Id_Area=areas.Id_Area and moviles.Patente= '%s' " % varpatente
    cursor.execute(query)
    var = cursor.fetchone()
    if var != None:
        for (Marca, Interno, Area_Responsable) in cursor:
             varmarca= Marca
             varinterno = Interno
             vararea= Area_Responsable
             return render_template('consultamovil.html', marca=varmarca, interno=varinterno, area=vararea)

thanks

    
asked by Julio 29.05.2018 в 14:39
source

0 answers