
- CANTEEN MANAGEMENT SYSTEM PROJECT ABSTRACT UPDATE
- CANTEEN MANAGEMENT SYSTEM PROJECT ABSTRACT FULL
If equal then loop will break and assign true to the found variable.
First selects all items and then checking if the row means our id column from database table is equal to or not. In this function, I searched item with one specific id passed as parameter. If query failed, then it will show the error message. In this function, I fetched all sold items from the sold table. If query failed, then it will show the error message. In this function, I fetched all items from the items table. CANTEEN MANAGEMENT SYSTEM PROJECT ABSTRACT UPDATE
After adding new item to sold table, an update query will run to update the quantity of item in items table in Canteen Management System C++ program. In this function I used stringstream to convert string to integer and integer to string. In this function I passed two parameter name and quantity of the item stored in canteen. If insertion query work successfully, then success message will be shown if not then error message will be shown in this Canteen Management System program. Then run the built in function mysql_query(). I took name and quantity input from user. If connection failure, then error message will be shown. In here, I connected with MySql database. In Canteen constructor I created the instance of database. the if statement shows the successful or failed connection. (MySql server should open while connecting) mysql_real_connect connects to the database. mysql_init is the initializer of mysql_real_connect. This class contains connection of the database. res is for getting all the values form the database. row is for getting the current row of the database. qstate represent the state of the query. Our main class is Canteen class and this class has some public functions like show, allItems, soldItems, addNewItem, editItem, deleteItem, searchById, searchByName, checkQuantity, addNewSale.īelow are the things we can do in this program:Ĭanteen Management System Program Detail: Global variables The program has a database connection class call at the beginning of the program. Canteen Management System Program in C++ and MySQL Description: CANTEEN MANAGEMENT SYSTEM PROJECT ABSTRACT FULL
You can see the full list of items stored in Canteen. The program can store new canteen item, edit them, delete them. Thanks to technology, virtual calls with organisation representatives gave students the opportunity to learn more about the needs of the organisations as well as present their recommendations to the organisations.ĭespite the current COVID situation and safety management measures in place, the school is grateful that our Yusoffians have grown in empathy and learnt much from their interactions with the community.C++ Program: Canteen Management System in C++ and MySQL Introduction:
One Portal All Learners (OPAL Sports and Recreation ClubĮducation Career Guidance Counsellor (ECGC)Īs part of Values In Action Projects, our Secondary 3 students partnered 2 organisations, namely the National Kidney Foundation (NKF) and Serving People with Disabilities (SPD).įor the NKF, students created surveys to help collate data from teenagers on what would motivate teenagers to volunteer with NKF and also participate in NKF's 7-day No Sugary Drinks Challenge.įor the SPD, students examined issues faced by clients at the Sheltered Workshop and created prototypes to resolve the problems faced by them. YI CONNECT Useful Links for Teachers MOE Intranet.YI STORIES Achievements Academic AchievementsĬommunity & Environment Related Achievements.YI EXPERIENCE Academic Programmes English Language & Literature Departmentĭirect School Admissions into Secondary Schools (DSA-SEC)Ĭharacter & Citizenship Education (CCE) CCE Programmes.Join Our YI Family We Spark Curiosity and Ignite Passion Centre for Teaching and Learning Excellence