Learning Web Design is Our Goal
CSS
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 […]
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? […]
There are plenty of Responsive menus on the net, which you can incorporate within your project to make an exciting navigation system. But more often than not we end up fixing and tweaking things with those menus! So today let’s focus on creating our own simple sliding navigation menu which will fit any screen size […]
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 […]
Did you ever want to create fancy neon effects? No? Well…to bad I’ll explain how to create them anyways. Neon text mostly is achieved by using the CSS3 property “text-shadow” on multiple layers and a saturated colour, as well as some animations to look more realistic. Live Example The most important are the “text-shadow” – […]
User experience can be greatly improved on an image upload feature if we enable the user to preview the image they have selected before actually uploading it to the server by clicking the upload button. In this tutorial, we will create a form that takes two inputs: the user’s profile picture (image), and their bio […]
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 […]
Creating, editing, updating and deleting content on a website is what makes the site dynamic. That’s what we are going to be doing in this post. A user who visits our site will be able to create posts that will be saved in a mysql database, retrieve the posts from the database and display them on […]