Tag: MySQL

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

  • Home
  • Tag Archives: MySQL
Filed under: PHPTagged 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

  • Home
  • Tag Archives: 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)
 
  • Home
  • Tag Archives: MySQL
Filed under: JavaTagged with: , , ,