import pymysql.cursors


# Connect to the database.

connection = pymysql.connect(host="sql25.phpnet.org",
  user="msb77833",
  password="GLSb0uhU5W3E",
  db="msb77833",
  charset="utf8mb4",
  cursorclass=pymysql.cursors.DictCursor)


print("connect successful!!")



try:
    with connection.cursor() as cursor:

        # SQL
        #sql = "SELECT * FROM t_mouvement"
        sql = "SELECT Valeur actuelle FROM global_action"
        
        # Execute query.
        cursor.execute(sql)
        
        result = cursor.fetchall()
        
        print("cursor.description: ", cursor.description)
        
        print()
        
        for x in result:
            print(x)
  
except pymysql.Error as e:
    print(e)

except :
    print("Unknown column 'Valeur' in 'field list'")
    
finally:
    # Close connection.
    connection.close()