Cashiering and Student Account System in Visual Basic 6 Features: 1. Process Payment Payment and Assessment of students. 2. Preview the payment history of students. 3. Real time balance of students. 4. View the income of every departments 5. Monitor…
Dictionary Program in Visual Basic 6.0
Dictionary Program in Visual Basic 6.0 Features: 1. Display words based on search query. 2. Display the meaning of selected word. 3. CRUD (Create, Update, Delete) word info and meaning. 4. Capable of speaking/pronouncing the word selected.
Automated Student Council Election System in Visual Basic
Automated Student Council Election System in Visual Basic 6.0 Features: 1. Encode Party List (Create, Update, Delete Party list information) 2. Encode Candidates (Create, Update, Delete Candidate Information) 3. Generate Voting Codes (The system generates random codes to be used as…
Water Billing System in Visual Basic 6.0
Water Billing System in Visual Basic 6.0 Features: 1. Add, Update, Delete Client Information (Client Personal Information such as name, address, contact info) 2. Connection/Disconnection Module 3. Create Billing (Create a billing statement for every client, this feature is scheduled…
Student Information System in Visual Basic 6
Student Information System in Visual Basic 6 Sample Student Information System using Visual Basic 6.0 and MS Access Features: 1. Add, Update, Delete student information (Personal Profile, Information of guardian or parents) 2. Back-up and Restore Database (Database backup creates…
Electronic Booking System in Visual Basic 6.0
Electronic Booking Check-in Check-out System – It enhances the system to provide faster services in order to increase the business productivity. This system electronically accepts information of the customers and generates automatically its transaction details such as billing, receipts and income…
MySQL Tutorial – Using BETWEEN condition
Using BETWEEN condition BETWEEN condition is used to retrieve records with in the given range. The syntax of BETWEEN condition: SELECT column_name(s) FROM table_name Where column_name BETWEEN value1 AND value2;
MySQL Tutorial – Using the IN function
The IN function can be used to replace the OR condition. It is also used to specify multiple value together with the WHERE clause. The syntax of IN function: SELECT column_name(s) FROM table_name Where column_name IN (value1,value2,etc…);
MySQL Tutorial – Using HAVING clause
Using HAVING clause HAVING clause is somewhat similar to WHERE clause and it is used together with the GROUP BY clause. It was added to SQL to combine with the aggregate functions because the WHERE clause doesn’t allow aggregates. The…
PHP-MySQL Lesson: DELETE statement
DELETE statement In this lesson we are going to write a PHP script that deletes records in MySQL database using the DELETE statement. We can execute any sql query like insert, update, delete, select etc. using the mysql_query() function. In…