首先在HTML頭部新增
- <script>
- function asking()
- {
- askingnya=confirm("Are you sure to delete this record ?");
- if (askingnya==true)
- {
- return True;
- }
- else
- {
- return False;
- }
- }
- </script>
複製代碼
HTML刪除那個ID用 a href 鏈結(GET)
- <a href="{{ url_for('company_delete',id=company.id)}}" class="btn btn-danger" onClick="return asking()">刪除</a>
複製代碼
在PYTHON檔案加入
- @app.route("/admin/company/delete/<id>", methods=["GET","POST"])
- def company_delete(id):
- id = str(id)
- print("del id:", id)
- conn = check_db_connection()
- # create a connection cursor
- # execute a SQL statement
- cursor = conn.cursor(dictionary=True)
- sql = "DELETE FROM net_company WHERE id=" + id
- cursor.execute(sql)
- conn.commit()
- conn.close()
- return redirect(url_for('admin_company'))
複製代碼 完成
展示圖
FLASK render_template MYSQL 紀錄
參考文章
https://medium.com/nerd-for-tech/developing-a-simple-create-read-update-and-delete-crud-application-using-flask-and-mariadb-f037a5798ee2
|