Učitajte sadržaj dinamički u Bootstrap modal s Jquery AJAX -om i Python Flask PostgreSQL -om

Isprobajte Naš Instrument Za Uklanjanje Problema

Učitajte sadržaj dinamički u Bootstrap modal s Jquery AJAX -om i Python Flask PostgreSQL -om

Pretplatite se: https://www.youtube.com/c/Cairocoders/featured

instalirajte psycopg2 https://pypi.org/project/psycopg2/
Psycopg je najpopularniji adapter baze podataka PostgreSQL za programski jezik Python.
(venv) PS C: flaskmyproject> pip install psycopg2

Izvorni kod

app.py

pitanje za intervju za zatvaranje javascripta
#app.py from flask import Flask, render_template, request, jsonify import psycopg2 #pip install psycopg2 import psycopg2.extras app = Flask(__name__) app.secret_key = 'caircocoders-ednalan' DB_HOST = 'localhost' DB_NAME = 'sampledb' DB_USER = 'postgres' DB_PASS = 'admin' conn = psycopg2.connect(dbname=DB_NAME, user=DB_USER, password=DB_PASS, host=DB_HOST) @app.route('/') def index(): cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor) cur.execute('SELECT * FROM employee ORDER BY id ASC') employee = cur.fetchall() return render_template('index.html', employee = employee) @app.route('/ajaxfile',methods=['POST','GET']) def ajaxfile(): cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor) if request.method == 'POST': userid = request.form['userid'] print(userid) cur.execute('SELECT * FROM employee WHERE id = %s', [userid]) employeelist = cur.fetchall() return jsonify({'htmlresponse': render_template('response.html',employeelist=employeelist)}) if __name__ == '__main__': app.run(debug=True)

predlošci/indeks.html

//templates/index.html Load content Dynamically in Bootstrap Modal with Jquery AJAX and Python Flask PostgreSQL

Load content Dynamically in Bootstrap Modal with Jquery AJAX and Python Flask PostgreSQL

{% for row in employee %} {% endfor %}
Photo Name Position Office Age Salary View
{{row.name}} {{row.position}} {{row.office}} {{row.age}} {{row.salary}} Info
$(document).ready(function(){ $('.userinfo').click(function(){ var userid = $(this).data('id'); $.ajax({ url: '/ajaxfile', type: 'post', data: {userid: userid}, success: function(data){ $('.modal-body').html(data); $('.modal-body').append(data.htmlresponse); $('#empModal').modal('show'); } }); }); });

User Info

× Close

predlošci/odgovor.html

//templates/response.html {% for row in employeelist %}

Name : {{row.name}}

angularjs node js vodič

Position : {{row.position}}

Office : {{row.office}}

Age : {{row.age}}

Salary : {{row.salary}}
{% endfor %}

#python #postgresql #flask

Učitajte sadržaj dinamički u Bootstrap modal s Jquery AJAX -om i Python Flask PostgreSQL -om

Naučite kako dinamički učitavati sadržaj u Bootstrap Modalu s Jquery AJAX -om i Python Flask PostgreSQL -om

Vidi Također:

Nove Stvari

Najčitljiviji

Izbor Urednika