Here we show you how to force download any types of file like text, image, document, pdf, zip, etc from directory or server in PHP. we need to force the browser to download file other than display. Using header() and readfile() function, you can easily download a file in PHP. We will provide the example …
Here we write a SQL Query for retrieve Max and Min salary with employees name in MySql. First we create a sample table with data. — — Table structure for table `employees` — CREATE TABLE `employees` ( `employee_id` int(11) NOT NULL, `employee_name` varchar(100) NOT NULL, `salary` int(11) NOT NULL, `department` varchar(50) NOT NULL ) ENGINE=InnoDB …
Max And Min Salary Of Employees With Employee Name In MySql Read More »
In this post, we will show you how you can import Excel file data to MySql Database using PHPExcel Library. Nowadays, in web development data import is an important functionality and most of the website user wants that his spreadsheet data stores in database with more manageable form. For achieve this result we are using …
PHP Import Excel File Data Into MySql Database Using PHPExcel Library Read More »
Check and Uncheck all checkboxes by one checkbox is very important and common functionality in website development. Here we show you how you can checked and unchecked all checkboxes. The code below will demonstrate Check and Uncheck All checkboxes by single checkbox. Check Uncheck All Checkboxes in Html Using JavaScript Language PHP JAVA C C++ …
Check Uncheck All Checkboxes in Html Using JavaScript Read More »
In WordPress when user sign in his control panel of their website, they are welcomed by the word “Howdy” with their screen name. Here we show you how you can change it by code without using Plugins. For changing this place below code end of the function.php file of your active theme. function remove_howdy( $wp_admin_bar …
How to Remove Howdy From Admin Bar Without plugin Read More »
Auto Suggestion(Auto Complete) Textbox Using Bootstrap PHP MySql Ajax And jQuery Auto Suggestion (Auto Complete) textbox is important functionality for any website. Here we show you how without using any JQuery Auto complete Plugin you can able to create Auto Suggestion functionality in textbox. Here we are using Ajax, JQuery,Php Mysql and Bootstrap. Let’s Start …
Auto Suggestion Textbox Using Bootstrap PHP MySql Ajax JQuery Read More »
MySql delete(remove) duplicate rows(records) We will show you how to remove duplicate rows in a MySql. First we will create a table with some duplicate records. Below show a sample table image with duplicate records. Here we run a query to know how many name column repeated. SELECT *,count(name) AS dup_rows FROM `user_info` GROUP BY …
MySQL copy data from one column to another column We will show you copy data from one column to another column in the same table by MySql UPDATE Command. We have a table sortable with blog_id, blog_title, blog_desc, blog_order Columns and we want to copy value of column blog_id into column blog_order. In the above …
MySql query to copy data from one column to another column Read More »
Dependent Drop Down using Bootstrap, PHP, MySqli, Ajax, jQuery We will create a dynamic dependent drop down using jQuery, Ajax,MySqli and PHP. This functionality is used to automatically add dependent data to a drop down list. This is a very common functionality that is used in Websites. According to the drop-down selection, the dependent data …
Dependent Drop Down using Bootstrap PHP MySqli Ajax jQuery Read More »
Reorder Bootstrap table rows with help of JQuery,Ajax,PHP and MySql Reorder table Rows is a important task. We will create an example with bootstrap.Where we can reorder rows and save into Database Table. First Create table In Database(MySql) and Save some records.Use Below query to create a table in Database with some records. — — …
Reorder Bootstrap table rows with help of JQuery-Ajax-PHP-MySql Read More »
