ikan Uploader :
Directory : /var/www/html/shardahospital.org/cronjobs/python/
Upload File : |
| Current File : /var/www/html/shardahospital.org/cronjobs/python/cronjobs.py |
import mysql.connector
# Replace these with your actual MySQL database credentials
db_config = {
'host': 'admissions.cluster-custom-c8m5zlhotfbm.ap-south-1.rds.amazonaws.com',
'user': 'shardezone_user',
'password': '7se%;pr*/A24AyTw',
'database': 'shardaac_ezone_2022_db'
}
try:
# Establish a connection to the database
connection = mysql.connector.connect(**db_config)
if connection.is_connected():
print("Connected to MySQL database")
# Create a cursor object to interact with the database
cursor = connection.cursor()
# Execute a SELECT statement
select_query = "SELECT * FROM history limit 10"
cursor.execute(select_query)
# Fetch all rows
rows = cursor.fetchall()
# Display the fetched rows
for row in rows:
print(row)
except mysql.connector.Error as e:
print("Error:", e)
finally:
# Close the cursor and connection
if 'cursor' in locals() and cursor is not None:
cursor.close()
if 'connection' in locals() and connection.is_connected():
connection.close()
print("Connection closed")
Kontol Shell Bypass