Hello everyone this is scout and guides data entry sql app..
where you can.
----> enter data on the your own sql database
----> connecting python and sql
----> using python
----> easy to use (graphical user interface)
program required to run this programe;
=====install mysql.
=====install python or python3.
=====and other following pip packages.
Before running the programe install the following:
====> pip install pyautogui
====> pip install Pyqt5
====> pip install pymysql
====> pip install pyttsx3
====> pip install sys
====> pip install cryptography
==>Then Do this
open mysql command line type following commands
==>>>>>>use mysql;
==>>>>>>Create table keeth (sno Integer,date varchar(35), customer varchar (50), mob_no integer,address varchar(100),medname varchar(50) not null,qty integer , price integer, paymode varchar (50) not null);
Then open main.py file with notepad.
on line 14,25,40,56 ===> mycon = pymysql.connect(host = "localhost", user = "root", password = "Your password", database = "mysql")
==>here change "your password" the sql command line password of your system.
==>here change "user" if different from others
Then save the main.py file and then run the python file.
if you have any issue you can rise over here in disscuse.
also visit my websites;
--->https://howtomakejarvisaiusingpythonwordpress.com/