Tag: mysql

Posted on by

Java NetBeans Grocery Shop Billing Supermarket Billing Project with Mysql Database

Subscribe YouTube For Latest Update Click Here

Buy Now ₹501

This software project is a traditional supermarket billing system with some added functionality. This system is built for fast data processing and bill generation for supermarket customers. The billing system consists of an Mysql database and effective front end designed in JAVA NetBeans. The billing database is a vast collection of product name, price and other product specific data. A product when billed is searched from the database and its price is added to the bill based upon the product quantity. The system also contains discounts on various products so that the product is offered at discounted price while billing. The supermarket billing system is built to help supermarkets calculate and display bills and serve the customer in a faster and efficient manner. This software project consists of an effective and easy Gui to help the employee in easy bill calculation and providing an efficient customer service.

How To Run?

Remember this system uses a MySQL back-end database. so you have to create the database manually on the basis of the project code.

  1. First, download the project and extract them.
  2. Then open your XAMPP and fire up the Apache server and MySQL server.
  3. Open your browser and create a database named as “grocery-store”.
  4. import sql file.
  5. Open your NetBeans IDE and look out for each of the table names and their attributes.

 

Buy Now ₹501

Posted on by

Simple Web-Based Chat Application using php, mysql, javascript, ajax

Subscribe YouTube For Latest Update Click Here

100 + PHP Projects with Source Code 

The chat application we will be building today will be quite simple. It not required login, AJAX-style features, and will also offer support for multiple users.

Installation

  • I like to use Wamp server, so I suggest installing Wamp server . Once that is installed, execute the following instructions.
  • Run wamp server ❗.
  • Make sure you have placed this entire application inside 📂 c://wamp/www/chat_application.
  • Left click on the wamp icon in system tray It will display list of options Select “start all services”.
  • Then open your preffered browser and type localhost in address bar Hit enter ❗ It will show the default page of wamp server.

Now include this index.php (my php file name) at the end of the url.

Setting Up The Database (.SQL File is present in dbase Folder)

Method 1 ✏️ Using Mysql Console !

I like to use mysql, so I suggest installing mysql. Once that is installed, execute the following commands don't worry it is inbuilt in Wamp server !.

  • If you are using wamp you can try this. Just type use your_Database_name first.
  • Click your wamp server icon then look for MYSQL > MSQL Console then run it.
  • If you dont have password, just hit enter and type :
  • mysql> use database_name;
  • mysql> source location_of_your_file;
  • If you have password, you will promt to enter a password. Enter you password first then type:
  • mysql> use database_name;
  • mysql> source location_of_your_file;

Method 2 ✏️

  • Left click on the wamp icon in system tray and run PHPMyAdmin (Access your database via PHPMyAdmin).
  • Go to the Import files tab
  • Click Browse, locate the SQL file on your computer (it is present in sql database folder), click Open, and then click Go.

Download link