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