| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/software/smsc smpp installer/software/Services/python/freesms/ |
Upload File : |
import time
from datetime import datetime
import os
import mysql.connector
os.system("cls")
mydb = mysql.connector.connect(
host="localhost",
user="smsEngine",
password="guEnaR28T",
database="smartsmsrouter"
)
mycursor = mydb.cursor()
query = "SELECT sn,totalsms from totalfreesms"
#print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
for x in myresult:
sn = x[0]
totalsms = str(int(x[1])+1)
query ="update totalfreesms set totalsms='{}' where sn ={}".format(totalsms,sn)
mycursor.execute(query)
mydb.commit()
mycursor.close()
mydb.close()