버미다

from flask import Flask,render_template,request,url_for,redirect,abortimport pymysqlimport mathapp = Flask(__name__)conn = pymysql.connect( host="127.0.0.1", user = "root", passwd="1234", charset="utf8", autocommit=True)cur = conn.cursor()cur.execute(f'CREATE SCHEMA IF NOT EXISTS list') # 나중에 DB 변수화conn.select_db("list")cur.execute(f'''CREATE TABLE IF NOT EXISTS userTable( ..

pymysql 2025. 6. 11. 14:30

import pymysqlfrom flask import Flask,render_template,request,jsonifyapp= Flask(__name__)conn = pymysql.connect( host = "127.0.0.1", user="root", passwd="비밀번호", # db="dolist", charset ="utf8", autocommit=True)cur = conn.cursor()cur.execute(f"CREATE SCHEMA IF NOT EXISTS dolist")conn.select_db("dolist")@app.route("/list",methods=['GET'])def list_todo(): date =request.args.get..

pymysql 2025. 5. 19. 15:06

DOCTYPE html>html lang="en">head> meta charset="UTF-8"> meta name="viewport" content="width=device-width, initial-scale=1.0"> script src="https://code.jquery.com/jquery-3.7.1.min.js" integrity="sha256-/JqT3SQfawRcv/BIHPThkBvs0OEvtFFmqPF/lYI/Cxo=" crossorigin="anonymous">script> script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.4.1/jquery.easing.min.js">script>..

pymysql 2025. 5. 18. 19:13

DOCTYPE html>html lang="en">head> meta charset="UTF-8"> meta name="viewport" content="width=device-width, initial-scale=1.0"> script src="https://code.jquery.com/jquery-3.7.1.min.js" integrity="sha256-/JqT3SQfawRcv/BIHPThkBvs0OEvtFFmqPF/lYI/Cxo=" crossorigin="anonymous">script> script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.4.1/jquery.easing.min.js">script>..

pymysql 2025. 5. 14. 18:03

DOCTYPE html>html lang="en">head> meta charset="UTF-8"> meta name="viewport" content="width=device-width, initial-scale=1.0"> script src="https://code.jquery.com/jquery-3.7.1.min.js" integrity="sha256-/JqT3SQfawRcv/BIHPThkBvs0OEvtFFmqPF/lYI/Cxo=" crossorigin="anonymous">script> title>todotitle> style> html, body, h1, h2, h3, div, ..

pymysql 2025. 5. 10. 03:10

import pymysqlfrom flask import Flask,request,render_template,abort,url_for,redirectapp=Flask(__name__)conn =pymysql.connect( host="127.0.0.1", user="root", passwd="cb02077075", db='mylist', charset = "utf8", autocommit = True )cur= conn.cursor()@app.route("/list")def lists(): page =request.args.get("page",default=1,type=int) #한페이지당 몇개의 값 limit = request.args.get("limi..

pymysql 2025. 5. 8. 15:16

import pymysqlfrom flask import Flask,request,render_template,abort,url_for,redirectapp=Flask(__name__)conn =pymysql.connect( host="127.0.0.1", user="root", passwd="cb02077075", db='mylist', charset = "utf8", autocommit = True )cur= conn.cursor()@app.route("/list")def lists(): page =request.args.get("page",default=1,type=int) #한페이지당 몇개의 값 limit = request.args.get("limi..

pymysql 2025. 5. 6. 01:49

DOCTYPE html>html lang="en">head> meta charset="UTF-8"> meta name="viewport" content="width=device-width, initial-scale=1.0"> title>리스트title>head>body> {% if datas|length > 0 %} table> thead> tr> td>번 호td> td>아이디td> td>이 름td> td>이메일td> td>출생연도td> tr> thead> tbody> ..

pymysql 2025. 5. 6. 01:13