Showing posts with label View Record Using Python and MySQL. Show all posts
Showing posts with label View Record Using Python and MySQL. Show all posts

Friday, January 11, 2019

View Record Using Python and MySQL

A code that will teach you how to view records using Python and MySQL.  I am still a beginner in Python programming which I find it interesting to learn.

I am currently accepting programming work, it projects, school and application development.

programming projects, thesis and capstone projects, IT consulting.

work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.

My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com


Program Listing

import pymysql

connection = pymysql.connect(
    host='localhost',
    user='root',
    password='',
    db='my_python',
)

try:
    with connection.cursor() as cursor:
        sql = "SELECT id,name,age,address FROM USERS ORDER BY ID ASC"
        try:
            cursor.execute(sql)
            result = cursor.fetchall()

            print("ID\t\t\tName\t\t\t\t Age\t\t\t\t\tAddress")
            print("---------------------------------------------------------------------------")
            for row in result:
                print(str(row[0]) + "\t\t\t" +row[1] + "\t\t\t" + row[2] + "\t\t\t" + row[3])

        except:
            print("Oops! Something wrong")

    connection.commit()
finally:
    connection.close()