Page 17 - project IP DEEPAK Full for youtub
P. 17

print('[2]Exit')


                       b=int(input('choose an option:'))


                       print('======================')

                       mycursor.execute('use fddel')


                       if b==1:


                           print('please choose an option')

                           print('======================')


                           print('[1]View Food Menu')

                           print('[2]Order Food')


                           print('[3]view customer details')


                           print('[4]view bill')

                           print('[5]Exit to main menu')


                           c=int(input(':'))


                           print('======================')

                           if c==1:


                               q1='select * from foodmenu'


                               mycursor.execute(q1)

                               data=mycursor.fetchall()


                               print(pd.DataFrame(data, columns=['s.no','name','price']))

                           if c==2:


                               print("**************************")


                               name=input("Enter customer name:")

                               print("**************************")


                               print('please choose an item')
   12   13   14   15   16   17   18   19   20   21