Category: Projects

PHP and MySQL Project for Client Server Validation Form

This is the simple project for validation where PHP is a server side scripting language. We have made connection using PHP to MySQL Database. The project consist of Registration ,Update and Login Form. The users is registered using registration form where PHP checks the inputs and validate the input and insert into database. The login form is used to login in website and display the content. Login form interact with MySQL Database to ensure the right user is logged in. If the user input is wrong the scripting language will throw exception and error. The update form is used to update the data in MySQL database.

Languages used for creating the project:

  • MySQL
  • PHP
  • Bootstrap
  • HTML

Click the link to  download the source code: PHP MySQL Client server Validation

This project was contributed by Aadil Shaikh. If you like to contribute or advertise on our website we reccomend you to write an article on the link provided below and you will see your article on our website

Contribution Link: Write a Article

Filed under: PHPTagged with: , ,

DBMS Project on Wildlife Sanctuary Management System

The project, Wildlife Sanctuary Management System is a web based application which is easy to access and user friendly. The application uses HTML for front-end display, PHP scripting language for interacting with database, MongoDB Database to store data regarding products and users behavior and EasyPHP Server.

The purpose of this application is for smooth administration and to get a brief idea of overall expenses and profit the sanctuary deals with. The application keeps a backup of the tourist data which includes their ticket details, the fare they pay and the donations they make out of good heart for the welfare of wild animals and different initiatives.

The application is fully optimized shopping website where it can  handle images, tourist data, animal data, feed cost, staff salary, expenditure and is in normalized form.

Software Used:

  • EASYPHP DEVSERVER 14.1
  • BROWSER
  • MongoDB Database

Concept Used:

  • MONGODB-(DATABASE BACKEND)
  • HTML & PHP-(FRONT END)
  • EASY PHP-(CONNECTIVITY)

Click the link to download the Project for Free: Wildlife Sanctuary Application

Filed under: DBMSTagged with: , , ,

DBMS Project on Online Shopping Management System

The project, Online Shopping Management System is a web-based application that sells products to customers in very easy and convenient way. The application uses HTML for front-end display, PHP scripting language for interacting with database, MongoDB Database to store data regarding products and users behavior and EasyPHP Server.

The application can be used by two kinds of people like manager to manage the products, their prices, photos, etc. and customer to buy products. The application gives the managers powers like remove products, add products, update product, change price, stocks, descriptions and much more while the customers get the power of buying the products, getting the total amount of purchase and billing.

The application is fully optimized shopping website where it can  handle images, total amount of purchase, billing, description, title, price, add to cart, order delivery records, stocks remaining and in normalized form.

DBMS Mini Project Online Shopping Management ER-Diagram
ER Diagram

Features: Clean separation of various components to facilitate easy modification and revision. 

All the data is maintained in a separate file to facilitate easy modification. 

All the data required for different operations is kept in a separate file. 

Quick and easy saving and loading of database file.

Database Design Model / Tables and Columns names: 

  1. LOGIN table contains user, pass, fname, lname, address, pincode, phone
  2. ORDER_DETAILS table contains buyer fname,buyer lname,buyer address,buyer pincodebuyer phone,buyer purchase pro_id, buyer purchase pro_name,delivery date,purchase date,buyer purchase pro_price
  3. PAYMENT table contains buyer fname,buyer lname,buyer address,purchase date,buyer phone,buyer purchase pro_id,buyer purchase pro_name,buyer purchase pro_price,buyer pincode
  4. PRODUCT table contains product id,product name,product desc,product price,product stock,product image

Concept Used:

  • MONGODB-(DATABASE BACKEND)
  • HTML & PHP-(FRONT END)
  • EASY PHP-(CONNECTIVITY)

Software Used:

  • EASYPHP DEVSERVER 14.1
  • BROWSER
  • MongoDB Database

Click the link to download the Project for Free: Online Shopping Application

Filed under: DBMSTagged with: , , ,

DBMS Project on Hardware Store using MySQL and PHP

The Project, Hardware Store is a web based application for selling hardware products online. The application uses HTML for front-end display, PHP scripting language for interacting with database, MySQL Database to store data regarding products and users behavior and Xampp Server.

The application can be used by two kinds of people like manager to manage the products, their prices, photos, etc. and customer to buy products. The application gives the managers powers like remove products, add products, update product, change price, stocks, descriptions and much more while the customers get the power of buying the products, getting the total amount of purchase and billing.

The application is fully optimized shopping website where it can  handle images, total amount of purchase, billing, description, title, price, add to cart, order delivery records, stocks remaining and in normalized form.

DBMS Mini Project Hardware Store Management System

Software Used:

Procedure / Steps to configure project:

  • Download the XAMPP and install and run MySQL and PHPMyAdmin.
  • Download the Source Code(given below) and extract the .rar file.
  • Copy the Source Folder in XAMPP -> htdocs.
  • In browser type -> http://localhost/phpmyadmin and create the following DATABASE in PHPMyAdmin

Create database named hardwarestore

  1. In hardwarestore -> create table as cart -> in cart create column as p_id as primary key.
  2. In hardwarestore -> create table as product-> in product create column as product_id as primary key, product_title, product_img, product_desc, product_stock, product_price.
  3. In hardwarestore -> create table as users -> in users create column as uid as primary key,name, email, password.
  4. Now in your browser type -> http://localhost/hardwarestore where main.php is the homepage where you can edit, add, delete, and update the products.

Note: Remember you can edit your project files in Folder -> XAMPP -> htdocs -> hardwarestore

Click to download free project : Hardware Store Application using PHP and MySQL

Filed under: DBMSTagged with: , , ,

Social Media Application using JSP, JAVA, MySQL

The JSP project is based on Social Media websites like Facebook, Twitter where user can post, comment, make friends and express their feeling. The project is build upon JSP, Servlet, Java, MySQL, Tomcat Server, HTML and BootStrap. The Student can modify the project with their own ideas to meet their requirements. 

The project working is like where we can send Post, Comment on Post, Send Friend request, Delete user where it has the ability to automatically delete all the posts, comments, friend requests of the delete user.

Software Required:

The project is made using Eclipse IDE and MySQL Server. Following are the requirements.
  1. Eclipse JAVA IDE 
  2. MySQL DATABASE 
  3. JDBC Connector for database
  4. TomCat Server

Statements for creating database and tables in MySQL:

  • In this project the database have the name : CipherBooK

Following are the Tables:

  • users (uid, uname, uemail, upass, udob, ugender, uloc, uimage);
create table users(
uid int unsigned not null primary key auto_increment,
uname varchar(30) not null,
uemail varchar(60) not null,
upass varchar(30) not null,
udob date null,
ugender enum('Male','Female') not null,
uloc varchar(30) not null,
uimage blob
);
  • posts (pid, uid, ptitle, pbody, pdate);
create table posts(
pid int unsigned not null primary key auto_increment,
uid int unsigned not null,
ptitle varchar(30) not null,
pbody text not null,
pdate date not null,
constraint fk_user foreign key(uid) references users(uid)
on delete cascade
on update cascade
);
  • relationship (user_one_id, user_two_id, status, action_user_id);
CREATE TABLE relationship(
user_one_id INT NOT NULL REFERENCES Users(uid) on delete cascade on update cascade,
user_two_id INT NOT NULL REFERENCES Users(uid) on delete cascade on update cascade,
status INT NOT NULL default 0,
action_user_id INT NOT NULL,
CONSTRAINT CheckOneWay CHECK (user_one_id < user_two_id),
CONSTRAINT UQ_Friends_Pairs UNIQUE (user_two_id, user_one_id),
CONSTRAINT PK_Friends_Pairs PRIMARY KEY (user_one_id, user_two_id)
);
  • comments( cid, uid, pid, cbody, cdate)
create table comments(
cid int unsigned not null primary key auto_increment,
pid int unsigned not null,
uid int unsigned not null,
cbody text not null,
cdate date not null,
constraint fk_post foreign key(pid) references posts(pid)
on delete cascade on update cascade
);

Steps:
Download the Project and extract it.

  1. The in Eclipse File-> New -> Dynamic Web Project.
  2. Select the target runt me as Tomcat Folder and keep the Dynamic web module version as 3.0
  3. Copy the files as per Folders given in project.
  4. Download and Copy the JAR file in WEB-INF -> lib folder.
Tips for errors:
  1. Make sure that Apache Tomcat server in check in eclipse Properties -> Targeted Runtime
  2. Change Build Path JRE System Library in Properties -> Java Build Path
  3. Import the packages
JSP Java MYSQL Project
This Image will help you to organize the files and packages(Folders).
After Reading the whole boring stuff here is the download(Make sure you read it, Its Important)
 
Filed under: JavaTagged with: , , ,