The code below when run ignores my menu and goes straight into the first def xx() command - WHY
import sqlite3
def mainMenu():
print(' \033[1mMenu program ')
print(' Press the number next to your choice ')
print(" 1 - Add Numbers to DataBase ")
print(" 2 - Print all the Data ")
print(" 3 - Add Numbers to DataBase ")
print(" 4 - Add Numbers to DataBase ")
print(" 5 - Exit the program ")
while True:
try:
selection=int(input('Enter choice: '))
if selection ==1:
addnewnames()
break
elif selection ==2:
list()
break
if selection ==3:
update()
break
elif selection ==4:
delete()
break
elif selection ==5:
print(' You selected 5 - the QUIT key \n Bye Bye!')
break
else:
print()
print(" INVALID SELECTION. \n Please enter a number between 1 and 3 ")
except ValueError:
print('Invalid choice \n Enyer anumber between 1 and 3')
exit
def addnewnames():
import sqlite3
conn = sqlite3 . connect ( 'phonebook.db' )
cursor = conn.cursor ()
s_SURNAME = input('Surname :')
s_FIRSTNAME = input('Firstname :')
s_NUMBER = input('Number :')
s_EMAILADDRESS = input ('EmailAdress :')
print()
print ( 'Posting information to database')
print()
cursor.execute("""
INSERT INTO phonedata(surname, firstname, number, emailaddress)
VALUES (?,?,?,?)
""", (s_SURNAME, s_FIRSTNAME, s_NUMBER, s_EMAILADDRESS))
conn.commit ()
print ( 'Data entered successfully.' )
conn . close ()
if (conn):
conn.close()
print("\nThe SQLite connection is closed.")
mainMenu()
def list():
import sqlite3
conn = sqlite3 . connect ( 'phonebook.db' )
cursor = conn.cursor ()
print ("Opened database successfully");
cursor = conn.execute("SELECT ID, SURNAME, FIRSTNAME, NUMBER, EMAILADDRESS from phonedata")
for row in cursor:
print ("ID = ", row[0])
print ("SURNAME = ", row[1])
print ("FIRSTNAME = ", row[2])
print ("NUMBER = ", row[3])
print ("EMAILADDRESS = ", row[4], "\n")
print ("Operation done successfully");
conn.close()
mainMenu()
def update():
print ('UPDATE')
anykey=input('Hit any key to continue')
mainMenu()
def delete():
print ('DELETE')
anykey=input('Hit any key to continue')
mainMenu()
mainMenu()
import sqlite3
def mainMenu():
print(' \033[1mMenu program ')
print(' Press the number next to your choice ')
print(" 1 - Add Numbers to DataBase ")
print(" 2 - Print all the Data ")
print(" 3 - Add Numbers to DataBase ")
print(" 4 - Add Numbers to DataBase ")
print(" 5 - Exit the program ")
while True:
try:
selection=int(input('Enter choice: '))
if selection ==1:
addnewnames()
break
elif selection ==2:
list()
break
if selection ==3:
update()
break
elif selection ==4:
delete()
break
elif selection ==5:
print(' You selected 5 - the QUIT key \n Bye Bye!')
break
else:
print()
print(" INVALID SELECTION. \n Please enter a number between 1 and 3 ")
except ValueError:
print('Invalid choice \n Enyer anumber between 1 and 3')
exit
def addnewnames():
import sqlite3
conn = sqlite3 . connect ( 'phonebook.db' )
cursor = conn.cursor ()
s_SURNAME = input('Surname :')
s_FIRSTNAME = input('Firstname :')
s_NUMBER = input('Number :')
s_EMAILADDRESS = input ('EmailAdress :')
print()
print ( 'Posting information to database')
print()
cursor.execute("""
INSERT INTO phonedata(surname, firstname, number, emailaddress)
VALUES (?,?,?,?)
""", (s_SURNAME, s_FIRSTNAME, s_NUMBER, s_EMAILADDRESS))
conn.commit ()
print ( 'Data entered successfully.' )
conn . close ()
if (conn):
conn.close()
print("\nThe SQLite connection is closed.")
mainMenu()
def list():
import sqlite3
conn = sqlite3 . connect ( 'phonebook.db' )
cursor = conn.cursor ()
print ("Opened database successfully");
cursor = conn.execute("SELECT ID, SURNAME, FIRSTNAME, NUMBER, EMAILADDRESS from phonedata")
for row in cursor:
print ("ID = ", row[0])
print ("SURNAME = ", row[1])
print ("FIRSTNAME = ", row[2])
print ("NUMBER = ", row[3])
print ("EMAILADDRESS = ", row[4], "\n")
print ("Operation done successfully");
conn.close()
mainMenu()
def update():
print ('UPDATE')
anykey=input('Hit any key to continue')
mainMenu()
def delete():
print ('DELETE')
anykey=input('Hit any key to continue')
mainMenu()
mainMenu()