โค้ด: เลือกทั้งหมด
import psycopg2 as p
try:
con = p.connect(
host = "localhost",
database="ben01",
user="postgres",
password="postgres",)
cur = con.cursor()
loop = 1
while loop == 1 :
name = input('Input Your First Name: ')
lastname = input('Input Your Last Name: ')
color = input('What Is Your Favorite Color: ')
if name == 'esc' or lastname == 'esc' or color == 'esc':
loop = 0
continue
sql = "INSERT INTO test_python(name_first , name_last , favorite_color) \
VALUES ('%s','%s','%s')" %(name,lastname,color)
sql = sql.encode('utf-8')
try:
cur.execute(sql)
cur.commit()
print('เพิ่มข้อมูลเรียบร้อย')
except:
con.rollback()
print('เก็บข้อมูลผิดพลาด')
except p.Error:
print('ติดต่อฐานข้อมูลผิดพลาด')
if con:
con.close()
https://www.mindphp.com/vdo-tutorial-py ... resql.html