Project Name Online Marriage Registration System Language Used PHP5.6, PHP7.x Database MySQL 5.x User Interface Design HTML, AJAX,JQUERY,JAVASCRIPT Web Browser Mozilla, Google Chrome, IE8, OPERA Software XAMPP / Wamp / Mamp/ Lamp (anyone) In the Online Marriage Registration System we use PHP and MySQL Database. This project has two modules i.e. admin and […]
DEMOS
DEMOS
Employee Record Management System in PHP and MySQL
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 Step User Interface Design Patterns: Tips, Code Snippets & Freebies
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? […]
How to Fetch Data in Excel or Generate Excel file in PHP
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 […]
Creating a web chat with PHP and MySQL
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 […]
How to create pagination in PHP
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 […]