DEMOS Archives - Web Design

Employee Record Management System in PHP and MySQL

February 18, 2019March 4, 2019 - by Web Design - 10 Comments.

Project Name : Employee Record Management System (ERMS) Language Used : PHP Database : My SQL User …

CSS / DEMOS / HTML / JAVASCRIPT

Progress Step User Interface Design Patterns: Tips, Code Snippets & Freebies

January 13, 2019January 13, 2019 - by Web Design - 22 Comments.

Progress steps are great for user experience. You typically find these on signup pages and checkout forms where the user needs to enter data across multiple steps. Breadcrumbs can also use …

CSS / DEMOS / HTML / MYSQL / PHP / PHP PROJECT

How to Fetch Data in Excel or Generate Excel file in PHP

September 30, 2018October 13, 2018 - by Web Design - Leave a Comment

File structure for this tutorial : config.php (database connection file) index.php (For fetching data ) genrate-excel.php (For genrating excel file) Create a sql table tblemployee. Structure of sql table employe …

CSS / DEMOS / HTML / MYSQL / PHP / PHP PROJECT / WEB DEVELOPMENT

Creating a web chat with PHP and MySQL

September 23, 2018October 13, 2018 - by Web Design - 4 Comments.

In this Tutorial, I’ll show you how you can write your very own web-based Chat App using HTML, CSS, JavaScript/jQuery, PHP and MySQL. For a full functioning Web-Chat we’ll need …

DEMOS / PHP / WEB DEVELOPMENT

How to create pagination in PHP

September 23, 2018October 13, 2018 - by Web Design - 14 Comments.

File structure for this tutorial : config.php (Database configuration file) index.php (Main file) tbluser.sql (SQL Table structure with dummy data) First create a table tbluser. Sturcture of tbluser :

CREATE TABLE `tbluser` (
`id` int(11) NOT NULL,
`Name` varchar(120) NOT NULL,
`PhoneNumber` int(11) NOT NULL,
`Emailid` varchar(150) NOT NULL,
`PostingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

1

2

3

4

5

6

7

CREATE TABLE `tbluser` (

`id` int(11) NOT NULL,

`Name` varchar(120) NOT NULL,

`PhoneNumber` int(11) NOT NULL,

`Emailid` varchar(150) NOT NULL,

`PostingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Insert some data …