Learner

Import Excel to MySQL database is a very important method.Sometimes you have a very big list of items in an excel file and at sometimes you need to import all that list into your database so you can see that list on your website.Today I will show you how you can Import Excel to MySQL using PHP programming language. In this Import Excel to MySQL script, we made one HTML form in which we use file input HTML element.A user will choose the CSV file and press on the import button.A form will be submitted and on the PHP script we will get the file and open this file through fopen() method and then separate the values through while loop.

Real-time search or live search is a great feature for filtering records in an HTML table.Live search helps to provide a better user interface in your web project. There are many jQuery plugins are available to perform a live search and filter on HTML table.But if you want a lightweight solution, our code snippets will best choice for you.However,adding a live search feature to HTML table is very easy and you can implement without any jQuery plugin.In this tutorial, we’ll provide a short code snippet to implement live search functionality on HTML table using jQuery. This live search functionality helps to filter data in real time based on the searched terms.

Pagination is the practice of dividing a piece of content into different pages and it heavily affects User experience, Web Development. Uses of Pagination on the Web: The Paginated Lists pagination is used when we split a large list into several pages.This is a very common navigation technique that we find on E commerce websites, where the product lists are usually divided in different pages, primarily because they are too large to display all at once.

There are many plugins available to add special effect on images when cursor move over the image. All of those plugins includes a lot of codes in the web page which may effect on page load time. If you want to use less code and avoid page load time issue,our simple image zoom effect script is a perfect choice for you. Enlarge image on hover creates a better user interface in any web application.You can easily add zoom effect to the image on mouse-over with CSS and jQuery Using PHP MySQL.