Learning Web Design is Our Goal
DEMOS
Project Name : Employee Record Management System (ERMS) Language Used : PHP Database : My SQL User Interface Design : HTML, AJAX,JQUERY,JAVASCRIPT Web Browser : Mozilla, Google Chrome, IE8,OPERA Software : XAMPP / Wamp / Mamp/ Lamp (any one) Employee […]
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 this progress UI since they flow in a natural hierarchical order. But how can you design a progress bar structure that works for your site? […]
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 .
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
CREATE TABLE `tblemploye` ( `id` int(11) NOT NULL, `fullName` varchar(120) NOT NULL, `emailId` varchar(150) NOT NULL, `phoneNumber` int(11) NOT NULL, `department` varchar(100) NOT NULL, `joiningDate` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ALTER TABLE `tblemploye` ADD PRIMARY KEY (`id`); ALTER TABLE `tblemploye` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; COMMIT; |
Now insert some data into this table.
|
1 2 3 4 5 |
INSERT INTO `tblemploye` (`id`, `fullName`, `emailId`, `phoneNumber`, `department`, `joiningDate`) VALUES (1, 'Ogbugbu Ejiroghene, 'ogbugbu14@gmail.com', 08154761214, 'IT', '2018-05-01'), (2, 'Ejiro', 'john@test.com', 45455454, 'HR', '2017-08-12'), (3, 'Kefe', 'demo@test.com', 23423423, 'Account', '2016-10-01'), (4, 'Test', 'test@test.com', 834856384, 'IT', '2017-12-01'); |
Index.php in this file we will read the data from database.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
?php $query=mysqli_query($con,"select * from tblemploye"); $cnt=1; while ($row=mysqli_fetch_array($query)) { ?> <tr> <td><?php echo $cnt; ?></td> <td><?php echo $row['fullName']?></td> <td><?php echo $row['emailId']?></td> <td><?php echo $row['phoneNumber']?></td> <td><?php echo $row['department']?></td> <td><?php echo $row['joiningDate']?></td> </tr> <?php $cnt++; } ?> </table> |
genrate-excel.php in this […]
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 three basic components: A Client-Side HTML Document that sends the Chat Text and receives Data from the database A PHP file which writes user input […]
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 :
|
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 into this table. We will use LIMIT clause for generating pagination.LIMIT clause uses two arguments one is OFFSET and second one is the number of records return from […]